OraFAQ Forum: Server Administration » Invalid objects in SYS schema

Home » RDBMS Server » Server Administration » Invalid objects in SYS schema

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

Invalid objects in SYS schema [message #138738]

Fri, 23 September 2005 06:00

vens
Messages: 14
Registered: September 2005
Location: Russia

Junior Member

After installing 9R2 patchset (9.2.0.7) some objects (packages,package bodies and views) in SYS schema obtained invalid status. It happened after running catpatch.sql script. utlrp was launched also. So recompilation doesn't help. Seems some objects are missing so they cause compilation errors. What can be done to help this?

Report message to a moderator

Re: Invalid objects in SYS schema [message #138758 is a reply to message #138738]

Fri, 23 September 2005 07:51

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

What are those objects?
In some cases, you might not chosen the right server option( like xmldb).
Did you try to compile them manually?
Did you issue startup migrate?

Report message to a moderator

Re: Invalid objects in SYS schema [message #138761 is a reply to message #138738]

Fri, 23 September 2005 08:08

vens
Messages: 14
Registered: September 2005
Location: Russia

Junior Member

Yes, i used startup migrate. The objects are - many views beginning with ku$_, then sys.dbms_repcat, sys.dbms_defergen, dbms_ias and some more packages and bodies. I used usual options, to say more some other our instances have such objects as valid.

Report message to a moderator

Re: Invalid objects in SYS schema [message #138866 is a reply to message #138761]

Sat, 24 September 2005 14:31

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

You will need to check with Individual Objects and their error codes and then proceed .. There might be some objects that could be missing..

-Sai Jeedigunta

Report message to a moderator

Re: Invalid objects in SYS schema [message #138892 is a reply to message #138738]

Sun, 25 September 2005 02:46

vens
Messages: 14
Registered: September 2005
Location: Russia

Junior Member

Yes, some references while checking indicate that some objects are missing. I just don't understand the reason.

Report message to a moderator

Re: Invalid objects in SYS schema [message #138918 is a reply to message #138892]

Sun, 25 September 2005 13:57

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

Every object that is Invalid / missing will refer to extended functionality within oracle like Java / XML / Replication etc., you then need to proceed with the corresponding Oracle provided script files to re-create/ fix those (if u need those functionalities ) ...for example : utlrepcat.sql will create replication related stuff ...initjvm.sql will create java related stuff etc.,

Hope that helps
-Sai Jeedigunta

Report message to a moderator

Re: Invalid objects in SYS schema [message #138993 is a reply to message #138738]

Mon, 26 September 2005 04:52

vens
Messages: 14
Registered: September 2005
Location: Russia

Junior Member

I havn't got utlrepcat - i reran utlrp.sql once again, invalid objects decreased, but still numerous.

Report message to a moderator

Re: Invalid objects in SYS schema [message #139607 is a reply to message #138738]

Wed, 28 September 2005 15:42

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

Acually ..tell us this ..
is any of our db functionalities throwing you errors ? ? if yes paste the errors ... there is no problem if some extended functionalities related packages / procs being invalid ..as we dont use them ..

-Sai Jeedigunta

Report message to a moderator

Re: Invalid objects in SYS schema [message #139663 is a reply to message #138738]

Thu, 29 September 2005 01:58

vens
Messages: 14
Registered: September 2005
Location: Russia

Junior Member

Invalid objects don't disturb us right now, but if we use replication or smth. else one day?

Report message to a moderator

Previous Topic:	Error during stoping of service
Next Topic:	How to Connect two oracle server with internet

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 08:19:15 CST 2025