Go up

Next thread:	ORA-48181 no space left for audit trail
Prev thread:	Can we have NON CDB databases in Oracle 19C

Message	Score	Author	Date
Hi DBA team, In our environment every thing is mo......		Sri Ram	May 22, 2020, 21:28
Hello Sri, your concern is not 100% clear... If......		Bruno Vroman	May 23, 2020, 18:09

Follow up by mail

Click here

---

Subject:	Listener issue.
Author:	Sri Ram, India
Date:	May 22, 2020, 21:28, 1106 days ago
Os info:	AIX
Oracle info:	11.2.0.4
Error info:	No error message. DB and ASM are up and running. user created alert is generated
Message:	Hi DBA team, In our environment every thing is monitoried by corn jobs. In below cronjob is reading out of lsnrctl status and giving error message. b'se one of the server is "UNKNOWN". How to fix it. $ ls -ltr /opt/oracle/asmcrs/product/11.2.0.4/network/admin/listener.ora -rw-r--r-- 3 oracle dba 691 Jun 13 2014 /opt/oracle/asmcrs/product/11.2.0.4/network/admin/listener.ora $ lsnrctl status LSNRCTL for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production on 22-MAY-2020 14:23:53 Copyright (c) 1991, 2017, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1563))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for IBM/AIX RISC System/6000: Version 11.2.0.4.0 - Production Start Date 30-MAY-2019 14:03:03 Uptime 358 days 0 hr. 20 min. 49 sec Trace Level off Security ON: Local OS Authentication SNMP ON Listener Parameter File /opt/oracle/asmcrs/product/11.2.0.4/network/admin/listener.ora Listener Log File /opt/oracle/base/diag/tnslsnr/pa-inpmdb001/listener/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1563))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=pa-inpmdb001)(PORT=1563))) Services Summary... Service "+ASM" has 2 instance(s). Instance "+ASM", status UNKNOWN, has 1 handler(s) for this service... Instance "+ASM", status READY, has 1 handler(s) for this service... Service "PMNTRNG" has 2 instance(s). Instance "PMNTRNG", status UNKNOWN, has 1 handler(s) for this service... Instance "PMNTRNG", status READY, has 1 handler(s) for this service... Service "PMNTRNGXDB" has 1 instance(s). Instance "PMNTRNG", status READY, has 1 handler(s) for this service... The command completed successfully
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here

---

Subject:	Re: Listener issue.
Author:	Bruno Vroman, Belgium
Date:	May 23, 2020, 18:09, 1105 days ago
Score:
Message:	Hello Sri, your concern is not 100% clear... If it is about the fact that you see the lines with UNKNOWN (has this changed recently?), a quick Google search will give you explanations... But I want to make a remark about something else:   ...Version 11.2.0.4.0...   Start Date 30-MAY-2019 14:03:03   Uptime 358 days 0 hr. 20 min. 49 sec... Gasp! When do you apply security patches? Never? Hmmmm, you might cry one day, when it will really be too late. Best regards, Bruno Vroman. (oh, I vaguely remember of a report of a bug hitting when a database was up for more than one year... Just for the fun, wait 1 more week before shutting down, maybe there is also something for a 11.2 listener ;-)
Your rating?:	This reply is Good Excellent
Goto:	Reply - Top of page

If you think this item violates copyrights, please click here