Re: automatic startup of an oracle instance on windows NT

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 Fri Apr 09 1999 - 07:28:11 CDT