3 August 2012

the following files are active oci.dll


The following files are active oci.dll while applying 11g patch in windows environment

Following files are active:
 E:\app\product\11.2.0\dbhome_1\bin\oci.dll
Apply Session failed during prerequisite checks: Prerequisite check "CheckActive FilesAndExecutables" failed.
System intact, OPatch will not attempt to restore the system

  OPatch failed with error code = 47

How to disable the oci.dll files accessing in windows.

1) Pls rename the oracle_home directory
2) Reboot the windows server
3) Again rename the oracle_home directory with original name.

Now apply the patch:

E:\app\product\11.2.0\dbhome_1\OPatch>opatch apply
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.

Oracle Home       : E:\app\product\11.2.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log filel ocation : E:\app\product\11.2.0\dbhome_1\cfgtoollogs\opatch\14223717_Aug_03_2012_11_57_20\apply2012-08-03_11-57-20AM_1.log
Applying interim patch '14223717' to OH 'E:\app\product\11.2.0\dbhome_1'
Verifying environment and performing prerequisite checks...
Patch 14223717: Optional component(s) missing : [ oracle.precomp.lang, 11.2.0.3.0 ] , [ oracle.rdbms.tg4msql, 11.2.0.3.0 ] , [ oracle.rdbms.ic, 11.2.
.0 ]
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit http://www.oracle.com/support/policies.html for details.
Email address/User Name: lakshminarayanan.n@media.in
Provide your My Oracle Support password to receive security updates via your My Oracle Support account.
Password (optional):
Unable to establish connection to Oracle Configuration Manager server.
Hostname (https://ccr.oracle.com) is unknown.

Unable to establish a network connection to Oracle. Specify the URL for an
Oracle Support Hub in this format:
    http[s]://<OracleSupportHubHost>:<OracleSupportHubPort>
If you do not wish to configure OCM through an Oracle Support Hub, enter NONE
Oracle Support Hub URL:
Invalid Oracle Support Hub address specified ().

Unable to establish a network connection to Oracle. Specify the URL for an
Oracle Support Hub in this format:
    http[s]://<OracleSupportHubHost>:<OracleSupportHubPort>
If you do not wish to configure OCM through an Oracle Support Hub, enter NONE
Oracle Support Hub URL: NONE

Unable to establish a network connection to Oracle. If your systems require a
proxy server for outbound Internet connections, enter the proxy server details
in this format:
    [<proxy-user>@]<proxy-host>[:<proxy-port>]
If you want to remain uninformed of critical security issues in your
configuration, enter NONE
Proxy specification:
An invalid proxy specification was given. Please re-enter the proxy information.

Unable to establish a network connection to Oracle. If your systems require a
proxy server for outbound Internet connections, enter the proxy server details
in this format:
    [<proxy-user>@]<proxy-host>[:<proxy-port>]
If you want to remain uninformed of critical security issues in your
configuration, enter NONE
Proxy specification: NONE
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = 'E:\app\product\11.2.0\dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms.plsql, 11.2.0.3.0...
Patching component oracle.network.rsf, 11.2.0.3.0...
Patching component oracle.precomp.common, 11.2.0.3.0...
Patching component oracle.rdbms.rman, 11.2.0.3.0...
Patching component oracle.rdbms.util, 11.2.0.3.0...
Patching component oracle.ntoledb.odp_net_2, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Patching component oracle.xdk.rsf, 11.2.0.3.0...
Patching component oracle.rdbms.rsf.ic, 11.2.0.3.0...

Patching component oracle.rdbms.oci, 11.2.0.3.0...
Patching component oracle.ntoramts, 11.2.0.3.0...
Patching component oracle.sysman.console.db, 11.2.0.3.0...
Patching component oracle.ntoledb, 11.2.0.3.0...
Patching component oracle.ctx, 11.2.0.3.0...
Patching component oracle.odbc.ic, 11.2.0.3.0...
Patching component oracle.network.listener, 11.2.0.3.0...
Patching component oracle.sysman.agent, 10.2.0.4.3...
Patching component oracle.ldap.rsf.ic, 11.2.0.3.0...
Patching component oracle.rdbms.deconfig, 11.2.0.3.0...

Verifying the update...
Patch 14223717 successfully applied
Log file location: E:\app\product\11.2.0\dbhome_1\cfgtoollogs\opatch\14223717_Aug_03_2012_11_57_20\apply2012-08-03_11-57-20AM_1.log

OPatch succeeded.

Ensure the OPatch applied successfully

E:\app\product\11.2.0\dbhome_1\OPatch>opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation.  All rights reserved.
Oracle Home       : E:\app\product\11.2.0\dbhome_1
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 11.2.0.3.0
OUI version       : 11.2.0.3.0
Log file location : E:\app\product\11.2.0\dbhome_1\cfgtoollogs\opatch\opatch201
-08-03_12-20-49PM_1.log

Lsinventory Output file location : E:\app\product\11.2.0\dbhome_1\cfgtoollogs\o
atch\lsinv\lsinventory2012-08-03_12-20-49PM.txt
-------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g                                                  11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch  14223717     : applied on Fri Aug 03 12:13:22 PDT 2012
Unique Patch ID:  15228601
Patch description:  "ORACLE 11G 11.2.0.3 PATCH 8 BUG FOR WINDOWS 32 BIT"
   Created on 21 May 2012, 23:46:07 hrs PST8PDT
   Bugs fixed:
     14223717, 14018752, 13258936, 13723052, 12898020, 10625145, 14052871
     13076238, 13992002, 13242070, 12955701, 12693573, 14026888, 13984965
     13366199, 13843286, 13616375, 12839247, 8547978, 13714926, 13023854
     13910420, 11837095, 12842909, 12959852, 13632140, 13780035, 13860201
     13711083, 13628002, 13397104, 12358083, 13743357, 13945708, 10384051
     13591484, 13051250, 14095819, 5144934, 13657605, 13582702, 12966665
     13463131, 13773133, 12918738, 13099577, 13690409, 13645917, 11708510
     14042380, 13627489, 13652437, 12733042, 13907462, 13608299, 13624984
     9095696, 12794090, 9706532, 13469158, 13947480, 13555112, 13399236
     12910565, 13790109, 12552578, 13896848, 13737746, 13080778, 13458016
     13873885, 12312133, 12731940, 12672969, 13355095, 13981051, 13467683
     13457582, 13370330, 13340388, 12976376, 12797420, 12658411, 10133521
     9761357, 13827394, 13729832, 13851978, 13559770, 13592937, 13592919
     13478856, 13559540, 13641696, 13729808, 13632530, 14100237, 11071989
     13786142, 13839641, 13041324, 13965210, 12424121, 13478060, 13786778
     13579992, 13705338, 13603613, 13476583, 12745662, 9190186, 13530646
     13520452, 9019231, 13610777, 12905053, 10263668, 13550185, 13385346
     13448206, 12772404, 13911711, 11072246, 13104881, 13863326, 12889054
     13775960, 13777823, 13464002, 11824898, 13535622, 13916709, 12880299
     12918338, 13885388, 13649031, 13350245, 13553883, 13388104, 13635347
     13404129, 13031118, 12530140, 13023541, 13767921, 13787482, 13641076
     13807411, 13724992, 12965899, 12879027, 13584130, 13495307, 12594032
     13709220, 13247965, 13243072, 13683125, 13652493, 12957127, 10215977
     13014128, 13040331, 12857222, 12977501, 12664456, 12405931, 13525554
     13492863, 13573521, 13873471, 13791443, 13366268, 13352423, 12919564
     12894807, 12829021, 12612118, 11063191, 13503598, 13482688, 13354082
     13484963, 13395403, 13542159, 12983611, 13718476, 12846562, 9659614
     13326736, 11846902, 11665727, 13257247, 13588248, 13544396, 13566938
     13615517, 13570056, 12403721, 12585543, 12784549, 12834800, 12975771
     13040171, 13058950, 13063120, 13077335, 13365700, 13382280, 13384397
     13440516, 13454210, 13457537, 13477790, 13496250, 13501787, 13505390
     13506110, 13524899, 13572659, 13594712, 13617627, 13555973, 13035360
     13420224, 13419660, 13036331, 13332439, 13420174, 12583826, 13358781
     11883969, 13524237, 12867713, 13328193, 13516727, 11865420, 13502183
     13259364, 12998795, 13044108, 12971242, 12834027, 12620823, 13420516
     12646784, 13366202, 11840910, 12656535, 12617123, 13073340, 12938841
     13023632, 12942119, 11877623, 13070939, 12535346, 12985184, 13103913
     12622441, 12923168, 13362079, 12591252, 12718090, 10350832, 12795861
     13017584, 12627504, 12847466, 12797765, 12861463, 12764337, 12662040
     12668341, 12597906, 12960925, 12886827, 12913474, 3522216, 12678920
     12827166, 9703627, 12905058, 10357727, 13004894, 12780983, 13146719
     12655301, 12960302, 12979199, 12638117, 13357509, 12401111, 8631856
     13035804, 12845115, 12971775, 12917230, 12582664, 13413167, 12849688
     12950644, 12588744

-------------------------------------------------------------------------------

OPatch succeeded.