Re: automatic startup of an oracle instance on windows NT

Please check the oradim80 command on NT, that will properly recreate the services, and set the correct location for the pfile:

Oradim80 -new -sid GDAT -intpwd perfit -startmode auto -pfile G:\orant\database\initGDAT.ora
Oradim80 -startup -sid GDAT -starttype srvc,inst -usrpwd perfit -pfile G:\orant\database\initGDAT.ora

Also check for a file called: strtGDAT.cmd, and take a look at that file too. I believe this cmd file will be created when you run the above to create your instance, but check this file first, because I think this is the file the startservice runs.

Kenton Ho
Perfit Computer Systems Group Inc.

Sylvain Leclerc <SLeclerc_at_magrit.com> wrote in message news:044CD796C702D111B56800608CCC51D00DD5B1_at_INT_04...
> Hi,
>
> I stumbled into the same problem when I tried to make two instances work
> on the same box.
> If the pfiles are not located in the default directory as specified in
> the registry, the automatic
> start doesn't work. The problem is that before 8.0.4, there's only one
> oracle_home that can
> be specified. We develop under Oracle7, so all my pfiles are under the
> same directory, even though
> the other instance files are under specific directories. Be careful
> with your backups.
>
> Sylvain Leclerc, DBA
> INT Systèmes d'information
> sleclerc_at_magrit.com
>
>
>
> > -----Original Message-----
> > From: rachamallu_reddy_at_my-dejanews.com
> > [SMTP:rachamallu_reddy_at_my-dejanews.com]
> > Posted At: Thursday, April 08, 1999 1:00 PM
> > Posted To: server
> > Conversation: automatic startup of an oracle instance on windows NT
> > Subject: automatic startup of an oracle instance on windows NT
> >
> > Hi,
> > I hav oracle 8.0.3 installed on a windows NT server. I have the
> > default ORCL
> > instance. I created a new GDAT instance. I was succesfully able to
> > create the
> > databae, tablespaces, users etc. The services OracleServiceGDAT and
> > OracleStartGDAT are marked AUTOMATIC STARTUP in the Services applet of
> > the
> > control panel. The differences between the ORCL database and GDAT
> > database are
> > that, GDAT's pfile initGDAT.ora is not in the default location and
> > GDAT
> > database has ARCHiving enabled.
> > When I reboot the NT server, ORCL instance comes up automatically.
> > The GDAT
> > instance does not. The GDATALRT.LOG does not have any entries
> > indicating that
> > an attemp was made to start the instance. I have to manually start
> > SVRMGR30,
> > connect internal and startup specifying the pfile.
> > Does anyone know what I should be doing to avoid manually running
> > SVRMGR30
> > everytime I reboot the NT server?
> >
> > thanks in advance
> > reddy
> >
> > -----------== Posted via Deja News, The Discussion Network
> > ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your
> > Own
>
>
Received on Tue Apr 13 1999 - 10:07:06 CDT