How to install the Oracle Client on Linux/Unix Operating Systems In Silent Mode

Being a business intelligence administrator it’s very important to have the hands on experience on Oracle client installation, tnsnames.ora file administration & database connectivity issue debugging. Here I’ve written the simple steps required to install the Oracle client on any of the app servers with Linux/Unix Operating systems.

                                                                                                Before you start installing please verify all the rpm packages required for the oracle have installed. You must have a separate OS account (oracle) & Group (oinstall) created for the oracle client & make sure to have the required installation directory /opt/oracle & /opt/oraInventory should be owned by the oracle account & oinstall group. You must have the access or switch user privilege to root account to execute the orainstRoot.sh script.

Please follow the below simple steps :

1.    Create the Installation directory /opt/oracle/product/12.1.0/client_1

2.    Create the directory /opt/oraInventory.

3.    Create a temp folder & copy the software dump to it & Unzip the software zip file.

4.    Update the /opt/oracle/product/12.1.0/temp/client/response/client_install.rsp with below variables (Search for the below variables & update accordingly to environment).

INVENTORY_LOCATION=/opt/oraInventory

ORACLE_HOSTNAME=local.host.com

UNIX_GROUP_NAME=oinstall

ORACLE_HOME=/opt/oracle/product/12.1.0/client_1

ORACLE_BASE=/opt/oracle

oracle.install.client.installType=Administrator

5.    Set the display (Color) variable.

DISPLAY=Host IP Adress:0.0;

export DISPLAY

For Example :

DISPLAY=11.02.103.010:0.0;

export DISPLAY

6.    Navigate to the software dump temp folder (cd /opt/oracle/product/12.1.0/temp/client)

7.    Execute the installation script in silent mode using the below command line.

./runInstaller -silent -showProgress -responseFile "/opt/oracle/product/12.1.0/temp/client/response/client_install.rsp"

8.    Once Installation is completed successfully, We need to logout & login back with root account

9.    Navigate to the /opt/oraInventory & execute the script ./orainstRoot.sh

10. Update the .bash_profile with below variables & execute .sqlplus & tnsping to verify the successful installation.

#####################ORACLE###########################

export ORACLE_BASE=/opt/oracle;

export ORACLE_HOME=/opt/oracle/product/12.1.0/client_1

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8;

export NLS_CHARACTERSET=AMERICAN_AMERICA.AL32UTF8;

export NLS_NCHAR_CHARACTERSET=AMERICAN_AMERICA.UTF8;

export TNS_ADMIN=$ORACLE_HOME/network/admin;

export PATH=$PATH:$ORACLE_HOME/bin;

export LD_LIBRARY_PATH=$ORACLE_HOME/lib;

client]$ ./runInstaller -silent -showProgress -responseFile "/opt/oracle/product/12.1.0/temp/client/response/client_install.rsp"

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 415 MB.   Actual 7291 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 8150 MB    Passed

Prepare in progress.

..................................................   8% Done.

Prepare successful.

Copy files in progress.

..................................................   23% Done.

..................................................   51% Done.

..................................................   56% Done.

..................................................   61% Done.

..................................................   71% Done.

Copy files successful.

Link binaries in progress.

Link binaries successful.

Setup files in progress.

..............................

Setup files successful.

Setup Inventory in progress.

Setup Inventory successful.

..................................................   76% Done.

Finish Setup successful.

The installation of Oracle Client 12c was successful.

Please check '/opt/oraInventory/logs/silentInstall2017-04-02_04-47-06PM.log' for more details.

Prepare for configuration steps in progress.

Prepare for configuration steps successful.

..................................................   95% Done.

As a root user, execute the following script(s):

        1. /opt/oraInventory/orainstRoot.sh

..................................................   100% Done.

Successfully Setup Software.

client]$