$SQLPATH vs $ORACLE_PATH

Every time I install a new oracle machine it hits me:

Why is login.sql not executed when I start a sqlplus session.

So here is a quick reminder for myself:

sqlplus is not looking in $SQLPATH for login.sql ….. it is looking in $ORACLE_PATH

 

So set $ORACLE_PATH and you will be fine.

 

This changed somewhere around oracle 11 or 12

Leave a Reply

Your email address will not be published. Required fields are marked *