ubuntu14.04下oracle客户端最小化装配
在Oracle官网下载Oracle Instant Client RPM文件(http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html)
下载以下3个文件,下载需要的版本,我下载的是Instant Client for Linux x86-64的 12.1.0.2.0-1.x86_64.版本。
oracle-instantclient12.1-basic-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
使用工具alien来转换或安装rpm文件,如果还没有安装,使用以下命令安装
$sudo apt-get install alien
安装alien后,接着运行下面的命令,安装Oracle客户端
$sudo alien -i oracle-instantclient12.1-basic-12.1.0.2.0-1.x86_64.rpm
$sudo alien -i oracle-instantclient12.1-sqlplus-12.1.0.2.0-1.x86_64.rpm
$sudo alien -i oracle-instantclient12.1-devel-12.1.0.2.0-1.x86_64.rpm
接着再来,安装 libaio.so.1 文件,运行
$sudo apt-get install libaio1
$sudo apt-get install libaio-dev
配置环境变量
export ORACLE_HOME=/usr/lib/oracle/12.1/client64
export LD_LIBRARY_PATH=/usr/lib/oracle/12.1/client64/lib
export PATH=$PATH:$ORACLE_HOME/bin
export TNS_ADMIN=$ORACLE_HOME
export NLS_LANG=american_america.AL32UTF8
在$ORACLE_HOME下创建 tnsnames.ora文件:
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.62.3)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
登录数据库测试:sqlplus iesdb/iesapp@TEST