Database component in valid state

Swadhin Ray
Swadhin Ray used Ask the Experts™
on
Hello Experts,

I see that my db components are not in valid status .

Here is the screen shot :

Invalid

Wanted to know what are the DB packages that went invalid during the installation.

To make this valid , we can run "ORACLE_HOME/rdbms/admin/catproc.sql" script , but wanted to know the cause of this status and what are the exact packages that got invalid.


Thanks,
Sloba
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018
Commented:
Have you performed an upgrade recently?

Check out the following note on Oracle Support:
CATPROC Component Is Invalid and Will Not Validate (Doc ID 759635.1)
There was an issue while doing the upgrade.

Thanks this solved this issue .

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial