Install Oracle Client 12c < Bonus Inside >

Administrator installation using ZIP distribution on dedicated Linux server or VM. Report prepared for: System Administration / Database Team Oracle Client Version: 12.2.0.1 Last validated: [Current Date]

export LD_LIBRARY_PATH=/opt/oracle/instantclient_12_2:$LD_LIBRARY_PATH export PATH=/opt/oracle/instantclient_12_2:$PATH export TNS_ADMIN=/opt/oracle/instantclient_12_2/network/admin 5.1 Set Environment Variables ( ~oracle/.bash_profile ) export ORACLE_HOME=/u01/app/oracle/product/12.2.0/client_1 export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH export PATH=$ORACLE_HOME/bin:$PATH export TNS_ADMIN=$ORACLE_HOME/network/admin 5.2 Configure tnsnames.ora Create $TNS_ADMIN/tnsnames.ora : install oracle client 12c

PROD = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = db-server.example.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = proddb) ) ) sqlplus scott/tiger@PROD sqlplus /nolog SQL> connect scott/tiger@PROD 5.4 Optional: Configure sqlnet.ora For connection timeout, logging: install oracle client 12c