Home » Infrastructure » Windows » need to startup database everytime server starts
need to startup database everytime server starts [message #129628] Tue, 26 July 2005 01:13 Go to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member


I have a Windows XP machine with Oracle 9i installed on it. I created the database manually after installing 9i.
Now the problem is that whenver i start my server i need to start the database manually. How to make it start automatically.
The Oracle service is in automatic mode n gets started the moment machine is up.
suggestions appreciated.

Regards ,
tarun
Re: need to startup database everytime server starts [message #129635 is a reply to message #129628] Tue, 26 July 2005 01:41 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

You need to edit the oracle service specific parameters in system registry.

Goto
HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\HOME0
Check for value for entry
ORA_<SID>_AUTOSTART.

Modify the entry & put the value as TRUE.

Regds
Girish
Re: need to startup database everytime server starts [message #129640 is a reply to message #129635] Tue, 26 July 2005 01:54 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
Hi girish,

I changed the registry value to true n restarted the machine bt its still the same. when connected to Oracle i need to startup manually.


Thanks
tarun
Re: need to startup database everytime server starts [message #129674 is a reply to message #129640] Tue, 26 July 2005 04:30 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
HI

A shot in dark... are you using Password file authentication or OS authentication?

Regds
Girish
Re: need to startup database everytime server starts [message #129677 is a reply to message #129674] Tue, 26 July 2005 04:36 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Hi ,

I m using password file authentication.
thanks for quick replies.

Regards,

Tarun
Re: need to startup database everytime server starts [message #129679 is a reply to message #129677] Tue, 26 July 2005 04:37 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
Hi

For a change, try using OS authentication...

Lets hope for the best...

Regds
Girish
Re: need to startup database everytime server starts [message #129681 is a reply to message #129679] Tue, 26 July 2005 04:38 Go to previous message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member

Ok ,

I wil try it .

thanks ,
tarun
Previous Topic: how to install server and developer on same pc
Next Topic: Installation of Oracle 9.0.1
Goto Forum:
  


Current Time: Mon Dec 06 00:24:04 CST 2021