Hi,
I have 10 database instances runnning in one unix box. To connect to each database..i have to set the environment. I am trying to write a shell script to set my environment for database by just tying the oracle instance name


After logging into the unix machine... i want to type the oracle instacne name and the environment needs to be set for the typed oracle instance

How to pass an oracle instance name typed in the console to the shell script

any idea? how to do this

Is there any other way to do?


$/u01/oracle/ORACLEINSTANCENAME

Script:

FILE_LOCATION=/etc/oratab

dbname=awk 'BEGIN{FS=":"}{print $1}' < "$FILE_LOCATION" )
do
#echo "USER #$n = $dbname"
echo $dbname
if [$dbname= passed_db_name]
export ORACLE_SID=dbname
done



Many Thanks,