在部署有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)
版权声明：本文为博主原创文章，未经博主允许不得转载。
是我一生的快乐;失去你，是我一生的遗憾;没有你，无法感受心灵的震撼。
