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.
- Posted in: Tales from the Scrypt