oracle服务端和客户端之间的网络监听设置
发布时间：2010/11/26 16:56:47 来源：城市学习网 编辑：ziteng
下面为您介绍的是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.) [NextPage] 3.重新启动监听
在服务端打开cmd运行：lsnrctl stop和lsnrctl start
2.多监听单端口
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. )
21.)
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 = 1521))
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.)
3.重新启动监听
在服务端打开cmd运行：lsnrctl stop和lsnrctl start
