Home » RDBMS Server » Server Administration » catpatch.sql
catpatch.sql [message #239969] Wed, 23 May 2007 15:06 Go to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Hi all,

There are about 20 invalid objects in the database of MDSYS,CTXSYS schemas.. I think mdsys is related to Oracle Spatial and ctxsys is related to oracle text/intermedia. I dont know how to check if any of these options are used in the database to ignore these invalid objects? Can somebody help me?

Thanks.
Re: catpatch.sql [message #239970 is a reply to message #239969] Wed, 23 May 2007 15:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If you don't use these components you can ignore these invalid objects.

Regards
Michel
Re: catpatch.sql [message #239972 is a reply to message #239969] Wed, 23 May 2007 15:19 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Here is something equivalent to giving chicken soup to a dead man.
It can't hurt & just might help.
While logged in as SYS invoke
@$ORACLE_HOME/rdbms/admin/utlrp.sql
-- this should recompile any & all invalid packages in the DB
Re: catpatch.sql [message #240231 is a reply to message #239969] Thu, 24 May 2007 07:33 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Michel,

I am not sure how to check if these components are used in the database?? And I know if they are not used, I can ignore the invalid objects.. I just dont know how to check if they are used.

Anacedent,

I ran utlrp.sql 3-4 times, but it doesn't help for some reason...
Re: catpatch.sql [message #240266 is a reply to message #240231] Thu, 24 May 2007 08:54 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What is your version?

Regars
Michel
Re: catpatch.sql [message #240268 is a reply to message #239969] Thu, 24 May 2007 08:56 Go to previous messageGo to next message
plshelp
Messages: 205
Registered: January 2007
Senior Member
OS is solaris and oracle is 9.2.0.7.
Re: catpatch.sql [message #240275 is a reply to message #240268] Thu, 24 May 2007 09:06 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Bad luck, in latest 10g Oracle keep trace of used component not in 9i.

Regards
Michel
Re: catpatch.sql [message #240278 is a reply to message #239969] Thu, 24 May 2007 09:10 Go to previous message
plshelp
Messages: 205
Registered: January 2007
Senior Member
Oh is it? so there is no way I can find out if these options have been used in the database? Well, so I think I can just ignore these invalid objects whether or not they have been used..
Previous Topic: Is there a way to track changes in system parameters? (merged)
Next Topic: Oracle Enterprise Manager
Goto Forum:
  


Current Time: Fri Dec 09 15:21:15 CST 2016

Total time taken to generate the page: 9.85393 seconds