EM CC SQL Jobs AND RMAN Jobs Fail with Listener Error (Doc ID 2108303.1)

Last updated on MARCH 08, 2017

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms

There is a 12c Database Target Monitored by EM Cloud control.

The database has 'service name' set with 'hostname+domainname'.
ex:
Instance Name is : orcl
Service Name is  : orcl.us.oracle.com

Listener is listening with service name.
ex:
.
.
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

Disconnected
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

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