Re: Oracle8i 8.1.5 on NT

From: banicki <banickiNOpmSPAM_at_webmart.net>
Date: Fri, 10 Sep 1999 09:26:16 -0700
Message-ID: <023a5bf4.12b9f6fc@usw-ex0102-012.remarq.com>

Here is my procedure: Doesn't answer your question, but this doesn't change with release levels of oracle. Change svrmgr23 to svrmgr30.
ORACLE ON NT, STANDARDS, STARTUP Oracle Startup and Shutdown Procedure

1. Set Remote_login_passwordfile = exclusive in the INIT.ORA
2. Stop and start Oracle.
3. Create user sysop1 identified by startup
4. grant sysoper to sysop1
5. copy the attached scripts to X:\orant\SID\ backup Where: X is a drive letter SID is the SID of the Oracle instance

DBSTART.CMD
rem ORACLE Startup Script
rem Start the listener service only if it has not been started already

net start | find /I "OracleTNSListener" || net start OracleTNSListener

rem Start the ASID database with SQL*DBA(use Server Manager for 7.3)

set ORACLE_SID=ASID
net start |find /I "OracleServiceASID" || net start OracleServiceASID
N:\orant\bin\svrmgr23 command=@N:\backup\dbstart.sql

pause

	DBSTART.SQL
		spool N:\backup\dbstart%ORACLE_SID%.log
 		connect sysop1/startup as sysoper;

startup
exit

        DBSTOP.CMD
rem ORACLE Stop script
rem Stop the Listeners and Agent services net stop OracleTNSListener
net stop OracleAgent

rem Stop the ASID Database with Svrmgr23, and then the service
set ORACLE_SID=ASID
N:\orant\bin\svrmgr23 command=@N:\backup\dbstop.sql net stop OracleServiceASID

pause

        DBSTOP.SQL
spool N:\backup\dbstop%ORACLE_SID%.log
connect sysop1/startup as sysoper;
shutdown immediate
exit

        Adjust the paths in the previous scripts

6. Use REGEDT32 to append or replace the Oracle start command.

        HKEY_LOCAL_MACHINE\Software\Microsoft\Windows \Current_Version\WinLogon\System
Add or Replace X:\backup\dbstart.cmd
Where: X is the drive letter

          backup is the proper path

7. Services should have startup set to the following;

	OracleAgent 		Automatic
	OracleServiceXXXX	Manual
	OracleStart		Disable
	OracleTNSListener	Manual

      Where XXXX is the SID installed on the machine

8. Test startup by rebooting machine.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Fri Sep 10 1999 - 11:26:16 CDT