Re: Changing ORACLE_SID
Date: Fri, 8 Apr 1994 05:08:47 GMT
Message-ID: <CnxCyo.Gp7_at_cuug.ab.ca>
[ stuff deleted]
> I know that I can use a setenv (we are on an Ultrix DEC5500) from the csh, but
> that is a bit of a pain when you want to flip back and forth quickly.
> 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
>
Oracle provides a shell script (oraenv for bourne/korn shell, coraenv for
csh) that I would recommend to use (possibly wrapped in a script of yours)
because it not only changes the ORACLE_SID environment variable, but also
the ORACLE_HOME environment variable and makes sure that the ORACLE_HOME/bin
is in the path. This is important if you run different oracle versions concurrently.
You need to run these scripts so that the change of the environment
variable is persistent ( . oraenv for korn shell, I don't how for csh).
Received on Fri Apr 08 1994 - 07:08:47 CEST