My Oracle Support Banner

Exacs:Cloned PDB's are not visible in OCI (Doc ID 2939565.1)

Last updated on APRIL 29, 2024

Applies to:

Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 

Customer created a CDB(TRGT) from UI and there after cloned the few PDB's(PDBCL1,PDBCL2) from another existing CDB(SRC) in TRGT CDB manually and therafter he is not able to visualize the cloned PDB's in UI under TRGT CDB.

TRGT CDB and its PDB's were all online and recorded in ocr as well but they doesnt exist in UI console.

//DB is online.

srvctl status database -d TRGT
Instance TRGT1 is running on node Node1
Instance TRGT2 is running on node Node2

 

////From dcs-agent-1.log

"databases" : {
[2023-02-19 14:05:13,839] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "TRGT" : {
[2023-02-19 14:05:13,846] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "id" : "3e6bba9b-4a19-40ca-be41-4bbd534c9535",
[2023-02-19 14:05:13,853] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dbSyncTime" : 1676810236074,
[2023-02-19 14:05:13,861] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "createTime" : 0,
[2023-02-19 14:05:13,866] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "updateTime" : 0,
[2023-02-19 14:05:13,869] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dbName" : "TRGT",
[2023-02-19 14:05:13,874] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dbUniqueName" : "TRGT",
[2023-02-19 14:05:13,880] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dbDomain" : null,
[2023-02-19 14:05:13,899] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dbId" : 0,
[2023-02-19 14:05:13,906] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "cpuCount" : 0,
[2023-02-19 14:05:13,910] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "sgaTarget" : null,
[2023-02-19 14:05:13,913] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "pgaAggregateTarget" : null,
[2023-02-19 14:05:13,917] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dbSize" : null,
[2023-02-19 14:05:13,920] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dbUsedSize" : null,
[2023-02-19 14:05:13,924] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "totalFraSize" : null,
[2023-02-19 14:05:13,927] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "fraSizeUsed" : null,
[2023-02-19 14:05:13,930] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dbKmsKeyOcid" : null,
[2023-02-19 14:05:13,934] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "isCDB" : false,
[2023-02-19 14:05:13,939] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dbRole" : null,
[2023-02-19 14:05:13,942] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dbType" : "RAC",
[2023-02-19 14:05:13,945] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dbClass" : "OLTP",
[2023-02-19 14:05:13,948] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dbEdition" : "EE",
[2023-02-19 14:05:13,951] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dgEnabled" : false,
[2023-02-19 14:05:13,954] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "patchVersion" : null,
[2023-02-19 14:05:13,957] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "resourceOCIDSettings" : null,
[2023-02-19 14:05:13,960] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "tdeDetails" : null,
[2023-02-19 14:05:13,964] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dbCharacterSet" : null,
[2023-02-19 14:05:13,967] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dbNodeLevelDetails" : {
[2023-02-19 14:05:13,970] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "dm06-jab5u1" : {
[2023-02-19 14:05:13,973] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "nodeName" : "Node1",
[2023-02-19 14:05:13,977] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "instanceName" : "TRGT1",
[2023-02-19 14:05:13,980] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "version" : "12.2.0.1.200714",
[2023-02-19 14:05:13,984] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "homePath" : "/u02/app/oracle/product/12.2.0/dbhome_7",
[2023-02-19 14:05:13,987] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "status" : "Not running"
[2023-02-19 14:05:13,990] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: },
[2023-02-19 14:05:13,994] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "Node2" : {
[2023-02-19 14:05:14,004] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "nodeName" : "Node2",
[2023-02-19 14:05:14,008] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "instanceName" : "TRGT2",
[2023-02-19 14:05:14,011] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "version" : "12.2.0.1.200714",
[2023-02-19 14:05:14,014] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "homePath" : "/u02/app/oracle/product/12.2.0/dbhome_7",
[2023-02-19 14:05:14,017] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "status" : "Not running">>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
[2023-02-19 14:05:14,021] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: }
[2023-02-19 14:05:14,025] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: },
[2023-02-19 14:05:14,029] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "pdbs" : null,
[2023-02-19 14:05:14,033] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "messages" : [ {
[2023-02-19 14:05:14,041] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "locale" : "en",
[2023-02-19 14:05:14,049] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "message" : "[FATAL] [DBAAS-60118] Unable to load details for the database 'TRGT'.",>>>>>>>>>>>>>>>>>
[2023-02-19 14:05:14,058] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "errorCode" : "DBAAS-60118",
[2023-02-19 14:05:14,065] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "cause" : "Either the database is not running on any of the nodes or is not open.",
[2023-02-19 14:05:14,078] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "action" : "Make sure that the database is functional.",
[2023-02-19 14:05:14,083] INFO [pool-167-thread-1] [] com.oracle.dbcs.agent.dbaascli.lib.SecureCommandExecutor: Read: "extraDetails" : null,

 

//From Healthcheck report

 

HEALTH_WARNING - Node1 : TRGT: The following PDBs do not have saved state enabled: PDBCL1 PDBCL2>>>>>>>>>>>

//From Sql queries.

 

SQL> show pdbs

CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
4 P_PDBCL1 READ WRITE NO
5 P_PDBCL2 READ WRITE NO

SQL> alter session set container=P_PDBCL1;

Session altered.

SQL> select a.name,b.state from v$pdbs a , dba_pdb_saved_states b where a.con_id = b.con_id;

no rows selected

SQL> alter session set container=P_PDBCL2;

Session altered.

SQL> select a.name,b.state from v$pdbs a , dba_pdb_saved_states b where a.con_id = b.con_id;

no rows selected

 

Changes

 Cloned the pdb's in to TRGT CDB manually from other existing CDB(SRC).

Cause

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
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.