CPU patch and catcpu.sql (5 posts)
About This Topic
- Posted 2 years ago
- By daniesh
- Latest reply from Amit Bansal
- This topic is
not a support question - RSS feed for this topic
Tags
No tags yet.
-
Hi ,
I know that I can found this answer on website also however want to clear some of my doubts related to CPU patch and catcpu.sql. I need to know when we need to apply the cpu patch why we need to execute the script catcpu.sql after applying the cpu patch. we catpu.sql when we migrate the database from 9.2.0.6 to some other 9i version.
can you please help me in clearing my doubts.Thanks and Regards,
Daniesh -
Daniesh,
1. Please read the folowing link for CPU patches. It will tell you when to apply patch:
http://www.oracle.com/technology/deploy/security/alerts.htm2. catcpu.sql is not needed after you upgrade databases to higher versions.
If you are upgrading you need to run catupgrd.sqlCheers!!!!!
Saurabh SoodSaurabh Sood
Senior Consultant:DBA Services -
Hi,
while upgrading from 9i to some other other 9i version we need to execute catcpu.sql script. when we upgrade from lower version to 10g at that we execute catupgrd.sql script. -
Hi,
Sorry for the last post.
Actually while upgrading in the first case, we have to start the database in startup migrate mode. however we have to execute the catupgrd.sql script.
why we need catcpu.sql script.Thanks,
Daniesh -
Daniesh,
I would say it's a question which never came to my mind. This is my understanding from the captcpu.sql notes.
Catcpu.sql inturn calls a script called catbundle.sql which is located under $ORACLE_HOME/rdbms/admin
This script will load sql files in database by looking in bundledata_CPU.xml for file information for particular patch. It will be creating a dynamic apply sql file and run it.
Hope this helps.
Cheers
Amit
Reply
You must log in to post.