install instant client

[root@ol354t1123 ~]# useradd -m -g oinstall -G dba oraClient

[root@ol354t1123 ~]# passwd oraClient
Changing password for user oraClient.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.

[root@ol354t1123 ~]# mkdir -p /client/instant
[root@ol354t1123 ~]# chown -R oraClient.oinstall /client
[root@ol354t1123 ~]# chmod -R 755 /opt
[root@ol354t1123 ~]# cd /client/instant
[root@ol354t1123 instant]# pwd
/client/instant

[root@ol354t1123 ~]# cd /client
[root@ol354t1123 client]# ll
合計 91120
drwxr-xr-x 2 root      root         4096 12月 18 14:51 10
drwxr-xr-x 2 root      root         4096 12月 18 14:51 11
drwxr-xr-x 2 oraClient oinstall     4096 12月 18 14:45 instant
-rw-r--r-- 1 root      root     58502865 12月 17 10:26 instantclient-basic-linux-11.2.0.3.0.zip
-rw-r--r-- 1 root      root     34687861 12月 17 10:31 oracle-instantclient-basic-10.2.0.4-1.i386.zip
[root@ol354t1123 client]# cd 10
[root@ol354t1123 10]# ll
合計 33348
-rw-r--r-- 1 root root 32782200 12月 17 10:31 oracle-instantclient-basic-10.2.0.4-1.i386.rpm
-rw-r--r-- 1 root root   289537 12月 18 14:41 oracle-instantclient-devel-10.2.0.4-1.i386.rpm
-rw-r--r-- 1 root root   279100 12月 18 14:41 oracle-instantclient-odbc-10.2.0.4-1.i386.rpm
-rw-r--r-- 1 root root   741350 12月 18 14:40 oracle-instantclient-sqlplus-10.2.0.4-1.i386.rpm
[root@ol354t1123 10]# rpm -ivh *.rpm
準備中...                ########################################### [100%]
   1:oracle-instantclient-ba########################################### [ 25%]
   2:oracle-instantclient-de########################################### [ 50%]
   3:oracle-instantclient-od########################################### [ 75%]
   4:oracle-instantclient-sq########################################### [100%]
[root@ol354t1123 10]# cd ..
[root@ol354t1123 client]# ll
合計 91120
drwxr-xr-x 2 root      root         4096 12月 18 14:51 10
drwxr-xr-x 2 root      root         4096 12月 18 14:51 11
drwxr-xr-x 2 oraClient oinstall     4096 12月 18 14:45 instant
-rw-r--r-- 1 root      root     58502865 12月 17 10:26 instantclient-basic-linux-11.2.0.3.0.zip
-rw-r--r-- 1 root      root     34687861 12月 17 10:31 oracle-instantclient-basic-10.2.0.4-1.i386.zip
[root@ol354t1123 client]# unzip oracle-instantclient-basic-10.2.0.4-1.i386.zip
Archive:  oracle-instantclient-basic-10.2.0.4-1.i386.zip
  inflating: instantclient_10_2/BASIC_README
  inflating: instantclient_10_2/classes12.jar
  inflating: instantclient_10_2/genezi
  inflating: instantclient_10_2/libclntsh.so.10.1
  inflating: instantclient_10_2/libnnz10.so
  inflating: instantclient_10_2/libocci.so.10.1
  inflating: instantclient_10_2/libociei.so
  inflating: instantclient_10_2/libocijdbc10.so
  inflating: instantclient_10_2/ojdbc14.jar
[oraClient@ol354t1123 admin]$ pwd
/client/instant/network/admin
[oraClient@ol354t1123 admin]$ vi tnsnames.ora

ora55 =
(DESCRIPTION =
  (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.236.55)(PORT = 1521))
   )
  (CONNECT_DATA=(SID=orcl))
)

[oraClient@ol354t1123 client]$ ll
合計 91856
drwxr-xr-x 2 oraClient oinstall     4096 12月 18 14:51 10
drwxr-xr-x 2 oraClient oinstall     4096 12月 18 14:51 11
drwxr-xr-x 3 oraClient oinstall     4096 12月 18 15:26 instant
-rw-r--r-- 1 oraClient oinstall 58502865 12月 17 10:26 instantclient-basic-linux-11.2.0.3.0.zip
drwxr-xr-x 2 oraClient oinstall     4096 12月 18 14:55 instantclient_10_2
-rw-r--r-- 1 oraClient oinstall 34687861 12月 17 10:31 oracle-instantclient-basic-10.2.0.4-1.i386.zip
-rw-r--r-- 1 root      root       744730 12月 18  2012 oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip
[oraClient@ol354t1123 client]$ unzip oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip
Archive:  oracle-instantclient-sqlplus-10.2.0.4-1.i386.zip
  inflating: instantclient_10_2/SQLPLUS_README
  inflating: instantclient_10_2/glogin.sql
  inflating: instantclient_10_2/libsqlplus.so
  inflating: instantclient_10_2/libsqlplusic.so
  inflating: instantclient_10_2/sqlplus

[oraClient@ol354t1123 client]$ cd instant
[oraClient@ol354t1123 instant]$ mkdir bin
[oraClient@ol354t1123 instant]$ mkdir lib

[oraClient@ol354t1123 instant]$ cd ..
[oraClient@ol354t1123 client]$ cd instantclient_10_2
[oraClient@ol354t1123 instantclient_10_2]$ ll
合計 102416
-rw-rw-r-- 1 oraClient oinstall      238  2月 17  2008 BASIC_README
-rw-rw-r-- 1 oraClient oinstall      242  2月 17  2008 SQLPLUS_README
-r--r--r-- 1 oraClient oinstall  1609607  2月 17  2008 classes12.jar
-rwxrwxr-x 1 oraClient oinstall    67766  2月 17  2008 genezi
-r--r--r-- 1 oraClient oinstall     1525  2月 17  2008 glogin.sql
-rwxrwxr-x 1 oraClient oinstall 19076649  2月 17  2008 libclntsh.so.10.1
-r-xr-xr-x 1 oraClient oinstall  5656445  2月 17  2008 libnnz10.so
-rwxrwxr-x 1 oraClient oinstall  1398244  2月 17  2008 libocci.so.10.1
-rwxrwxr-x 1 oraClient oinstall 72698427  2月 17  2008 libociei.so
-r-xr-xr-x 1 oraClient oinstall   120443  2月 17  2008 libocijdbc10.so
-r-xr-xr-x 1 oraClient oinstall  1069221  2月 17  2008 libsqlplus.so
-r-xr-xr-x 1 oraClient oinstall  1434263  2月 17  2008 libsqlplusic.so
-r--r--r-- 1 oraClient oinstall  1555682  2月 17  2008 ojdbc14.jar
-r-xr-xr-x 1 oraClient oinstall     8903  2月 17  2008 sqlplus
[oraClient@ol354t1123 instantclient_10_2]$ cp glogin.sql sqlplus $ORACLE_HOME/bin

[oraClient@ol354t1123 instantclient_10_2]$ cp BASIC_README SQLPLUS_README classes12.jar genezi libclntsh.so.10.1 libnnz1
0.so libocci.so.10.1 libociei.so libocijdbc10.so libsqlplus.so libsqlplusic.so ojdbc14.jar $ORACLE_HOME/lib

[oraClient@ol354t1123 ~]$ export ORACLE_HOME=/client/instant
[oraClient@ol354t1123 ~]$ export TNS_ADMIN=$ORACLE_HOME/network/admin
[oraClient@ol354t1123 ~]$ export LD_LIBRARY_PATH=$ORACLE_HOME/lib
[oraClient@ol354t1123 ~]$ export PATH=$ORACLE_HOME/bin:$PATH

[oraClient@ol354t1123 instantclient_10_2]$ cd

oraClient@ol354t1123 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Tue Dec 18 16:08:53 2012

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> conn userA/userA@ora55
Connected.
SQL> select * from test1;

        ID
----------
1

[root@ol354t1123 11]# ll
合計 58128
-rw-r--r-- 1 root root 57765315 12月 17 10:31 oracle-instantclient11.2-basic-11.2.0.3.0-1.i386.rpm
-rw-r--r-- 1 root root   608961 12月 18 14:50 oracle-instantclient11.2-devel-11.2.0.3.0-1.i386.rpm
-rw-r--r-- 1 root root   274625 12月 18 14:50 oracle-instantclient11.2-odbc-11.2.0.3.0-1.i386.rpm
-rw-r--r-- 1 root root   792165 12月 18 14:50 oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.i386.rpm
[root@ol354t1123 11]# rpm -ivh *.rpm
準備中...                ########################################### [100%]
        ファイル /usr/bin/sqlplus (パッケージ oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.i386 から) は、パッケージ oracle-instantclient-sqlplus-10.2.0.4-1.i386 からのファイルと競合しています。
[root@ol354t1123 11]#
[root@ol354t1123 11]# rpm -qa|grep oracle-instantclient
oracle-instantclient-sqlplus-10.2.0.4-1
oracle-instantclient-basic-10.2.0.4-1
oracle-instantclient-devel-10.2.0.4-1
oracle-instantclient-odbc-10.2.0.4-1
[root@ol354t1123 11]# rpm -e oracle-instantclient-sqlplus-10.2.0.4-1
[root@ol354t1123 11]# rpm -qa|grep oracle-instantclient
oracle-instantclient-basic-10.2.0.4-1
oracle-instantclient-devel-10.2.0.4-1
oracle-instantclient-odbc-10.2.0.4-1
[root@ol354t1123 11]# rpm -ivh *.rpm
準備中...                ########################################### [100%]
   1:oracle-instantclient11.########################################### [ 25%]
   2:oracle-instantclient11.########################################### [ 50%]
   3:oracle-instantclient11.########################################### [ 75%]
   4:oracle-instantclient11.########################################### [100%]

[oraClient@ol354t1123 ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.3.0 Production on Tue Dec 18 17:15:12 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> conn userA/userA@ora55
Connected.
SQL> select * from test1;

        ID
----------
1

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24756186/viewspace-752393/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24756186/viewspace-752393/