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

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

密码：hnqi

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

2、配置文件配置

 1 # tnsnames.ora Network Configuration File.
 2 # Generated by Oracle InstantClient tools.
 3 # For more information, please visit: http://www.oracle.com/technetwork/database/features/instant-client/index-100365.html
 4 
 5 # Sample:
 6 #DatabaseName =
 7 #  (DESCRIPTION =
 8 #    (ADDRESS_LIST =
 9 #      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
10 #    )
11 #    (CONNECT_DATA =
12 #      (SERVER = DEDICATED)
13 #      (SERVICE_NAME = ServiceName)
14 #      (INSTANCE_NAME = InstanceName)
15 #    )
16 #  )
17 
18 # Modify the following content to fit your own needs.
19 DummyDatabase =
20   (DESCRIPTION =
21     (ADDRESS_LIST =
22       (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
23     )
24     (CONNECT_DATA =
25       (SERVER = DEDICATED)
26       (SERVICE_NAME = DummyService)
27     )
28   )
29 OSS = 
30     (DESCRIPTION = 
31         (ADDRESS_LIST = 
32             (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.9.73)(PORT = 1521)) 
33         ) 
34         (CONNECT_DATA = 
35             (SERVER = DEDICATED) 
36             (SERVICE_NAME = oss) 
37         ) 
38     ) 
39 MAILP3 = 
40     (DESCRIPTION = 
41         (ADDRESS_LIST = 
42             (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.9.41)(PORT = 1521)) 
43         ) 
44         (CONNECT_DATA = 
45             (SERVER = DEDICATED) 
46             (SERVICE_NAME = mailp3) 
47         ) 
48     )

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

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

3、PL/SQ里面配置

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

 

PLSQL加载配置

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

 

版权声明：本文为zhuziyu原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/zhuziyu/p/8877147.html