| problems during shutdown [message #129527] |
Mon, 25 July 2005 10:57  |
an.shri
Messages: 1
Registered: July 2005
Location: india
|
Junior Member |
|
|
I faced following error messages while trying to shut down the database
dba-00342 'unable to complete internal login'
ora-01034 'oracle not available'
ora-07429 'smsgsg:shmget, failed to get segment'
if you have any clue or solution, pls. respond ASAP......
Anu
|
|
|
|
| Re: problems during shutdown [message #129553 is a reply to message #129527] |
Mon, 25 July 2005 14:13  |
srinivas4u2
Messages: 66
Registered: June 2005
|
Member |
|
|
Your instance is down. Check the alert log for more information.
Looks like the SGA is not getting adequate memory. Free any 'held' memory if your instance went down from an open/mount state state.
Hope that helps!
-Sri
|
|
|
|
| Re: problems during shutdown [message #129697 is a reply to message #129553] |
Tue, 26 July 2005 05:12 |
Achchan
Messages: 86
Registered: June 2005
|
Member |
|
|
if you are on windows go to services and stop all oracle services.Now start OracleService<your_SID> and then start listener.If problem does not solve then from sqlplus startup nomount,if not successful then try to edit the pfile and reduce the amount of SGA.
-Good luck!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
