oraenv on Steroids part 4

Once we have the $ORACLE_SID and $ORACLE_HOME, we can now assign environment variables for important files that are always used but a pain in the ass to manage:

  • PFILE – Points to $ORACLE_HOME/dbs/init$ORACLE_SID.ora
  • ORAPW – Points to the password file $ORACLE_HOME/dbs/orapw$ORACLE_SID
  • RLWRAP – Is rlwrap installed?  If so it will be used by other scripts to give BASH command completion with tools like SQL*Plus, RMAN , etc.  If not, it will be blank and have no effect.
  • GRID_HOME – when using the –grid option, sets $GRID_HOME and $ORACLE_HOME to the configured ASM home
  • PATH – ensures $ORACLE_HOME/bin is in your path

The full implementation of oraenv.sh can be downloaded here.


Comments are closed.