Hi all,

I have problem with switching env from one to another. Any way, I tried to have two Oracle version on the same server, part of it when I am trying to set it up is change env from 9i to 10G

Below is env I have:

AGENT_HOME=/home/oracle/product/10.1.0/agent
BASH=/bin/bash
BASH_VERSINFO=([0]="2" [1]="05" [2]="8" [3]="1" [4]="release" [5]="i386-redhat-linux-gnu")
BASH_VERSION=$'2.05.8(1)-release'
CLASSPATH=/home/oracle/product/9.2.0/JRE:/home/oracle/product/9.2.0/jlib:/home/oracle/product/9.2.0/rdbms/jlib:/home/oracle/product/9.2.0/network/jlib
COLORS=/etc/DIR_COLORS
COLUMNS=80
CRS_HOME=/home/oracle/product/10.1.0/crs
DB10G_HOME=/home/oracle/product/10.1.0
DB9I_HOME=/home/oracle/product/9.2.0

....................
................
NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
OLDPWD=/home/oracle
OPTERR=1
OPTIND=1
ORACLE_BASE=/home/oracle
ORACLE_HOME=/home/oracle/product/9.2.0
ORA_NLS33=/home/oracle/product/9.2.0/ocommon/nls/admin/data
OSTYPE=linux-gnu
PATH=/opt/IBMJava2-131/bin:/opt/IBMJava2-131/jre/bin:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/home/oracle/bin:/home/oracle/product/9.2.0/bin:/home/oracle/bin
............................
..................................
........................



so I wrote a small bash file as follow:


#!/bin/bash
export ORACLE_HOME=$DB10G_HOME
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORACLE_HOME/network/jlib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/openwin/lib
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export TMP=/usr/temp
export TMPDIR=$TMP
~




so when I run the bash, the env still pointed to 9i instead of 10G


1. what did I do wrong???? but when I do: export ORACLE_HOME=$DB10G_HOME on the command line, it works fine.

2. what is the differences between !#bin/bash and !#bin/ksh???? b/c at fitrst when I have !#/bin/bash, it tells me that wrong version.

Please advise

Have you tried using oraenv for your settings?

No, How do you do that??? Could you please give me some instructions???

How are you running the script? Are you using:
./scriptname
or
. ./scriptname

If you are using the first method, then your environment goes back to the original settings when the script exits. If you want to make them permanent, then putting them in your login scripts is a good choice.

I think I want to use
./script_name b/c I want to reset the env everytime I log out of the server. and every time I log in the database server I have to run ./script_name to set the env.

coudl you please give me instructions of how to do that???

If you are simply doing ./scriptname, then your environment is gone when the script exits. Do the following:
. ./scriptname

Notice the space between the periods. This will "source" the script to your current shell. When you exit the shell or logout, then the environment is gone.

They will be permanent if you put them in your login scripts.

thanks