OraFAQ Forum: Server Administration » 54 invalid objects after updating server from 10.2.0.1 to 10.2.0.2

Home » RDBMS Server » Server Administration » 54 invalid objects after updating server from 10.2.0.1 to 10.2.0.2

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

54 invalid objects after updating server from 10.2.0.1 to 10.2.0.2 [message #197675]

Thu, 12 October 2006 04:56

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?

Attachment: invalid_objects_after_update_10_2_0_2_ora01.txt
(Size: 1.85KB, Downloaded 1011 times)

[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

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

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

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.

Report message to a moderator

Previous Topic:	How to find out Biggest Schema in Database
Next Topic:	some clarifications in Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 06:58:08 CDT 2024