RE: Upgrade EM to 11gR1
- To: <s.cislaghi@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 24 Jun 2010 10:29:32 -0400
P.S. I was referring bug 8821030, OMS Upload to Repository Fails with ....
TASK_COUNT ... ID 1063856.1
Anyway, this scenario is that the agent needs another field, whereas yours is
that it won't have it.
Some of the Agents which are monitoring 11.1.0.x version of Databases have been
upgraded to the 10.2.0.5 version.
Cause
Issue has been investigated in Bug 8821030: JAVA.SQL.SQLEXCEPTION: ORA-904:
"TASK_COUNT": INVALID IDENTIFIER
This issue occurs when Oracle Management Service version 10.2.0.4 or lower
collects information from 10.2.0.5 agent(s) version. The Oracle Management
Service prior to 10.2.0.4 version does not have a required column in a specific
repository table, which a 10.2.0.5 agent is trying to insert to.
The xml files which fail the upload are related to the latest_hdm_metric_helper
metric of the 11g Database.
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: Patterson, Joel
Sent: Thursday, June 24, 2010 9:36 AM
To: 's.cislaghi@xxxxxxxxx'; 'oracle-l'
Subject: RE: Upgrade EM to 11gR1
I upgraded an agent or two to 10.2.0.5, and discovered there is an extra field
in one of the tables that is sent to the repository, so the repository needs to
be upgraded from 10.2.0.4 (I think).
In your situation, if you upgrade OMS, then the 10.2.0.4 agent will send one
less field than exists in that same table. I cannot tell you if it will fail
or if that will generate [error] messages.
Just passing the info along for your consideration. This is all buried in an
SR somewhere in the past, so I don't have the specifics.
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Stefano
Sent: Wednesday, June 23, 2010 3:59 PM
To: 'oracle-l'
Subject: Upgrade EM to 11gR1
Hi all,
Does anyone has just upgraded to EM 11gR1?
I'm reading docs and I still have some opened questions:
- remote systems using 10.2.0.4 em agent will continue to work?
- weblogic server have to be installed after upgrade? Which configuration
requires?
From metalink matrix I've found that DB may continue to be 10gR2 and need not
to be upgraded to 11g
Any others experience to share?
Thanks
Ste
--
http://www.stefanocislaghi.eu
Sent by BlackBerry® Bold 9700†ÿÁz¶ƒn{i
--
//www.freelists.org/webpage/oracle-l
Other related posts:
