Avatar of michael4606
michael4606
 asked on

Oracle 10g CPU and ORA-02291

Hello,

Has anyone ever applied an Oracle 10g\11g CPU (Critical Patch Update) on an Oracle database and then started to experience "ORA-02291: integrity constraint" errors?

I have talked to Oracle on this but would like to hear if anyone else in the industry has experienced this.

Thanks,

Michael
Oracle DatabaseEnterprise Software

Avatar of undefined
Last Comment
ee_auto

8/22/2022 - Mon
Fayyaz

I have applied a couple of CPUs on 9i and 10g databases but never faced this issue. At which stage you are getting this error? while applying catcpu.sql/catbundle.sql or ?
 
michael4606

ASKER
Fayyaz,

Thanks for the response.  We got this well after the application of the last CPU.  Perhaps 24 hours or more.  

I should mention that Oracle feels overwhelmingly that it is not caused by the CPU and have communicated that they have no record of any CPU causing this.

 So far I am having great trouble in finding anyone that has experienced this error as a direct (or indirect) result of the application of a CPU.  I am just looking to determine the facts on this matter.


Thanks,

Michael


michael4606

ASKER
As it stands no one seem to be able to confirm a single instance of an  "ORA-02291: integrity constraint" error being caused directly or indirectly from the application of an Oracle CPU (Critical Patch Update).


I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
michael4606

ASKER
Matt,

If someone needs to search on the criteria of "CPU and ORA-02291" it would be useful to know that the question was posed at one time and what the response was.

This is a topic that needs as much factual evidence associated with it as possible.  For many, having it posted on this medium and seeing a lack of responses may help clarify where the problem actually is by ruling out where it is not.

I'd say in most posts this is not a major factor but on this one it can be significant.  If you need more information or would like to discuss it in greater detail please let me know.

Thanks,

Michael


ASKER CERTIFIED SOLUTION
ee_auto

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.