Step-by-step – Oracle 12c R2 Database Ubuntu 21.10 Installation

Setting Up Paths

11. 11. Setting the PATH

    Next to Add Paths to oracle’s .bashrc
    First, Login as the Oracle User with:

    su oracle

    Then Edit the .bashrc file:

    nano ~/.bashrc

    Append:

    # Oracle Settings/nexport TMP=/tmp;/nexport TMPDIR=$TMP; /nexport ORACLE_HOSTNAME=[HOSTNAME]; /nexport ORACLE_BASE=/u01/app/oracle;/nexport ORACLE_HOME=$ORACLE_BASE/product/12/dbhome_1; /nexport ORACLE_SID=[DBSID]; /nexport ORACLE_UNQNAME=$ORACLE_SID;/nexport PATH=/usr/sbin:$ORACLE_HOME/bin:$PATH; /nexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/lib64; /nexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;
    

    Replace [HOSTNAME] with IP and [DBSID] with SID Name
    For a Local Setup as here, Respectively:

    • HOSTNAME = 127.0.0.1.

    • DBSID = SID.

    Finally, ReLoad the New .bashrc Settings simply as:

    bash