Configure Oracle environment variables

  1. Switch to the Oracle account.

su - oracle

  1. Modify the .bash_profile file.

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/db

export ORACLE_SID=orcl

export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib

export DISPLAY=172.20.176.207:0.0

172.20.176.207 is the local PC's IP address.

  1. Validate the configuration.

source .bash_profile