Is it possible to change ORACLE_SID for one instance?

From: Juergen Diet <juergen.diet_at_mch.sbs.de>
Date: Thu, 12 Nov 1998 15:32:11 +0100
Message-ID: <364AF16B.8F1A3637@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 - 08:32:11 CST