SAP system message: No connect to database, session terminated

[Former Member]

Getting the error message "SAP system message No connect to database, session terminated" when connected from GUI.

This second time in last one week.

DB - Oracle 10

OS - Windows 2008 R2

Oracle and SAP are on the same server and in running state. Oracle listener is running and r3trans gave return code 0000, still none of us are able to connect to server. No network issue and None of the LUNS are SAN disks are altered from storage.

Dev_w0.txt, alert_chq.txt and DB status.JPG are attached for your reference.

Quick help is much appreciated.

dev_w0.txt.zip

alert_chq.txt.zip

[Former Member]

Hi Suman,

I don't see anything particularly strange from the logs you attached, I could only think of the processes on DB maxing out, which is set to 80. Did you find any other reasons, please share?

Cheers.

Kalyan

[Brindavan_M]

Hi Suman,

May the server running with network loop-back adapter. you need to check main work-group domain IP address might be changed or not reachable. check the message server address has been maintained. If everything fine then check the logon group might be deleted or changed.Alert log and other SAP log will show only successful log if sever if running fine. if the server having problem then you can find the issue in logs.Better find some root cause from your side to find and let us know.

Thanks,

Brindavan

[tamil_arasan]

Hi,

I don't see any errors in the attached log. could you please open the window syslog in the MMC and see any errors reported there ?

Please paste the error from syslog from MMC.

Thanks and regards,

Pradeep

[Former Member]

Audit trail: LENGTH : '149' ACTION :[7] 'CONNECT' DATABASE USER:[1] '/' PRIVILEGE :[7] 'SYSOPER' CLIENT USER:[11] 'CORP\chqadm' CLIENT TERMINAL:[10] 'ABTMSSDQ01' STATUS:[1] '0' .

will this help by any way

[tamil_arasan]

Sorry Suman,

Please paste complete logs you are getting in the syslog link in MMC. By the way have you tried complete restart of the server (SAP+DB+OS) ?

If no, Please try to restart and check as sometimes any deadlock condition blocking the system operation.

Thanks and regards,

Pradeep