| whats catpatch.sql for ??? [message #176835] |
Fri, 09 June 2006 22:08  |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
pertaining to 9.2.0.1 version
when i apply patch according to metalink document run the script for patch of 9.2.0.6
using
./patch-directory/runinstaller
i have to select the patch and proceed.
but i am not sure of what catpatch.sql does during patch application.
but its mentioned in post-install step.
can anyone guide me on the same.
|
|
|
|
|
|
|
|
| Re: whats catpatch.sql for ??? [message #176898 is a reply to message #176872] |
Sun, 11 June 2006 10:21  |
 |
ebrian
Messages: 2794
Registered: April 2006
|
Senior Member |
|
|
Whether it's mandatory or not may depend on the patch. If the patch's readme indicates it's needed, you definitely need to run it after patching the binaries.
In the case of patching, don't let the STARTUP MIGRATE command mislead you.
Per Metalink:
STARTUP MIGRATE was introduced in 9.2 as a mechanism to be sure that most everything that needs to be done to run an upgrade script or a patch script is done automatically. In the past, customers were expected to adjust certain initialization parameters prior to beginning an upgrade or applying a a patch, but most of this is now done automatically by STARTUP MIGRATE.
STARTUP MIGRATE should only be used when a database instance is being migrated to a different version or when a patch is being applied. Further, once the migration or patch has been successfully applied, the instance should be shutdown and restarted in normal mode.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
