Dispatcher stopped

[Former Member]

Hi,

Urgent help needed. I'm having problem to start my dispather disp+work.exe. for my PRD server.

The error log from dev_w0:

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

trc file: "dev_w0", trc level: 1, release: "700"

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

*

*  ACTIVE TRACE LEVEL           1

*  ACTIVE TRACE COMPONENTS      all, MJ

*

B 

B Fri Jan 10 01:05:26 2014

B  create_con (con_name=R/3)

B  Loading DB library 'D:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' ...

B  Library 'D:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' loaded

B  Version of 'D:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' is "700.08", patchlevel (0.205)

B  New connection 0 created

M sysno      00

M sid        PRD

M systemid   562 (PC with Windows NT)

M relno      7000

M patchlevel 0

M patchno    185

M intno      20050900

M make:      multithreaded, ASCII, 64 bit, optimized

M pid        5176

M

M  kernel runs with dp version 241(ext=110) (@(#) DPLIB-INT-VERSION-241)

M  length of sys_adm_ext is 364 bytes

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

I  MtxInit: 30000 0 0

M  DpSysAdmExtCreate: ABAP is active

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

M  DpShMCreate: sizeof(wp_adm) 29376 (1224)

M  DpShMCreate: sizeof(tm_adm) 5283968 (26288)

M  DpShMCreate: sizeof(wp_ca_adm) 18048 (60)

M  DpShMCreate: sizeof(appc_ca_adm) 6000 (60)

M  DpCommTableSize: max/headSize/ftSize/tableSize=500/16/552048/552064

M  DpShMCreate: sizeof(comm_adm) 552064 (1088)

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

M  DpShMCreate: sizeof(slock_adm) 0 (104)

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

M  DpShMCreate: sizeof(file_adm) 0 (72)

M  DpShMCreate: sizeof(vmc_adm) 0 (1616)

M  DpShMCreate: sizeof(wall_adm) (25648/36736/64/104)

M  DpShMCreate: sizeof(gw_adm) 48

M  DpShMCreate: SHM_DP_ADM_KEY (addr: 000000000FD20050, size: 5959424)

M  DpShMCreate: allocated sys_adm at 000000000FD20050

M  DpShMCreate: allocated wp_adm at 000000000FD21C90

M  DpShMCreate: allocated tm_adm_list at 000000000FD28F50

M  DpShMCreate: allocated tm_adm at 000000000FD28FB0

M  DpShMCreate: allocated wp_ca_adm at 0000000010233030

M  DpShMCreate: allocated appc_ca_adm at 00000000102376B0

M  DpShMCreate: allocated comm_adm at 0000000010238E20

M  DpShMCreate: system runs without slock table

M  DpShMCreate: system runs without file table

M  DpShMCreate: allocated vmc_adm_list at 00000000102BFAA0

M  DpShMCreate: allocated gw_adm at 00000000102BFB20

M  DpShMCreate: system runs without vmc_adm

M  DpShMCreate: allocated ca_info at 00000000102BFB50

M  DpShMCreate: allocated wall_adm at 00000000102BFB60

M 

M Fri Jan 10 01:05:27 2014

M  rdisp/queue_size_check_value :  -> off

M  ThTaskStatus: rdisp/reset_online_during_debug 0

X  EmInit: MmSetImplementation( 2 ).

X  MM global diagnostic options set: 0

X  <ES> client 0 initializing ....

X  Using implementation view

X  <EsNT> Using memory model view.

M  <EsNT> Memory Reset disabled as NT default

X  ES initialized.

X  mm.dump: set maximum dump mem to 96 MB

M  ThInit: running on host hmkapp03

M 

M Fri Jan 10 01:05:28 2014

M  calling db_connect ...

C  Prepending E:\oracle\PRD\102 to Path.

C  Oracle Client Version: '10.2.0.2.0'

C  application info callback registered

C  Client NLS setting (OCINlsGetInfo): connection handle 0 -> 'AMERICAN_AMERICA.WE8DEC'

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

C  Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 220409)

C  Nls CharacterSet                 NationalCharSet                   EnvHp      ErrHp ErrHpBatch

C    0 WE8DEC                                                    0000000009763C80 000000000976BEB0 000000000976EFF8

C  Attaching to DB Server PRD (con_hdl=0,svchp=000000000976EEB8,srvhp=00000000097712C8)

C  Starting user session: OCISessionBegin(con_hdl=0, usr='/',svchp=000000000976EEB8, srvhp=00000000097712C8, usrhp=000000000976C6C8)

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1033:

C     ORA-01033: ORACLE initialization or shutdown in progress                                                                 

C  Detaching from DB Server (con_hdl=0,svchp=000000000976EEB8,srvhp=00000000097712C8)

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

[dbsloci.c    11239]

C  Try to connect with default password

C  Connecting as SAPR3/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 700 220409)

C  Nls CharacterSet                 NationalCharSet                   EnvHp      ErrHp ErrHpBatch

C    0 WE8DEC                                                    0000000009763C80 000000000976BEB0 000000000976EFF8

C  Attaching to DB Server PRD (con_hdl=0,svchp=000000000976EEB8,srvhp=00000000097712C8)

C  Starting user session: OCISessionBegin(con_hdl=0, usr=SAPR3/<pwd>, svchp=000000000976EEB8, srvhp=00000000097712C8, usrhp=000000000976C6C8)

C     OCISessionBegin(OCI_DEFAULT) failed with SQL error 1033:

C     ORA-01033: ORACLE initialization or shutdown in progress                                                                 

C  Detaching from DB Server (con_hdl=0,svchp=000000000976EEB8,srvhp=00000000097712C8)

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

[dbsloci.c    11239]

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#5 @ 431] [dblink  0431 ]

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

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

M  in_ThErrHandle: 1

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

M 

M  Info for wp 0

M 

M    pid = 5176

M    severity = 0

M    status = 0

M    stat = WP_RUN

M    waiting_for = NO_WAITING

M    reqtype = DP_RQ_DIAWP

M    act_reqtype = NO_REQTYPE

M    rq_info = 0

M    tid = -1

M    mode = 255

M    len = -1

M    rq_id = 65535

M    rq_source =

M    last_tid = 0

M    last_mode = 0

M    semaphore = 0

M    act_cs_count = 0

M    csTrack = 0

M    csTrackRwExcl = 0

M    csTrackRwShrd = 0

M    mode_cleaned_counter = 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    attachedVm = no VM

M 

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

M  *

M  *  LOCATION    SAP-Server hmkapp03_PRD_00 on host hmkapp03 (wp 0)

M  *  ERROR       ThInit: db_connect

M  *

M  *  TIME        Fri Jan 10 01:05:28 2014

M  *  RELEASE     700

M  *  COMPONENT   Taskhandler

M  *  VERSION     1

M  *  RC          13

M  *  MODULE      thxxhead.c

M  *  LINE        10744

M  *  COUNTER     1

M  *

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

M 

M  PfStatDisconnect: disconnect statistics

M  Entering TH_CALLHOOKS

M  ThCallHooks: call hook >BtcCallLgCl< for event BEFORE_DUMP

M  ThCallHooks: call hook >ThrSaveSPAFields< for event BEFORE_DUMP

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

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

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 5176) [dpnttool.c   333]

I already tried to restart my Oracle, then start the SAP MMC. But still could not bring up the dispather.

I had checked the Oracle listener (ORACLEPRD102TNSListener) at windows services and its started.

I had run the R3trans -d also and result as below.

C:\WINDOWS\Application Compatibility Scripts\Logon\prdadm.HMKAPP03>R3trans -d

This is R3trans version 6.14 (release 700 - 16.10.08 - 16:26:00).

2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_o

ra_tnsname = 'PRD'"

R3trans finished (0012).

Appreciate your kind help.

Sri

[former_member184472]

Sorry this is not the right location for this question. Please try another forum. Thanks.