Home » RDBMS Server » Server Administration » Database Down after Server Reboot
Database Down after Server Reboot [message #228253] Mon, 02 April 2007 04:39 Go to next message
Messages: 39
Registered: March 2007
Location: UK

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

Re: Database Down after Server Reboot [message #228270 is a reply to message #228253] Mon, 02 April 2007 06:20 Go to previous message
Mahesh Rajendran
Messages: 10673
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Did you try manually?
set your ORACLE_SID.
Login as SYS and startup.
Search the forum for more details.
Previous Topic: Rename table
Next Topic: view table change date
Goto Forum:

Current Time: Sun Jul 23 17:49:19 CDT 2017

Total time taken to generate the page: 0.14305 seconds