Sample Header Ad - 728x90

Database Open but Oracle gives ORA-01033: ORACLE initialization or shutdown in progress

1 vote
0 answers
9880 views
We are using 4 node Oracle 10GR2 RAC in Windows x64. 3 instances of our database crashed today and later started normally. I started them by connecting (Remote Desktop) to individual instances and executing startup command in sqlplus. I can connect to database using SYS account but when I try to connect using application user account, I get following error: > 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 Interesting thing is my instances started and database are open according to following queries. SELECT * FROM GV$INSTANCE; SELECT * FROM GV$DATABASE; I tried to use following command thinking that there is a mistake. SQL> alter database open; alter database open * ERROR at line 1: ORA-01531: a database already open by the instance I also tried to control RAC node statuses using following command. srvctl status database -d DBNAME database status command is following: Instance DBNAME1 is running on node NODE01 Instance DBNAME2 is running on node NODE02 Instance DBNAME3 is running on node NODE03 Instance DBNAME4 is running on node NODE04 So I can connect to database using SYS account, but WHY not application user account? Situation resolved itself in 15 minutes. I can connect to database now. But there is nothing in the alert logs about this situation. Should I check additional places to learn about real problem? Is there anything I can do in similar situation? After a while, I understood why this is happening! Oracle executes following command which we can see in alert logs. ALTER DATABASE OPEN Some time later , We can see following line in alert.log Completed ALTER DATABASE OPEN Only after this line, we can connecto to database. Interesting thing is in this 4 node RAC , we need to wait for this event in all instances before database start serving.
Asked by Atilla Ozgur (1466 rep)
Mar 6, 2014, 12:26 PM
Last activity: Feb 10, 2021, 01:36 PM