Are you running RAC\/GI with role separation? You’re tired of constantly switching between “oracle” and “grid” users or you don’t have access to “grid” at all?
\nThis little trick saves me lots of time whenever I need to check the status or services details of a listener running as “grid”. I hope it serves you as well as it does serve me \ud83d\ude42<\/p>\n
This gives me the listener names running on the connected node:<\/p>\n
\r\n$ ps -ef|grep tnslsnr\r\ngrid 3468 1 0 21:50 ? 00:00:00 \/u01\/app\/gi12201\/bin\/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit\r\ngrid 3643 1 0 21:50 ? 00:00:00 \/u01\/app\/gi12201\/bin\/tnslsnr LISTENER -no_crs_notify -inherit\r\ngrid 3646 1 0 21:50 ? 00:00:00 \/u01\/app\/gi12201\/bin\/tnslsnr MGMTLSNR -no_crs_notify -inherit\r\ngrid 3652 1 0 21:50 ? 00:00:00 \/u01\/app\/gi12201\/bin\/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit\r\ngrid 3665 1 0 21:50 ? 00:00:00 \/u01\/app\/gi12201\/bin\/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit\r\n<\/pre>\nBy default, every listener in a GI\/RAC setup has an IPC end-point with the KEY being the same as the listener name. For instance:<\/p>\n
\r\nListening Endpoints Summary...\r\n (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))\r\n (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=192.168.56.55)(PORT=1523)))\r\n (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.55)(PORT=1521)))\r\n<\/pre>\nSo you can simply run lsnrctl with the connect descriptor on the command line (as oracle):<\/p>\n
\r\n$ lsnrctl status "(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))"\r\n\r\nLSNRCTL for Linux: Version 12.2.0.1.0 - Production on 17-MAY-2018 22:12:49\r\n\r\nCopyright (c) 1991, 2016, Oracle. All rights reserved.\r\n\r\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))\r\nSTATUS of the LISTENER\r\n------------------------\r\nAlias LISTENER_SCAN1\r\nVersion TNSLSNR for Linux: Version 12.2.0.1.0 - Production\r\nStart Date 17-MAY-2018 21:52:41\r\nUptime 0 days 0 hr. 20 min. 8 sec\r\nTrace Level off\r\nSecurity ON: Local OS Authentication\r\nSNMP OFF\r\nListener Parameter File \/u01\/app\/gi12201\/network\/admin\/listener.ora\r\nListener Log File \/u01\/app\/grid\/diag\/tnslsnr\/ol7122rac2\/listener_scan1\/alert\/log.xml\r\nListening Endpoints Summary...\r\n (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))\r\n (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=192.168.56.55)(PORT=1523)))\r\n (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.55)(PORT=1521)))\r\nServices Summary...\r\nService "65388e79ee096b69e0533238a8c08c32.localdomain" has 2 instance(s).\r\n Instance "RAC11", status READY, has 2 handler(s) for this service...\r\n Instance "RAC12", status READY, has 2 handler(s) for this service...\r\nService "RAC1.localdomain" has 2 instance(s).\r\n Instance "RAC11", status READY, has 2 handler(s) for this service...\r\n Instance "RAC12", status READY, has 2 handler(s) for this service...\r\nService "pdbrac1.localdomain" has 2 instance(s).\r\n Instance "RAC11", status READY, has 2 handler(s) for this service...\r\n Instance "RAC12", status READY, has 2 handler(s) for this service...\r\nThe command completed successfully\r\n<\/pre>\nYes, this only works for listeners that run on the node you’re connected to. You can’t do it across nodes, but I still find it extremely useful.<\/p>\n
For your convenience, you can put the connect descriptors in the TNSNAMES.ORA sourced by “oracle”:<\/p>\n
\r\n$ cat $TNS_ADMIN\/tnsnames.ora \r\nlistener_scan1=(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))\r\n\r\n$ lsnrctl services listener_scan1\r\n\r\nLSNRCTL for Linux: Version 12.2.0.1.0 - Production on 17-MAY-2018 22:30:10\r\n\r\nCopyright (c) 1991, 2016, Oracle. All rights reserved.\r\n\r\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))\r\nServices Summary...\r\nService "65388e79ee096b69e0533238a8c08c32.localdomain" has 2 instance(s).\r\n Instance "RAC11", status READY, has 2 handler(s) for this service...\r\n Handler(s):\r\n "DEDICATED" established:0 refused:0 state:ready\r\n REMOTE SERVER\r\n (ADDRESS=(PROTOCOL=TCPS)(HOST=192.168.56.53)(PORT=1523))\r\n...\r\n<\/pre>\nIt also works within the lsnrctl command line:<\/p>\n
\r\n$ lsnrctl\r\n\r\nLSNRCTL for Linux: Version 12.2.0.1.0 - Production on 17-MAY-2018 22:39:58\r\n\r\nCopyright (c) 1991, 2016, Oracle. All rights reserved.\r\n\r\nWelcome to LSNRCTL, type "help" for information.\r\n\r\nLSNRCTL> set current_listener (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))\r\nCurrent Listener is (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))\r\nLSNRCTL> services\r\nConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))\r\nServices Summary...\r\nService "65388e79ee096b69e0533238a8c08c32.localdomain" has 2 instance(s).\r\n Instance "RAC11", status READY, has 2 handler(s) for this service...\r\n Handler(s):\r\n "DEDICATED" established:0 refused:0 state:ready\r\n REMOTE SERVER\r\n (ADDRESS=(PROTOCOL=TCPS)(HOST=192.168.56.53)(PORT=1523))\r\n "DEDICATED" established:0 refused:0 state:ready\r\n REMOTE SERVER\r\n (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.53)(PORT=1521))\r\n...\r\n<\/pre>\nAny comments? I’m listening…<\/p>\n","protected":false},"excerpt":{"rendered":"
Are you running RAC\/GI with role separation? You’re tired of constantly switching between “oracle” and “grid” users or you don’t have access to “grid” at all? This little trick saves me lots of time whenever I need to check the status or services details of a listener running as “grid”. I hope it serves you […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-371","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts\/371","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=371"}],"version-history":[{"count":3,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts\/371\/revisions"}],"predecessor-version":[{"id":374,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=\/wp\/v2\/posts\/371\/revisions\/374"}],"wp:attachment":[{"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.spotonoracle.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}