1.安装包的下载
官网下载路径:https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html
本文中下载的为Oracle21的版本,各位看官可根据自己需求自行下载
2.安装软件包
rpm -ivh oracle-instantclient-basic-21.1.0.0.0-1.x86_64.rpm
rpm -ivh oracle-instantclient-sqlplus-21.1.0.0.0-1.x86_64.rpm
注:按顺序执行
3.创建 目录
mkdir -p /usr/lib/oracle/21/client64/network/admin
4.配置环境变量
cd /etc
vi profile
export ORACLE_HOME=/usr/lib/oracle/21/client64
export TNS_ADMIN=$ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN_AMERICA.UTF8
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
使环境变量生效:
source /etc/profile
配置tnsnames.ora
cd /usr/lib/oracle/21/client64/network/admin
vi tnsnames.ora
tnsnames.ora内容
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.64)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
host为用户ip,port为端口号,service_name为远程数据库的sid,一般为orcl
5.测试连接orcle
sqlplus64 system/Oracle12c@orcl
当终端显示如下图时表示连接成功