| Database Down after Server Reboot [message #228253] |
Mon, 02 April 2007 04:39  |
t.summerfield
Messages: 39
Registered: March 2007
Location: UK
|
Member |
|
|
Hello
I am getting a weird problem after I reboot my server (windows 2003) where by my database (10.2) does not automatically start. To get it to start I have to go into administrative tools >> services and then manually restart the OracleASMService+ASM (it says it is already running).
When I reboot the server and lauch the OEM Database Control it tells me the following:
- Database Instance = Down
- Listener = Up
- Agent Connection to Instance = Failed ORA-12505: TNS:Listener does not currently know of SID given in connect descriptor(DBD ERROR: OCIServerAttach)
Things I have checked/tried;
alert.log has no new errors logged in the past week
I can not connect to the database with sql*plus (before I restart the OracleASMService+ASM). SQL*Plus errors:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
After I restart the service I can connect without any problems.
Thanks in advance for any idea's/suggestions
Regards
Toby
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
