Oracle 一个数据库如何在不同端口上监听
来源:互联网 发布:mac听写功能不能用 编辑:程序博客网 时间:2024/06/08 18:51
原listener.ora配置文件:
# listener.ora Network Configuration File: /opt/oracle/db/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gtlions)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /opt/oracle/db
1、一个监听对应2个端口 1521 1522
listener.ora配置如下:
# listener.ora Network Configuration File: /opt/oracle/db/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = TEST)
(ORACLE_HOME = /opt/oracle/db/db_1)
(SID_NAME = TEST)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gtlions)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gtlions)(PORT = 1522))
)
)
ADR_BASE_LISTENER = /opt/oracle/db
tnsnames.ora配置如下:
# tnsnames.ora Network Configuration File: /opt/oracle/db/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
)
)
TEST2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
)
)
测试
通过TEST和TEST2均能够连接和使用,但是stop掉监听listener之后2个端口无法都无法使用。
2、2个监听对应2个端口1521 1522
listener.ora配置如下:
# listener.ora Network Configuration File: /opt/oracle/db/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = TEST)
(ORACLE_HOME = /opt/oracle/db/db_1)
(SID_NAME = TEST)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gtlions)(PORT = 1521))
)
)
SID_LIST_TEST =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = TEST)
(ORACLE_HOME = /opt/oracle/db/db_1)
(SID_NAME = TEST)
)
)
TEST =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = gtlions)(PORT = 1522))
)
)
ADR_BASE_LISTENER = /opt/oracle/db
tnsnames.ora配置不变。
测试
通过TEST和TEST2均能够连接和使用,而且因为2个端口分别由2个listener管理,单独停掉或被封住一个端口并不影响另一个端口使用。
小结
第1种方式一个监听对应2个端口,带来的问题是无法单独关掉这个端口的监听。
- Oracle 一个数据库如何在不同端口上监听
- 一个数据库如何在不同端口上监听
- 如何查看oracle中不同数据库的端口号
- QTcpServer如何监听两个不同的端口
- 修改oracle数据库监听端口号
- 如何修改ssh默认端口 如何修改oracle监听端口
- grails运行在不同的端口上
- 在Linux和Window下如何查看一个端口是否监听以及被哪个进程监听命令
- 让一个Apache在不同端口上运行多个网站
- 修改oracle监听端口
- 修改oracle监听端口
- 修改Oracle监听端口
- 修改oracle监听端口
- oracle修改监听端口
- oracle修改监听端口
- Oracle、Sql Server数据库服务器新增监听端口
- solaris 10中设置oracle数据库监听80端口
- Oracle 数据库开启关闭 及 端口监听相关命令
- 监听器模型,MouseAdpter与Mouse的3个监听器小结
- jquery表格插件DataTables 合计功能(当前页)
- listener.ora--sqlnet.ora--tnsnames.ora的关系以及手工配置举例
- Linux C++显示系统当前时间 time
- C++编程中设置文件长度的方法
- Oracle 一个数据库如何在不同端口上监听
- Nios II 中的DMA
- new delete运算符
- 初始引导时/dev/console /dev/ram0来历
- How Tomcat Works学习笔记<一>
- hdu3004 The Chess
- MySQL5.5(免安装版)的配置及UTF8设置
- C/C++内存管理(随笔)
- poj 2029 Get Many Persimmon Trees 二维树状数组