Changing ORACLE_SID
Date: 6 Apr 1994 13:00:45 -0500
Message-ID: <2nutcd$h88_at_tisdec.tis.tandy.com>
Good afternoon Internet!
I am posing this question to the masses, because, quite frankly, I am stumped
for a solution and was hoping that someone could shed some light on this
subject for me.
We are currently running a single instance of an Oracle V6 database, but, on
our test system, we have recently begun to dabble in using 2 separate
instances. I know that this requires changing the ORACLE_SID, but I have not
figured out an easy way to do this to allow toggling back and forth.
Any hints? If someone could help me solve this dilemna I would really
appreciate it. I have tried a script, but all that does is changed the
environment for the current execution so it doesn't help much. I need to
change the ORACLE_SID until I tell it to change back.
Thanks in advance for your help!
Byron Pearce | The thoughts and views herein do not Tandy Information Services | necessarily reflect that of Tandy bpearc1_at_tisdec.tis.tandy.com | Corporation. ------------------------------------------------------------------------------"It's hard to be a ninja when you wear a beeper."
Received on Wed Apr 06 1994 - 20:00:45 CEST