Agent Monitoring DB Shows- Failed to connect to database instance: ORA-1250
Last updated on MARCH 08, 2017
Applies to:Enterprise Manager for Oracle Database - Version 22.214.171.124 to 126.96.36.199 [Release 11.1]
Information in this document applies to any platform.
Agent status in 188.8.131.52 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.
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