I was trying to apply DST v4 timezone patch 5632264 to Oracle 9.2.0.6 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 9.2.0.7 or 9.2.0.8 patch. Whenever I tried to apply the patch through opatch, I got this error:
MISSING_COMPONENT : oracle.rsf.oracore_rsf, 9.2.0.8.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 1.0.0.0.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
Subscribe to:
Post Comments (Atom)
2 comments:
thanx for your post, i had the same problem.
[ oracle.rsf.oracore_rsf, 10.1.0.5.0 ] not present ...
even after upgrading OPatch directory to 10.2.0.3
I just copyed files from 6672979 to oracore directory and restarted DB.
Then i see that
SQL> select * from v$timezone_file;
timezlrg.dat 7
good luck)
Hi Vikram,
I am also in the same boat. Let me know if you found some fix for this one.
Thanks,
Ashu
Post a Comment