Ouch ... again OCM

Another customer, another upgrade - and again from Oracle Database 11.1.0.7 to Oracle Database 11.2.0.3. And again an OCM error during upgrade which is not very obvious to relate to OCM once you see the errors during upgrade.

While monitoring the database during upgrade with tail -f on the alert.log we've spotted this one here:

ORA-604: error occurred at recursive SQL level 3
ORA-904: "XDB"."DBMS_CSX_INT"."GUIDTO32": invalid identifier
XDB SGA reset to NULL.

Looks like some issue with XDB. But actually it is related to OCM and it seems that something gets created in the wrong order. Currently DEV is working on that issue - and the good message: after the upgrade has been completed everything is VALID. But it's one of those strange errors you might wonder about ...

This issue has been filed under:
Bug 13710092: ORA-00904: "XDB"."DBMS_CSX_INT"."GUIDTO32": DURING UPGRADE
and the bug is not public at the moment - but you could simply ignore that error.

- Mike

Comments:

Post a Comment:
Comments are closed for this entry.
About

Mike Dietrich - Oracle Mike Dietrich
Senior Principal Technologist - Database Upgrade Development Group - Oracle Corporation

Based near Munich/Germany and spending plenty of time in airplanes to run either upgrade workshops or work onsite with reference customers. Acting as interlink between customers and the Upgrade Development.

Contact me either via XING or LinkedIn

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
4
5
6
9
10
12
13
15
16
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today
Slides Download Center
OOW Slides Download
Visitors since 17-OCT-2011
White Paper and Docs
Oracle Blogs
Workshops
Viewlets and Videos
This week on my Rega/iPod/CD
Workshop Map
Upgrade Reference Papers