安装oracle的客户端工具,安装oracle客户端连接工具

oracle客户端工具

1.1 从oracle官网下载两个rpm包放置任意路径下，使用rpm安装：

rpm -ivh oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm

rpm -ivh oracle-instantclient11.2-sqlplus-11.2.0.3.0-1.x86_64.rpm

#默认安装在/usr/lib/oracle/这个路径下。

(注：下载前需要注册账号，免费的，可以放心注册)

1.2 配置环境变量(oracle客户端)

vim ~/.bash_profile

#oracle客户端连接工具

PATH=$PATH:$HOME/bin

export ORACLE_HOME=/usr/lib/oracle/11.2/client64/

export TNS_ADMIN=$ORACLE_HOME/network/admin

export ORACLE_BASE=/usr/lib/oracle/11.2/

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

export PATH

退出并保存

1.3 生效环境配置文件(oracle客户端)

source ~/.bash_profile

1.4 创建tnsnames.ora配置文件(oracle客户端)

cd  /usr/lib/oracle/11.2/client64/ 或#cd $ORACLE_HOME

mkdir -p /network/admin(创建这两个目录)

vim /usr/lib/oracle/11.2/client64/network/admin/tnsnames.ora

1 orcl =

2   (DESCRIPTION =

3     (ADDRESS_LIST =

4        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.198.182)(PORT = 1521))

5      )

6        (CONNECT_DATA =

7          (SERVER = DEDICATED)

8          (SERVICE_NAME = orcl)

9        )

10      )

注：

1:自己定义的连接描述符名。

4:HOST要远程连接的数据库的IP，PORT端口默认1521。

8:数据库的实例名。

(注：查看实例名# ps -ef |grep pmon

oracle    3894     1  0 08:30 ?        00:00:00 ora_pmon_orcl

root      5154  4546  0 09:56 pts/1    00:00:00 grep pmon

orcl就是实例名)

1.5 修改oracle服务端listener.ora文件

cd /opt/oracle/product/11.2.0/dbhome_1/network/admin/

vim listener.ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = orcl)

(ORACLE_HOME = /opt/oracle/product/11.2.0/dbhome_1)

(SID_NAME = orcl)

)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.198.182)(PORT = 1521))

)

)

ADR_BASE_LISTENER = /opt/oracle

1.6 修改oracle服务端的tnsnames.ora配置文件

cd /opt/oracle/product/11.2.0/dbhome_1/network/admin/

vim  tnsnames.ora

LISTENER_ORCL =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.198.182)(PORT = 1521))

ORCL =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.198.182)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = orcl)

)

)

1.7 测试连接数据库：

sqlplus zabbix/123456@orcl

SQL*Plus: Release 11.2.0.3.0 Production on Tue Dec 27 11:05:09 2016

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

连接成功！！

安装oracle客户端连接工具

标签：mes   connected   实例名   测试   定义   path   glob   add   变量

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：https://www.cnblogs.com/A121/p/10559376.html