OraFAQ Forum: Windows » need to startup database everytime server starts

Home » Infrastructure » Windows » need to startup database everytime server starts

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

need to startup database everytime server starts [message #129628]

Tue, 26 July 2005 01:13

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

Report message to a moderator

Re: need to startup database everytime server starts [message #129635 is a reply to message #129628]

Tue, 26 July 2005 01:41

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

Report message to a moderator

Re: need to startup database everytime server starts [message #129640 is a reply to message #129635]

Tue, 26 July 2005 01:54

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

Report message to a moderator

Re: need to startup database everytime server starts [message #129674 is a reply to message #129640]

Tue, 26 July 2005 04:30

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

Report message to a moderator

Re: need to startup database everytime server starts [message #129677 is a reply to message #129674]

Tue, 26 July 2005 04:36

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Hi ,

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

Regards,

Tarun

Report message to a moderator

Re: need to startup database everytime server starts [message #129679 is a reply to message #129677]

Tue, 26 July 2005 04:37

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

Report message to a moderator

Re: need to startup database everytime server starts [message #129681 is a reply to message #129679]

Tue, 26 July 2005 04:38

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

Ok ,

I wil try it .

thanks ,
tarun

Report message to a moderator

Previous Topic:	how to install server and developer on same pc
Next Topic:	Installation of Oracle 9.0.1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 13:16:50 CST 2024