Oraenv in 11.2.0.2

Posted in: Technical Track

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:

[[email protected] trace]$ . oraenv
ORACLE_SID = [r1] ? t1
The Oracle base has been changed from /u01/app/oracle to /u04/app/oracle
[[email protected] 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!

email
Want to talk with an expert? Schedule a call with our team to get the conversation started.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *