课
程
程
资
讯
讯
综
合
合
下面为您介绍的是oracle服务端和客户端之间的网络监听设置，如果您在oracle <http://database.51cto.com/art/201011/232267.htm>服务端和客户端之间的网络监听设置方面遇到过类似的问题，不妨一看。
oracle服务端和客户端之间的网络监听设置
假如我现在有两个数据库kkman和orcl，现在我想在服务端设立两个监听来处理从客户端发过来的连接请求。
-----------------------------------------------------------------
第一种多端口监听
1.服务端listener.ora配置
1.# listener.ora Network Configuration File: C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
2.# Generated by Oracle configuration tools.
3.
4.SID_LIST_LISTENERORCL =
5.(SID_LIST =
6. (SID_DESC =
7. (GLOBAL_DBNAME = ORCL)
8. (SID_NAME = ORCL)
9. )
10. (SID_DESC =
11. (GLOBAL_DBNAME = KKMAN)
12. (SID_NAME = KKMAN)
13. )
14.)
15.
16.LISTENER =
17.(DESCRIPTION_LIST =
18. (DESCRIPTION =
19. (ADDRESS = (PROTOCOL = TCP)(HOST = rac02)(PORT = 1521))
20. (ADDRESS = (PROTOCOL = TCP)(HOST = rac02)(PORT = 1522))
21. )
22.)
2.服务端和客户端tnsnames.ora配置
1.# tnsnames.ora Network Configuration File: C:\oracle\product\10.2.0\client_1\NETWORK\ADMIN\tnsnames.ora
2.# Generated by Oracle configuration tools.
3.
4.KKMAN =
5.(DESCRIPTION =
6. (ADDRESS_LIST =
7. (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1522))
8. )
9. (CONNECT_DATA =
10. (SERVICE_NAME = KKMAN)
11. )
12.)
13.
14.ORCL =
15.(DESCRIPTION =
16. (ADDRESS_LIST =
17. (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.3)(PORT = 1521))
18. )
19. (CONNECT_DATA =
20. (SERVICE_NAME = orcl)
21. )
22.)
| 广告合作：400-664-0084 全国热线：400-664-0084 Copyright 2010 - 2017 www.my8848.com 珠峰网 粤ICP备15066211号 珠峰网 版权所有 All Rights Reserved 
|
