Automatic Oracle instance startup on WinXP
Date: Sat, 6 Jul 2002 22:24:35 +0200
Message-ID: <ag7jl5$9qc$1_at_news.tpi.pl>
[Quoted] Does anybody has any experience with starting Oracle instance using startup scripts ? This scripts can be assigned using gpedit.msc in the following position of the console :
Rules>Computer Configuration>Windows Settings>Scripts-Startup-Shutdown
(here some other names can be found because I translate it from my WinXP
Professional workstation because of its Polish version) ? I use the following script (named for example startup.bat) that contains the subsequent commands:
C:\ORACLE\Oracle81\BIN\SVRMGRL.EXE < C:\ORACLE\Oracle81\BIN\startup.mgr >> C:\ORACLE\Oracle81\BIN\startup.log
The startup.mgr file contains following data:
connect INTERNAL/PASSWORD
startup
exit
Unfortunately (despite that EXACTLY THE SAME script worked correctly after running it from command prompt), during startup the following error (that can be found in startup.log) occurrs:
ORA-12560: TNS: Protocol adapter error
SVRMGR> ORA-12560: TNS:Protocol adapter error
SVRMGR> LCC-00161: Message 161 not found; product=RDBMS; facility=MGR
ORA-12560: TNS:Protocol adapter error
Further explanation can be found in SQLNET.LOG, that contains the data, like this (host names, and SID are changed):
Fatal NI connect error 12560, connecting to:
(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=ora
cleSID)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))')))(CONNECT_
DATA=(SID=SID)(CID=(PROGRAM=C:\ORACLE\Oracle81\BIN\SVRMGRL.EXE)(HOST=HOST)(U
SER=SYSTEM))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.5.0.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.5.0.0 -
Production
Time: 06-LIP-02 21:29:53
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12560
TNS-12560: TNS:Protocol adapter error
ns secondary err code: 0
nt main err code: 530
TNS-00530: Protocol adapter error
nt secondary err code: 0
nt OS err code: 0
Can anybody explain this behaviour?
Thank you for any help
Greetings
- Jan