Shulou(Shulou.com)06/01 Report--

By default, Oracle 11g RAC database listeners are managed by grid users through clustering tools, but sometimes we find that database listeners are started by oracle users, so there are some problems here. For example, we can kill the extra listening processes that appear.

$ps-ef | grep tnsroot 10 20 08:11? 00:00:00 [netns] grid 4880 08:24? 00:00:00 / u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1-inheritoracle 11067 10 09:09? 00:00:00 / u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER-inheritgrid 11745 1 0 09:13? 00:00:00 / u01/app/11.2.0/grid/bin/tnslsnr LISTENER-inheritgrid 11977 11140 0 09:14 pts/0 00:00:00 grep tns$kill-9 11067-bash: kill: (11067)-Operation not permitted$exitlogout [root@roidb2 ~] # kill-9 11067 [root@roidb2 ~] # ps-ef | grep tnsroot 10 20 08:11? 00:00:00 [netns] grid 4880 10 08:24? 00:00:00 / u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1-inheritgrid 11745 10 09:13? 00:00:00 / u01/app/11.2.0/grid/bin/tnslsnr LISTENER-inheritroot 12046 2589 0 09:15 pts/0 00:00:00 grep tns [root@roidb2 ~] # [root@roidb2 ~] # Oracle user starts monitoring This must be the wrong operation. Lsnrctl statusLSNRCTL for Linux: Version 11.2.0.4.0-Production on 09-JUL-2018 09:18:55Copyright (c) 1991, 2013, Oracle. All rights reserved.Connecting to (ADDRESS= (PROTOCOL=tcp) (HOST=) (PORT=1521)) TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refused$lsnrctl startLSNRCTL for Linux: Version 11.2.0.4.0-Production on 09-JUL-2018 09:18:58Copyright (c) 1991, 2013, Oracle. All rights reserved.Starting / u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr: please wait...TNSLSNR for Linux: Version 11.2.0.4.0-ProductionLog messages written to / u01/app/oracle/diag/tnslsnr/roidb2/listener/alert/log.xmlListening on: (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=roidb2) (PORT=1521)) Connecting to (ADDRESS= (PROTOCOL=tcp) (HOST=) (PORT=1521)) STATUS of the LISTENER- -Alias LISTENERVersion TNSLSNR for Linux: Version 11.2.0.4.0-ProductionStart Date 09-JUL-2018 09:18:58Uptime 0 days 0 hr. 0 min. 0 secTrace Level offSecurity ON: Local OS AuthenticationSNMP OFFListener Log File / u01/app/oracle/diag/tnslsnr/roidb2/listener/alert/log.xmlListening Endpoints Summary... (DESCRIPTION= (ADDRESS= (PROTOCOL=tcp) (HOST=roidb2) (PORT=1521)) The listener supports no servicesThe command completed successfully$ps-ef | grep tnsroot 10 20 08:11? 00:00:00 [netns] grid 4880 08:24? 00:00:00 / u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1-inheritgrid 11745 10 09:13? 00:00:00 / u01/app/11.2 .0 / grid/bin/tnslsnr LISTENER-inheritoracle 12598 10 09:18? 00:00:00 / u01/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr LISTENER-inheritoracle 12605 12521 0 09:19 pts/0 00:00:00 grep tns$$exitlogout [root@roidb2 ~] # kill-9 12598 [root@roidb2] # ps-ef | grep tnsroot 10 20 08:11? 00:00:00 [netns] grid 4880 10 08:24? 00:00:00 / u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1-inheritgrid 11745 10 09:13? 00:00:00 / u01/app/11.2.0/grid/bin/tnslsnr LISTENER-inheritroot 12695 2589 0 09:19 pts/0 00:00:00 grep tns [root@roidb2 ~] #

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.