Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PATH versus ORACLE_HOME

Stephan van HoofJul 19 2007 — edited Nov 28 2008
Hi,
(the paths I mention below are just for this question, in real life they would be different)
Using Oracle on Linux (Debian)
Imagine I've 2 Oracle Homes on this machine: /u01/ora817 and /u01/ora920

PATH is set to : /usr/local/bin:/usr/bin:/bin:/usr/games:/u01/ora817/bin
ORACLE_HOME is set to: /u01/ora920
(PLEASE note: the Oracle part in PATH differs from ORACLE_HOME/bin)

Next I start sqlplus, which will run (from /u01/ora817/bin) because of a valid PATH to it and and valid ORACLE_HOME set (so sqlplus can find the message files and others, but from a different oracle_home)

My questions:
- I wonder what happens when I issue a 'startup nomount' --> what Oracle version (binaries) are used in the situation outlined above?
- In general: what role plays sqlplus in controlling an instance?
- Is it a good practice to incorparate an ORACLE_HOME/bin in the PATH environment variable? Or should I always issue commands like $ORACLE_HOME/bin/sqlplus to be sure of the version (oracle_home) used?

Thanks
Regards
Stephan

null
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 26 2008
Added on Jul 19 2007
8 comments
1,238 views