oracle配置端口,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/oracle@localhost:1521/orcl

sqlplus system/oracle@localhost:1522/orcl

sqlplus system/oracle@localhost:1523/orcl

测试连接