Step by Step installation of Oracle Client
As most of us already know oracle client is installed on the application server to execute SQL command or compile script related to the application.
Below is the step by step installation of Oracle client on UNIX.
Step1: Created users and group
Below we are creating groups and user.
[root@DBsGuru01 ~]# groupadd dba
[root@DBsGuru01 ~]# useradd oracle
[root@DBsGuru01 ~]# passwd oracle
Changing password for user oracle
New password: Retype new password:
Step2: Create required directories and Changing ownership
Below are the directories required for installation. it is optional you can use any directories where you want to install oracle client binary.
[root@DBsGuru01 tmp]# mkdir -p /u01/app/oracle
[root@DBsGuru01 tmp]# mkdir -p /u01/app/oraInventory
[root@DBsGuru01 tmp]# chown -R oracle:dba /u01
[root@DBsGuru01 tmp]# chown -R oracle:dba /u02
Step3: Switch user oracle, go to a binary location and unzip Oracle Client binary
Here oracle client binary present in /u01/software/client in your case it would be in a different locations. after unzipping the client binary, we get the below output.
[oracle@DBsGuru01 client]$ unzip V839967-01.zip
[oracle@DBsGuru01 client]$ pwd
/u01/software/client
[oracle@DBsGuru01 client]$ ls -lrt
-rwxrwxr-x 1 oracle dba 500 Feb 6 2013 welcome.html
-rwxr-xr-x 1 oracle dba 8775 Jan 26 2017 runInstaller
drwxr-xr-x 4 oracle dba 234 Jan 26 2017 install
drwxrwxr-x 2 oracle dba 49 Jan 26 2017 response
drwxr-xr-x 14 oracle dba 4096 Jan 26 2017 stage
step 4: Now start Installation of Oracle Client
After executing runInstaller, it will check for some pre-requisite then it will direct to the installation page.
[oracle@DBsGuru01 admin]$ ./runInstaller
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 415 MB. Actual 20429 MB Passed
Checking swap space: must be greater than 150 MB. Actual 24574 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-10-12_10-59-13AM. Please wait ...$
Follow below screenshots to further steps:
Select option Administrator or custom as required
Put here Oracle Base & Software location as we created in step2.
In this section put Inventory location and select group for the same.
Since we have opted here custom so click on the check box for required components.
Here it shows a summary before proceeding with client installation.
In this section, we can see the completion progress of client installation.
Now we have to execute orainstRoot.sh as root user either execute by own if have privileges or ask Unix admin to execute it and click on OK once successful execution.
Congratulation Oracle client installation is successful.
Step5: Execute orainstRoot.sh from root user.
In my environment, we have root access to execute orainstRoot.sh, so we have executed as mentioned earlier.
Below is the output of OrainstRoot.sh
[root@DBsGuru01 ~]# /u01/app/oracle/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oracle/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oracle/oraInventory to dba.
The execution of the script is complete.
Step6: Add TNS entry.
Add tns entry into tnsname.ora on oracle client server and validate Tnsping command
[oracle@DBsGuru01 admin]$ pwd
/u01/oracle/base/product/12.1.0/client_1/network/admin
TEST1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =DBsguru-scan)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST1)
)
)
Check tnsping status from a remote server(Oracle client-server)
[oracle@DBsGuru01 admin]$ tnsping test1
TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 14-OCT-2020 13:37:06
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
/u01/oracle/base/product/12.1.0/client_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =DBsguru-scan)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TEST1)))
OK (0 msec)
Step6: Test one remote connection from the client machine where we have a newly installed Oracle client.
Below is the test connection which we made from the remote server where we installed oracle client.
SQL*Plus: Release 12.1.0.2.0 Production on Thu Oct 15 08:56:32 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Enter user-name: demouser@test1
Enter password:
Last Successful login time: Wed Oct 14 2020 17:47:52 -04:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select host_name, LOGINS,INSTANCE_NAME,ACTIVE_STATE,DATABASE_STATUS,to_char(startup_time,'dd-mon-yyyy hh24:mi:ss') startup_time from gv$instance;
HOST_NAME LOGINS INSTANCE_NAME ACTIVE_ST DATABASE_STATUS STARTUP_TIME
-------------------------------------------------- ---------- ---------------- --------- ----------------- -----------------------------
rvccdrdbadm01.raritanval.edu ALLOWED TEST1 NORMAL ACTIVE 15-oct-2020 10:24:09
rvccdrdbadm02.raritanval.edu ALLOWED TEST2 NORMAL ACTIVE 15-oct-2020 10:24:09
This document is just for learning purpose and always validate in the LAB environment first before applying in the LIVE environment.
Hope so you like this article!
Please share your valuable feedback/comments/subscribe and follow us below and don’t forget to click on the bell icon to get the most recent update. Click here to know more about our pursuit.
