Hi,
I am trying to set the environment for my oracle database. I have 5 database in an unix box. My idea is to create 5 files for each database with the following script on it.
After logging into the unix box ...just by typing the database name....the enviornment for the database will be set.
not able to set the environment by calling the file name which is sadev(same as database name)
-
Created a file with name sadev
-
contents in sadev file
export ORACLE_SID=SADEV
echo $ORACLE_SID -
running the file
eg: deveopmentbox# sadev
sadev
# echo $ORACLE_SID
sademo
I am not able to set the environment the ORACLE_SID=sadev. The "sademo" is set in the .profile of the user.
when i execute the commands inside the file i am able to set the environment for any database instance.
Is there anything wrong in the above steps???
Many Thanks,