最近发现很多项目安装oracle客户端直接使用oracle服务端的软件包,但其实oracle客户端有自己的轻量包:
下载地址:
Instant Client for Linux x86-64 (64-bit)
选择需要的版本,如 Version 12.2.0.1.0,
下载basic和sqlplus的包,安装过程如下:
1、groupadd dba
useradd oracle -g dba
2、su - oracle
unzip instantclient-basic-linux.x64-12.2.0.1.0.zip
unzip instantclient-sqlplus-linux.x64-12.2.0.1.0.zip
3、cd /home/oracle/instantclient_12_2
ln -s libclntsh.so.12.1 libclntsh.so
ln -s libocci.so.12.1 libocci.so
4、mkdir -p /home/oracle/instantclient_12_2/network/admin
vi /home/oracle/instantclient_12_2/network/admin/tnsnames.ora
CC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.80.56)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cc)
)
)
5、配置环境变量
echo "export LD_LIBRARY_PATH=/home/oracle/instantclient_12_2:\$LD_LIBRARY_PATH" >> ~/.bash_profile
echo "export PATH=/home/oracle/instantclient_12_2:\$PATH" >> ~/.bash_profile
6、测试sqlplus和tnsnames.ora
sqlplus test/test@cc
7、压缩包
zip -q -r oracleclient_12.2.zip instantclient_12_2
可把此压缩包传到其他业务主机上解压使用