Tuesday 3 November 2015

ORA-65093: multitenant container database not set up properly

Today when i was trying to mount my Far Sync Instance, i got the following error :-

SQL> startup mount
ORACLE instance started.

Total System Global Area  218103808 bytes
Fixed Size                  2922712 bytes
Variable Size             159385384 bytes
Database Buffers           50331648 bytes
Redo Buffers                5464064 bytes

ORA-65093: multitenant container database not set up properly

## This error is applicable for multitenant 12C Database option

## Lets see what this indicates

[oracle@node4 u01]$ oerr ora 65093
65093, 00000, "multitenant container database not set up properly"
// *Cause:  An attempt was made to open a multitenant container database without
//          the correct parameter set for a multitenant container database in
//          the initialization parameter file.
// *Action: Set the 'enable_pluggable_database=true' parameter for the
//          multitenant container database in the initialization parameter file
//          and restart the database.
//


## To resolve this we need to make sure that initialization parameter enable_pluggable_database   is set to true

SQL> show parameter enable_pluggable_database

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
enable_pluggable_database            boolean     TRUE

## Then i was able to mount the Far Sync Instance

SQL>  startup mount
ORACLE instance started.

Total System Global Area  272629760 bytes
Fixed Size                  2923336 bytes
Variable Size             213910712 bytes
Database Buffers           50331648 bytes
Redo Buffers                5464064 bytes
Database mounted.













1 comment:

  1. how to solve it? you didn't write how you set it to TRUE

    ReplyDelete