-
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
Thanx
Sam
Life is a journey, not a destination!
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|