OEM 13C : Create_Pluggable_Database Using EMCLI Fails To Create "Users Tablespace"
(Doc ID 3043191.1)
Last updated on NOVEMBER 20, 2024
Applies to:
Enterprise Manager for Oracle Database - Version 13.5.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
In Enterprise Manager (EM) 13.5 Cloud Control, customer on creating emcli create_pluggable_database completes successfully but fails to create users tablespaces.
Command :
$emcli create_pluggable_database -cdbTargetName=XXX-cdbTargetType=oracle_database -cdbHostCreds=HOST_ORACLE -pdbName=TESTPDB-sourceType=DEFAULT -cdbTargetCreds=HOST -pdbAdminCreds=PDBADMIN -newPDBFileLocation=+DATA -sourcePDBTempStagingLocation="/opt/oracle/admin/work"
After Completion Users Tablespace Does Not Creates:
SQL> alter session set container=PDBTST4;
Session altered.
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
$emcli create_pluggable_database -cdbTargetName=XXX-cdbTargetType=oracle_database -cdbHostCreds=HOST_ORACLE -pdbName=TESTPDB-sourceType=DEFAULT -cdbTargetCreds=HOST -pdbAdminCreds=PDBADMIN -newPDBFileLocation=+DATA -sourcePDBTempStagingLocation="/opt/oracle/admin/work"
After Completion Users Tablespace Does Not Creates:
SQL> alter session set container=PDBTST4;
Session altered.
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
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 |
| Cause |
| Solution |