Oracle Client客户端+PLSQL配置

1、安装Oracle客户端（注意，PLSQL只支持32位的Oracle的客户端，64系统使用32客户端的Oracle也没问题）

网盘分享：https://pan.baidu.com/s/1WtuwzoqcSuV5FnBhBEaQ_A

密码：hnqi

直接软件安装，直接下一步dao结束即可

2、配置文件配置

# tnsnames.ora Network Configuration File.
# Generated by Oracle InstantClient tools.
# For more information, please visit: http://www.oracle.com/technetwork/database/features/instant-client/index-100365.html

# Sample:
#DatabaseName =
#  (DESCRIPTION =
#    (ADDRESS_LIST =
#      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
#    )
#    (CONNECT_DATA =
#      (SERVER = DEDICATED)
#      (SERVICE_NAME = ServiceName)
#      (INSTANCE_NAME = InstanceName)
#    )
#  )

# Modify the following content to fit your own needs.
DummyDatabase =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = DummyService)
    )
  )
OSS = 
    (DESCRIPTION = 
        (ADDRESS_LIST = 
            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.9.73)(PORT = 1521)) 
        ) 
        (CONNECT_DATA = 
            (SERVER = DEDICATED) 
            (SERVICE_NAME = oss) 
        ) 
    ) 
MAILP3 = 
    (DESCRIPTION = 
        (ADDRESS_LIST = 
            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.9.41)(PORT = 1521)) 
        ) 
        (CONNECT_DATA = 
            (SERVER = DEDICATED) 
            (SERVICE_NAME = mailp3) 
        ) 
    )

字段解释：
MAILP3：对应你数据库服务器名

PROTOCOL：客户端与服务器端通讯的协议，一般为TCP，该内容一般不用改。
HOST：服务器所在的IP地址
PORT：端口号
SERVICE_NAME：服务名

3、PL/SQ里面配置

 选择首选项，选择配置项，对应路径如下

 

PLSQL加载配置

结果：可以看到数据库有对应的MAILP3，成功