Friday, June 13, 2014

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.
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



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.

1 comment:

  1. I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in TECHNOLOGY , kindly contact us http://www.maxmunus.com/contact
    MaxMunus Offer World Class Virtual Instructor led training on TECHNOLOGY. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
    For Demo Contact us.
    Saurabh Srivastava
    MaxMunus
    E-mail: saurabh@maxmunus.com
    Skype id: saurabhmaxmunus
    Ph:+91 8553576305 / 080 - 41103383
    http://www.maxmunus.com/


    ReplyDelete

Dear User,

Thank you very much for your kind response