Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps

Monday, August 11, 2008

MISSING_COMPONENT : oracle.rsf.oracore_rsf

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.

2 comments:

Unknown said...

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)

Ashu said...

Hi Vikram,

I am also in the same boat. Let me know if you found some fix for this one.

Thanks,
Ashu