OraFAQ Forum: Server Administration » Database hasn't coming up after rebooting.

Home » RDBMS Server » Server Administration » Database hasn't coming up after rebooting.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Database hasn't coming up after rebooting. [message #254742]

Fri, 27 July 2007 15:30

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?

Report message to a moderator

Re: Database hasn't coming up after rebooting. [message #254745 is a reply to message #254742]

Fri, 27 July 2007 15:34

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

And the OS is?

Regards
Michel

Report message to a moderator

Re: Database hasn't coming up after rebooting. [message #254747 is a reply to message #254745]

Fri, 27 July 2007 16:10

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,

Report message to a moderator

Re: Database hasn't coming up after rebooting. [message #254752 is a reply to message #254742]

Fri, 27 July 2007 19:32

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.

Report message to a moderator

Re: Database hasn't coming up after rebooting. [message #254757 is a reply to message #254752]

Fri, 27 July 2007 22:27

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?

Report message to a moderator

Re: Database hasn't coming up after rebooting. [message #254758 is a reply to message #254757]

Sat, 28 July 2007 00:10

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

Report message to a moderator

Re: Database hasn't coming up after rebooting. [message #254772 is a reply to message #254757]

Sat, 28 July 2007 01:22

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	reclaim free space
Next Topic:	SPFILE

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 10:52:37 CST 2024