multiple ORACLE_HOMEs for oracle user
Platform - HP-UX PA-RISC OS 11.11 DB - EE 9.2.0.7.0
Had a problem upgrading to 9.2.0.8.0 with custom app. So rolled back to 9.2.0.7.0. Have 3 db's (TEST, STAGING & RCO) db's on this box.
Even though I did not upgrade rco db specifically, when I try logging into rco using SQL Plus after rollback, it thinks it is @9.2.0.8.0. I ended up deleting rco (had problem with JAVA) during uninstall using DBCA. So I just rm files for rco db. Want to create a seperate mount point for newly created rco database. But have concerns about how to differentiate between Oracle Homes when logging in as oracle user(blowing away other 2 db's). Would have 2 9.2.0.7.0 OH after another install.
0