AWS RDS Multi-Tenant

0

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

1 Respuesta
0

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
SV
respondido hace un año

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas