Q

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 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.

This was first published in August 2005

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close