Re: Oracle on NT (autostarting)
Date: 1995/07/17
Message-ID: <petersen.805967314_at_com1.dwhl.de>#1/1
David Luong <_at_dluong.ozemail.com.au> writes:
>bass_at_sgrops.msfc.nasa.gov (Robert E. Bass) wrote:
> >
> >
> >I am running Oracle 7.1 on a NT 3.5 server. I would like to
> >start and mount the database on boot up. How do I configure my
> >server to do that?????
> >
> >Thanks
> >Robert Bass
>Robert,
>When you get an answer to this question, can you email a copy to me. Many
>thanks.
Hello Robert and David,
In our NT test installation we're able to start the database and the SQL*Net listener on system startup (without login of any user).
We did this:
- Create a batch file, e.g. C:\ORANT\COM\DBSTART.BAT with the following contents:
SET ORACLE_SID=XXXX
SET ORACLE_HOME=C:\ORANT
rem startup listener
C:\ORANT\BIN\LSNRCTL START
rem get listener status to wait a few seconds (workaround !!)
C:\ORANT\BIN\LSNRCTL STATUS
rem startup instance
C:\ORANT\BIN\SQLDBA71.EXE _at_C:\ORANT\COM\DBSTART LMODE=Y
and a sql script C:\ORANT\COM\DBSTART.SQL with
SPOOL C:\ORANT\COM\DBSTART.LOG
CONNECT INTERNAL/<YOUR_INTERNAL_PASSWORD>
STARTUP
SPOOL OFF
EXIT
2. Start REGEDT32 (in a DOS box) and modify
HKEY_LOCAL_MACHINE
SOFTWARE
Microsoft
WindowsNT
CurrentVersion
WinLogon
System
from lsass.exe
to c:\orant\com\dbstart.bat, lsass.exe
WARNING: CHECK THE SYNTAX OF THIS STRING VERY CAREFULLY !
IF THERE ARE MISTAKES, YOU'RE UNABLE TO LOGIN !!
In our installation it was not possible to start the instance on startup of
the machine, when the listener was started by setting the startup type of
OracleTNSListener to automatic.
And (in our installation) we cannot start the instance BEFORE the listener,
if we want both from a batch file at system startup.
Hope this helps
Helge
Helge Petersen Datenbankadministrator Draeger Synematic GmbH D-23558 Luebeck, Germany Tel. 0451/882-4044 Fax -3031 Email petersen_at_dwhl.de ***************************************************************************Received on Mon Jul 17 1995 - 00:00:00 CEST