Home » RDBMS Server » Server Administration » Invalid database objects
icon4.gif  Invalid database objects [message #148844] Mon, 28 November 2005 11:16 Go to next message
skoskos
Messages: 19
Registered: November 2005
Location: Hell(as)
Junior Member
Hello ,
I have successfully installed Oracle 10g on Windows XP.
After that , I run the file catalog.sql which creates the oracle dictionary connecting as user sys (file C:\oracle\product\10.2.0\database10g\RDBMS\ADMIN\catalog.sql).
Every command in this file executed successfully - except for some commands for dbobjects which were already in the database(during the RDBMS installation).

The problem is that some objects in sys mainly schema are invalid and remain invalid after compilation . What can I do?

The invalid objects in sys schema are in the attached file.....

Report message to a moderator

Re: Invalid database objects [message #148876 is a reply to message #148844] Mon, 28 November 2005 16:31 Go to previous messageGo to next message
srinivas4u2
Messages: 66
Registered: June 2005
Member
Run utlrp.sql as sys. And that should solve your problem, incase if it doesn't check whether you need the selected features.

Report message to a moderator

Re: Invalid database objects [message #148995 is a reply to message #148876] Tue, 29 November 2005 08:04 Go to previous messageGo to next message
skoskos
Messages: 19
Registered: November 2005
Location: Hell(as)
Junior Member
Thanks for your reply ,
but this script didn't solve the problem because the package body 'SYS.DBMS_REGISTRY_SYS' has compilation errors!!
Any other idea?

Report message to a moderator

Re: Invalid database objects [message #149041 is a reply to message #148844] Tue, 29 November 2005 16:58 Go to previous messageGo to next message
nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...
Senior Member
Can you run Enterprise Manager? You can recompile objects under any schema if you have the correct privileges.

Of course there are many 3rd party products, like sqlprogrammer, Insight, ...

Good luck!

Report message to a moderator

Re: Invalid database objects [message #149181 is a reply to message #149041] Wed, 30 November 2005 08:15 Go to previous messageGo to next message
skoskos
Messages: 19
Registered: November 2005
Location: Hell(as)
Junior Member
Thanks for your reply ,
I can run Enterprise Manager Console - connect as sys/sysdba -through which I see the invalid objects. Unfortunately , the invalid objects cannot become valid.
According to the names of invalid objects (packages , e.t.c.) these objects seem to be related to system registry or somehow a system misconfiguration.
Have you any idea on which can be the problem?

Report message to a moderator

Re: Invalid database objects [message #149502 is a reply to message #149181] Fri, 02 December 2005 01:20 Go to previous messageGo to next message
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
Senior Member
i am not sure about this scenario in 10G .. but an invalid package / procedure in db after its creation need not be a problematic sympton ..if you need that object then Oracle will have a .SQL file associated with it ..so we can run that file and troubleshoot the issue from there ..

-Sai Jeedigunta

Report message to a moderator

Re: Invalid database objects [message #149613 is a reply to message #149502] Fri, 02 December 2005 08:16 Go to previous message
skoskos
Messages: 19
Registered: November 2005
Location: Hell(as)
Junior Member
Running script catproc.sql solved the problem.
Anyway , thanks!!!

Report message to a moderator

Previous Topic: Problem with oracle 10G
Next Topic: Audit all schema's tables, in one trigger/table...
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jan 26 13:35:24 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.