Dispatcher Emergency Shutdown

[former_member681001]

Dear Guri Please Help!!!

I have checked DB consistency...
what else can i do

Tue Dec 24 17:59:17 2013

*** WARNING => DpNetCheck: NiAddrToHost(1.0.0.0) took 5 seconds

***LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings [dpxxtool2.c  5273]

MtxInit: 30000 0 0

DpSysAdmExtInit: ABAP is active

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

DpIPCInit2: start server >saptestserver_TST_00                    <

DpShMCreate: sizeof(wp_adm) 18304 (1408)

DpShMCreate: sizeof(tm_adm) 3994272 (19872)

DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

DpShMCreate: sizeof(comm_adm) 528064 (1048)

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

DpShMCreate: sizeof(file_adm) 0 (72)

DpShMCreate: sizeof(vmc_adm) 0 (1440)

DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

DpShMCreate: sizeof(gw_adm) 48

DpShMCreate: SHM_DP_ADM_KEY (addr: 05DF0040, size: 4653368)

DpShMCreate: allocated sys_adm at 05DF0040

DpShMCreate: allocated wp_adm at 05DF1E40

DpShMCreate: allocated tm_adm_list at 05DF65C0

DpShMCreate: allocated tm_adm at 05DF65F0

DpShMCreate: allocated wp_ca_adm at 061C5890

DpShMCreate: allocated appc_ca_adm at 061CB650

DpShMCreate: allocated comm_adm at 061CD590

DpShMCreate: system runs without file table

DpShMCreate: allocated vmc_adm_list at 0624E450

DpShMCreate: allocated gw_adm at 0624E490

DpShMCreate: system runs without vmc_adm

DpShMCreate: allocated ca_info at 0624E4C0

DpShMCreate: allocated wall_adm at 0624E4C8

Tue Dec 24 17:59:18 2013

MBUF state OFF

DpCommInitTable: init table for 500 entries

Tue Dec 24 17:59:20 2013

EmInit: MmSetImplementation( 2 ).

MM global diagnostic options set: 0

<ES> client 0 initializing ....

<ES> InitFreeList

<ES> block size is 1024 kByte.

Using implementation flat

<EsNT> Memory Reset disabled as NT default

<ES> 511 blocks reserved for free list.

ES initialized.

Tue Dec 24 17:59:26 2013

rdisp/http_min_wait_dia_wp : 1 -> 1

***LOG CPS=> DpLoopInit, ICU ( 3.0 3.0 4.0.1) [dpxxdisp.c   1623]

Tue Dec 24 17:59:31 2013

***LOG Q0K=> DpMsAttach, mscon ( saptestserver) [dpxxdisp.c   11586]

DpStartStopMsg: send start message (myname is >saptestserver_TST_00                    <)

DpStartStopMsg: start msg sent

Tue Dec 24 17:59:32 2013

CCMS: AlInitGlobals : alert/use_sema_lock = TRUE.

Tue Dec 24 17:59:33 2013

CCMS: Initalizing shared memory of size 60000000 for monitoring segment.

Tue Dec 24 18:00:39 2013

CCMS: start to initalize 3.X shared alert area (first segment).

Tue Dec 24 18:00:43 2013

DpMsgAdmin: Set release to 7000, patchlevel 0

MBUF state PREPARED

Tue Dec 24 18:00:44 2013

MBUF component UP

DpMBufHwIdSet: set Hardware-ID

***LOG Q1C=> DpMBufHwIdSet [dpxxmbuf.c   1050]

DpMsgAdmin: Set patchno for this platform to 75

Release check o.K.

Tue Dec 24 18:02:20 2013

*** ERROR => W9 (pid 884) died [dpxxdisp.c   14241]

*** ERROR => W11 (pid 1444) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xbf --> 0xaf

Tue Dec 24 18:02:40 2013

*** ERROR => W10 (pid 996) died [dpxxdisp.c   14241]

Tue Dec 24 18:03:00 2013

*** ERROR => W0 (pid 1888) died [dpxxdisp.c   14241]

*** ERROR => W1 (pid 812) died [dpxxdisp.c   14241]

*** ERROR => W2 (pid 988) died [dpxxdisp.c   14241]

*** ERROR => W3 (pid 152) died [dpxxdisp.c   14241]

*** ERROR => W4 (pid 940) died [dpxxdisp.c   14241]

*** ERROR => W5 (pid 288) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xaf --> 0xae

*** ERROR => W6 (pid 952) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xae --> 0xac

*** ERROR => W7 (pid 692) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xac --> 0xa8

*** ERROR => W8 (pid 688) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xa8 --> 0xa0

*** ERROR => W12 (pid 1168) died [dpxxdisp.c   14241]

my types changed after wp death/restart 0xa0 --> 0x80

*** DP_FATAL_ERROR => DpWPCheck: no more work processes

*** DISPATCHER EMERGENCY SHUTDOWN ***

increase tracelevel of WPs

NiWait: sleep (10000ms) ...

NiISelect: timeout 10000ms

NiISelect: maximum fd=1649

NiISelect: read-mask is NULL

NiISelect: write-mask is NULL

Tue Dec 24 18:03:10 2013

[former_member681001 · Accepted solution]

i simply restore the database...and it worked....now connected to SAP.

Thanx to all

[former_member681001]

Dear All .... R3trans -d is working well and Sql is in open state;lsnrctl is in "start" status
sap<sid>service and saposcol ..both i have restarted
i have done--the parameter change in default.pfl i.e.- dbs\mss\schema but didnt worked so removed it.
Instane name is showing correctly in
sql>select instance_name from V$instance;
INSTANCE_NAME
-----------------------------------
tst

but not lucky to resolve

Thanx to all

[Reagan]

sqlplus "/as sysdba"

select name, open_mode from v$database;

Output please

Regards

RB

[Former Member]

In addition to the above output as requested , can you tell what is the message shown in the dev_disp file when you are starting up SAP ?

Also are you still getting this message as posted in the initial question : LOG GZZ=> 1 possible network problems detected - check tracefile and adjust the DNS settings ?

Thanks

Rishi

Message was edited by: Rishi Das

[former_member681001]

NAME                                     OPEN_MODE

-----------------------------------------     ----------------------------------

TST                                             READ WRITE

[Former Member]

Also as mentioned by you - was there any recent changes done in the system after which you are facing the problem ?  Was there some parameter change ?

Thanks

Rishi

[Reagan]

If R3trans -d is successful then stop the database.

Restart the Windows system

Start Oracle services including the Listener

Start SAP.

If SAP fails to start provide dev_w0, dev_disp.

Did you do any modifications to the system until this issue occurred (like kernel patching) ?

Regards

RB

[former_member185239]

Hi Kool,

Follow the below steps

1. Stop your database

2. Start the database

3. Check the aler logs.

With Regards

Ashutosh Chaturvedi

[Former Member]

Hi

From the details of the issue pasted above -

LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress

looks like the DB is not okay when you are observing the above.

First check if the DB is open and running -  select instance_name , status from v$instance;

Also check the alert log for any issues -

If it is OPEN , then check if listener is running and if it is listening to the service for your SID.

lsnrctl status

if both above are okay - then check R3trans -d .   This needs to be working fine.

If yes , then ensure that all SAP Processes are clean and then do a fresh start of SAP .   Run cleanipc before starting up SAP.

Also from your initial post - LOG GZZ=> 1 possible network problems detected

Please check if DNS hostnames are getting resolved fine at the OS level .. as sometimes the SAP connection to the DB fails due to network issues.

Thanks

Rishi

[Former Member]

Is your database in "OPEN" state?If its "OPEN" state ensure your listener is running too,and you are able to TNSPING your database.

Regards

[former_member681001]

database is in open state sir..and lsnrctl is okay

[Former Member]

Hi

What is the output of R3trans -d ? Is it working fine ?

Thanks

Rish

[Reagan]

sqlplus "/as sysdba"

select name, open_mode from v$database;

Output please

Regards

RB

[Reagan]

Execute R3trans -d under sidadm and check the trans.log file.

Provide dev_w0 log file

Regards

RB

[former_member681001]

Tue Dec 24 17:59:59 2013

B  create_con (con_name=R/3)

B  Loading DB library 'H:\usr\sap\TST\DVEBMGS00\exe\dboraslib.dll' ...

B 

B Tue Dec 24 18:00:00 2013

B  Library 'H:\usr\sap\TST\DVEBMGS00\exe\dboraslib.dll' loaded

B  Version of 'H:\usr\sap\TST\DVEBMGS00\exe\dboraslib.dll' is "700.08", patchlevel (0.73)

B  New connection 0 created

M sysno      00

M sid        TST

M systemid   560 (PC with Windows NT)

M relno      7000

M patchlevel 0

M patchno    75

M intno      20050900

M make:      multithreaded, Unicode, optimized

M pid        1888

M

M  kernel runs with dp version 217000(ext=109000) (@(#) DPLIB-INT-VERSION-217000-UC)

M  length of sys_adm_ext is 572 bytes

M  ***LOG Q0Q=> tskh_init, WPStart (Workproc 0 1888) [dpxxdisp.c   1299]

I 

I Tue Dec 24 18:00:02 2013

I  MtxInit: 30000 0 0

M 

M Tue Dec 24 18:00:03 2013

M  DpSysAdmExtCreate: ABAP is active

M  DpSysAdmExtCreate: VMC (JAVA VM in WP) is not active

M  DpShMCreate: sizeof(wp_adm) 18304 (1408)

M  DpShMCreate: sizeof(tm_adm) 3994272 (19872)

M  DpShMCreate: sizeof(wp_ca_adm) 24000 (80)

M  DpShMCreate: sizeof(appc_ca_adm) 8000 (80)

M  DpCommTableSize: max/headSize/ftSize/tableSize=500/8/528056/528064

M  DpShMCreate: sizeof(comm_adm) 528064 (1048)

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

M  DpShMCreate: sizeof(file_adm) 0 (72)

M  DpShMCreate: sizeof(vmc_adm) 0 (1440)

M  DpShMCreate: sizeof(wall_adm) (38456/34360/64/184)

M  DpShMCreate: sizeof(gw_adm) 48

M  DpShMCreate: SHM_DP_ADM_KEY (addr: 05DF0040, size: 4653368)

M  DpShMCreate: allocated sys_adm at 05DF0040

M  DpShMCreate: allocated wp_adm at 05DF1E40

M  DpShMCreate: allocated tm_adm_list at 05DF65C0

M  DpShMCreate: allocated tm_adm at 05DF65F0

M  DpShMCreate: allocated wp_ca_adm at 061C5890

M  DpShMCreate: allocated appc_ca_adm at 061CB650

M  DpShMCreate: allocated comm_adm at 061CD590

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 0624E450

M  DpShMCreate: allocated gw_adm at 0624E490

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated ca_info at 0624E4C0

M  DpShMCreate: allocated wall_adm at 0624E4C8

X 

X Tue Dec 24 18:00:13 2013

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X 

X Tue Dec 24 18:00:16 2013

X  <ES> client 0 initializing ....

X 

X Tue Dec 24 18:00:18 2013

X  Using implementation flat

M  <EsNT> Memory Reset disabled as NT default

X  ES initialized.

M 

M Tue Dec 24 18:00:19 2013

M  ThInit: running on host saptestserver

M 

M Tue Dec 24 18:00:43 2013

M  calling db_connect ...

C  Prepending H:\usr\sap\TST\DVEBMGS00\exe to Path.

C 

C Tue Dec 24 18:01:41 2013

C  Oracle Client Version: '10.2.0.1.0'

C 

C Tue Dec 24 18:01:43 2013

C  Client NLS settings: AMERICAN_AMERICA.UTF8

C  Logon as OPS$-user to get SAPSR3's password

C  Connecting as /@TST on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      1   06377B38   0637D0D4   0637C95C

C  Attaching to DB Server TST (con_hdl=0,svchp=0637C8A8,svrhp=0638E174)

C 

C Tue Dec 24 18:02:48 2013

C  Starting user session (con_hdl=0,svchp=0637C8A8,srvhp=0638E174,usrhp=063A2BF8)

C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033

[dboci.c      4391]

C  Detaching from DB Server (con_hdl=0,svchp=0637C8A8,srvhp=0638E174)

C  *** ERROR => CONNECT failed with sql error '1033'

[dbsloci.c    10933]

C  Try to connect with default password

C  Connecting as SAPSR3/<pwd>@TST on connection 0 (nls_hdl 0) ... (dbsl 700 110706)

C  Nls CharacterSet                 NationalCharSet              C      EnvHp      ErrHp ErrHpBatch

C    0 UTF8                                                      1   06377B38   0637D0D4   0637C95C

C  Attaching to DB Server TST (con_hdl=0,svchp=0637C8A8,svrhp=0638E174)

C  Starting user session (con_hdl=0,svchp=0637C8A8,srvhp=0638E174,usrhp=063A2BF8)

C  *** ERROR => OCI-call 'OCISessionBegin' failed: rc = 1033

[dboci.c      4391]

C  Detaching from DB Server (con_hdl=0,svchp=0637C8A8,srvhp=0638E174)

C  *** ERROR => CONNECT failed with sql error '1033'

[dbsloci.c    10933]

B  ***LOG BV3=> severe db error 1033      ; work process is stopped [dbsh#2 @ 1199] [dbsh    1199 ]

B  ***LOG BY2=> sql error 1033   performing CON [dblink#3 @ 431] [dblink  0431 ]

B  ***LOG BY0=> ORA-01033: ORACLE initialization or shutdown in progress [dblink#3 @ 431] [dblink  0431 ]

M  ***LOG R19=> ThInit, db_connect ( DB-Connect 000256) [thxxhead.c   1411]

M  in_ThErrHandle: 1

M  *** ERROR => ThInit: db_connect (step 1, th_errno 13, action 3, level 1) [thxxhead.c   10156]

M 

M  Info for wp 0

M 

M    stat = 4

M    reqtype = 1

M    act_reqtype = -1

M    rq_info = 0

M    tid = -1

M    mode = 255

M    len = -1

M    rq_id = 65535

M    rq_source = 255

M    last_tid = 0

M    last_mode = 0

M    semaphore = 0

M    act_cs_count = 0

M    control_flag = 0

M    int_checked_resource(RFC) = 0

M    ext_checked_resource(RFC) = 0

M    int_checked_resource(HTTP) = 0

M    ext_checked_resource(HTTP) = 0

M    report = >                                        <

M    action = 0

M    tab_name = >                              <

M    vm = V-1

M 

M  *****************************************************************************

M  *

M  *  LOCATION    SAP-Server saptestserver_TST_00 on host saptestserver (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Tue Dec 24 18:02:48 2013

M  *  RELEASE     700

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        10354

M  *  COUNTER     1

M  *

M  *****************************************************************************

M 

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

M  *** ERROR => ThrSaveSPAFields: no valid thr_wpadm [thxxrun1.c   720]

M  *** ERROR => ThCallHooks: event handler ThrSaveSPAFields for event BEFORE_DUMP failed [thxxtool3.c  260]

M  Entering ThSetStatError

M  ThIErrHandle: do not call ThrCoreInfo (no_core_info=0, in_dynp_env=0)

M  Entering ThReadDetachMode

M  call ThrShutDown (1)...

M  ***LOG Q02=> wp_halt, WPStop (Workproc 0 1888) [dpnttool.c   327]

[jimguo]

Hi,

Please have a look at the following note and see if it helps:

655240 Composite SAP note: ORA-01033

Thanks.

Jim

[Reagan]

Hello

First start the database.

If the database doesn't start then check what the error is from the alert log.

Regards

RB

[RamanKorrapati]

Pls refer this thread - http://scn.sap.com/thread/1179605

Post your query at http://scn.sap.com/community/netweaver-administrator