Dispatcher is not working all work process are in endded states.

[Former Member]

Hi ,

I Have SAP4.6C on my PC on a Windows 2000 server. Now when I start the SAP server from Windows 2000 the dispatcher starts and stops immediately. It shows following processes on the right side of the MMC:

strdbs.cmd started

msg_server.exe running

disp+work.exe stopped

And with the WPtable all 0-12 processes change from 'Run' to 'Ended' after some time. The server color changed to green. After some seconds, the dispatcher was automatically stopped and the server name changed to yellow.

I am also posting dev_w0 log file

Plz help me ...

-

---

trc file: "dev_w0", trc level: 1, release: "46D"

-

---

*

• ACTIVE TRACE LEVEL 1

• ACTIVE TRACE COMPONENTS all, M

*

B

B Fri Mar 02 07:16:31 2018

B create_con (con_name=R/3)

B Loading DB library 'E:\pusr\sap\PRD\SYS\exe\run\dboraslib.dll' ...

B Library 'E:\pusr\sap\PRD\SYS\exe\run\dboraslib.dll' loaded

B Version of 'E:\pusr\sap\PRD\SYS\exe\run\dboraslib.dll' is '46D.00'

B New connection 0 created

M relno 4640

M patchlevel 0

M patchno 534

M intno 0

M pid 1472

M

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

I MtxInit: -2 0 0

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation std

M <ES> Memory Reset enabled

X ES initialized.

M ThSysUsrCheck: clear T0

M calling db_connect ...

B find_con found the following connection for reuse:

B 0: name = R/3, concnt= 000000 state = DISCONNECTED, perm = YES, reco = NO

C Got ORACLE_HOME=E:\oracle\ora81 from environment

C Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

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

C Connecting as /@PRD on connection 0 ...

C

C Fri Mar 02 07:16:32 2018

C *** ERROR => OCI-call 'olog' failed: rc = 12505

[dboci.c 2423]

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

[dboci.c 6550]

C Try to connect with default password

C Connecting as SAPR3/<pwd>@PRD on connection 0 ...

C

C Fri Mar 02 07:16:33 2018

C *** ERROR => OCI-call 'olog' failed: rc = 12505

[dboci.c 2423]

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

[dboci.c 6550]

C Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

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

C Connecting as /@PRD on connection 0 ...

C *** ERROR => OCI-call 'olog' failed: rc = 12505

[dboci.c 2423]

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

[dboci.c 6550]

C Try to connect with default password

C Connecting as SAPR3/<pwd>@PRD on connection 0 ...

C *** ERROR => OCI-call 'olog' failed: rc = 12505

[dboci.c 2423]

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

[dboci.c 6550]

B ***LOG BY2=> sql error 12505 performing CON [dbsh 0695 ]

B ***LOG BY0=> [dbsh 0695 ]

B ***LOG BY2=> sql error 12505 performing CON [dblink 0627 ]

B ***LOG BY0=> [dblink 0627 ]

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

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

M

M Info for wp 0

M

M stat = 4

M reqtype = 1

M act_reqtype = -1

M tid = -1

M mode = 255

M len = -1

M rq_id = -1

M rq_source = 255

M last_tid = 0

M last_mode = 0

M rfc_req = 0

M report = > <

M action = 0

M tab_name = > <

M

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

M *

M * LOCATION SAP-Server psm22_PRD_01 on host psm22 (wp 0)

M * ERROR tskh_init: db_connect

M *

M * TIME Fri Mar 02 07:16:33 2018

M * RELEASE 46D

M * COMPONENT Taskhandler

M * VERSION 1

M * RC 13

M * MODULE thxxhead.c

M * LINE 7831

M * COUNTER 1

M *

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

M

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

[andreas_herzog · Accepted solution]

-> ORA 12505: TNS:listener could not resolve SID given in connect descriptor

try using

> tnsping PRD

check your tnsnames.ora and sqlnet.ora -> resolve any errors involving your sap sid...

GreetZ, AH

[Former Member · Accepted solution]

Hi !

Thank You !

Problem solved !

[Former Member]

Thanks you guys ...

[Former Member]

i am also have same problem ... How u solved it . ?

how to check the archive directory ?

--- pls need solution.

-

---

Lee Green

[former_member204746]

Lee, you should start a new topic and make a reference to this one.

[Former Member]

Please check your archive directory is full or not. if it is full some times this problem occur.please check it.

Regards,

Pulla Rao

[former_member204746]

check http://www.cryer.co.uk/brian/oracle/ORA12505.htm

your listener.ora file does not have an entry for your SID. adapt it accordingly.