| shikhu |
Posted: Oct 19, 2007 03:13:36 AM |
Total Post: 61
Joined: Jul, 2006
|
Hi All,
I have installed Oracle on Linux machine it is working fine but each and every time when I open a session I have to set .oraenv for oracle_sid I have set this parameter in .bash_profile also but it is not working.
I dont want to set it each and every time rather I want to set it permanently
plz. help me out.
Its urgent!!!!!!!!!!!!!
- shikha
|
|
|
 dbavinod |
| Posted: Oct 19, 2007 05:46:24 AM |  |
|
Total Post: 90
Joined: Sep, 2006
|
Hello
Have all the Parms in .profile or .bash_profile depends on Platform
Thats it these profiles executes automatically for new session.
export EDITOR
export ORACLE_BASE=/var/oracle/oracle/product/10.2.0/db_1
export ORACLE_HOME=/var/oracle/oracle/product/10.2.0/db_1
export ORACLE_SID=TEST
export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
Regards
Vinod
|
|
|
|
|
| Mohammed Taj |
| Posted: Oct 20, 2007 12:59:13 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
As vinod desc ...set your .bash_profile or .profile as user default profile.
and after set all above oracle variable run bash profile like $ ./.bash_profile
so next time whenever you login you have not set any oracle variable.
Regards
Mohammed Taj
|
|
|
|
|
| shikhu |
| Posted: Oct 22, 2007 03:46:34 AM | |
|
Total Post: 61
Joined: Jul, 2006
|
Hi,
Its not working I have set all the parameters but again I need to set the .oraenv , I have checked with echoing also it is showing the sid and home.
what to do ?????????
|
|
|
|
|
| suni |
| Posted: Oct 24, 2007 03:01:44 AM | |
|
Total Post: 11
Joined: Oct, 2007
|
while switching to user, try to switch as
# su - <oracleuser>
then the .bash_profile of the user gets executed.
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
