Problem: While opening the session of one of the schema in pluggable database, getting error ‘ORACLE initialization or shutdown in progress‘.
An error was encountered performing the requested operation: ORA-01033: ORACLE initialization or shutdown in progress 01033. 00000 - "ORACLE initialization or shutdown in progress" *Cause: An attempt was made to log on while Oracle is being started up or shutdown. *Action: Wait a few minutes. Then retry the operation. Vendor code 1033
Solution: Login the database using the sysdba. Check the status of the pluggable database.
select name, open_mode from v$pdbs ; # In my case database name is PDB select name, open_mode from v$pdbs where name='PDB';
So the status of the database is mounted, we have to open this database.
alter pluggable database PDB open;
Checking the database status & connection details.
Refer below blogs for setting Oracle 12c Database:
- Oracle Database 12c Installation & Setup| Windows 10
- Container & Pluggable Database | Oracle 12c
- Customer-Orders Sample Schema | Oracle 12c
Happy Learning! Your feedback would be appreciated!Follow @shobhitsinghIN