Start Oracle Instance

[mrkamran]

Hi,
I have a problem with my Oracle 8i database, that is when my computer restart my database will shutdown. Every time when i start my computer then also start oracle database from DBA studio. Is there any way to start my database autometically with windows or why it is happening?
Thanks

 

[SantaMufasa]

Kamran,

Depending upon your version of Windows...

Start -> Settings -> Control -> Administrative Tools -> Services -> <right-click>"OracleService<SID name>" -> Properties -> Startup Type...change "Manual" to "Automatic".

Let us know if this all works for you.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[mrkamran]

Hi,

This service is already on "Automatic" and is started but my database is still shutdown and i open it from DBA studio. Is there any script which could start my DB without entering in DBA Studio becuase I dont want to open database from DBA Studio.

Thanks

 

[Turkbear]

Hi,

There is a Registry entry that will enable an automatic database startup/open/mount when the Oracle service has started, but I no longer have my notes to detail it..
You could also place a batch file in your startup folder to run the database startup script.






To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[SantaMufasa]

Kamran,

Yes, as Turkbear mentions, once you have confirmed that your Oracle <SID> service starts automatically, you should confirm (via regedit) that your registry supports automatic starting:

HKEY_LOCAL_MACHINE -> SOFTWARE -> ORACLE -> HOME0 -> <right-click>ORA_<SID>_AUTOSTART -> Modify -> Value data -> "TRUE"

If this is already TRUE, please advise; if it is not TRUE, please make it so, re-test, and advise.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I can provide you with low-cost, remote Database Administration services: see our website and contact me via www.dasages.com]

 

[mrkamran]

I have checked this value ORA_<SID>_AUTOSTART and it is already TRUE and ORA_<SID>_SHUTDOWN is also true, and i have changed value of ORA_<SID>_SHUTDOWN to FALSE but database is shutdown still with windows startup. Is there any batch file script that can start oracle?

 

[Turkbear]

Hi, Try these ( supply correct SID name)
<SIDNAME>_UP.BAT

SET ORACLE_SID=<SIDNAME>

sqlplus /nolog @<SIDNAME_up>.sql

<SIDNAME>_up.Sql

CONNECT / as sysdba

STARTUP PFILE=<Pathto your Initora files>\init<SIDNAME>.ora

exit

To Paraphrase:"The Help you get is proportional to the Help you give.."