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