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.

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.

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