Bug 518985 - ORA-00918 when running Oracle: Idle Sessions probe
Summary: ORA-00918 when running Oracle: Idle Sessions probe
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: Red Hat Satellite 5
Classification: Red Hat
Component: Monitoring
Version: 530
Hardware: All
OS: Linux
low
medium
Target Milestone: ---
Assignee: Milan Zázrivec
QA Contact: Martin Korbel
URL:
Whiteboard:
Depends On:
Blocks: sat550-lowbug
TreeView+ depends on / blocked
 
Reported: 2009-08-24 13:26 UTC by Milan Zázrivec
Modified: 2012-09-21 09:35 UTC (History)
2 users (show)

Fixed In Version: NOCpulsePlugins-Oracle-2.209.3-4
Doc Type: Bug Fix
Doc Text:
Clone Of:
Environment:
Last Closed: 2012-09-21 09:35:44 UTC
Target Upstream Version:
Embargoed:


Attachments (Terms of Use)

Description Milan Zázrivec 2009-08-24 13:26:57 UTC
Description of problem:
Running probe named "Oracle: Idle Sessions" generates following error:
ORA-00918: column ambiguously defined 

Version-Release number of selected component (if applicable):
NOCpulsePlugins-2.208.6-7.el5sat

How reproducible:
Always

Steps to Reproduce:
1. Install Satellite 5.3.0, enable monitoring & monitoring scout
2. Register a client with a running oracle server, listener available
from outside
3. Setup a "Oracle: Idle Sessions" probe for it
4. on your satellite: #su - nocpulse
5. as a nocpulse user: $ rhn-runprobe ...
  
Actual results:
$ rhn-runprobe --live 69
NOCpulse::Probe::InternalError: Database error 918 executing query select count(*) as COUNT 
                                  from v$session_wait a, v$session b
                                  where event = 'SQL*Net message from client'
                                  and a.seconds_in_wait >= ?
                                  and a.sid = b.sid
                                  and b.username is not null
                                  with 36000: ORA-00918: column ambiguously defined (DBD ERROR: error possibly near <*> indicator at char 79 in 'select count(*) as COUNT 
                                  from v$session_wait a, v$session b
                                  where <*>event = 'SQL*Net message from client'
                                  and a.seconds_in_wait >= :p1
                                  and a.sid = b.sid
                                  and b.username is not null
                                 ')     /usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/Probe/DataSource/AbstractDatabase.pm line 186
        called from /usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/Probe/DataSource/AbstractDatabase.pm line 190
        called from /usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/Probe/DataSource/Oracle.pm line 112
        called from /usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/Probe/DataSource/AbstractDatabase.pm line 133
        called from /var/lib/nocpulse/libexec/Oracle/IdleSessions.pm line 18
        called from /usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/Probe/ProbeRunner.pm line 115
        called from /usr/lib/perl5/vendor_perl/5.8.8/NOCpulse/Probe/ProbeRunner.pm line 131
        called from /usr/bin/rhn-runprobe line 59
2009-08-24 09:18:42     Caught an error, status changing to UNKNOWN
2009-08-24 09:18:42 
============================================================
UNKNOWN: Internal problem executing check. Please contact Red Hat
============================================================


Expected results:
No error, probe works.

Additional info:
N/A

Comment 1 Milan Zázrivec 2012-04-02 10:08:21 UTC
spacewalk.git master: 96ffe1f15c1017f079000fae6c5e10b21729aa40

Comment 3 Milan Zázrivec 2012-08-03 13:29:44 UTC
Forgotten cherry-pick into satellite.git SATELLITE-5.5:
5f392527b2355d6f2ea0493241bbafd0bf7e6bb7

Comment 5 Clifford Perry 2012-09-21 09:35:44 UTC
This issue is resolved with the release of RHN Satellite 5.5. 

As of September 20th 2012, RHN Satellite 5.5 has been generally available. 

Release Notes and other 5.5 documentation can be found here:

 https://access.redhat.com/knowledge/docs/Red_Hat_Network_Satellite/

The associated Errata for the 5.5 release are:

5.5 Satellite GA Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1296.html

5.5 Upgrade Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1298.html

5.5 RHN Proxy GA Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1297.html

5.5 RHN Tools GA Errata
 - http://rhn.redhat.com/errata/RHEA-2012-1299.html

Regards,
Clifford
- Engineering Manager, Satellite


Note You need to log in before you can comment on or make changes to this bug.