Step by step – Oracle 12c R2 Database Ubuntu 21.04 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
    export TMP=/tmp;
    export TMPDIR=$TMP; 
    export ORACLE_HOSTNAME=[HOSTNAME]; 
    export ORACLE_BASE=/u01/app/oracle;
    export ORACLE_HOME=$ORACLE_BASE/product/12/dbhome_1; 
    export ORACLE_SID=[DBSID]; 
    export ORACLE_UNQNAME=$ORACLE_SID;
    export PATH=/usr/sbin:$ORACLE_HOME/bin:$PATH; 
    export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/lib64; 
    export 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