OraFAQ Forum: Server Utilities » Oracle Database Startup

Home » RDBMS Server » Server Utilities » Oracle Database Startup

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

Oracle Database Startup [message #152979]

Wed, 28 December 2005 04:36

karan.shandilya
Messages: 64
Registered: July 2005
Location: mumbai

Member

Hi to all

Can anybody tell me how do i start the database with the start of my computer.
What parameters should i write in init.ora to do this.

Waiting for reply
Thanks in advance.

Karan.

Report message to a moderator

Re: Oracle Database Startup [message #152983 is a reply to message #152979]

Wed, 28 December 2005 04:59

orausern
Messages: 826
Registered: December 2005

Senior Member

For windows:
Go into control panel and you should see the services
there. You can set the method for starting the database to "automatic", "manual", or "disabled". Its default setting is "automatic".
(From Tom kyte's site)

For unix:
You can configure your Oracle Instance to start automatically once the Solaris box gets rebooted by putting an entry of your database in the file /etc/oratab. The entry should be like this

sid:<path of Oracle_Home>:Y

For example

atgzdb15:/slot06/db/atgzdb15:Y

(From another forum..)

Pl. test this to verify..

Report message to a moderator

Re: Oracle Database Startup [message #152999 is a reply to message #152983]

Wed, 28 December 2005 05:49

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

http://oraclesvca2.oracle.com/docs/html/A96167_01/post-inst.htm#sthref548

Report message to a moderator

Re: Oracle Database Startup [message #153017 is a reply to message #152983]

Wed, 28 December 2005 06:59

karan.shandilya
Messages: 64
Registered: July 2005
Location: mumbai

Member

Hi Tarun,
My services already on automatic option. They get started but the database remains shutdown.
Manually i have to open it.

My Machine is Windows Advance Server 2000.
Oracle is 9i.

Karan.

Report message to a moderator

Re: Oracle Database Startup [message #153019 is a reply to message #153017]

Wed, 28 December 2005 07:16

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

One more try :

Go to HKEY_LOCAL_MACHINE\SOFTWARE\Oracle\HOME0 in windows registry and look for the value of--

ORA_<ORACLE_SID>_AUTOSTART .

Set it to TRUE if FALSE.

And restart the server.

Report message to a moderator

Re: Oracle Database Startup [message #153639 is a reply to message #153017]

Tue, 03 January 2006 08:00

karan.shandilya
Messages: 64
Registered: July 2005
Location: mumbai

Member

Thanx Tarun.
I got the solution by your help.

Karan.

Report message to a moderator

Previous Topic:	Import Error
Next Topic:	Error while login in sqlplus

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jul 02 04:14:24 CDT 2024