Ask the Expert

Post-installation steps after applying patches

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 to run okay if I don't do the post-install steps for them immediately? Thank you.

    Requires Free Membership to View

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.

This was first published in August 2005

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
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
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: