Installing patch 9 for 18.104.22.168 wipes out my ora92 directory and files. I have successfully applied patch 9 for 22.214.171.124 on two previous servers with no issues. These are Windows Advanced Servers running Oracle9i Enterprise Edition. The only difference on this server is that everything is on the C drive. Upon trying to apply the same patch to a third server, the Opatch script errors out. Partial logs shows:
preparing to execute C:Oracle_Patches5064365customscriptspre.bat Executing the Apply pre-patch script (C:Oracle_Patches5064365customscriptspre.bat)... C:oracleora92PATCH_~15064365Apply_5064365_05-18-2006_11-28-08.log - The process cannot access the file because it is being used by another process. C:oracleora92PATCH_~15064365rollback_5064365.cmd - The process cannot access the file because it is being used by another process. C:oracleora92Apacheperl59402~1.005binMSWIN3~1perl.dll - Access is denied. C:oracleora92Apacheperl59402~1.005binMSWIN3~1perl.exe - Access is denied. C:oracleora92Apacheperl59402~1.005libMSWIN3~1autoPOSIXPOSIX.dll - Access is denied. C:oracleora92binoci32.dll.old.2 - Access is denied. The system cannot find the path specified.
All services and processes have been shut down and verified that nothing is accessing the ora92 directory or its files. After I discontinue the Opatch script I check the ora 92 directory and 99.9% of my files and directories are wiped out.
Before running Opatch:
- 2.26 GB
- 64,805 files
- 7,320 folders
- 828 KB
- 463 files
- 106 folders
In addition ALL the files that have been copied to the ora92.patch_storage5064365 directory have a 0 KB size. Oracle states that Opatch does not delete any files and that I have an OS problem. Any ideas on what I can look for or at to resolve this issue? I have tried to install this patch six times with the same results every time.
My first recommendation would be to download the latest version of OPatch prior to applying any patches with it. In the past, there have been problems with older versions of OPatch and you may be using one of these versions. In the README file for this specific patch, it states that the minimum version of OPatch required is 126.96.36.199.55.
Prior to applying the patch again (I'm assuming you restored the software to its previous state), check that the inventory can be read by using the following command:
If this command completes successfully, then at least the inventory is intact.
Also, from the error log output above, it shows that OPatch is being denied access to Perl or some Perl-related files. OPatch requires Perl to function. If a typical Oracle installation was performed, OPatch will attempt to use Perl located under the Apache directory of your ORACLE_HOME. From the output above, it looks as though Perl was installed but OPatch cannot access it. This may be why OPatch is failing.
Dig Deeper on Oracle database installation, upgrades and patches
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.