Never stop learning ...!!!
Greetings! Welcome to my Oracle DBA blog.
Disclaimer
▼
▼
Wednesday, 22 September 2021
instance status was not showing in listener status
[oracle@rac3 ~]$ lsnrctl status LISTENER LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 22-SEP-2021 13:26:42 Copyright (c) 1991, 2016, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 22-SEP-2021 13:23:19 Uptime 0 days 0 hr. 3 min. 22 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u02/app/12.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac3/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.103)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.105)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_ARCH" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_CRS" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@rac3 ~]$ [oracle@rac3 ~]$
Note:- There was issue with local_listener IP address because it was not 192.168.0.104 IP for rac3 server so modify the local_listener with correct IP address 192.168.0.103
[oracle@rac3 ~]$ sqlplus '/as sysdba' SQL*Plus: Release 12.2.0.1.0 Production on Wed Sep 22 13:34:36 2021 Copyright (c) 1982, 2016, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production SQL> show parameter local_ NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ local_listener string (ADDRESS=(PROTOCOL=tcp)(HOST=1 92.168.0.104)(PORT=1521)) SQL> ALTER SYSTEM SET LOCAL_LISTENER='(ADDRESS=(PROTOCOl=TCP)(HOST=192.168.0.103)(PORT=1521))' SCOPE=BOTH; System altered. SQL> alter system register; System altered. SQL> show parameter local_ NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ local_listener string (ADDRESS=(PROTOCOl=TCP)(HOST=1 92.168.0.103)(PORT=1521)) SQL> SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production [oracle@rac3 ~]$ [oracle@rac3 ~]$ lsnrctl status LISTENER LSNRCTL for Linux: Version 12.2.0.1.0 - Production on 22-SEP-2021 13:44:21 Copyright (c) 1991, 2016, Oracle. All rights reserved. Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521)) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 12.2.0.1.0 - Production Start Date 22-SEP-2021 13:23:19 Uptime 0 days 0 hr. 21 min. 2 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u02/app/12.2.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/rac3/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.103)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.0.105)(PORT=1521))) Services Summary... Service "+ASM" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_ARCH" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_CRS" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "+ASM_DATA" has 1 instance(s). Instance "+ASM1", status READY, has 1 handler(s) for this service... Service "ORCL.samik.com" has 1 instance(s). Instance "ORCL11", status READY, has 1 handler(s) for this service... Service "ORCL1XDB.samik.com" has 1 instance(s). Instance "ORCL11", status READY, has 1 handler(s) for this service... Service "srv_gold.samik.com" has 1 instance(s). Instance "ORCL11", status READY, has 1 handler(s) for this service... The command completed successfully [oracle@rac3 ~]$ [oracle@rac3 ~]$
No comments:
Post a Comment