Re: Is it possible to change ORACLE_SID for one instance?

I don't know if this would work
( I don't even understand it, aren't you just changing the devault Instance by changing ORACLE_SID?)

The normal way to do things like that
is to change the listener I guess:

stop your Listener
change the configuration so that it connects only to the test-DB but set the alias for this Instance to Prod

So everybody would connect to your Test-DB

Hope to be helpfull

Jens

Juergen Diet <juergen.diet_at_mch.sbs.de> wrote in article <364AF16B.8F1A3637_at_mch.sbs.de>...
> I have two Oracle-instances (with ORACLE_SID=prod and =test) running
> on an AIX-machine. They access the databases prod_db and test_db,resp.
> If the Production-DB is down for some reasons, I want all users connect
> to the Test-DB without changing their connection strings or
> tnsnames.ora-files. Is it possible to start the Test-DB with instance-
> name prod so that all previous connections to the Production-DB now
> go to the Test-DB? I am thinking of:
>
> setenv ORACLE_SID prod
> svrmgrl
> >connect internal
> >startup pfile=.../inittest.ora
> >exit
>
> There should now be an instance "prod" that accesses the Test-DB.
> Of course, I cannot start the Production-DB with the instance-name
> prod as long as this ORACLE_SID is used for the Test-DB.
> Does anybody see any other drawbacks to this method?
> Thanks in advance,
> ------------------------------------------------------------
> Juergen Diet
> mailto:juergen.diet_at_mch.sbs.de
> ------------------------------------------------------------
>
Received on Thu Nov 12 1998 - 10:56:53 CST