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

Ian
已提問 1 年前檢視次數 974 次
1 個回答
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
已回答 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南