OraFAQ Forum: Enterprise Manager » Oracle Grid job broken

Home » RDBMS Server » Enterprise Manager » Oracle Grid job broken

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle Grid job broken [message #263634]

Thu, 30 August 2007 09:48

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?

Report message to a moderator

Re: Oracle Grid job broken [message #263647 is a reply to message #263634]

Thu, 30 August 2007 10:39

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Report message to a moderator

Re: Oracle Grid job broken [message #263690 is a reply to message #263686]

Thu, 30 August 2007 14:40

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Thanks for the feedback and Metalink note.

Regards
Michel

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 18:12:07 CST 2024