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!

How can I determine if a Critical Patch Update has been installed?

455096Mar 22 2006 — edited Mar 23 2006

I know I can use opatch -lsinventory to confirm that a the patch has been installed in an Oracle home, but how can I check to see if the CPU script (catcpu.sql) has been run in a database?

I'd like to know for two reasons:
1. I am concerned because I have many databases to patch under a single Oracle home and I'd like to check them all to make sure I didn't miss any.
2. I've heard that I'll have to run catcpu.sql in any new database I create under this Oracle home. I know I'll eventually forget to do this, so I'd like some way to check if the script has been run.

Thanks in advance

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2006

Added on Mar 22 2006

#general-database-discussions

2 comments

776 views