EM 12c : Custom Service Name for PDB Target Reverts Back to Original Value Automatically After Sometime (Doc ID 2207848.1)

Last updated on DECEMBER 06, 2016

Applies to:

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

Symptoms

Oracle 12C RAC PDBs running on single instance are being monitored via EM. For these targets, when the default_service_name (same as pdb) is used in the monitoring configuration, the connection fails with "ORA-01033: ORACLE initialization or shutdown in progress".

This is expected since the PDB is in mount state and connection fails as dbsnmp user even from sqlplus.
The default_service_name in the monitoring configuration page was modified to use another service at the DB which is actually running in one of the open PDB instances only. The connection from console works and the PDB target is shown as UP in the console UI.

However, the service name reverts back to the default service name automatically after sometime. This is affecting OEM monitoring of these
single instance PDBs and Corrective Actions / Jobs cannot get executed.

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