Re: Two different Oracle versions on one server?

Add a new line to /var/opt/oracle/oratab, temporarely use a dummy Oracle sid and let it point to the new Oracle home to be installed. Use oraenv script to set the environment by specifying that dummy sid. Check all your environment variables. None should include the old Oracle home.
Most important variables are PATH, LD_LIBRARY_PATH, ORA_NLS33, because oraenv only takes care of the PATH variable. If core dumps occur just by starting sqlplus or so, you did not do this part properly. Now you can start the OraInstaller and install softare in another home

It is because of these situations, I never never want to see lines like

   ORACLE_HOME=/oracle/product/817
   PATH=$ORACLE_HOME/bin;$PATH
in shell scripts because then you are in trouble. I believe that Oracle's script oraenv does an incomplete job unfortunately. So write your own, complete script but use the trick of oraenv to remove the old ORACLE_HOME/bin from the PATH and include the new one for LD_LIBRARY_PATH etc...

Rick Denoire <100.17706_at_germanynet.de> schreef in berichtnieuws 0duvlugjepf2v6eliv9v9nm0ngq2js8vs3_at_4ax.com...
| "Anton Buijs" <aammbuijs_at_xs4all.nl> wrote:
|
| >Please first specify the platform you are running on before the "gotchas"
| >can be told.
| >(Oracle version(s) and platform(s) should always be stated when posting
this
| >newsgroup)
| >
|
| Oh sorry!
|
| Oracle 8.1.7 / Solaris 2.7 /Sun E3500
|
| Bye
| Rick
Received on Sun Aug 18 2002 - 15:03:47 CDT