1.下载
oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm
oracle-instantclient11.2-devel-11.2.0.2.0.x86_64.rpm
oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm2通过执行以下命令,安装Oracle Client。
rpm -ivh oracle-instantclient11.2-basic-11.2.0.2.0.x86_64.rpm rpm -ivn oracle-instantclient11.2-devel-11.2.0.2.0.x86_64.rpm rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.2.0.x86_64.rpm |
如果出现如下错误
需要安装libio:
libio安装成功!!!
如果不能使用apt-get命令,则需要安装apt-get:
yum install apt-get
3安装完成的标志
4.进行Oracle Client的环境设定
su - appl(appl是我用的一个用户)
mkdir /usr/lib/oracle/11.2/client64/etc/
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/11.2/client64/lib
export TNS_ADMIN=/usr/lib/oracle/11.2/client64/etc
exportNLS_LANG=American_China.UTF85.tnsnames文件(/usr/lib/oracle/11.2/client64/etc/tnsnames.ora)。 (创建命令:touch tnsnames.ora)
内容如下
CIN=(
DESCRIPTION = (
ADDRESS_LIST = (
ADDRESS =
(PROTOCOL =TCP)
(HOST = XXX.XXX.XXX.XXX)ç Database Server IP address
(PORT = YYYY) ç Database Server Port (eg. 1521)
(CHARSET =UTF8)
)
)
(CONNECT_DATA =
(SERVICE_NAME =CIN)
)
)