oracle之lsnrctl命令

oracle之lsnrctl命令

[oracle@sh02 ~]$ ps -ef | grep -i tnsroot 405 2 0 2021 ? 00:00:00 [netns]grid 12854 1 0 15:46 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inheritgrid 32735 1 0 16:30 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit

1、修改前,先检查一下SCAN及SCAN Listener 的配置情况:

[oracle@sh02 ~]$ srvctl config scanSCAN name: sh-cluster-scan, Network: 1/10.128.51.0/255.255.255.0/eth0SCAN VIP name: scan1, IP: /sh-cluster-scan/10.128.51.22

2、关闭SCAN Listener

[oracle@sh02 ~]$ srvctl stop scan_listener

3、检查是否被关闭

[oracle@sh02 ~]$ srvctl status scan_listenerSCAN Listener LISTENER_SCAN1 is enabledSCAN listener LISTENER_SCAN1 is not running

客户端连接出现

4、修改端口

srvctl modify scan_listener -p 1526srvctl modify scan_listener -endpoints 1526

5、检查修改是否生效

[oracle@sh02 ~]$ srvctl start scanPRCC-1014 : scan1 was already runningPRCR-1004 : Resource ora.scan1.vip is already runningPRCR-1079 : Failed to start resource ora.scan1.vipCRS-5702: Resource 'ora.scan1.vip' is already running on 'sh02'

[oracle@sh02 ~]$ srvctl config scan_listenerSCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521

6、启动SCAN Listener:

[oracle@sh02 ~]$ srvctl start scan_listener//启动后,ps/sql能够正常登录

7、检查下,确保成功

srvctl status scan_listener

srvctl modify 命令除了能够修改SCAN端口,还可以修改SCAN的名字:

srvctl modify scan -n newname停止和启动scan listener时要注意下

//我在oracle用户在执行启动scan listener

[oracle@sh02 ~]$ srvctl start scan_listener

//查看进程看不到scan[oracle@sh02 ~]$ ps -ef | grep -i tnsroot 405 2 0 2021 ? 00:00:00 [netns]grid 32735 1 0 16:30 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit

//停止sacn_listener

[oracle@sh02 ~]$ srvctl stop scan_listener

//退出[oracle@sh02 ~]$ exitlogout

//用grid用户登录[root@sh02 ~]# su - grid[grid@sh02 ~]$ srvctl stop scan_listenerPRCC-1016 : LISTENER_SCAN1 was already stoppedPRCR-1005 : Resource ora.LISTENER_SCAN1.lsnr is already stopped

//启动scan_listener

[grid@sh02 ~]$ srvctl start scan_listener[grid@sh02 ~]$ ps -efww |grep lsnrgrid 32735 1 0 16:30 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inheritgrid 42083 1 0 16:50 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inheritgrid 42195 41859 0 16:50 pts/0 00:00:00 grep lsnr[grid@sh02 ~]$ ps -efww |grep tnsroot 405 2 0 2021 ? 00:00:00 [netns]grid 32735 1 0 16:30 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inheritgrid 42083 1 0 16:50 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inheritgrid 42224 41859 0 16:50 pts/0 00:00:00 grep tns

//再回到oracle用户,这个时候就可以查看到

[oracle@sh02 ~]$ ps -ef | grep tnsroot 405 2 0 2021 ? 00:00:00 [netns]grid 32735 1 0 16:30 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inheritgrid 42083 1 0 16:50 ? 00:00:00 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inheritoracle 43393 43352 0 16:53 pts/0 00:00:00 grep tns

相关推荐