oracle添加配置多个端口监听

原来配置：listener.ora文件如下：

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = DESKTOP-L9P3QTT)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

修改如下

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-L9P3QTT)(PORT=1521)(RATE_LIMIT=yes))
(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-L9P3QTT)(PORT=1522)(RATE_LIMIT=yes))
(ADDRESS=(PROTOCOL=tcp)(HOST=DESKTOP-L9P3QTT)(PORT=1523)))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

)
)

重启监听服务

?

?

启动监听

?

?

查看端口

?

?

测试连接

?

输入sqlplus system/[email?protected]:1521/orcl

sqlplus system/[email?protected]:1522/orcl

sqlplus system/[email?protected]:1523/orcl

测试连接

?

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!