Home » RDBMS Server » Server Administration » 54 invalid objects after updating server from 10.2.0.1 to 10.2.0.2
54 invalid objects after updating server from 10.2.0.1 to 10.2.0.2 [message #197675] Thu, 12 October 2006 04:56 Go to next message
oracle_synedra_com
Messages: 2
Registered: October 2006
Location: Austria
Junior Member
I tried an update of the database-server from 10.2.0.1 to 10.2.0.2 and all went fine except that I got more than the 42 "allowed" invalid objects.

Docu says:
When the 10.2.0.2 patch set is applied to an Oracle Database 10g Standard Edition database or Standard Edition One database, there may be 42 invalid objects after the utlrp.sql script runs.

https://updates.oracle.com/ARULink/Readme/process_form?aru=8251421&no_header=1#CJAIIGJG

I got 54 invalid object, before the update, all objects were valid. I didn't find a hint in www or metalink, which objects may remain invalid or what to do with more than 42 invalid objects.

My invalid objects are attached.

System is a RHEL 4 x86_64

Any suggestions?

[Updated on: Thu, 12 October 2006 04:57]

Report message to a moderator

Re: 54 invalid objects after updating server from 10.2.0.1 to 10.2.0.2 [message #197705 is a reply to message #197675] Thu, 12 October 2006 06:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> I got more than the 42 "allowed" invalid objects
It is NOT a hard rule. Actually it depends on the options you use.
Try to compile those views again.
If you are not using them (or those options), ignore them.
Re: 54 invalid objects after updating server from 10.2.0.1 to 10.2.0.2 [message #197725 is a reply to message #197675] Thu, 12 October 2006 07:35 Go to previous message
oracle_synedra_com
Messages: 2
Registered: October 2006
Location: Austria
Junior Member
OK, I hope you're right Smile

I checked all invalid objects, they are all related to OLAP-stuff. Recompiling of them failed.
Previous Topic: How to find out Biggest Schema in Database
Next Topic: some clarifications in Oracle
Goto Forum:
  


Current Time: Fri Dec 09 21:16:19 CST 2016

Total time taken to generate the page: 0.06172 seconds