Issue with Oracle TNS Listener Service in Windows Cluster

[Former Member]

Dear All,

Our users are getting following error on SAP GUI Screen frequently.

Also we have found the below error on Windows Event Log which started coming in event log from Last SAP Startup:
Its now coming continuously.

Event Type:    Error
Event Source:    OracleMSCSServices
Event Category:    Oracle TNS Listener
Event ID:    1
Date:        4/2/2012
Time:        6:57:00 PM
User:        N/A
Computer:    SERVERDB
Description:
Looks alive detected problem for resource OracleECP102TNSListenerFslencecpvidb .

Event Type:    Error
Event Source:    Service Control Manager
Event Category:    None
Event ID:    7034
Date:        4/3/2012
Time:        2:53:31 AM
User:        N/A
Computer:    SERVERDB
Description:
The OracleECP102TNSListenerFslencecpvidb service terminated unexpectedly.  It has done this 21 time(s).
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

What will be the cause?

- Ashish K

Message was edited by: Ashish Kesarkar

[former_member182034]

hi Ashish,

check the following link and alertSID.log

No connect to database, session terminated

No connect to database, session terminated

Regards,

[Former Member]

Hi,

First of all check if DB is up and running. If DB is up then do following.

Please restart Listerner service

click on start command run and typer services.msc. there you can find the service "

OracleECP102TNSListenerFslencecpvidb ."

Restart it. and then check now if you are able to connect.

Regards,

Venkata S Pagolu.

[Former Member]

DB is up. Users are getting connected.
But the issue is, they are getting disconnected after sometime throwing the above SAP GUI Screenshot.

Now cluster has failed over to Another Node.

DB and CI is on CI Instance only.

The error is not comming now.

But what will be the cause of the issue regarding "OracleECP102TNSListenerFslencecpvidb" service?

- Ashish K

[former_member189546]

Hello,

Check for errors in cluster.log on c drive at time of the problem.

Also check note 1043592

regards,

John Feely