Oraenv in 11.2.0.2

Oct 13, 2010 / By Andrey Goryunov

Tags: ,

oraenv is great utility that helps to control environment
and to avoid exact use of ORACLE_… variables in scripts.
With invention of ORACLE_BASE it was enhanced to change the variable
and to print the value in the output.

But with more than one oracle homes installed that use not the same oracle base
path it does not switch oracle bases and leaves it to be the same as it is selected
during the first execution of oraenv(switching $ORACLE_BASE using oraenv in 11g)

More interesting that behaviour of oraenv in 11.2.0.2 has been changed
and now it is able to switch oracle base variables but it does not
show oracle home path in the output, only oracle base:

[oracle@r1 trace]$ . oraenv
ORACLE_SID = [r1] ? t1
The Oracle base has been changed from /u01/app/oracle to /u04/app/oracle
[oracle@r1 trace]$ . oraenv
ORACLE_SID = [t1] ? r1
The Oracle base has been changed from /u04/app/oracle to /u01/app/oracle

Is that a new feature or just a bug that does not show oracle home path
in oraenv output…

Have a good day!

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>