Home » RDBMS Server » Server Administration » Database hasn't coming up after rebooting.
Database hasn't coming up after rebooting. [message #254742] Fri, 27 July 2007 15:30 Go to next message
jhsong01
Messages: 7
Registered: July 2007
Junior Member
Hi there.

I installed a oracle 10g on one of my virtual machine. I rebooted the machine and orcl database wasn't coming up eventhough all orcale related services got started already.

Any clues? How can I fix it?
Re: Database hasn't coming up after rebooting. [message #254745 is a reply to message #254742] Fri, 27 July 2007 15:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And the OS is?

Regards
Michel
Re: Database hasn't coming up after rebooting. [message #254747 is a reply to message #254745] Fri, 27 July 2007 16:10 Go to previous messageGo to next message
jhsong01
Messages: 7
Registered: July 2007
Junior Member
It is on Windows 2003 R2.

BTW: I found a solution in a different forum. the db is up and running.

I did following.

1) sqlplus /nolog
2) conn sys as sysdba
3) startup

Thanks,

Re: Database hasn't coming up after rebooting. [message #254752 is a reply to message #254742] Fri, 27 July 2007 19:32 Go to previous messageGo to next message
krblr
Messages: 24
Registered: April 2007
Location: MD
Junior Member

I'm curious as to what your error was. Can you give some more details? When you said services I am assuming you are on Windows. Yes it is possible for your services to say it has started, even if it has not started the database. So what you want to do is switch off the service, then start it up again from the services window. This time it will not start. Then check event viewer for any errors that come up when you try to start it. Also post us the tail of your alert log when you attempt that.
Re: Database hasn't coming up after rebooting. [message #254757 is a reply to message #254752] Fri, 27 July 2007 22:27 Go to previous messageGo to next message
jhsong01
Messages: 7
Registered: July 2007
Junior Member
As you said,
the service has stared, but not the database. I have to start the database up manually.

Is there any way to start the database up when the service gets started?
Re: Database hasn't coming up after rebooting. [message #254758 is a reply to message #254757] Sat, 28 July 2007 00:10 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,
Yes, for that you have to change "startup" type for each Oracle Related services.

Open Windows Services and change startup type.

cmd>services.msc ----> OracleServiceSID change startup type from manual to "automatic"


Regards
Taj
Re: Database hasn't coming up after rebooting. [message #254772 is a reply to message #254757] Sat, 28 July 2007 01:22 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In the registry:
HKLM\SOFTWARE\ORACLE\KEY_<something>\ORA_<oracle_sid>_AUTOSTART => TRUE

Or execute in a DOS box:
oradim -edit -sid <your sid> -startmode auto

Regards
Michel
Previous Topic: reclaim free space
Next Topic: SPFILE
Goto Forum:
  


Current Time: Mon Dec 05 15:02:59 CST 2016

Total time taken to generate the page: 0.09684 seconds