Solved

Database component in valid state

Posted on 2014-03-06
2
438 Views
Last Modified: 2014-03-07
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
0
Comment
Question by:Swadhin Ray
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 39909154
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)
0
 
LVL 16

Author Closing Comment

by:Swadhin Ray
ID: 39912145
There was an issue while doing the upgrade.

Thanks this solved this issue .
0

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup
Suggested Courses

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question