Oracle 12c Database Installation How-to SetUp PATH and SID

The Guide Show Visually How-to Properly SetUp PATH and SID for Oracle 12c Database Installation.

This is Good because it Facilitate the Oracle 12c Database Installation and Management...

1. Oracle PATH and SID SetUp Login as Oracle

   su oracle

2. Edit the .bash_profile

   nano /home/oracle/.bash_profile

   Insert:

   # Oracle Settings
   TMP=/tmp; export TMP
   TMPDIR=$TMP; export TMPDIR
   
   ORACLE_HOSTNAME=<HOSTNAME>; export ORACLE_HOSTNAME
   ORACLE_UNQNAME=DB11G; export ORACLE_UNQNAME
   ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
   ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1; export ORACLE_HOME
   ORACLE_SID=<DBSID>; export ORACLE_SID
   
   PATH=/usr/sbin:$PATH; export PATH
   PATH=$ORACLE_HOME/bin:$PATH; export PATH
   
   LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
   CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
   

   Substitute HOSTNAME and DBSID with the Values you Will Use During Software Installation In this Example Respectively:
   • HOSTNAME = 127.0.0.1
   • DBSID = SID

3. Then Load the New SetUp:

   source /home/oracle/.bash_profile