Only one time set up the ORACLE_HOME, ORACLE_SID, and ORACLE_BASE variables (Linux)

To configure our environment variables only once, we have to edit a file called bash_profile, with the Oracle user.

In the file we have to add three ORACLE_BASE variables which is the path where our oracle is, ORACLE_HOME which is the home path of the database and lastly ORACLE_SID which is the sid ne our database.

In my case the ORACLE_BASE is '/ oracle / app / oracle', the ORACLE_HOME is '/oracle/app/oracle/product/11.2.0/db_1' and the ORACLE_SID is 'ora11g'.

To edit the file we run:

Vi ~ / .bash_profile

To add the variables we go to the end of the file and press the insert key, next we add the variables that in my case would be:

 
ORACLE_BASE=/oracle/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=ora11g; export ORACLE_SID

And finally to save the file we press the escape key and type ': wq' we press enter and then we proceed to restart the machine.