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!! :)
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