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 laterInformation 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 |