Bug 518985
| Summary: | ORA-00918 when running Oracle: Idle Sessions probe | ||
|---|---|---|---|
| Product: | Red Hat Satellite 5 | Reporter: | Milan Zázrivec <mzazrivec> |
| Component: | Monitoring | Assignee: | Milan Zázrivec <mzazrivec> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | Martin Korbel <mkorbel> |
| Severity: | medium | Docs Contact: | |
| Priority: | low | ||
| Version: | 530 | CC: | jpazdziora, mkorbel |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Fixed In Version: | NOCpulsePlugins-Oracle-2.209.3-4 | Doc Type: | Bug Fix |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | 2012-09-21 09:35:44 UTC | Type: | --- |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
| Bug Depends On: | |||
| Bug Blocks: | 819081 | ||
spacewalk.git master: 96ffe1f15c1017f079000fae6c5e10b21729aa40 Forgotten cherry-pick into satellite.git SATELLITE-5.5: 5f392527b2355d6f2ea0493241bbafd0bf7e6bb7 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 |
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