my production server is getting restated

[Former Member]

Dear All,

I am facing problem in my production server is getting restated form yesterday and cant find any error just a mail form server

HpEventLog: Watchdog timer expired - hard reset (2E0H)

The system has detected the following event:

SNMP Trap: 736

Date time: 06/09/2009 01:14:54 PM

Computer:

Source: HpEventLog

Type: Error

Category: (0)

Description:

Watchdog timer expired, and a hard reset of the system occurred. Some process took longer than it should. Identify that process and contact the vendor of that application.

Details:

For more details, look at the System Event Log.

But today also my only Sap application got restated not the database and there are the error log

By this error log a have face this problem that time if I restart the server than the problem will not come for 12 to 15 hr than again SM21 I am getting this error and the ABAP dumps and then work process will stop .

If there is no one to restart the server (In nigth) than the error come for 1 to 2hr than restart the sap application by automatily

After apply the latest kernel patch it is solve but not aging I am getting the problem.

We are using ecc5 ,oracle 9i on win2003

SM21 Log

Q02 Stop Workproc 0, PID 464

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

R19 Initialization DB-Connect Failed, Return Code 000256

Q02 Stop Workproc 9, PID 5980

trc file: "dev_w0", trc level: 1, release: "640"

B

B Sat Jun 13 08:09:58 2009

B create_con (con_name=R/3)

B Loading DB library 'G:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' ...

B Library 'G:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' loaded

B Version of 'G:\usr\sap\PRD\SYS\exe\run\dboraslib.dll' is "640.00", patchlevel (0.220)

B New connection 0 created

M sysno 00

M sid PRD

M systemid 561 (PC with Windows NT)

M relno 6400

M patchlevel 0

M patchno 247

M intno 20020600

M make: multithreaded, Unicode, 64 bit

M pid 3444

M

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

I MtxInit: -2 0 0

M DpSysAdmExtCreate: ABAP is active

M

M Sat Jun 13 08:10:01 2009

M calling db_connect ...

C Prepending E:\oracle\ora92 to Path.

C got NLS_LANG='AMERICAN_AMERICA.UTF8' from environment

C Client NLS settings: AMERICAN_AMERICA.UTF8

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

C Connecting as /@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 070308)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 000000000FABC010 000000000D0CF8F0 000000000D0CF228

C Attaching to DB Server PRD (con_hdl=0,svchp=000000000D0CF0F8,srvhp=000000000FADD708)

C

C Sat Jun 13 08:10:16 2009

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

[dboci.c 4289]

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

[dbsloci.c 11395]

C Try to connect with default password

C Connecting as SAPPRD/<pwd>@PRD on connection 0 (nls_hdl 0) ... (dbsl 640 070308)

C Nls CharacterSet NationalCharSet C EnvHp ErrHp ErrHpBatch

C 0 UTF8 1 000000000FABC010 000000000D0CF8F0 000000000D0CF228

C Detaching from DB Server (con_hdl=0,svchp=000000000D0CF0F8,srvhp=000000000FADD708)

C Attaching to DB Server PRD (con_hdl=0,svchp=000000000D0CF0F8,srvhp=000000000FADD708)

C

C Sat Jun 13 08:10:31 2009

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

[dboci.c 4289]

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

[dbsloci.c 11395]

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

*B **LOG BY0=> ORA-12560: TNS:protocol adapter error [dbsh#3 @ 1204] [dbsh 1204 ]

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

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

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

M in_ThErrHandle: 1

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

M

Regards,

Edited by: kumarmoh on Jun 13, 2009 1:36 PM

[Former Member]

Hi,

Please check your listner port is used by another application if yes then assign to other port that application.

Anil

[Former Member]

Hi,

please give the OS version, type 32 or 64 bit, oracle version, unicode/nonunicode. your oracle client version?

check the files:

%oracle home%network/admin/tnsname.ora

hostname\sapmnt\SID\SYS\profile\oracle\tnsnames.ora both should be same

-gokul

Edited by: Gokul Chitode on Jun 16, 2009 7:46 PM

[Former Member]

Send alert.log

or it is the problem of Listner then check SID and IP of Listner.ora file and match it with ur TNS file parameter.

Thanks

[Former Member]

Thanks all, when i try LSNRCTL i am getting the error

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

But if stop the database from oracle failsafe manager and restart the server than the problem is solve fo only 10 to 12 hr that again the same problem came. Please suggest

Regards,

[JPReyes]

Read,

SAP Note 441518 - ORA-12560 composite SAP Note

Regards

Juan

[Former Member]

Hi,

you can start your listener service manualy

Regards,

Nitin

[former_member185031]

>ORA-12560: TNS:protocol adapter error BY2 Database error 12560 at CON BY0 > ORA-12560: >TNS:protocol adapter error R19 Initialization DB-Connect Failed, Return Code 000256 Q02

ORA-12560 means your listner is not started or may be some problem with listner.

Regards,

Subhash