Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Catproc.sql and Catalog.sql by mistake ran in production Database while database was running.

user12187861Sep 9 2014 — edited Sep 9 2014

Hi,

DB version: 10.2.0.4.0 cluster db. EE

OS version: Win server 2008

by mistake one of our dba has ran CATPROC.sql and CATALOG.sql scripts in our live production rac database.

after that issues has rised and developers faced invalid objects. we manually cleared our main user's invalid objects and looks like everything is running fine for now.

BUT when i checked all_objects for status invalid , it showed me around 600 invalid objects. i am afraid in future some unacceptable errors will come.

what to do? any suggestions? are we in danger? what are the work arounds.

Thanks

This post has been answered by Hemant K Chitale on Sep 9 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 7 2014

Added on Sep 9 2014

#general-database-discussions

12 comments

1,991 views