需求:
服务端在172.16.100.102,现在需要在Linux上安装连接服务端的oracle客户端。
#一、下载
法1:在官网下载
oracle官网地址
或复制:
http://www.oracle.com/technetwork/database/database-technologies/instant-client/overview/index.html
- 1、点击downloads
- 2、选择系统版本
- 3、选择客户端需要的3个文件,basic,sqlplus,sdk
下载完之后,上传到Linux服务器。
法2:在自己百度网盘下载:
链接:https://pan.baidu.com/s/1WqD_IYzAkOg1XbuYJCM_bA 密码:a9c4
#二、解压
mkdir -p /opt/oracle/lib
mkdir -p /opt/oracle/network/admin
unzip instantclient-basic-linux.x64-11.2.0.4.0.zip
unzip instantclient-sqlplus-linux.x64-11.2.0.4.0.zip
unzip instantclient-sdk-linux.x64-11.2.0.4.0.zip
自动会解压到:
/root/instantclient_11_2
[root@worker-136 ~]# cd instantclient_11_2/
mv sdk /opt/oracle/sdk
mv * /opt/oracle/lib
#三、配置环境变量
vim /etc/profile
export JAVA_HOME=/usr/local/jdk1.8.0_171
export JAVA_BIN=/usr/local/jdk1.8.0_171/bin
export PATH=${JAVA_HOME}/bin:$PATH
export CLASSPATH=.:${JAVA_HOME}/lib/dt.jar:${JAVA_HOME}/lib/tools.jar
ORACLE_HOME=/opt/oracle
DYLD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$JAVA_HOME/bin:$ANT_HOME/bin:$ORACLE_HOME/lib:$PATH
CLASSPATH=.:$JAVA_HOME/lib/dt.jar:$JAVA_HOME/lib/tools.jar
export JAVA_HOME ANT_HOME PATH CLASSPATH DYLD_LIBRARY_PATH ORACLE_HOME LD_LIBRARY_PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
:wq
source /etc/profile //立即生效
vim /root/.bash_profile
export ORACLE_HOME=/opt/oracle
export PATH=$ORACLE_HOME:$PATH
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME
:wq
source /root/.bash_profile //立即生效
#四、配置oracle参数(也可以省略)
此步骤是为了客户端直接使用监听名字方便,
比如服务端的监听名字是:orcl
修改三个配置:
[root@worker-136 admin]# cd /opt/oracle/network/admin
[root@worker-136 admin]# ll
总用量 12
-rw-r--r-- 1 root root 280 7月 3 14:22 listener.ora
-rw-r--r-- 1 root root 87 7月 3 14:24 sqlnet.ora
-rw-r--r-- 1 root root 312 7月 3 14:19 tnsnames.ora
这三个文件配置如下:
listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = /opt/oracle)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.100.102)(PORT = 1521))
)
)
sqlnet.ora
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES,EZCONNECT)
tnsnames.ora
LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.100.102)(PORT = 1521))
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.100.102)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
#五、测试连接
连接成功!
[root@worker-136 admin]# sqlplus census/oracle@172.16.100.102:1521/orcl
SQL*Plus: Release 11.2.0.4.0 Production on Tue Jul 3 14:45:46 2018
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
#其他: