SAP 4.6 work processes too often goes to completed status

[Former Member]

Hello,

SAP 4.6 C (Oracle 9i / windows NT) system, always work process goes to completed status. This a quality system.

As of now we are only restaring the work processes (SM50->process->restart after error-> yes) manually as a temporary fix.

Could you please suggest any solution to this issue ?

Here is more information about the system :

SAP R/3 Kernel 46D_EXT

Support package number 2283

Thanks,

Prabhakar Reddy.

[Former Member]

select the WPs and click on the logs (trace --> Display file). See what you get in the log and also paste the log here.

[Former Member]

Thank you for your quick reply. Below is the log

B

B Wed Sep 29 06:15:32 2010

B create_con (con_name=R/3)

B Loading DB library 'E:\usr\sap\ING\SYS\exe\run\dboraslib.dll' ...

B Library 'E:\usr\sap\ING\SYS\exe\run\dboraslib.dll' loaded

B Version of library 'E:\usr\sap\ING\SYS\exe\run\dboraslib.dll' is "46D.00", patchlevel (0.2238)

B New connection 0 created

M relno 4640

M patchlevel 0

M patchno 2283

M intno 0

M pid 8144

M

M ***LOG Q0Q=> tskh_init, WPStart (Workproc 9 8144) [dpxxdisp.c 976]

I MtxInit: -2 0 0

X EmInit: MmSetImplementation( 2 ).

X <ES> client 9 initializing ....

X Using implementation std

M <ES> Memory Reset enabled

X ES initialized.

M ThSysUsrCheck: clear T9

M calling db_connect ...

C Got NLS_LANG=AMERICAN_AMERICA.US7ASCII from environment

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

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

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

[dboci.c 2460]

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

[dboci.c 7025]

C Try to connect with default password

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

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

[dboci.c 2460]

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

[dboci.c 7025]

C Got NLS_LANG=AMERICAN_AMERICA.US7ASCII from environment

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

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

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

[dboci.c 2460]

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

[dboci.c 7025]

C Try to connect with default password

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

C

C Wed Sep 29 06:15:33 2010

C Now I'm connected to ORACLE using OCI_7 API

C

C Wed Sep 29 06:15:36 2010

C Database instance ing is running on TIRUINT04 with ORACLE version 9.2.0.4.0 since 20100929

B Connection 0 opened

B Wp Hdl ConName ConCnt ConState TX PRM RCT Date Time

B 000 000 R/3 000000 ACTIVE NO YES NO 20100929 061532

B ***LOG BY2=> sql error 0 performing CON [dbsh 0707 ]

B ***LOG BY0=> ORA-00000: normal, successful completion

[dbsh 0707 ]

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

B ***LOG BY0=> ORA-00000: normal, successful completion

[dblink 0627 ]

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

M in_ThErrHandle: 1

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

Edited by: prabhakaryc on Sep 29, 2010 2:03 PM

[Former Member]

The WP cannot get to the DB using the supplied OPS$ password.

Please check to make sure you have set the password correctly.

It is eventually connecting with the default password for SAPR3, but this is probably why the automatic restart is failing.

[former_member311580]

Hello prabhakaryc ,

You are using Oracle version 9.2.0.4 which is very old.

I would recommend you to install the latest patch set 9.2.0.8 and set the all the init<sid>.ora parameters (including underscore parameters and events) as per note 124361.

Regards,

Rafa

[Former Member]

follow http://help.sap.com/saphelp_nw04/helpdata/en/9d/12962024bd674ea37c218de3e65c68/content.htm to change ops$ password.

also go through Note 131561 - Work processes sometimes abend during database connect

Note should resolve your issue.