taaz
asked on
. oraenv
I did change the
Oracle user environment in the user oracle's .bash_profile file in linux
as
ORACLE_BASE=/u0/app/oracle
ORACLE_BASE=/u0/pp/oracle/ product/11 .2.0/db_7
ORACLE__SID=ORCLT
export ORACLE_BASE
export ORACLE_BASE
export ORACLE__SID
why the change is not effective in
env | grep ora
user=oracle
HOME=/home/oracle
...
Oracle user environment in the user oracle's .bash_profile file in linux
as
ORACLE_BASE=/u0/app/oracle
ORACLE_BASE=/u0/pp/oracle/
ORACLE__SID=ORCLT
export ORACLE_BASE
export ORACLE_BASE
export ORACLE__SID
why the change is not effective in
env | grep ora
user=oracle
HOME=/home/oracle
...
assuming you started a new session after you saved the .bashrc: Case sensitivity:
env | grep -i ora
env | grep -i ora
taaz is correct
>>taaz is correct
taaz is the asker, correct about what?
If you meant 'slightwv is correct', there is not really a need to post this.
taaz is the asker, correct about what?
If you meant 'slightwv is correct', there is not really a need to post this.
no...slightwv is not correct fully :))
Please show:
Please show:
cat /etc/oratab
Oraenv scan this file.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
cat /etc/oratab
#
ORCLT:/u0/app/oracle/produ ct/11.2.0/ db_7:N
#
ORCLT:/u0/app/oracle/produ
taaz,
Please clarify the question. Are you asking why you cannot see ORACLE_HOME with "env | grep ora" or why the file 'oraenv' isn't properly setting the environment?
Please clarify the question. Are you asking why you cannot see ORACLE_HOME with "env | grep ora" or why the file 'oraenv' isn't properly setting the environment?
ASKER
even though I set the environment in the .bash_profile of user oracle
I still have to manually set the
ORACLE_HOME after running the
. oraenv
ORACLE_SID = [ORCTL]?
ORACLE_HOEM = [/u0/oracle]?
I still have to manually set the
ORACLE_HOME after running the
. oraenv
ORACLE_SID = [ORCTL]?
ORACLE_HOEM = [/u0/oracle]?
ASKER
. oraenv reflects the entries in the .bash_profile?
If you want oraenv to set the variables, set ORAENV_ASK to NO:
export ORACLE_SID=ORCLT
ORAENV_ASK=NO
. oraenv
export ORACLE_SID=ORCLT
ORAENV_ASK=NO
. oraenv
ASKER
slightwv is correct and I'll be more careful in putting questions.
Need to be more patient.
Sorry for causing trouble.
Need to be more patient.
Sorry for causing trouble.
after modification of .profile do this
$soruce .profile
Then check the variables using echo
echo $ORACLE_SID
$soruce .profile
Then check the variables using echo
echo $ORACLE_SID
ASKER
ORACLE_BASE=/u0/app/oracle
ORACLE_HOME=/u0/pp/oracle/
ORACLE__SID=ORCLT
export ORACLE_BASE
export ORACLE_HOME
export ORACLE__SID
why the change is not effective in
env | grep ora
user=oracle
HOME=/home/oracle