AWS RDS Multi-Tenant

Question

Hi, 
     I am hoping to start using RDS Oracle with Multi-Tenant support(CBD), but I am struggling to create another PDB (a clone of the first PDB ORCL) using the master user "admin".

CREATE PLUGGABLE DATABASE ORCL1 FROM ORCL
Error report -
ORA-65040: operation not allowed from within a pluggable database
65040. 00000 -  "operation not allowed from within a pluggable database"
*Cause:    An operation was attempted that can only be performed in the root
           or application root container.

If I try to switch to root

alter session set container=CDB$ROOT
Error report -
ORA-01031: insufficient privileges
01031. 00000 -  "insufficient privileges"
*Cause:    An attempt was made to perform a database operation without
           the necessary privileges.
*Action:   Ask your database administrator or designated security
           administrator to grant you the necessary privileges

I have also tried another user and tried to assign the privileges for both of the above but I get a permission denied. Has anyone done similar?

Thanks

Answer

At this time. Amazon RDS for Oracle only supports 1 PDB per CDB in multi-tenant architecture. However, you can use RDS Custom for Oracle which supports more than 1 PDBs per CDB architecture.
https://docs.amazonaws.cn/en_us/AmazonRDS/latest/UserGuide/custom-creating.html

AWS RDS Multi-Tenant

Relevant content