me again
anybody tell why i get this error message
>ORACLE INITIALIZATION/SHUTDOWN IN PROGRESS<
HOW CAN I FIX THIS.....HELP PLEASE
THANKS
Printable View
me again
anybody tell why i get this error message
>ORACLE INITIALIZATION/SHUTDOWN IN PROGRESS<
HOW CAN I FIX THIS.....HELP PLEASE
THANKS
probably you are trying to logon to sql before the db is not completely shutdown.. it could still have the SGA hanging..
if db is cleanly shutdown , you will get ORACLE NOT AVAILABLE.. So, log inot svrmgr and shutdown the db cleanly.. You should see "Instance shutdown".. If immediate or normal doesnot work use "Abort"..
Always check your alert logs at $ORACLE_BASE/admin/sid/bdump/alert_sid.log for the details.
Sam
You probably issued 'shutdown normal' and still have open connections to the db. In this case the database cannot be shutted down until you don't close all connections. Also, no user is able to connect to the database, because the shutdown process started, so that's why you get the message. Connect as internal and check v$session view to see which are the connections hanging. Then you can kill them and the database will shut down