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.
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
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.
how to solve it? you didn't write how you set it to TRUE
ReplyDelete