I was trying to apply DST v4 timezone patch 5632264 to Oracle 18.104.22.168 RDBMS home of a Vision 11i instance which is being upgraded to 11g. Applying time zone patch is one of the pre-requisites. However this patch was not available for 5632264. The DST v4 Metalink note said that if patchset is not available, you could try to apply 22.214.171.124 or 126.96.36.199 patch. Whenever I tried to apply the patch through opatch, I got this error:
MISSING_COMPONENT : oracle.rsf.oracore_rsf, 188.8.131.52.0
This Oracle Home does not have components/versions required by the patch.
ERROR: OPatch failed during pre-reqs check.
I tried applying DSTv7 patch 6672979 also. However the same error cropped up. I downloaded new version of OPatch 184.108.40.206.58. However, there was no change in the error. In the end, I followed the manual process to apply the DST v7 patch:
The manual process is:
a) download the correct 6672979 patch for your base version and platform.
b) unzip the 6672979 patch
c) make a backup of the 2 *.dat files in your $ORACLE_HOME/oracore/zoneinfo
directory and removed them (Databases may be running but if possible stop them to avoid any file locks)
d) copy the 2 *.dat files and the readme.txt from the unzipped patch 6672979/files/oracore/zoneinfo directory to your $ORACLE_HOME/oracore/zoneinfo directory (Databases may be running but if possible stop them to avoid any file locks).
e) stop all databases using this $ORACLE_HOME and after all databases are stopped start them again.
Applying this manually does not update the v$timezone_file. I am still figuring out how to do that manually.
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps