Oracle 11g: Install Instant Client 11.2.0.3.0 on Linux x86_64 Server.

Oracle 11g: Install Instant Client 11.2.0.3.0 on Linux x86_64 Server.



***What is Instant Client &benefits?
As per Oracle docs,

Oracle Database Instant Client

Instant Client allows you to run your applications without installing the standard Oracle client or having an ORACLE_HOME. OCI, OCCI, Pro*C, ODBC, and JDBC applications work without modification, while using significantly less disk space than before. Even SQL*Plus can be used with Instant Client. No recompile, no hassle.

ISVs and Partners benefit greatly from packaging Instant Client along with their applications, saving customers the extra step of installing and configuring an Oracle client. Free. The same fully-featured, high-performance applications that Oracle ISVs and partners have always delivered will continue to work, untouched.


Customers can try new packaged applications and Oracle client features quickly without worrying about other installations. Larger enterprises can automate setup and configuration of Instant Client by using installation scripts accessing a central IT repository. Finally, everyone can benefit from the smaller footprint.
Especially for production use. Especially for free.



Follow below steps (implemented & tested).

1. Download Instant client.

Use below link.
RPM Files.

oracle-instantclient11.2-jdbc-11.2.0.3.0-1.x86_64.rpm
instantclient-sqlplus-linux.x64-11.2.0.3.0.zip
 
2. Additional perquisite for 11.2.0.3.

Install Basics of 11.2.0.3

instantclient-basic-linux.x64-11.2.0.3.0.zip

oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm

3. Copy this all downloads to particular location where we can set path.

Oracle$usr/bin/instantclient.

Please change permission to oracle:dba.

Chgrpdba *
Chown oracle *

4. Unzip all .zip

unzip instantclient-basic-linux.x64-11.2.0.3.0.zip
unzip instantclient-sqlplus-linux.x64-11.2.0.3.0.zip
  

5. Install rpm 

a) rpm –ivh oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm
b) rpm –ivh oracle-instantclient11.2-jdbc-11.2.0.3.0-1.x86_64.rpm

6.set PATH & LD_LIBRARY_PATH

export LD_LIBRARY_PATH=/usr/bin/instantclient/instantclient_11_2
export PATH=$PATH:$LD_LIBRARY_PATH

7. Test Database connection with sqlplus

Sqlplus username/password@//ipaddressofdbserver:port/service_name
For e.g.
sqlplusdbexpert/dbexpert@//100.100.1.120:1521/experdb

Comments

Post a Comment

Dear User,

Thank you very much for your kind response

Popular posts from this blog

Agent Installation on Windows Server. SQL Server (Failover Cluster) target addition in OEM 12c

Image
Agent Installation on Windows Server. SQL Server (Failover Cluster) target addition in OEM 12c This document is prepared for monitoring windows server where sql server installed.Mostly used OEM for monitoring databases. In this document we will cover agent installation with target addition into OEM 12c. We will also cover prerequisite like enabling port for communication from agent to oms server Agent Installation on windows server  As a part of installation, we require to fulfil prerequisite like connectivity between OEM server and Window server. For Port opening and communication between two servers Ports required to open : 4903 , 7799 , 3872 Following steps require doing for manually installation of Agent in Windows server. Verifying if the agent exists on OMS. To begin, open your Cloud Control and go to "Setup -> Extensibility -> Self Update". Open the "Agent Software" folder and check if the Agent Software of Windows x64 is with statu...
Read more

Oracle 12c : How To Purge The UNIFIED AUDIT TRAIL

Image
Oracle 12c : How To Purge The UNIFIED AUDIT TRAIL  APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and later Information in this document applies to any platform. GOAL  How to purge the  UNIFIED_AUDIT_TRAIL table ? SOLUTION The unified audit trail can be purged using the DBMS_AUDIT_MGMT package:  qlplus / as sysdba SQL>  select  count(*) from unified_audit_trail;   COUNT(*) ----------       2619 SQL>  BEGIN DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL( audit_trail_type         =>  DBMS_AUDIT_MGMT.AUDIT_TRAIL_UNIFIED, use_last_arch_timestamp  =>  FALSE); END; / PL/SQL procedure successfully completed. SQL>  select  count(*) from unified_audit_trail;   COUNT(*) ----------          1 You can also use the last_arch_timestamp, if you don't want to purge all ...
Read more