Re: Anyone else experience this?

  • From: Robert Pegram <pegramrg@xxxxxxxxx>
  • To: rjoralist@xxxxxxxxxxxxxxxxxxxxx, Chris.Taylor@xxxxxxxxxxxxxxx
  • Date: Thu, 29 Nov 2007 12:49:33 -0800 (PST)

QUOTE - "Another major one is some of the RMAN jobs scheduled
through GC just disappeared last week.  I've been ranting about OEM's
reliability since 8i.  I'm still far from satisfied, unfortunately."

We ran into this bug and I worked with Oracle for months to try to reach a 
resolution.  We have since upgraded the OMS to and that has seemed to 
fix the problem.

Before upgrading, I ran this query against the repository database daily.  It 
should show any jobs that are supposed to repeat, but are not.  

SELECT j.job_name
FROM   mgmt_job_schedule s, mgmt_job j
WHERE  s.frequency_code > 1
  AND  s.schedule_id    = j.schedule_id
  AND  j.job_status     = 0
  AND  j.nested         = 0
  AND  j.is_library     = 0
  AND  (s.end_time > SYSDATE OR s.end_time IS NULL)
       (SELECT 1
        FROM   mgmt_job_exec_summary e
        WHERE  e.job_id = j.job_id
          AND  e.status NOT IN (3,4,5,8))
ORDER BY j.job_owner, j.job_name

Rob Pegram
Duke University

----- Original Message ----
From: Rich Jesse <rjoralist@xxxxxxxxxxxxxxxxxxxxx>
To: Chris.Taylor@xxxxxxxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Sent: Thursday, November 29, 2007 3:02:47 PM
Subject: Re: Anyone else experience this?

More often?  Not sure, but I do know that since my intro to Oracle back
7.3.4, I've been an unknowing accomplice of bugdom in our database by
utilizing more functionality of Oracle.  A few that come to mind:

    This has caused me the most grief of anything I've used in Oracle,
including the solitary "wrong results" (9.2.0, I think).  At the time,
though, it was the best solution, because we weren't taught the
importance of bind variables in our SQL classes.  I know better now!

 -- OEM/Database Control/Grid Control
    4/6 of my current SRs are about Grid Control  And I have
issues that I haven't started an SR because there is no reference to
part of the error messages on Metalink or even Google.  And with the
pain and time I seem to have with relatively "known" bugs, I
unfortunately can't afford to blaze the trail for new ones.  One major
bug I did file included a metric that failed to collect, and failed to
notify the collection failure, which led to a full tablespace, and a
discrepancy in our financials from the failed transaction.  This was
never resolved and Support relayed that they are not able to allocate
time for root cause analysis (apparently I'm supposed to debug their
software now?).  Another major one is some of the RMAN jobs scheduled
through GC just disappeared last week.  I've been ranting about OEM's
reliability since 8i.  I'm still far from satisfied, unfortunately.

-- Oracle Client on Windows
    In a past life, we used homegrown client/server apps (e.g.
8.0.5 was very stable.  Very few issues that we could attribute to the
Oracle Client.  The other two versions we replaced it with, 9.2.0 and
then 10.2.0, were buggy to the point of not being usable.  I had an SR
for the 9.2.0 client open for 10 months (escalated to Development for
most of that time) that was never resolved.

-- Oracle UltraSearch
    It's probably that I'm just not a Java-type (or class!).  It would
great for weeks (10gR1, I think?!?), then puke unexplicably, throwing
30+ errors/second until the drives filled.  Only a bounce could fix it.
The next *patch-level* release of the database included a fix, but also
*introduced* (in a patch-level release!) a different third-party engine
for the Text portion, if I remember correctly.  Because of the testing
requirements of that huge change, the patch could not be justifed to

-- Oracle Internet Directory
   Version 9iR2 (or was it even 10gR1?) was not usable with replication
Linux.  It flat out didn't work, and Support couldn't tell me what was
wrong or how to fix it.  To be fair, 10gR2 seemed nicely stable with
newer (and simpler!) LDAP-based replication agreements instead of the
Advanced Replication.  And at least one person on the OID Support team
was downright fantastic in helping me troubleshoot the miniscule error
my install (and I left feedback about it, too).

All that being said, I still think the core database is the best out
bar none.  It's just that I don't feel that 11 years experience with a
safety ringing my bell after catching a high pass in the flat should be
needed to know what options and features I should not use (Sorry for
football reference, but the Superbowl of the NFC is on tonight.  GO

My $.02000000001, (w/rounding error)

p.s.  Best of luck to you in kicking the habit!

> Do you find yourself saying more often, "It's an Oracle bug.  Fixed
> 'xx' patch."  Or "It's an Oracle bug and its not fixed yet."  Or
> an Oracle bug and it looks like its fixed in 11g."???
> We're running (can't remember the patchset off the top of my
> head) and we've got a few bugs that aren't fixed and we seem to hit
> another every other week.
> The latest is ORA-01008: Not all variables bound when setting
> cursor_sharing = SIMILAR for PeopleSoft performance.
> I just looked at the release notes (which has not been
> for any platform, nor are any release dates provided) and I think
> the biggest list of Oracle bugs I've ever seen in a patch.
> I know with added complexity comes added potential for bugs, but this
> becoming more and more bothersome.
> Thoughts?
> Disclaimer:
> I've recently quit smoking and taking Chantix so maybe I'm just in a
> very bad mood.
> Chris Taylor


Get easy, one-click access to your favorites. 
Make Yahoo! your homepage. 

Other related posts: