windows에서 Opatch 진행시 oci.dll 화일 에러로 진행이 안될때가 있다.
아래와 같을 때는...
Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.
C:\Documents and Settings\Administrator>cd %ORACLE_HOME%\opatch
C:\oracle\product\10.2.0\db_1\OPatch>opatch apply C:\GTech10\p6430171_10203_WINN
T\6430171
Invoking OPatch 10.2.0.3.4
Oracle Interim Patch Installer version 10.2.0.3.4
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : C:\oracle\product\10.2.0\db_1
Central Inventory : C:\Program Files\Oracle\Inventory
from : n/a
OPatch version : 10.2.0.3.4
OUI version : 10.2.0.3.0
OUI location : C:\oracle\product\10.2.0\db_1\oui
Log file location : C:\oracle\product\10.2.0\db_1\cfgtoollogs\opatch\opatch2008-
04-25_17-31-16PM.log
ApplySession applying interim patch '6430171' to OH 'C:\oracle\product\10.2.0\db
_1'
Interim patch 6430171 is a superset of the patch(es) [ 5556081 5557962 ] in OH
C:\oracle\product\10.2.0\db_1
OPatch will rollback the subset patches and apply the given patch.
Running prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following files are active :
C:\oracle\product\10.2.0\db_1\bin\oci.dll
ApplySession failed during prerequisite checks: Prerequisite check "CheckActiveF
ilesAndExecutables" failed.
System intact, OPatch will not attempt to restore the system
The following warnings have occurred during OPatch execution:
1) OUI-67078:Interim patch 6430171 is a superset of the patch(es) [ 5556081 555
7962 ] in OH C:\oracle\product\10.2.0\db_1
--------------------------------------------------------------------------------
OPatch failed with error code = 74
C:\oracle\product\10.2.0\db_1\OPatch>
-----------------------------------------------------------------------------------
원인과 해결법
Cause
This error occurs when the Oracle Files are in use.
Windows will not allow a file to be overwritten, while it is in use.
Solution
- Make sure ALL Oracle Services are stopped.
- Check to see if you have a service called Distributed Transaction Coordinator running.
- If so, stop it.
- Try to apply the patch again.
If you get the same error, then it means some other application / service is using the Oracle Files.
There is a simple workaround for this:
- Boot the machine into SAFE MODE.
- Apply the patch.
- After the patch is applied, reboot the machine back into Normal Mode.
- Finish applying the patch, by using the Post Installation Procedures.
Other possible workarounds:
Remove Oracle from the PATH, reboot the machine, apply the patch, then put Oracle back in the PATH.
Steps recommended:
- Set ALL Oracle Services to Manual Start (Note which ones are set this way, so you can
set them back later).
- Edit the System Environment Variables.
- Copy the ENTIRE PATH into a Notepad Text file (for later use).
- Remove the Oracle directories from the PATH.
- Reboot the machine.
- Apply the patch.
- Restore the PATH back to how it was (using the Notepad text file).
- Set the Oracle Services back to AUTO startup (only the ones that were set this way before).
- Reboot the machine.
- Finish applying the patch with the Post Installation Procedures (ie., the scripts).
It has been reported by some, an application such as a Virus Checker, Backup software, DiskKeeper, and other programs such as these, have a lock on some of the Oracle files.
You may want to disable these programs, and see if the patch gets applied.
See the next section, to help determine what process / program is locking the files.
Use a utility to determine what process is using the Oracle files.
- One such utility is called Process Explorer.
- You can find this at: http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx
- Once installed, search for the Oracle .dll files.
- When you find the process that is using the files, you can kill that process.
- Then try applying the patch.
If the above steps have been tried, and you are still getting errors copying the files:
Check to see if the 'Read-Only' attribute is set, either on the patch bundle files, or>br> in the Oracle_Home.
(Note: A good indication of this problem is when there are 80+ files that can not be copied).
A common reason for this, is if the patch bundle was put onto a CD-ROM, then copied onto
the local disk. Or, if someone intentionally sets the read-only attribute on the Oracle files.
To check for the 'Read-Only' Attribute, you can:
- Use Windows Explorer
- CD to the directory (either the patch directory, or the Oracle_Home)
- Right click on a file
(Use the Opatch Apply.log, to determine the filename or folders.)
- Select Properties
- You can see if the Read-Only Attribute is set.
If the Read-Only attribute is set, you need to remove it:
- Open a CMD Prompt.
- CD to directory (the patch directory or the Oracle_Home).
- Type: attrib -r *.* /s
(This command will remove the 'read-only' attribute from all files and all sub-folders).
Now try applying the patch.
