Post-installation steps after applying patches

After Patch8 is on and I create a new database, do I then have to do the post-install steps for that newly created db? Also, if I have only one Oracle home but multiple databases, can some databases continue to run okay if I don't do the post-install steps for them immediately?

Can you please clarify the following excerpt under "3. Patches To Apply," DocID Note:311062.1 (top of page 3 if printed): "For all database versions, any new database created or upgraded after CPUJul2005 was applied is required to run the post-installation script (catcpu.sql) following the steps listed in the readme file of the patches." I'm confused. Does this mean after Patch8 is on and I create a new database, I then have to do the post-install steps for that newly created db?

Also, along the same lines, if I have only one Oracle home but multiple databases, can some databases continue...

By submitting my Email address I confirm that I have read and accepted the Terms of Use and Declaration of Consent.

By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.

You also agree that your personal information may be transferred and processed in the United States, and that you have read and agree to the Terms of Use and the Privacy Policy.

to run okay if I don't do the post-install steps for them immediately? Thank you.

In the DocID, it does in fact state that you must run catcpu.sql if a new database is created using the patched Oracle binaries. You have to remember that patching usually involves two steps: patching the Oracle binaries and then patching the database(s). If you have recently patched the binaries, then any new databases created will be using those patched binaries but will not have the required dictionary changes, hence the step to run catcpu.sql on any new databases. For clarification, it would be best to open a TAR with Oracle Support.

With respect to your second question about patching only some databases running from the same ORACLE_HOME, I would not recommend this. If you patch the binaries, you should run the database-specific post-installation steps for each database using that ORACLE_HOME. If you don't perform the post-installation steps your partially patched databases may appear to run fine, but you may later encounter problems due to this that will be difficult to troubleshoot.

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy