Re: using SVRMGR for Ora8 on NT - help!

On Fri, 18 Jun 1999 13:31:02 +0400, "Andrey D. Shindarev" <ashindarev_at_ptrsrv.spb.ru> wrote:

>Hi.
>
>Fuzzy <granta_at_nospam.student.canberra.edu.au> wrote in message
>news:37697fb0.19293502_at_newshost.interact.net.au...
>> Hi all,
>>
>> I can't seem to get SVRMGR to behave on an Ora8 NT box. I'm trying to
>> alter our backup régime from cold to hot - but it's a bit hard without
>> SVRMGR. I'm trying to go through the usual mount, alter to
>> archivelogs, open stuff, and also build some scripts to automate
>> restores when necessary.
>>
>> Every time I try to use SVRMGR, I get the 12203 TNS:Unable to connect
>U can try to:
> 1) define u database in ?\NET80\ADMIN\tnsnames.ora (not
>network\admin\tnsnames.ora)
> +2) set LOCAL=%you db tnsname%
> +3) set ORACLE_SID=%you db sid%
> +4) use svrmgr30 (not 23)
>
>Regards, Andrey.

Thanks Andrey and Sybrand.

I can get this to work now ... if the instance was shutdown through svrmgr30. (And therefore the services are still running - though not doing anything)

The trick was to alter the strtsid.cmd file to only start the services - not the instance. Then the above worked like a charm.

Thanks again
Fuzzy
:-) Received on Mon Jun 21 1999 - 16:51:37 CDT