Oracle Client客户端+PLSQL配置
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 版权协议，转载请附上原文出处链接和本声明。