在部署有OGG的資料庫主機上打資料庫patch遇到的問題libclntsh.so.11.1 active，libclntsh.so.11.1

在部署有OGG的資料庫主機上打資料庫patch遇到的問題libclntsh.so.11.1 active，libclntsh.so.11.1

在部署有OGG的資料庫主機上打資料庫patch遇到的問題$ORACLE_HOME/lib/libclntsh.so.11.1 active

如下是報錯提示：

[oracle@lei1 17579684]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch applyOracle Interim Patch Installer version 11.2.0.3.10Copyright (c) 2015, Oracle Corporation.  All rights reserved.Oracle Home       : /u01/app/oracle/product/11.2.0/dbhome_1Central Inventory : /u01/app/oraInventory   from           : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.locOPatch version    : 11.2.0.3.10OUI version       : 11.2.0.3.0Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/17579684_Jun_29_2015_16_41_59/apply2015-06-29_16-41-58PM_1.logApplying interim patch '17579684' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'Verifying environment and performing prerequisite checks...Prerequisite check "CheckActiveFilesAndExecutables" failed.The details are:Following executables are active :/u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/17579684_Jun_29_2015_16_41_59/apply2015-06-29_16-41-58PM_1.logRecommended actions: OPatch needs to modify files which are being used by some processes.OPatch failed with error code 41[oracle@lei1 17579684]$

很奇怪，為啥提示還佔用，db instance 和db listener 都事先關閉了。

下面fuser和lsof上場：

[root@lei1 ~]# fuser /u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1/u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1:  3288m[root@lei1 ~]# lsof /u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1COMMAND  PID   USER  FD   TYPE DEVICE SIZE/OFF   NODE NAMEggsci   3288 oracle mem    REG  253,0 52699035 661288 /u01/app/oracle/product/11.2.0/dbhome_1/lib/libclntsh.so.11.1[root@lei1 ~]#

原來是ggsci程式還在訪問libclntsh.so.11.1，其實，當時ogg的進程已經stop了，但是ggsci並沒有退出。退出ggsci即可。然後重新opatch apply 即可！

 

參考文章：
OPatch failed with error code 73 (文檔 ID 1942237.1)

著作權聲明：本文為博主原創文章，未經博主允許不得轉載。