Ask the Expert

Patch installation wiping out files and directories

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.

    Requires Free Membership to View

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: