No question at this time
DBA Top 10
1 A. Kavsek 10000
2 M. Cadot 9900
3 B. Vroman 5700
4 P. Wisse 4300
5 J. Péran 1800
6 . Lauri 1200
7 J. Schnackenberg 600
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48503
Total active users1429
Act. users last 24h2
Act. users last hour0
Registered user hits last week104
Registered user hits last month599
Go up

Listener issue.
Next thread:
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, 6 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, 5 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