安装与配置 Oracle 11g RAC（19）—— 修改监听端口号
文章目录
安装与配置 Oracle 11g RAC（19）—— 修改监听端口号一、修改 SCAN listener port1、修改 SCAN listener port2、重启 SCAN listener 使新端口生效3、查看监听状态
二、修改 Listener Ports1、修改 Listener Ports2、修改初始化参数：local_listener、remote_listener3、重新启动监听程序4、查看监听5、查看监听服务状态（1）查看本地监听服务状态（2）查看 scan 监听服务状态
三、修改 ASM 监听端口1、使用 grid 账号登录系统，执行如下操作：2、查看本地监听服务状态3、查看 scan 监听服务状态
四、使用新的端口号连接服务器1、使用 windows 客户端登录2、使用 linux 客户端登录
生产环境中，为了安全考虑，需要修改 Oracle rac 监听默认的端口号。修改 Oracle rac 监听的端口号需要同时修改本地监听和 scan 监听的端口号。
一、修改 SCAN listener port
1、修改 SCAN listener port
以 grid 用户操作：
[grid@rac1 admin]$ srvctl modify scan_listener -p 7788
2、重启 SCAN listener 使新端口生效
[grid@rac1 admin]$ srvctl stop scan_listener
[grid@rac1 admin]$ srvctl start scan_listener
[grid@rac1 ~]$ srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:7788
SCAN Listener LISTENER_SCAN2 exists. Port: TCP:7788
SCAN Listener LISTENER_SCAN3 exists. Port: TCP:7788
3、查看监听状态
[grid@rac1 ~]$ lsnrctl status listener_scan2
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 25-AUG-2021 08:49:10
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN2
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 25-AUG-2021 08:15:25
Uptime 0 days 0 hr. 33 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/rac1/listener_scan2/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN2)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.202)(PORT=7788)))
The listener supports no services
The command completed successfully
--发现端口号已经更为为 7788，但监听状态显示为：no services
二、修改 Listener Ports
1、修改 Listener Ports
[grid@rac1 ~]$ srvctl modify listener -l LISTENER -p "TCP:7788"
2、修改初始化参数：local_listener、remote_listener
以 oracle 用户登录执行以下命令：
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=
192.168.1.101)(PORT=1521))
remote_listener string rac-scan:1521
SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.101)(PORT=7788))' scope=both sid='orcl1';
System altered.
SQL> alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.102)(PORT=7788))' scope=both sid='orcl2';
System altered.
SQL> alter system set remote_listener='rac-scan:7788' scope=both sid='*';
System altered.
--查看初始化参数：local_listener、remote_listener
--节点1
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=1
92.168.1.101)(PORT=7788))
remote_listener string rac-scan:7788
--节点1
SQL> show parameter listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (ADDRESS=(PROTOCOL=TCP)(HOST=1
92.168.1.102)(PORT=7788))
remote_listener string rac-scan:7788
3、重新启动监听程序
两个节点同时操作：
[grid@rac2 admin]$ srvctl stop listener
[grid@rac2 admin]$ srvctl start listener
4、查看监听
##节点1
[grid@rac1 ~]$ srvctl config Listener
Name: LISTENER
Network: 1, Owner: grid
Home:
End points: TCP:7788
##节点2
[grid@rac2 admin]$ srvctl config Listener
Name: LISTENER
Network: 1, Owner: grid
Home:
End points: TCP:7788
5、查看监听服务状态
（1）查看本地监听服务状态
[grid@rac1 ~]$ lsnrctl status listener
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 25-AUG-2021 09:09:19
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 25-AUG-2021 09:07:25
Uptime 0 days 0 hr. 1 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.11)(PORT=7788)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.101)(PORT=7788)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully
######## asm 监听没有启动！！
（2）查看 scan 监听服务状态
[grid@rac1 ~]$ lsnrctl status listener_scan2
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 25-AUG-2021 09:09:33
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN2
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 25-AUG-2021 08:15:25
Uptime 0 days 0 hr. 54 min. 11 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/rac1/listener_scan2/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN2)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.202)(PORT=7788)))
Services Summary...
Service "orcl" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully
三、修改 ASM 监听端口
1、使用 grid 账号登录系统，执行如下操作：
[grid@rac1 ~]$ sqlplus / as sysasm
SQL*Plus: Release 11.2.0.4.0 Production on Wed Aug 25 11:48:00 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
--查看初始化参数：local_listener
SQL> show parameter listen
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(A
DDRESS=(PROTOCOL=TCP)(HOST=192.168.1.101)(PORT=1521))))
remote_listener string
--修改初始化参数：local_listener
SQL> alter system set local_listener = '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.102)(PORT=7788))))' scope=both sid='+AS
M2';
System altered.
SQL> alter system set local_listener = '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.101)(PORT=7788))))' scope=both sid='+AS
M1';
--查看初始化参数：local_listener
--节点1
SQL> show parameter listen
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(AD
DRESS=(PROTOCOL=TCP)(HOST=192.
168.1.101)(PORT=7788))))
remote_listener string
--节点2
SQL> show parameter listen
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
listener_networks string
local_listener string (DESCRIPTION=(ADDRESS_LIST=(A
DDRESS=(PROTOCOL=TCP)(HOST=192
.168.1.102)(PORT=1521))))
remote_listener string
2、查看本地监听服务状态
### 节点1
[grid@rac1 ~]$ lsnrctl status listener
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 25-AUG-2021 12:09:50
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 25-AUG-2021 09:07:25
Uptime 0 days 3 hr. 2 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/rac1/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.11)(PORT=7788)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.101)(PORT=7788)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
The command completed successfully
### 节点2
[grid@rac2 admin]$ lsnrctl status listener
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 25-AUG-2021 12:03:22
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 25-AUG-2021 09:07:25
Uptime 0 days 2 hr. 55 min. 56 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/rac2/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.12)(PORT=7788)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.102)(PORT=7788)))
Services Summary...
Service "+ASM" has 1 instance(s).
Instance "+ASM2", status READY, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 1 instance(s).
Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully
3、查看 scan 监听服务状态
[grid@rac1 ~]$ lsnrctl status listener_scan2
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 25-AUG-2021 12:12:10
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN2)))
STATUS of the LISTENER
------------------------
Alias LISTENER_SCAN2
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 25-AUG-2021 08:15:25
Uptime 0 days 3 hr. 56 min. 48 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/rac1/listener_scan2/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN2)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.202)(PORT=7788)))
Services Summary...
Service "orcl" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Instance "orcl2", status READY, has 1 handler(s) for this service...
Service "orclXDB" has 2 instance(s).
Instance "orcl1", status READY, has 1 handler(s) for this service...
Instance "orcl2", status READY, has 1 handler(s) for this service...
The command completed successfully
四、使用新的端口号连接服务器
1、使用 windows 客户端登录
C:\>sqlplus sys/oracle@192.168.1.201:7788/orcl as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Aug 27 17:38:27 2021
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL>
2、使用 linux 客户端登录
[oracle@rac2 ~]$ sqlplus scott/tiger@rac-scan:7788/orcl
SQL*Plus: Release 11.2.0.4.0 Production on Wed Aug 25 09:12:46 2021
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL>