Re: Automatic Oracle instance startup on WinXP

On Sat, 6 Jul 2002 22:24:35 +0200, "Jan Kubacki" <kubackij_at_poczta.onet.pl> wrote:

>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
>

I'm not sure why you are writing scripts where you can simply set the service to start up automatically (and to shutdown automatically) The issue is being caused by probably a few things

- the account running the scripts is not in the ora_dba grou[
- ORACLE_SID hasn't been set
- sqlnet.authentication_services in sqlnet.ora is set to NONE where

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jul 06 2002 - 22:56:49 CEST