Service Name Conflict When Opening PDB

Symptom:

    After we  create a new PDB  from non-CDB via dblink for migration project.  The PDB opens with warning.

select name,cause,type,message,status from PDB_PLUG_IN_VIOLATIONS where status <> 'RESOLVED';

TESTPDB                      Service Name Conflict                                            WARNING

Service name or network name of service TESTSTG in the PDB is invalid or conflicts with an existing service name or network name in the CDB.

Solution:

    It is an old service name inherited  from source non-CDB. We can remove it and recreate them.

Delete on PDB Level:

PDB> exec DBMS_SERVICE.DELETE_SERVICE('TESTSTG ');

Recreate:

srvctl add service -db TESTDB -service TEST_APP -preferred "TESTDB1,TESTDB2" -pdb TESTDBPDB

srvctl status service -s TESTDBPDB_APP -db TESTDB

srvctl start service -s TESTDBPDB_APP -db TESTDB