Nida Akram
asked on
Oracle gives ORA-01033: ORACLE initialization or shutdown in progress
I started my oracle database but when i try to connect it gives this error please tell me how to solve this problem.
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
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
Check the alert log. If there is any issues with the startup, the messages will be in there.
If you aren't familiar with the location, check:
http://docs.oracle.com/database/122/REFRN/DIAGNOSTIC_DEST.htm#REFRN10280
I prefer the old style that is in the trace folder instead of the XML version in the alert folder.
If you aren't familiar with the location, check:
http://docs.oracle.com/database/122/REFRN/DIAGNOSTIC_DEST.htm#REFRN10280
I prefer the old style that is in the trace folder instead of the XML version in the alert folder.
Is this a database that you have started successfully in the past? Or, is this a new database that you are trying to open for the first time?
If you aren't familiar with the "alert.log" file for your database, you should certainly find that (as slightwv suggested) and read the last entries in it. The default location for that is:
$ORACLE_HOME/diag/rdbms/<d
And the name of the file is: alert<instname>.log (or: <instname>.xml for the XML version).
But, the actual location of those in your system may be somewhere else, since this location can be changed by setting the value of the DIAGNOSTIC_DEST parameter to a different value. We always set this to a location outside of the $ORACLE_HOME directory on our database servers, because we don't want the partition that holds the Oracle executable files to be filled up by the log and trace files that Oracle writes to this location.
If your database pfile (or spfile) is available outside of ASM (these are usually in the $ORACLE_HOME/dbs directory) check that for the location of DIAGNOSTIC_DEST in your system.
And, like slightwv, I also prefer to look at the plain-text version in the trace sub-directory, instead of the XML version in the alert sub-directory.
If you aren't familiar with the "alert.log" file for your database, you should certainly find that (as slightwv suggested) and read the last entries in it. The default location for that is:
$ORACLE_HOME/diag/rdbms/<d
And the name of the file is: alert<instname>.log (or: <instname>.xml for the XML version).
But, the actual location of those in your system may be somewhere else, since this location can be changed by setting the value of the DIAGNOSTIC_DEST parameter to a different value. We always set this to a location outside of the $ORACLE_HOME directory on our database servers, because we don't want the partition that holds the Oracle executable files to be filled up by the log and trace files that Oracle writes to this location.
If your database pfile (or spfile) is available outside of ASM (these are usually in the $ORACLE_HOME/dbs directory) check that for the location of DIAGNOSTIC_DEST in your system.
And, like slightwv, I also prefer to look at the plain-text version in the trace sub-directory, instead of the XML version in the alert sub-directory.
so, after waiting for some time, can you connect?
or do you get this message all the time and not be able to connect at all?
or do you get this message all the time and not be able to connect at all?
ASKER
I had to uninstall oracle
You likely didn't have to but I assume everything is OK now?
ASKER
Actually i couldn't understand what happened all of sudden and i have was in a hurry so i had to reinstall
solution here
https://youtu.be/Smm-eL9H0i8
1- select name, open_mode from v$pdbs
2-Alter pluggable database pdborcl open
https://youtu.be/Smm-eL9H0i8
1- select name, open_mode from v$pdbs
2-Alter pluggable database pdborcl open
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
just wait... it may take some time...