THE WORLD DISCUSSES #PYTHIAN ON TWITTER. HAVE A QUESTION? USE OUR HASHTAG AND ASK AWAY.

oraenv in 11.2.0.2

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!

Facebook Twitter Email

Leave a Reply

Start NowWith Pythian - database design, management and emergency handling capabilities...

Live Updates

pythian: RT @FN_Press2: Schooner Information Technology Teams with Pythian to Deliver Advanced Support and High... http://finanznachrichten.de/20
more



Testimonials

  • Serge Racine

    DBA, Brookfield Energy

    We are very satisfied by the service given to us by Andre and Shakir in support of our recent data quality and reorganization initiative.... more



Social links powered by Ecreative Internet Marketing