Instant Client for linux

Instant Client for linux sometime for some reason, ex. you can't install on the host, not get the install package, or others. but you want connnect the oracle database via sqlplus only, in times you can use oracle Instant Client, the package very small than database or client package. I will show how-to use the package conn the database.0. download the package and extract file ~ /Define lient. [gtlions @ o564gtser1 ~] $ Ll initialize lient/total 185224-rwxrwxr-x 1 gtlions 25308 Sep 17 2011 adrci-rw-r -- 1 gtlions 437 Sep 17 2011 BASIC_README-rwxrwxr-x 1 gtlions 46228 Sep 17 2011 genezi-r -- r -- 1 gtlions 368 Sep 17 2011 glogin. SQL-rwxrwxr-x 1 gtlions 52761218 Sep 17 2011 libclntsh. so.11.1-r-xr-x 1 gtlions 7955322 Sep 17 2011 libnnz11.so-rwxrwxr-x 1 gtlions 1 971762 Sep 17 2011 libocci. so.11.1-rwxrwxr-x 1 gtlions 118408281 Sep 17 2011 libociei. so-r-xr-x 1 gtlions 164836 Sep 17 2011 libocijdbc11.so-r-xr-x 1 gtlions 1503303 Sep 17 2011 libsqlplusic. so-r-xr-x 1 gtlions 1477446 Sep 17 2011 libsqlplus. so-r -- 1 gtlions 2095661 Sep 17 2011 ojdbc5.jar-r -- 1 gtlions 2714016 Sep 17 2011 ojdbc6. Jar-r-xr-x 1 gtlions 9352 Sep 17 2011 sqlplus-rw-r -- 1 gtlions 441 Sep 17 2011 SQLPLUS_README-rw-rw-r -- 1 gtlions 177 May 6 tnsnames. ora-rwxrwxr-x 1 gtlions 191237 Sep 17 2011 uidrvci-rw-r -- 1 gtlions 66779 Sep 17 2011 xstreams. jar 1. edit env file. bash_profile like follow lines. [gtlions @ o564gtser1 ~] $ Cat. bash_profile #. bash_profile # Get the aliases and functionsif [-f ~ /. Bashrc]; then .~ /. Bashrcfi # User specific environment and startup programsexport LD_LIBRARY_PATH =/home/gtlions/Your lientexport PATH = $ PATH :~ /Define lientexport TNS_ADMIN = ~ /Define lient [gtlions @ o564gtser1 ~] $ Source. bash_profile 2. manual edit ~ /Define lient/tnsnames. ora connect strings. [gtlions @ o564gtser1 ~] $ Cat shortlient/tnsnames. oraora11g = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 10.46.1.3) (PORT = 1521) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ora11g ))) 3. connect it. [gtlions @ o564gtser1 ~] $ Sqlplus gtlions/000000 @ ora11g SQL * Plus: Release 11.2.0.3.0 Production on Mon May 6 12:17:46 2013 Copyright (c) 1982,201 1, Oracle. all rights reserved. connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> select * from v $ version; BANNER login Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit ProductionPL/SQL Release 11.2.0.2.0-ProductionCORE 11.2.0.2.0 ProductionTNS for IBM/AIX RISC System/6000: version 11.2.0.2.0-ProductionNLSRTL Version 11.2.0.2.0-Production-EOF-