Sm50 almost all work process are stop status

[Former Member]

Dear All,

I am facing problem in my production server.

In sm50 almost all work process are stop status and in

sm21 log

R19 Initialization DB-Connect Failed, Return Code 000256

Q02 Stop Workproc33, PID 5564

BY2 Database error 12560 at CON

BY0 > ORA-12560: TNS:protocol adapter error

BY2 Database error 12560 at CON

BY0 > ORA-12560: TNS:protocol adapter error

At the time of prblem user are getting ABAp dumps

Runtime Error MESSAGE_TYPE_X

If i run LSNRCTL i

LSNRCTL> status

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=#####)(PORT=1521))

)

TNS-12560: TNS:protocol adapter error

TNS-00530: Protocol adapter error

64-bit Windows Error: 55: Unknown error

LSNRCTL>

Please suggest

Regards,

[Former Member]

Hi,

Can you please the check Oracle alert logs to see whether there any ORA-0600 errors. Also please check whether there are in ORA-00610 errors. Please check the Oracle trace files for any errors.

Please run the rsoradjv report to check whether the Oracle memory parameters and events are appropriately set / reset as per SAP recommendations. Also please refer SAP Note 830576 - Parameter recommendations for Oracle 10g.

Please concentrate on the memory parameters such as-

java_pool_size

large_pool_size

streams_pool_size

job_queue_processes

etc.

Also, please check the Oracle event 14532 is set.

regards,

Subhajit.

[ImtiazKaredia]

Hi,

Its seems your listner in Hanging.

Is your Oracle version 10.2.0.2.

If yes, the below may be true in your case

Known issue list of upgarde from 10.2.0.1 to 10.2.0.2

Oracle Listener Issue

If you apply this patch set, the listener might hang intermittently in both RAC, and nonRAC environments.

Workaround: Perform the following steps:

Rename the $ORACLE_HOME/opmn/conf/ons.config file by entering the following commands:

cd $ORACLE_HOME/opmn/conf

mv ons.config ons.config.orig

Alternatively, change each port value in the $ORACLE_HOME/opmn/conf/ons.config file to an unused port.

Restart the listener.

This issue is tracked with Oracle bug 3881276.

[Former Member]

Hi,

Check R3Trans -d and check the file trans.log

Check below thread. It may help you.

Thanks,

Sushil

[Former Member]

Thanks , yes after the restart the sever it solve to problem for only a time fram it will agin happen in 10 to 12 hr of time of rstart.Please suggest

Regards,

[former_member204746]

Metalink note 124140.1 might help. check that out.

[Former Member]

Hi,

which OS & database you are using.Check login name which ur trying to run lsnrctl start.

it should be ora<SID>.have you change IP address hostname

$ping <HOSTNAME>

if pinging then check tnsnames.ora and listener.ora file.

lsnrctl stop;l

snrctl start

tnsping <sid>

if not sucessful give log file

Surendrajain

[Former Member]

check if ur database is up and running .Also execute R3trans -d and check trans.log generated.

A normal reboot of the server can solve ur problem provided its due to some memory problems

[sunny_pahuja2]

Hi,

Please go through SAP Note 441518 - ORA-12560 composite...

Thanks

Sunny