Re: Autostart at boottime-Oracle8

With 8i on NT, database startup and shutdown are controlled from the registry. Now, there is only a single service: OracleServiceSID, which starts the instance and can also startup and open the database, and with 8.1.6 can also shutdown the database cleanly. The relevant registry values are ORA_SID_AUTOSTART, ORA_SID_SHUTDOWN, ORA_SID_SHUTDOWN_TYPE, and ORA_SID_SHUTDOWN_TIMEOUT. If ORA_SID_AUTOSTART is set to TRUE, when the OracleServiceSID is started either at system bootup or via a "net start..." command, an oradim process is spawned to startup and open the database. Oradim obtains the internal password by reading the pwdSID.ora file for the particular instance. If the pwdSID.ora file is missing or invalid, an error is written to the oradim.log file.

hth

Regards,
Chuck
----- Original Message -----
From: Jack Silvey <JSilvey_at_XOL.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Thursday, July 06, 2000 12:37 PM
Subject: RE: Autostart at boottime-Oracle8

> I did not see the startsid.cmd file from my 8i installation either. I
wonder
> how the OracleStartSID service knows the internal password now?
>
> Jack Silvey
>
> -----Original Message-----
> Sent: Thursday, July 06, 2000 11:07 AM
> To: Multiple recipients of list ORACLE-L
>
>
>
> This file was created when I created 8.0 database but it is not created
for
> 8.1.6.(at least not in my istallation). I do not think that you will have
> this problem with 8.1. For 8.0 you can recreate the instance with oradim80
> or manually change this file.
>
> Alex Hillman
>
> -----Original Message-----
>
> Sent: Thursday, July 06, 2000 9:27 AM
> To: Multiple recipients of list ORACLE-L
>
>
> you will have to change the password in the strtsid.cmd file which is on
> \orant\database\ directory
> edit this file you will see the password which uses the internal password
of
>
> the password file
> it should work
>
> >From: "Ravi Babu" <lravibabu_at_hotmail.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >Subject: Autostart at boottime-Oracle8
> >Date: Thu, 06 Jul 2000 02:25:27 -0800
> >
> >Hello,
> >For security reasons i have changed the internal password with the help
of
> >ORAPWD80. After that whenever i restart the server, oracle is not auto
> >started and i have to start it explicitly. I am using Oracle8 ver 8.0.5
on
> >NT 4.0. I have checked the registry but not finding any variable to set
for
>
> >autostart at boot. What should i try to make it autostart at bootime.
> >Please
> >help.
> >Bye
> >Ravi.
> >________________________________________________________________________
> >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> <http://www.hotmail.com>
> >
> >--
> >Author: Ravi Babu
> > INET: lravibabu_at_hotmail.com
> >
> >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> >San Diego, California -- Public Internet access / Mailing Lists
> >--------------------------------------------------------------------
> >To REMOVE yourself from this mailing list, send an E-Mail message
> >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> >the message BODY, include a line containing: UNSUB ORACLE-L
> >(or the name of mailing list you want to be removed from). You may
> >also send the HELP command for other information (like subscribing).
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> <http://www.hotmail.com>
>
> --
> Author: ARUN K C
> INET: arun_k_c_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Author: Jack Silvey
> INET: JSilvey_at_XOL.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
Received on Thu Jul 06 2000 - 17:37:33 CDT