Ubuntu下安装oracle客户端
1) 下载zip包
http://www.oracle.com/technetwork/topics/linuxx86-64soft-092277.html
a. instantclient-basic-linux.x64-11.2.0.4.0.zip
b. instantclient-jdbc-linux.x64-11.2.0.4.0.zip
c . instantclient-sdk-linux.x64-11.2.0.4.0.zip
d. instantclient-sqlplus-linux.x64-11.2.0.4.0.zip
2) 解压到目录
a=> /usr/lib/oracle/11.2/client64/lib
b=> /usr/lib/oracle/11.2/client64/lib
c=> /usr/lib/oracle/11.2/client64/sdk
d=>/usr/lib/oracle/11.2/client64/lib
创建目录和文件连接:
3) tnsnames.ora
$ sudo vi /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora
内容如下:
4) 配置 /etc/profile
增加下面内容:
使生效:
. /etc/profile
5) 打开sqlplus
SQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 10 23:43:08 2017
Copyright (c) 1982, 2013, 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