bash profile and listener.ora file entries

After we've Installed a new database, we need to add entries in .bash_profile and listener.ora files as per our requirements. So here in this post I've shared the generally used entries. Add the below entries apart from already existing entries of your database.

.bash_profile entry

LD_LIBRABRY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRABRY_PATH

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

BASE_PATH=/usr/sbin:$PATH:$HOME/bin; export BASE_PATH

PATH=$ORACLE_HOME/bin:$BASE_PATH; export PATH

                                  

listener.ora file entry

SID_LIST_ocl =

 (SID_LIST =

  (SID_DESC =

   (ORACLE_HOME=/u01/app/oraprim/product/12.1.0/dbhome_1)

   (SID_NAME=orcl)

  )

 )