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

Last updated on MARCH 08, 2017

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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms