OraFAQ Forum: Enterprise Manager » On system startup Oracle Instance is not getting started

Home » RDBMS Server » Enterprise Manager » On system startup Oracle Instance is not getting started (Oracle 9.02 i, Win 2000)

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

On system startup Oracle Instance is not getting started [message #298427]

Wed, 06 February 2008 01:50

shyamala
Messages: 11
Registered: May 2003

Junior Member

Hi,
i have installed Oracle 9.02i and all these days my system was in workgroup domain. but some time back my system is shifted to our dept domain. since then oracle instance is not getting started on startup of system. everytime i need to goto Oracle Enterprise Manager and start the instance. i have edited TNSNames.ora and Listener.ora file by changing host name to localhost. even then this problem exists.

can any body tell me any other settings do i need to do?

Report message to a moderator

Re: On system startup Oracle Instance is not getting started [message #298438 is a reply to message #298427]

Wed, 06 February 2008 02:06

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

Senior Member
Account Moderator

You have to first put the Oracle services in autostart mode.
Then you have to check your registry for ORA_<SID>_AUTOSTART in HKLM\Software\Oracle\<your home> and set to TRUE.

Regards
Michel

Report message to a moderator

Re: On system startup Oracle Instance is not getting started [message #298448 is a reply to message #298427]

Wed, 06 February 2008 02:21

yogee
Messages: 1
Registered: December 2007

Junior Member

hello shyamala ..

goto control panel>administretive tool>services>
search your service>into that ..set startup type to automatic...

thats it

Report message to a moderator

Re: On system startup Oracle Instance is not getting started [message #298863 is a reply to message #298427]

Fri, 08 February 2008 01:12

shyamala
Messages: 11
Registered: May 2003

Junior Member

Hi
thanx for reply, actually i have already set the Oracle service to autostart mode. i checked in the registry for ORA_<SID>_AUTOSTART and it is also set to TRUE. even now the problem exists. any other solution??????????
is it anything to do with domain name in the registry...

regards
shyamala

Report message to a moderator

Re: On system startup Oracle Instance is not getting started [message #298872 is a reply to message #298863]

Fri, 08 February 2008 01:39

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

Senior Member
Account Moderator

The Oracle server must NOT be a domain controller.
Have a look at Windows event log.

Regards
Michel

Report message to a moderator

Previous Topic:	how to reuse the space been recovered from table's row deletion
Next Topic:	automate to start the grid control agent when the host boxes reboot.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 18:02:35 CST 2024