可以为oracle数据库添加多个监听吗?答案是可以滴,只是,一般没人这样做吧,下面试试,如何为oracle配置多个监听?
1.本地先确定使用哪些端口用于监听
[root@xuan1 ~]# netstat -tlnp|grep -e 1521
-e 1152 -e 1158 -e 1222 -e 15210
tcp
0 0 :::1521 :::* LISTEN 2653/tnslsnr
tcp
0 0 :::1158 :::* LISTEN 3109/java
[root@xuan1 ~]# netstat -tlnp|grep -E
"1521|1152|1222|1158|15210"
tcp
0 0 :::1521 :::* LISTEN 2653/tnslsnr
tcp
0 0 :::1158 :::* LISTEN 3109/java
----好了,1521端口是目前数据库使用的监听端口,1152和1222及15210端口号是没有使用的,我们就将15210、1152、1222端口用于数据库的监听端口
2.配置监听
[oracle@xuan1 ~]$ vim
/u01/app/oracle/product/11.2.0/db_1/network/admin/listener.ora
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.111)(PORT = 15210))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.111)(PORT = 1152))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.11.111)(PORT = 1222))
)