If you connect to a user in a PDB and u get error ORA-01033
and following query returns MOUNTED
SELECT name, open_mode FROM v$pdbs;
then we need to open it in read write mode and save state so that it would survive a shutdown.
sqlplus / as sysdba
SELECT name, open_mode FROM v$pdbs;
alter pluggable database PDBORCL open read write;
alter pluggable database all save state;
and following query returns MOUNTED
SELECT name, open_mode FROM v$pdbs;
then we need to open it in read write mode and save state so that it would survive a shutdown.
sqlplus / as sysdba
SELECT name, open_mode FROM v$pdbs;
alter pluggable database PDBORCL open read write;
alter pluggable database all save state;
No comments:
Post a Comment