Re: oracle backup scripts not working on W2K

Try running the script on the console first and if it still fails, the ORACLE_SID variable isn't being fully recognized (as per Niall's response). I would suspect though it should run.

Under Terminal Server, you need to do two things in order to get Oracle to properly function:

1. set ORACLE_SID
2. if you are shutting down via svrmgrl (obsolete), run 'set instance ...'

There's only a few things that absolutely won't run under Terminal Server, but generally if it's command line, then there are work-arounds.

I long for the *NIX days, but unfortunately my company is all MS (although every day I try to convince them...)

As a side note, I've converted all our backup scripts (including shutdowns, startups, verifications, etc) to PERL (much to the chagrin of our completely MS IT department). This does enable me however to work around some of the problems with Terminal Server and other W2K issues.

Good luck.

Brad
Oracle DBA

On 10 Jun 2002 11:57:21 -0700, hmatijaca_at_sapo.pt (Helena) wrote:

>Hi have oracle 8160 running on W2K which I have 6 instance's running,
>I have creatd scripts to shutdown and startup oracle and they were
>working until last friday which there was a power off in the office. I
>get the following error messages:
>Fatal NI connect error 12560, connecting to:
> (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=oracle)(ARGV0=oraclepdprd)(ARGS='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(SID=pdprd)(CID=(PROGRAM=c:\OraHome1\bin\SVRMGRL.EXE)(HOST=DELLDB1)(USER=Administrator))))
>
> VERSION INFORMATION:
> TNS for 32-bit Windows: Version 8.1.6.0.0 - Production
> Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version
>8.1.6.0.0 - Production
> Time: 10-JUN-2002 14:52:42
> 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: 2
> nt OS err code: 0
>
>
>Any help would be great
>
>Thanks
>Helena
Received on Mon Jun 10 2002 - 20:02:14 CDT