Link to home
Start Free TrialLog in
Avatar of taaz
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
...
Avatar of taaz
taaz

ASKER

correction:
ORACLE_BASE=/u0/app/oracle
ORACLE_HOME=/u0/pp/oracle/product/11.2.0/db_7
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
Avatar of slightwv (䄆 Netminder)
assuming you started a new session after you saved the .bashrc:  Case sensitivity:

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.
no...slightwv is not correct fully :))
Please show:
cat /etc/oratab

Open in new window

Oraenv scan this file.
ASKER CERTIFIED SOLUTION
Avatar of slightwv (䄆 Netminder)
slightwv (䄆 Netminder)

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of taaz

ASKER

cat /etc/oratab
#
ORCLT:/u0/app/oracle/product/11.2.0/db_7:N
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?
Avatar of taaz

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]?
Avatar of taaz

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
Avatar of taaz

ASKER

slightwv is correct and I'll be more careful in putting questions.
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