下面为您介绍的是oracle服务端和客户端之间的网络监听设置如果您在oracle <;服务端和客户端之间的网络监听设置方面遇到过类似的问题不妨一看
oracle服务端和客户端之间的网络监听设置
假如我现在有两个数据库kkman和orcl现在我想在服务端设立两个监听来处理从客户端发过来的连接请求
第一种多端口监听
服务端listenerora配置
# listenerora Network Configuration File: C:\oracle\product\\db_\NETWORK\ADMIN\listenerora
# Generated by Oracle configuration tools
SID_LIST_LISTENERORCL =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(SID_NAME = ORCL)
)
(SID_DESC =
(GLOBAL_DBNAME = KKMAN)
(SID_NAME = KKMAN)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac)(PORT = ))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac)(PORT = ))
)
)
服务端和客户端tnsnamesora配置
# tnsnamesora Network Configuration File: C:\oracle\product\\client_\NETWORK\ADMIN\tnsnamesora
# Generated by Oracle configuration tools
KKMAN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = ))
)
(CONNECT_DATA =
(SERVICE_NAME = KKMAN)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = ))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
重新启动监听
在服务端打开cmd运行lsnrctl stop和lsnrctl start
多监听单端口
服务端listenerora配置
# listenerora Network Configuration File: C:\oracle\product\\db_\NETWORK\ADMIN\listenerora
# Generated by Oracle configuration tools
SID_LIST_LISTENERORCL =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(SID_NAME = ORCL)
)
(SID_DESC =
(GLOBAL_DBNAME = KKMAN)
(SID_NAME = KKMAN)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac)(PORT = ))
)
)
服务端和客户端tnsnamesora配置
# tnsnamesora Network Configuration File: C:\oracle\product\\client_\NETWORK\ADMIN\tnsnamesora
# Generated by Oracle configuration tools
KKMAN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = ))
)
(CONNECT_DATA =
(SERVICE_NAME = KKMAN)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = )(PORT = ))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)
重新启动监听
在服务端打开cmd运行lsnrctl stop和lsnrctl start
