Home » RDBMS Server » Server Administration » Service name or network name of service icdbXDB in the PDB is invalid or conflicts with an existing (12.1.0.2, windows 2016 Data Center)
Service name or network name of service icdbXDB in the PDB is invalid or conflicts with an existing [message #676929] Mon, 29 July 2019 02:17
juniordbanewbie
Messages: 239
Registered: April 2014
Senior Member
Dear Sir/Mdm,

I found the following error in alert log.


Sun Jun 16 06:46:37 2019
Database Characterset is AL32UTF8
Starting background process SMCO
SMCO started with pid=27, OS id=5064 
Opening with Resource Manager plan: DEFAULT_CDB_PLAN 
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process AQPC
AQPC started with pid=30, OS id=5100 
Sun Jun 16 06:47:00 2019
Database Characterset for PDB$SEED is AL32UTF8
Opening pdb PDB$SEED (2) with Resource Manager plan: DEFAULT_PLAN
Database Characterset for wpdb is AL32UTF8
***************************************************************
WARNING: Pluggable Database wpdb with pdb id
altered with errors or warnings. Please look into
         PDB_PLUG_IN_VIOLATIONS view for more details.

From pdb_plug_in_violations
SYS@cambridge icdb>COLUMN error_number FORMAT 99
SYS@cambridge icdb>SELECT to_char(time,'YYYY-MM-DD HH24:MI:SS.FF TZR') time_s, name, cause, status, error_number, message, action FROM PDB_PLUG_IN_VIOLATIONS WHERE status='PENDING';

TIME_S                                                         NAME       CAUSE                  STATUS    ERROR_NUMBER
-------------------------------------------------------------- ---------- ---------------------- --------- ------------
MESSAGE
----------------------------------------------------------------------------------------------------------------------------------------------------------------
ACTION
------------------------------------------------------------
2019-07-18 19:01:57.153000 +00:00                              icdb      Service Name Conflict  PENDING              0
Service name or network name of service icdbXDB in the PDB is invalid or conflicts with an existing service name or network name in the CDB.
Drop the service and recreate it with an appropriate name.



but when I list service$, I found that there is no duplicate service

solution suggested in PDB Name Conflicts With Existing Service Name In The CDB Or The PDB (Doc ID 2247291.1)

is not applicable to me as I cannot rename the database.

The Database, wpdb is created from non CDB remotely via database link.



SYS@cambridge icdb>SELECT sys_context('userenv','con_name') FROM dual;

SYS_CONTEXT('USERENV','CON_NAME')
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CDB$ROOT

SYS@cambridge icdb>SELECT name, network_name, to_char(deletion_date,'YYYY-MM-DD HH24:MI:SS') deletion_date_s, pdb FROM service$ ORDER BY name;

NAME                           NETWORK_NAME                   DELETION_DATE_S     PDB
------------------------------ ------------------------------ ------------------- ----------
SYS$BACKGROUND                                                                    CDB$ROOT
SYS$USERS                                                                         CDB$ROOT
seeddata                       seeddata                       2018-12-20 11:39:56 CDB$ROOT
seeddataXDB                    seeddataXDB                    2018-12-20 11:39:56 CDB$ROOT
icdb.cambridge.com              icdb.cambridge.com                                  CDB$ROOT
icdbXDB                        icdbXDB                                            CDB$ROOT

SYS@cambridge icdb>ALTER SESSION SET container=wpdb;

Session altered.

SYS@cambridge icdb>SELECT sys_context('userenv','con_name') FROM dual;

SYS_CONTEXT('USERENV','CON_NAME')
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
wpdb

SYS@cambridge icdb>SELECT name, network_name, to_char(deletion_date,'YYYY-MM-DD HH24:MI:SS') deletion_date_s, pdb FROM service$ ORDER BY name;

NAME                           NETWORK_NAME                   DELETION_DATE_S     PDB
------------------------------ ------------------------------ ------------------- ----------
seeddata                       seeddata                       2018-09-26 09:40:58 wpdb
seeddataXDB                    seeddataXDB                    2018-09-26 09:40:58 wpdb
wpdb.cambridge.com              wpdb.cambridge.com                                  wpdb
wpdbXDB                       wpdbXDB                                           wpdb


many thanks in advance!
Previous Topic: ORA-28000: the account is locked - how to investigate it ?
Next Topic: Do I need to explicity run datapatch after upgrading
Goto Forum:
  


Current Time: Tue Nov 12 00:06:57 CST 2019