Re: Startup problems - cannot specify SID for svrmgr30

From: Frank <fbortel_at_home.nl>
Date: Wed, 22 May 2002 21:17:36 +0200
Message-ID: <3CEBEED0.7040108@home.nl>

Harald Buesching wrote:

> Hello!
>
> We are using NT with 8.0.5.2.6.

Autch! Desupported and not a final version.

> Maybe the spaces Set 'Oracle_SID = DWH2' are fatal, don't remember, if
> i really used them.

So - have you retried *without* spaces? IFAIK, this is the problem.

And local would be in the registry - I would advise against it, as you have several instances running.
Not setting your environment will cause an error (tns12xxx, strangely), making you aware of what you're doing.
Consider this (with local set!)
DOS> set oracle_sid=dwh2
DOS> svrmgr30

SVRMGR> connect internal
SVRMGR> shutdown ...
SVRMGR> exit

DOS> exit
Oops! Should have started it...
DOS> svrmgr30

SVRMGR> connect internal
SVRMGR> startup

..cannot start - oracle is running shutdown first SVRMGR> shutdown
-> You are now shutting ORCL (or whatever value local has)

Frank
Almost forgot: local would have the same value as your tnsalias would have in connect uid/passwd_at_tnsalias Received on Wed May 22 2002 - 14:17:36 CDT