Install Oracle Client 11 on centos 7.4

Il cliente Oracle contiene un set di librerie e utility per connettersi ad un database Oracle.
Contiene API come ODBC, OCCI, OCI, JBD e Pro*C e utility come Sql Plus.

• Effettuare il download dell'Instant client da Oracle.

Individuare la versione linux da scaricare.
[root@coslab02 ~]# uname -r
3.10.0-693.5.2.el7.x86_64

Scaricare i pacchetti:
instantclient-sdk-linux.x64-11.2.0.4.0.zip
instantclient-sqlplus-linux.x64-11.2.0.4.0.zip
instantclient-basic-linux.x64-11.2.0.4.0.zip

• Creare la directory seguente dove  trasferire i suddetti file in formato zip.

[root@coslab02 oracle]# mkdir -p /u01/app/oracle
[root@coslab02 oracle]# ls -lrt
totale 60732
-rw-r--r-- 1 root root 60704657 13 nov 11.39 instantclient-basic-linux.x64-11.2.0.4.0.zip
-rw-r--r-- 1 root root   643089 13 nov 11.39 instantclient-sdk-linux.x64-11.2.0.4.0.zip
-rw-r--r-- 1 root root   834491 13 nov 11.39 instantclient-sqlplus-linux.x64-11.2.0.4.0.zip

• Effettuare l'unzip di tutti i file che verranno scaricati sotto la directory "instantclient_11_2"

[root@coslab02 oracle]# ls -lrt
totale 60736
-rw-r--r-- 1 root root 60704657 13 nov 11.39 instantclient-basic-linux.x64-11.2.0.4.0.zip
-rw-r--r-- 1 root root   643089 13 nov 11.39 instantclient-sdk-linux.x64-11.2.0.4.0.zip
-rw-r--r-- 1 root root   834491 13 nov 11.39 instantclient-sqlplus-linux.x64-11.2.0.4.0.zip
drwxr-xr-x 3 root root     4096 13 nov 11.42 instantclient_11_2

• Creare due link simobili

[root@coslab02 instantclient_11_2]# ln -s libocci.so.11.1 libocci.so
[root@coslab02 instantclient_11_2]# ln -s libclntsh.so.11.1 libclntsh.so
[root@coslab02 instantclient_11_2]# ls -lrt
totale 186444
-rwxrwxr-x 1 root root    192365 24 ago  2013 uidrvci
-rwxrwxr-x 1 root root 118738042 24 ago  2013 libociei.so
-r-xr-xr-x 1 root root   7996693 24 ago  2013 libnnz11.so
-rwxrwxr-x 1 root root     47860 24 ago  2013 genezi
-rw-rw-r-- 1 root root       439 24 ago  2013 BASIC_README
-rwxrwxr-x 1 root root     25420 24 ago  2013 adrci
-rwxrwxr-x 1 root root   1973074 24 ago  2013 libocci.so.11.1
-rwxrwxr-x 1 root root  53865194 24 ago  2013 libclntsh.so.11.1
-rw-rw-r-- 1 root root     66779 24 ago  2013 xstreams.jar
-r--r--r-- 1 root root   2739616 24 ago  2013 ojdbc6.jar
-r--r--r-- 1 root root   2091135 24 ago  2013 ojdbc5.jar
-r-xr-xr-x 1 root root    164942 24 ago  2013 libocijdbc11.so
-rw-rw-r-- 1 root root       443 24 ago  2013 SQLPLUS_README
-r-xr-xr-x 1 root root      9320 24 ago  2013 sqlplus
-r-xr-xr-x 1 root root   1469542 24 ago  2013 libsqlplus.so
-r-xr-xr-x 1 root root   1502287 24 ago  2013 libsqlplusic.so
-r-xr-xr-x 1 root root       368 24 ago  2013 glogin.sql
drwxrwxr-x 4 root root        79 24 ago  2013 sdk
lrwxrwxrwx 1 root root        15 13 nov 11.45 libocci.so -> libocci.so.11.1
lrwxrwxrwx 1 root root        17 13 nov 11.46 libclntsh.so -> libclntsh.so.11.1

• Impostare la variabile di ambiente LD_LIBRARY_PATH prima di eseguire le applicazioni.

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/u01/app/oracle/instantclient_11_2;

• Se si vogliono usare file di configurazione per la connessione sqlplus come tnsnames.ora e sqlnet.ora, creare le sottodirectory network/admin

[root@coslab02 instantclient_11_2]# mkdir -p /u01/app/oracle/instantclient_11_2/network/admin
[root@coslab02 admin]# ls -lrt
totale 8
-rw-r----- 1 root root 1477 13 nov 12.12 tnsnames.ora
-rw-r----- 1 root root  274 13 nov 12.12 sqlnet.ora

• Impostare la variabile d'ambiente per eseguire sqlplus da qualsiasi path.

export PATH=$PATH:/u01/app/oracle/instantclient_11_2

Collegarsi al db con il metodo "Local Naming" che utilizza il file di configurazione tnsnames.ora lato client.

[root@coslab02 instantclient_11_2]# sqlplus ad200/ad200@SAIT
SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 13 12:19:37 2019
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
SQL> show user
USER is "AD200"

Se invece non è presente il tnsnames.ora o non è configurato correttamente usare il metodo "Easy Connect" che non usa file di configurazione lato cliente ma la stringa di connessione tcp/ip

[root@coslab02 instantclient_11_2]# sqlplus ad200/ad200@<nome_server.dominio>:1521/SAIT
SQL*Plus: Release 11.2.0.4.0 Production on Wed Nov 13 12:22:12 2019
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
SQL> show user
USER is "AD200"