on SM50 workprocess can't start

[Former Member]

Hello,

could you please help me on a problem, in fact worprocess can't start even if i cancel and restart them.

to resolve the problem, i have to restart the Listner, i have add a parameter in sqlnet.ora ( sqlnet.expire_time = 60 secondes) (oracle 9.2)

but this morning the problem has occured.

how to do to resolve it permanently ?

Thank's

[Former Member]

close this ticket

[Former Member]

Hi,

i have found it on /oracle/<sid>/saptrace/background

but no alert between 07:05 and 12:35 (when i restart Listner), it seems the tracing at this time have not worked

Sincerly

[Former Member]

please,

where can i find Alert.log ?

Thank's

[former_member227283]

Hi,

Can you check the database alert.log which will clear the error more.

Thanks

Anil

[Former Member]

C

• ** ERROR => OCI-call 'olog' failed: rc = 12203

[dboci.c 2460]

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

[dbsloci.c 7024]

C Try to connect with default password

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

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

[dboci.c 2460]

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

[dbsloci.c 7024]

C Got NLS_LANG=AMERICAN_AMERICA.WE8DEC from environment

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

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

C

C Sun Oct 4 12:05:08 2009

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

[dboci.c 2460]

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

[dbsloci.c 7024]

C Try to connect with default password

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

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

[dboci.c 2460]

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

[dbsloci.c 7024]

Sur SM21 :

Q04 Connection to user 19638 (OPER4602 ), terminal 156 (FRLBMAPP11 ) lost

R19 Initialization DB-Connect Failed, Return Code 000256

Q02 Stop Workproc38, PID 15561

R19 Initialization DB-Connect Failed, Return Code 000256

Q02 Stop Workproc31, PID 18783

R19 Initialization DB-Connect Failed, Return Code 000256

Q02 Stop Workproc30, PID 20852

u2026

this error messages appeare on all workproc trace files

if it is not sufficient i paste the hole of trace file

[sunny_pahuja2]

Hi,

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

> [dboci.c 2460]

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

> [dbsloci.c 7024]

Check SAP Note 445029 - ORA-12203 composite SAP note

Thanks

Sunny

[sunny_pahuja2]

Hi,

Could you please paste dev_w0 logs here ?

Thanks

Sunny

[former_member227283]

Hi,

Can you check the dailog process log file , which can help much better.

log file name :- dev_w*

Thanks

Anil