EM CC SQL Jobs AND RMAN Jobs Fail with Listener Error
Last updated on MARCH 08, 2017
Applies to:Enterprise Manager for Oracle Database - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
There is a 12c Database Target Monitored by EM Cloud control.
The database has 'service name' set with 'hostname+domainname'.
Instance Name is : orcl
Service Name is : orcl.us.oracle.com
Listener is listening with service name.
Service "orcl.us.oracle.com" has 1 instance(s).
Instance "orcl", status READY, has 1 handler(s) for this service...
Listener is using 'USE_SID_AS_SERVICE_<LISTENER_NAME>=ON" parameter
1. When the SID of above target database is mentioned as service_name (i.e. orcl.us.oracle.com) in 'Monitoring configuration' in EM, the database is shown as UP.
But any simple 'SQL job' is failing.
Connected to an idle instance.
SQL> SQL> SQL> SQL> SQL> select 'x' from dual
Error at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
Error from SQLPLUS: 1
2. If the SID in 'Montioring configuration' is changed to database SID(i.e. orcl) , the SQL job succeeds.
But the 'Database is shown as Down'
Response Metric gives Error:
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor
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