EM CC SQL Jobs AND RMAN Jobs Fail with Listener Error
(Doc ID 2108303.1)
Last updated on FEBRUARY 17, 2019
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 : Name
- Service Name is : service_Name
Listener is listening with service name.
Service "service_Name" has 1 instance(s).
Instance "Name", 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. service_Name) in 'Monitoring configuration' in EM, the database is shown as UP.
But any simple 'SQL job' is failing.
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