Q

Patch installation wiping out files and directories

Installing patch 9 for 9.2.0.7 wipes out my ora92 directory and files. Any ideas on what I can look for or at to resolve this issue?

Installing patch 9 for 9.2.0.7 wipes out my ora92 directory and files. I have successfully applied patch 9 for 9.2.0.7 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
After running Opatch:
  • 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.

Thank you.

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 1.0.0.0.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:

%ORACLE_HOME%OPatchopatch lsinventory

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.

This was first published in July 2006

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close