ORA-65093: multitenant container database not set up properly

RMAN-00571: ======================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =========== RMAN-00571: ======================================================== RMAN-03002: failure of Duplicate Db command at 06/20/2024 08:01:54 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored script Memory Script RMAN-06136: Oracle error from auxiliary database: ORA-65093: multitenant container database not set up properly

I faced above error when I was building a database using DUPLICATE command using backup of the source database, although ORA-65093 may be returned during different scenarios. This error requires parameter enable_pluggable_database to bet to a value of TRUE if the database is a CDB. This means, we should not forget to set this parameter in auxiliary instance’s init file before we initiate DUPLICATE command for a container database.

This error may also be returned if this parameter is not present in the init file of an existing CDB database that you are trying to open because if parameter is not specified, by default value of this parameter is FALSE. Example is as follows.

SQL>  startup pfile=d:\init.ora ORACLE instance started. Total System Global Area 4462736672 bytes Fixed Size                  9037088 bytes Variable Size             889192448 bytes Database Buffers         3556769792 bytes Redo Buffers                7737344 bytes ORA-65093: multitenant container database not set up properly