Tuesday, 17 July 2018

Resolving "ORA-01033: ORACLE initialization or shutdown in progress.

Hi,

This error I was getting after I restarted my system; when i tried connecting to Oracle DB 12c.
 "ORA-01033: ORACLE initialization or shutdown in progress.

Tried restarting the service -- control panel -- oracle service ( but did not help )

So below is the method which helped.

Go to cmd

>sqlplus SYS/Oracle_1@orclpdb AS SYSDBA    ( here orclpdb is my oracle service name )

sql>alter pluggable database orclpdb open read write;

sql>connect hr/hr@orclpdb


This will help to resolve the error. DB gets connected again.

All good n fine!

Thanks!

Keep Learning!! :)

No comments:

Post a Comment