cancel
Showing results for 
Search instead for 
Did you mean: 

work process died after instance started

xinjiang_li
Active Participant
0 Kudos

Hi,gurus,

After we started the instance,we found the work process died.

The log in file dev_wo was as below:

M DpShMCreate: allocated wp_adm at 049017D8

M DpShMCreate: allocated tm_adm_list at 049031B8

M DpShMCreate: allocated tm_adm at 049031E0

M DpShMCreate: allocated wp_ca_adm at 04B48220

M DpShMCreate: allocated appc_ca_adm at 04B4C870

M DpShMCreate: allocated comm_adm_list at 04B4DFE0

M DpShMCreate: allocated comm_adm at 04B4DFF8

M DpShMCreate: allocated vmc_adm_list at 04B7CDF8

M DpShMCreate: system runs without vmc_adm

M DpShMCreate: allocated ca_info at 04B7CE20

M DpShMCreate: allocated wall_adm at 04B7CE28

X

X Thu Dec 18 11:39:30 2008

X EmInit: MmSetImplementation( 2 ).

X <ES> client 0 initializing ....

X Using implementation flat

M <EsNT> Memory Reset disabled as NT default

X ES initialized.

M

M Thu Dec 18 11:39:32 2008

M calling db_connect ...

C Prepending H:\oracle\ora92 to Path.

C got NLS_LANG='AMERICAN_AMERICA.WE8DEC' from environment

C

C Thu Dec 18 11:39:33 2008

C Client NLS settings: AMERICAN_AMERICA.US7ASCII

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

C Connecting as /@ECC on connection 0 (nls_hdl 0) ... (dbsl 640 010307)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 US7ASCII 1 0469F028 046A46A4 046A3F2C

C Attaching to DB Server ECC (con_hdl=0,svchp=046A3E78,srvhp=046A4CB4)

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12557

[dboci.c 4283]

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

[dbsloci.c 11332]

C Try to connect with default password

C Connecting as SAPECC/<pwd>@ECC on connection 0 (nls_hdl 0) ... (dbsl 640 010307)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 US7ASCII 1 0469F028 046A46A4 046A3F2C

C Detaching from DB Server (con_hdl=0,svchp=046A3E78,srvhp=046A4CB4)

C Attaching to DB Server ECC (con_hdl=0,svchp=046A3E78,srvhp=046A4CB4)

C *** ERROR => OCI-call 'OCIServerAttach' failed: rc = 12557

[dboci.c 4283]

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

[dbsloci.c 11332]

B ***LOG BY2=> sql error 12557 performing CON [dbsh#3 @ 1204] [dbsh 1204 ]

B ***LOG BY0=> ORA-12557: TNS:protocol adapter not loadable [dbsh#3 @ 1204] [dbsh 1204 ]

B ***LOG BY2=> sql error 12557 performing CON [dblink#3 @ 428] [dblink 0428 ]

B ***LOG BY0=> ORA-12557: TNS:protocol adapter not loadable [dblink#3 @ 428] [dblink 0428 ]

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

M in_ThErrHandle: 1

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

M

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi xinjiang li

Check the Database connectivity, you're TNS maybe down. check in services.msc if all the oracle related services are up.

Regards

Kaleem

xinjiang_li
Active Participant
0 Kudos

hi,

I have checked TNSlinstner, and it was started.Any ideas?

Former Member
0 Kudos

Hi Li

At the DB level there will be a orasid user, can you check if it's locked or not.

also run R3trans -d and check what is the return code you're getting.

Regards

Kaleem

Edited by: Kaleem on Dec 18, 2008 10:06 AM