Dispatcher Shut down

Hi All,

Our SAP Server was down all of sudden and when i re started it it says SAP is running and database is also up.

R3trans return code is also 0.

But when i execute dpmon it i sthrowing error :

kernel runs with dp version 243000(ext=110000) (@(#) DPLIB-INT-VERSION-243000-UC)

length of sys_adm_ext is 576 bytes

ERROR => DpSysAdmExtCreate: ShmCreate (ATTACH) failed (3) [dpxxtool2.c 652]
ERROR => DpIPCInit2: DpSysAdmExtCreate [dpxxtool2.c 369]
ERROR => DpMonInit: DpIPCInit [dpxxmon.c 961]
ERROR => main: DpMonInit [dpxxmon.c 488]

Can you please suggest any solution.

Currently our SAP is on Oracle 10g and HP-UNIX 11.31.Kernal is on patch 69.

Regards,

sandhya

SAP Managed Tags:
SAP NetWeaver Application Server

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Hello,

with which user do you execute the dpmon command?

The dpmon output looks like an user rights problem.

Could you please provide the logfiles from your dispatcher.

Kind Regards

Franz

Edited by: Franz Hiltscher on Jun 14, 2010 12:20 PM

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks Franz,I have executed dpmon with "sidadm" user.

Please find the log of "dev_disp"

Mon Jun 14 13:28:02 2010

kernel runs with dp version 243000(ext=110000) (@(#) DPLIB-INT-VERSION-243000-UC)

length of sys_adm_ext is 576 bytes

SWITCH TRC-HIDE on ***

***LOG Q00=> DpSapEnvInit, DPStart (00 2734) [dpxxdisp.c 1283]

shared lib "dw_xml.sl" version 69 successfully loaded

shared lib "dw_xtc.sl" version 69 successfully loaded

shared lib "dw_stl.sl" version 69 successfully loaded

shared lib "dw_gui.sl" version 69 successfully loaded

shared lib "dw_mdm.sl" version 69 successfully loaded

rdisp/softcancel_sequence : -> 0,5,-1

use internal message server connection to port 3900

Mon Jun 14 13:28:03 2010

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

DpSysAdmExtInit: VMC (JAVA VM in WP) is not active

DpIPCInit2: start server >V02ITGDBO001_VLL_00 <

DpShMCreate: sizeof(wp_adm) 31536 (1752)

DpShMCreate: sizeof(tm_adm) 6009216 (29896)

DpShMCreate: sizeof(wp_ca_adm) 28800 (96)

DpShMCreate: sizeof(appc_ca_adm) 9600 (96)

DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552064/552080

DpShMCreate: sizeof(comm_adm) 552080 (1088)

DpSlockTableSize: max/headSize/ftSize/fiSize/tableSize=0/0/0/0/0

DpShMCreate: sizeof(slock_adm) 0 (104)

DpFileTableSize: max/headSize/ftSize/tableSize=0/0/0/0

DpShMCreate: sizeof(file_adm) 0 (72)

DpShMCreate: sizeof(vmc_adm) 0 (2008)

DpShMCreate: sizeof(wall_adm) (41664/36752/80/192)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 0xc000000010000000, size: 6718992)

DpShMCreate: allocated sys_adm at 0xc000000010000000

DpShMCreate: allocated wp_adm at 0xc000000010002310

DpShMCreate: allocated tm_adm_list at 0xc000000010009e40

DpShMCreate: allocated tm_adm at 0xc000000010009ea0

DpShMCreate: allocated wp_ca_adm at 0xc0000000105c5020

DpShMCreate: allocated appc_ca_adm at 0xc0000000105cc0a0

DpShMCreate: allocated comm_adm at 0xc0000000105ce620

DpShMCreate: system runs without slock table

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 0xc0000000106552b0

DpShMCreate: allocated gw_adm at 0xc000000010655330

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 0xc000000010655360

DpShMCreate: allocated wall_adm at 0xc000000010655370

MBUF state OFF

DpCommInitTable: init table for 500 entries

***LOG Q0I=> NiPGetHostByName: hostname 'localhost' not found: gethostbyname [niuxi.c 1477]

ERROR => NiGetLoopbackAddr: NiIGetNodeAddr failed (rc=-2) [nixx.c 1894]

rdisp/queue_size_check_value : -> off

ThTaskStatus: rdisp/reset_online_during_debug 0

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 4096 kByte.

Using implementation std

<ES> Info: use normal pages (no huge table support available)

EsStdUnamFileMapInit: ES base = 0x0xc000000580000000

EsStdInit: Extended Memory 4092 MB allocated

<ES> 1022 blocks reserved for free list.

ES initialized.

mm.dump: set maximum dump mem to 96 MB

ERROR => NiDgHdlBindName: invalid hostname 'localhost' (rc=-2;hdl 0) [nixx.c 3659]
ERROR => DpCommInit: NiDgHdlBindName failed: -8 [dpxxdisp.c 10162]
DP_FATAL_ERROR => DpSapEnvInit: DpCommInit
DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=9

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jun 14 13:28:13 2010

NiISelect: TIMEOUT occured (10000ms)

dump system status

Workprocess Table (long) Mon Jun 14 07:58:13 2010

========================

No Ty. Pid Status Cause Start Err Sem CPU Time Program Cl User Action Table

0 DIA -1 Run no 0 0 0

1 DIA -1 Run no 0 0 0

2 DIA -1 Run no 0 0 0

3 DIA -1 Run no 0 0 0

4 DIA -1 Run no 0 0 0

5 DIA -1 Run no 0 0 0

6 DIA -1 Run no 0 0 0

7 DIA -1 Run no 0 0 0

8 UPD -1 Run no 0 0 0

9 UPD -1 Run no 0 0 0

10 ENQ -1 Run no 0 0 0

11 ENQ -1 Run no 0 0 0

12 BTC -1 Run no 0 0 0

13 BTC -1 Run no 0 0 0

14 SPO -1 Run no 0 0 0

15 SPO -1 Run no 0 0 0

16 UP2 -1 Run no 0 0 0

17 UP2 -1 Run no 0 0 0

Dispatcher Queue Statistics Mon Jun 14 07:58:13 2010

===========================

--------

+
+
+
+--

Typ

now

high

max

writes

reads

--------

+
+
+
+--

NOWP

2000

--------

+
+
+
+--

DIA

2000

--------

+
+
+
+--

UPD

2000

--------

+
+
+
+--

ENQ

2000

--------

+
+
+
+--

BTC

2000

--------

+
+
+
+--

SPO

2000

--------

+
+
+
+--

UP2

2000

--------

+
+
+
+--

max_rq_id 0

wake_evt_udp_now 0

wake events total 0, udp 0 ( 0%), shm 0 ( 0%)

since last update total 0, udp 0 ( 0%), shm 0 ( 0%)

Dump of tm_adm structure: Mon Jun 14 07:58:13 2010

=========================

Term uid man user term lastop mod wp ta a/i (modes)

Workprocess Comm. Area Blocks Mon Jun 14 07:58:13 2010

=============================

Slots: 300, Used: 0, Max: 0

--------

+
+--

owner

pid

eyecatcher

--------

+
+--

NiWait: sleep (5000ms) ...

NiISelect: timeout 5000ms

NiISelect: maximum fd=9

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jun 14 13:28:18 2010

NiISelect: TIMEOUT occured (5000ms)

DpHalt: shutdown server >V02ITGDBO001_VLL_00 < (normal)

DpJ2eeDisableRestart

Switch off Shared memory profiling

ShmProtect( 57, 3 )

ShmProtect( key 57 valid )

ShmProtect( slot Index 56 )

ShmProtect( Mode: 0 )

ShmProtect( before shmdt )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 57 prot 3/0 done

ShmProtect(SHM_PROFILE, SHM_PROT_RW

ShmProtect( 57, 1 )

ShmProtect( key 57 valid )

ShmProtect( slot Index 56 )

ShmProtect( Mode: 0 )

ShmProtect( before shmdt )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 57 prot 1/4096 done

ShmProtect(SHM_PROFILE, SHM_PROT_RD

DpWakeUpWps: wake up all wp's

kill(-1,0) successful -> process alive

Stop work processes

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=9

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jun 14 13:28:19 2010

NiISelect: TIMEOUT occured (1000ms)

wait for end of exclusive shutdown

NiWait: sleep (1000ms) ...

NiISelect: timeout 1000ms

NiISelect: maximum fd=9

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Mon Jun 14 13:28:20 2010

NiISelect: TIMEOUT occured (1000ms)

Terminate gui connections

wait for end of work processes

not attached to the message server

cleanup EM

EsCleanup ....

EmCleanup() -> 0

Es2Cleanup: Cleanup ES2

ShmCreate( 76, 0, 2, 0x0x6000000002b8ada8 )

ShmKeyPermission( 76 ) = 0740 (octal)

cleanup event management

cleanup shared memory/semaphores

ShmCleanup SHM_SYS_ADM_KEY

ShmCleanup( 1 )

ShmCreate( 1, 0, 2, 0x0x9fffffffffffe370 )

ShmProtect( 1, 3 )

ShmProtect( key 1 valid )

ShmProtect( slot Index 0 )

ShmProtect( Mode: 0 )

ShmProtect( before shmdt )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 1 prot 3/0 done

ShmCreate( 1, 0, 2, -> 0x0xc000000000502000 )

ShmCleanup SHM_DP_ADM_KEY

ShmCleanup( 2 )

ShmCreate( 2, 0, 2, 0x0x9fffffffffffe370 )

ShmProtect( 2, 3 )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 3 prot 3/0 done

ShmCreate( 3, 0, 2, -> 0x0xc000000010800000 )

ShmCleanup SHM_PF_KEY

ShmCleanup( 4 )

ShmCreate( 4, 0, 2, 0x0x9fffffffffffe370 )

ShmKeyPermission( 4 ) = 0740 (octal)

ShmCleanup SHM_PRES_BUF

ShmCleanup( 14 )

ShmCreate( 14, 0, 2, 0x0x9fffffffffffe370 )

)

ShmCleanup SHM_DB_TTBUFF

ShmCleanup( 42 )

)

ShmKeyPermission( 40 ) = 0740 (octal)

ShmCleanup SHM_DB_IRBUFF

ShmCleanup( 44 )

ShmCreate( 44, 0, 2, 0x0x9fffffffffffe370 )

ShmGet( 40, 44, 0, 2, 0x0x9fffffffffffe2b8 )

ShmCreate( 40, 0, 2, 0x0x9fffffffffffe198 )

ShmKeyPermission( 40 ) = 0740 (octal)

ShmCleanup SHM_DB_OBJ_BUFFER

ShmCleanup( 54 )

)

ShmKeyPermission( 64 ) = 0740 (octal)

ShmCleanup SHM_DB_ESM_BUFFER

)

ShmCleanup SHM_PAGING_ADM_KEY

ShmCleanup( 18 )

ShmCreate( 18, 0, 2, 0x0x9fffffffffffe370 )

ShmKeyPermission( 18 ) = 0740 (octal)

ShmCleanup SHM_PXA_KEY

ShmCleanup( 6 )

ShmCreate( 6, 0, 2, 0x0x9fffffffffffe370 )

ShmKeyPermission( 6 ) = 0740 (octal)

ShmCleanup SHM_ENQ_TABLE_KEY

ShmCleanup( 34 )

ShmCreate( 34, 0, 2, 0x0x9fffffffffffe370 )

ShmProtect( slot Index 50 )

)

ShmProtect( after shmat )

ShmProtect: shmat key 57 prot 3/0 done

ShmCreate( 57, 0, 2, -> 0x0xc00000000a500000 )

ShmCleanup SHM_NO_BUFFER

ShmCleanup( 48 )

ShmCreate( 48, 0, 2, 0x0x9fffffffffffe370 )

ShmGet( 40, 48, 0, 2, 0x0x9fffffffffffe2b8 )

ShmCreate( 40, 0, 2, 0x0x9fffffffffffe198 )

ShmKeyPermission( 40 ) = 0740 (octal)

removing request queue

ShmProtect( slot Index 9 )

ShmProtect( Mode: 124000000 )

ShmCreate( 10, 0, 2, -> 0x0xc000000018000000 )

ShmCleanup SHM_DB_POOL

ShmCleanup( 40 )

ShmCreate( 40, 0, 2, 0x0x9fffffffffffe370 )

ShmKeyPermission( 40 ) = 0740 (octal)

ShmCleanup SHM_POOL_50

ShmCleanup( 50 )

ShmCreate( 50, 0, 2, 0x0x9fffffffffffe370 )

ShmKeyPermission( 50 ) = 0740 (octal)

MiCleanup:

ShmCleanup( 62 )

ShmCreate( 62, 0, 2, 0x0x9fffffffffffe370 )

ShmProtect( 62, 3 )

ShmProtect( key 62 valid )

ShmProtect( slot Index 61 )

ShmProtect( Mode: 0 )

ShmProtect( before shmdt )

ShmProtect( after shmdt )

ShmProtect( before shmat )

ShmProtect( after shmat )

ShmProtect: shmat key 62 prot 3/0 done

ShmCreate( 62, 0, 2, -> 0x0xc000000020000000 )

MpiCleanup() -> 0

SemKeyPermission( 1 ) = 0740 (octal)

SemKeyPermission( 6 ) = 0740 (octal)

SemKeyPermission( 72 ) = 0740 (octal)

removing Semaphore-Management

closing connect handles (dgm + tcp)

***LOG Q05=> DpHalt, DPStop ( 2734) [dpxxdisp.c 11428]

shutdown completed - server stopped ***

Good Bye .....

I have also tried giving full path to Instance profile .but same error.

Regards,

sandhya.

Hello,

check you network configuration:

/etc/hosts entries

full qualified hostnames

name resolution

Are all configurations correct?

Kind Regards

Franz

Yeh ,

I have checked all configurations ,i mean host file entries have been made.....................and IP address ..everything is correct.

Actually according to our IT team .DNS was changed and when i asked them to check ,they said everything is working fine.

Can you please tell me if there is anything else in UNIX server i need to check apart from /etc/host files and /etc/services file.

Is this error relatedto shared memory????Please find the dev_ms log :

Thr 1] Mon Jun 14 13:27:59 2010

[Thr 1] MsSSetTrcLog: trc logging active, max size = 20971520 bytes

systemid 274 (HP (IA-64) with HP-UX)

relno 7010

patchlevel 0

patchno 63

intno 20020600

make: multithreaded, Unicode, 64 bit, optimized

pid 2733

*[Thr 1] **LOG Q01=> MsSInit, MSStart (Msg Server 1 2733) [msxxserv_mt. 1847]

[Thr 1] SigISetDefaultAction : default handling for signal 18

[Thr 1] load acl file = /usr/sap/VLL/SYS/global/ms_acl_info

*[Thr 1] **LOG Q0I=> NiPGetHostByName2: hostname 'localhost' not found: gethostbyname_r [niuxi.c 1536]

[Thr 1] MsGetOwnIpAddr: my host addresses are :

[Thr 1] 1 : [172.17.3.121] V02ITGDBO001.vimtalabs.com (HOSTNAME)

[Thr 1] Mon Jun 14 13:28:00 2010

[Thr 1] 2 : [127.0.0.1] 127.0.0.1 (NILIST)

[Thr 1] 3 : [172.17.8.68] 172.17.8.68 (NILIST)

[Thr 1] 4 : [172.17.6.68] 172.17.6.68 (NILIST)

[Thr 1] 5 : [172.17.7.68] 172.17.7.68 (NILIST)

[Thr 1] MsHttpInit: full qualified hostname = V02ITGDBO001.vimtalabs.com

[Thr 1] HTTP logging is switch off

[Thr 1] set HTTP state to LISTEN

[Thr 1] MsHttpOwnDomain: own domain[1] = vimtalabs.com

[Thr 1] ms/icf_info_server : deleted

*[Thr 1] *** I listen to port sapmsVLL (3600) ****

*[Thr 1] *** I listen to internal port 3900 (3900) ****

*[Thr 1] *** HTTP port 8100 state LISTEN ****

[Thr 1] CUSTOMER KEY: >B1002238914<

[Thr 1] build version=701.2009.03.11

[Thr 1] Mon Jun 14 13:38:57 2010

*[Thr 1] *** ERROR => MsSCheckConnections: no response from client C0 (127.0.0.1) after 300 secs received [msxxserv_mt. 3200]*

*[Thr 1] *** ERROR => MsSCheckConnections: disconnect now [127.0.0.1] [msxxserv_mt. 3207]*

Regards,

sandhya..

Hi,

execute r3trans -d and post the trans.log

excecute ping localhost

Kind Regards

Franz

Hi,

Following are the return codes of ;

1) ping localhost

ping: unknown host localhost

2) R3trans -d

This is R3trans version 6.14 (release 701 - 12.06.09 - 15:20:00).

unicode enabled version

R3trans finished (0000).

sandhya...

Hi,

check /etc/hosts. Is there an entry localhost 127.0.0.1 ?

could you ping 127.0.0.1 ? If not ask your Systemadmin how to configure it. I'am not very experienced with HPUX.

Franz

Hi Please find the trans.log

4 ETW000 R3trans version 6.14 (release 701 - 12.06.09 - 15:20:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000 date&time : 14.06.2010 - 17:17:27

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Mon Jun 14 17:17:27 2010 264 0.000264

4 ETW000 [dev trc ,00000] db_con_init called 24 0.000288

4 ETW000 [dev trc ,00000] create_con (con_name=R/3) 125 0.000413

4 ETW000 [dev trc ,00000] Loading DB library '/usr/sap/VLL/SYS/exe/run/dboraslib.so' ... 34 0.000447

4 ETW000 [dev trc ,00000] DlLoadLib() success: dlopen("/usr/sap/VLL/SYS/exe/run/dboraslib.so"), hdl 0

4 ETW000 31425 0.031872

4 ETW000 [dev trc ,00000] Library '/usr/sap/VLL/SYS/exe/run/dboraslib.so' loaded 19 0.031891

4 ETW000 [dev trc ,00000] function DbSlExpFuns loaded from library /usr/sap/VLL/SYS/exe/run/dboraslib.so

4 ETW000 57 0.031948

4 ETW000 [dev trc ,00000] Version of '/usr/sap/VLL/SYS/exe/run/dboraslib.so' is "700.08", patchlevel (0.42)

4 ETW000 257 0.032205

4 ETW000 [dev trc ,00000] function dsql_db_init loaded from library /usr/sap/VLL/SYS/exe/run/dboraslib.so

4 ETW000 42 0.032247

4 ETW000 [dev trc ,00000] function dbdd_exp_funs loaded from library /usr/sap/VLL/SYS/exe/run/dboraslib.so

4 ETW000 48 0.032295

4 ETW000 [dev trc ,00000] New connection 0 created 42 0.032337

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = -000000001, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 51 0.032388

4 ETW000 [dev trc ,00000] db_con_connect (con_name=R/3) 32 0.032420

4 ETW000 [dev trc ,00000] find_con_by_name found the following connection for reuse: 15 0.032435

4 ETW000 [dev trc ,00000] 000: name = R/3, con_id = 000000000, state = DISCONNECTED, tx = NO , hc = NO , perm = YES,

4 ETW000 reco = NO , frco = NO , timeout = 000, con_max = 255, con_opt = 255, occ = NO

4 ETW000 41 0.032476

4 ETW000 [dev trc ,00000] Oracle Client Version: '10.2.0.1.0' 565 0.033041

4 ETW000 [dev trc ,00000] -->oci_initialize(con_hdl=0, char='', nchar='') 29 0.033070

4 ETW000 [dev trc ,00000] application info callback registered 17 0.033087

4 ETW000 [dev trc ,00000] OCIEnvCreate(mode=16384=OCI_UTF16) returned 0 (for default NLS handle)

4 ETW000 5096 0.038183

4 ETW000 [dev trc ,00000] Client character set UTF16 -> UTF8 331 0.038514

4 ETW000 [dev trc ,00000] Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.UTF8'

4 ETW000 31 0.038545

4 ETW000 [dev trc ,00000] charset='', chset='UTF8', UNI_ASC=FALSE/FALSE 81 0.038626

4 ETW000 [dev trc ,00000] Logon as OPS$-user to get SAPVLL's password 34 0.038660

4 ETW000 [dev trc ,00000] Connecting as /@VLL on connection 0 (nls_hdl 0) ... (dbsl 701 220409)

4 ETW000 34 0.038694

4 ETW000 [dev trc ,00000] Nls CharacterSet NationalCharSet EnvHp ErrHp ErrHpBatch

4 ETW000 39 0.038733

4 ETW000 [dev trc ,00000] 0 UTF8 0x60000000010edc60 0x60000000010f5590 0x6000000001105f28

4 ETW000 29 0.038762

4 ETW000 [dev trc ,00000] Allocating service context handle for con_hdl=0 35 0.038797

4 ETW000 [dev trc ,00000] Allocating server context handle 18 0.038815

4 ETW000 [dev trc ,00000] Attaching to DB Server VLL (con_hdl=0,svchp=0x6000000001105e58,srvhp=0x6000000001109488)

4 ETW000 33 0.038848

4 ETW000 [dev trc ,00000] Assigning server context 0x6000000001109488 to service context 0x6000000001105e58

4 ETW000 53812 0.092660

4 ETW000 [dev trc ,00000] Allocating user session handle 85 0.092745

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=0x6000000001105e58, srvhp=0x6000000001109488, usrhp=0x60000000010f5da8)

4 ETW000 36 0.092781

4 ETW000 [dev trc ,00000] Assigning user session 0x60000000010f5da8 to service context 0x6000000001105e58

4 ETW000 8145 0.100926

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=52, stmth_p=0x6000000001111c00) 103 0.101029

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_MODULE(:A0,:A1);END;

4 ETW000 31 0.101060

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x6000000001112c58) 23 0.102824

4 ETW000 [dev trc ,00000] ALTER SESSION SET NLS_SORT = BINARY

4 ETW000 35 0.103259

4 ETW000 [dev trc ,00000] Got SAPVLL's password from OPS$-user 557 0.103816

4 ETW000 [dev trc ,00000] Disconnecting from connection 0 ... 21 0.103837

4 ETW000 [dev trc ,00000] Rolling back transaction ... 32 0.103869

4 ETW000 [dev trc ,00000] Closing user session (con_hdl=0,svchp=0x6000000001105e58,usrhp=0x60000000010f5da8)

4 ETW000 149 0.104018

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 449 0.104467

4 ETW000 [dev trc ,00000] Connecting as SAPVLL/<pwd>@VLL on connection 0 (nls_hdl 0) ... (dbsl 701 220409)

4 ETW000 [dev trc ,00000] Assigning username to user session: con_hdl=0, usrhp=0x60000000010f5da8

4 ETW000 26 0.104584

4 ETW000 [dev trc ,00000] Assigning password to user session: con_hdl=0, usrhp=0x60000000010f5da8

4 ETW000 33 0.104617

4 ETW000 [dev trc ,00000] Starting user session: OCISessionBegin(con_hdl=0, usr=SAPVLL/<pwd>, svchp=0x6000000001105e58, srvhp=0x6000000001109488, usrhp=0x60000000010f5da8)

4 ETW000 42 0.104659

4 ETW000 [dev trc ,00000] BEGIN DBMS_APPLICATION_INFO.SET_CLIENT_INFO(:A0); END;

4 ETW000 [dev trc ,00000] Database NLS settings: AMERICAN_AMERICA.UTF8 274 0.109579

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x6000000001111c00) 774 0.110353

4 ETW000 [dev trc ,00000] SELECT UPPER(INSTANCE_NAME),HOST_NAME,VERSION,TO_CHAR(STARTUP_TIME,'MON DD, YYYY, HH24:MI:SS') FROM V$INSTANCE

4 ETW000 41 0.110394

4 ETW000 [dev trc ,00000] DB instance VLL is running on V02ITGDB with ORACLE version 10.2.0.4.0 since JUN 14, 2010, 13:27:22

4 ETW000 295 0.110689

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=0, stmth_p=0x6000000001111c00) 23 0.110712

4 ETW000 [dev trc ,00000] SELECT SUBSTR(NAME,1,3), TO_CHAR(CREATED,'YYYYMMDDHHMMSS') FROM V$DATABASE

4 ETW000 29 0.110741

4 ETW000 [dev trc ,00000] Connection 0 opened (DBSL handle 0) 968 0.111709

4 ETW000 [dev trc ,00000] build_stmt: reallocating stmt buffer: 256 -> 2000 characters 3772 0.115481

4 ETW000 [dev trc ,00000] -->oci_prepare_stmt(con_hdl=0, len=26, stmth_p=0x6000000001111c00) 56 0.115537

4 ETW000 [dev trc ,00000] SELECT VERSION FROM SVERS

4 ETW000 29 0.115566

4 ETW000 [dev trc ,00000] DbSlRead(): table='SVERS' 47 0.115613

4 ETW000 [dev trc ,00000] OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data 358 0.115971

4 ETW000 [dev trc ,00000] -> rc=1403=OCI_ERR_NOT_FOUND 22 0.115993

) 118 0.127388

4 ETW000 [dev trc ,00000] INSERT INTO "PATCHHIST" VALUES( :A0 , :A1 , :A2 , :A3 , :A4 , :A5 , :A6 , :A7 )

4 ETW000 30 0.127418

4 ETW000 [dev trc ,00000] OCIStmtExecute() completed, rc=100=OCI_NO_DATA, no further data 241 0.127659

4 ETW000 [dev trc ,00000] Now I'm disconnected from ORACLE 637 0.001660

4 ETW000 [dev trc ,00000] Disconnected from connection 0 22 0.001682

4 ETW000 [dev trc ,00000] statistics db_con_commit (com_total=1, com_tx=1) 43 0.001725

4 ETW000 [dev trc ,00000] statistics db_con_rollback (roll_total=0, roll_tx=0) 48 0.001773

4 ETW000 Disconnected from database.

4 ETW000 End of Transport (0000).

4 ETW000 date&time: 14.06.2010 - 17:17:27

Hey Franz,

I am able to ping 127.0.01 and yes there is an entry in /etc/host with

127.0.0.1 localhost loopback.

Regards,

Sandhya

Hi,

the system should be able to resovle localhost. I think that is the problem.

Kind Regards

Franz

Edited by: Franz Hiltscher on Jun 14, 2010 2:15 PM

Thanks Franz,

I have updated the same to my Network manager.

Hopefully my issue should be resolved.

I will update you the same once done.

Regards,

sandhya.

Hi ,

We still are facing the same issue with our UNIX server.

But that "localhost" resolution is not yet solved and our IT team are still looking into it.

But i am facing another issue in same server,when i execute "saplicense -get"

following is output :

saplicense -show

LICENSE system: VLL hardware key: TEMPLICENSE expiration_date: 20100415

installation no: INITIAL key: CT1XSO7OYOFMUXIVYUWDWVBT

userlimit: 0 productid: R3_ORA

system-nr: INITIAL_SYSTEM_IDX

license expired *

Is this could be reason of dispatcher not getting up???I have applied permanent but how come its showing "expired" is this the

"maintainance certificate".

Regards,

Sandhya

License issue should not prevent dispatcher from starting up.

License issue only affect user logon, as license check will be enforced during logon (except sap* user)

For your instance, check following:

- sappfpar check pf=<instance profile>

if there is any error on SHM key, fine tuning it

- Removing shared memory from an SAP instance that terminated:

+ Find out which instance number was involved

+ Is this instance really no longer running?

+ Use SAP command showipc <instance number> to check

+ Use SAP command cleanipc <instance number> remove

or cleanipc <instance number>

- Check whether other shared memory segments can be deleted:

Use UNIX command ipcs -m or ipcs -a -m

to view the list of all shared memory segments.