My Oracle Support Banner

Agent Monitoring DB Shows- Failed to connect to database instance: ORA-1250 (Doc ID 1453838.1)

Last updated on AUGUST 19, 2021

Applies to:

Enterprise Manager for Oracle Database - Version 11.1.0.1 to 11.1.0.1 [Release 11.1]
Information in this document applies to any platform.

Symptoms

Agent status in 11.1.0.1 OMS is showing:

 Failed to connect to database instance: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach).


The monitored DB and Listener show status as 'up.'


The command line shows:
<agent_oh>/bin/emctl status agent

<agent_oh>/bin/emctl upload agent

that these are working correclty with no errors.


Connecting to to the database in question through the listener via the details in the tnsnames.ora file connects with no error. 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.