一、install the Oracle Instant Client
注意:Each step must be performed as root.
- oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm (必须的)
- oracle-instantclient12.1-odbc-12.1.0.2.0-1.x86_64.rpm
- oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
- oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
- oracle-instantclient12.1-jdbc-12.1.0.2.0-1.x86_64.rpm
(2) Install the packages.
[root@localhost ~]# rpm -ivh oracle-instantclient12.1-*
卸载rpm -e file 这里的file不要有.rpm后缀
(3) 在/etc/ld.so.conf.d目录下创建一个配置文件
oracle-instant-client.conf 用来将Oracle client libraries 添加到
LD_LIBRARY_PATH
[root@localhost ~]# cat > /etc/ld.so.conf.d/oracle-instant-client.conf << EOL
> /usr/lib/oracle/12.1/client64/lib
> EOL
Rebuild the LD_LIBRARY_PATH:
[root@localhost ~]# ldconfig
(4)使用sqlplus连接数据库,如果你使用RPMs来安装client,则它们已经存在你的PATH中了。(运行之前确保网络没问题)
[root@localhost ~]# sqlplus64 username/password@remoteIP:1521/databaseName
SQL*Plus: Release 12.1.0.2.0 Production on Tue Dec 15 22:58:53 2015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
sqlplus登录命令常用的几种方式:
- sqlplus username/password 如:普通用户登录 sqlplus scott/tiger <