Home » RDBMS Server » Enterprise Manager » Oracle Grid job broken
Oracle Grid job broken [message #263634] Thu, 30 August 2007 09:48 Go to next message
DriveShaft
Messages: 20
Registered: August 2007
Junior Member
I just installed Oracle Grid Control and have a few databases reporting to it. It is working great but I seem to have 2 warnings that I can't clear up.

Both warnings are for the EM Repository instance. The fist appeared right after the installation and the only thing it says is.... "1 job(s) have failed" It gives no indication as to what job.

6 days later another alert appeared that says..... "1 job(s) are broken"

I have looked at the job history and nothing indicates a failed or broken job.

Without knowing "what" job failed or broke, I am finding it rather hard to figure out what or where to look now.

Has anyone else ran across this?
Re: Oracle Grid job broken [message #263647 is a reply to message #263634] Thu, 30 August 2007 10:39 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know with EM but with SQL*Plus you can execute:
select job, last_date, what from dba_jobs where broken != 'N';

Regards
Michel

[Updated on: Thu, 30 August 2007 14:39]

Report message to a moderator

Re: Oracle Grid job broken [message #263686 is a reply to message #263647] Thu, 30 August 2007 14:21 Go to previous messageGo to next message
DriveShaft
Messages: 20
Registered: August 2007
Junior Member
Thanks Michel, that led me to discover that the culprit job is "MGMT_CNTR_TT.clean_up_old_ticket_recs". With that info I found MetaLink Note:416352.1, which states that this is a bug after applying Grid Patchset 10.2.0.3
Re: Oracle Grid job broken [message #263690 is a reply to message #263686] Thu, 30 August 2007 14:40 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback and Metalink note.

Regards
Michel
Previous Topic: To find Port number in Oracle 9i database
Next Topic: How to Query list of Schema and User in a mounted DB
Goto Forum:
  


Current Time: Sat Dec 10 20:53:47 CST 2016

Total time taken to generate the page: 0.34939 seconds