No question at this time
DBA Top 10
1 M. Cadot 10400
2 A. Kavsek 9400
3 B. Vroman 4800
4 P. Wisse 4300
5 J. Schnackenberg 2900
6 J. Péran 2000
7 . Lauri 1000
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
9 T. Boles 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48524
Total active users1409
Act. users last 24h3
Act. users last hour0
Registered user hits last week77
Registered user hits last month415
Go up

Listener issue.
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...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts 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, 76 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, 76 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
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