天萃荷净
运维DBA反映在给Oracle数据库安装patch补丁时报错OPatch failed with error code 73,分析原因为相关服务未关闭导致
打patch出现Copy failed—tfa服务导致部分lib未释放
在aix的11.2.0.4打psu之时,可能遇到由于tfa服务未停止导致部分lib未能够随着crs关闭而释放,从而导致升级升级失败,遇到这样的情况auto方式或者人工方式打patch都会失败,需要关闭tfa,并且使用slibclean释放lib对象,然后重新打patch
1.打11.2.0.4.3 psu中的18522515 patch失败
oracleplus01:/home/grid> cle/app/grid -local /oradata/sys/soft/18706472/18522515 <
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) , Oracle Corporation. All rights reserved.
Oracle Home : /u01/oracle/app/grid
Central Inventory : /u01/oracle/app/oraInventory
from : /u01/oracle/app/grid/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.4.0
Log file location : /u01/oracle/app/grid/cfgtoollogs/opatch/opatch-10-17_11-56-27AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 18522515
Do you want to proceed? [y|n]
y
User Responded with: Y
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 /support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/oracle/app/grid')
Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '18522515' to OH '/u01/oracle/app/grid'
Patching component oracle.crs, 11.2.0.4.0...
Copy failed from '/oradata/sys/soft/18706472/18522515/files/lib/libhasgen11.so' to '/u01/oracle/app/grid/lib/libhasgen11.so'...
Please verify all applications associated with the Oracle Home '/u01/oracle/app/grid' are shut down. If this is AIX,
please perform solution documented in Note 739963.1 on .
Do you want to retry copying the file? [y|n]
y
User Responded with: Y
Retry copying the file to '/u01/oracle/app/grid/lib/libhasgen11.so'.
Copy failed from '/oradata/sys/soft/18706472/18522515/files/lib/libocr11.so' to '/u01/oracle/app/grid/lib/libocr11.so'...
Please verify all applications associated with the Oracle Home '/u01/oracle/app/grid' are shut down. If this is AIX,
please perform solution documented in Note 739963.1 on .
Do you want to retry copying the file? [y|n]
y
User Responded with: Y
Retry copying the file to '/u01/oracle/app/grid/lib/libocr11.so'.
Copy failed from '/oradata/sys/soft/18706472/18522515/files/lib/libocrb11.so' to '/u01/oracle/app/grid/lib/libocrb11.so'...
Please verify all applications associated with the Oracle Home '/u01/oracle/app/grid' are shut down. If this is AIX,
please perform solution documented in Note 739963.1 on .
Do you want to retry copying the file? [y|n]
y
User Responded with: Y
Retry copying the file to '/u01/oracle/app/grid/lib/libocrb11.so'.
The following actions have failed:
Copy failed from '/oradata/sys/soft/18706472/18522515/files/lib/libhasgen11.so' to '/u01/oracle/app/grid/lib/libhasgen11.so'...
Copy failed from '/oradata/sys/soft/18706472/18522515/files/lib/libocr11.so' to '/u01/oracle/app/grid/lib/libocr11.so'...
Do you want to proceed? [y|n]
y
User Responded with: Y
Verifying the update...
There are 2 copy files under ORACLE_HOME that are not patched.
Files check failed: Some files under ORACLE_HOME are not patched. Please see log file for details.
ApplySession failed in system modification phase... 'Verification of patch failed: Files are not updated completely.'
Restoring "/u01/oracle/app/grid" to the state prior to running NApply...
OPatch failed to restore the files from backup area. Not running "make".
NApply was not able to restore the home. Please invoke the following scripts:
- restore.[sh,bat]
- make.txt (Unix only)
to restore the ORACLE_HOME. They are located under
"/u01/oracle/app/grid/.patch_storage/NApply/-10-17_11-56-27AM"
UtilSession failed: ApplySession failed in system modification phase... 'Verification of patch failed: Files are not updated completely.'
Log file location: /u01/oracle/app/grid/cfgtoollogs/opatch/opatch-10-17_11-56-27AM_1.log
OPatch failed with error code 73
2.关闭tfa服务
oracleplus01:/home/grid> ps -ef|grep -v grep|grep -E 'init|d.bin|ocls|UID|ora|crs|sql|tns|grid'
UID PID PPID C STIME TTY TIME CMD
root 1 0 0 11:16:01 - 0:00 /etc/init
root 32243912 1 0 11:19:15 - 0:00 /usr/sbin/vxnotify -g oradata_dg -icfspdvACLMSk
root 32374816 1 0 11:17:46 - 0:00 /bin/sh /etc/init.ohasd run
root 32505956 1 0 11:17:56 - 0:09 /u01/oracle/app/grid/jdk/jre/bin/java -Xms64m -Xmx256m -classpath
/u01/oracle/app/grid/tfa/oracleplus01/tfa_home/jar/RATFA.jar:/u01/oracle/app/grid/tfa/oracleplus01/tfa_home/jar/je-4.0.103.jar:
/u01/oracle/app/grid/tfa/oracleplus01/tfa_home/jar/ojdbc6.jar oracle.rat.tfa.TFAMain /u01/oracle/app/grid/tfa/oracleplus01/tfa_home
root 33095694 1 0 11:19:15 - 0:00 /usr/sbin/vxnotify -g crsdata_dg -icfspdvACLMSk
grid 34013244 5505292 0 11:56:25 pts/0 0:00 -sh
root 3211548 1 0 11:17:34 - 0:00 /opt/VRTSdbed/bin/vxdbd
root 5112296 1 0 11:17:46 - 0:00 /bin/sh /etc/init.tfa run
grid 6422822 34013244 0 13:03:33 pts/0 0:00 ps -ef
oracleplus01:/home/grid> exit
oracleplus01/#/etc/init.tfa stop
Stopping TFA
TFA is running - Will wait 5 seconds (up to 3 times)
TFA is running - Will wait 5 seconds (up to 3 times)
TFA is running - Will wait 5 seconds (up to 3 times)
TFAmain Force Stopped Successfully
Killing TFA running with pid 32505956
. . .
Successfully stopped TFA..
oracleplus01/#ps -ef|grep -v grep|grep -E 'init|d.bin|ocls|UID|ora|crs|sql|tns|grid'
UID PID PPID C STIME TTY TIME CMD
root 1 0 0 11:16:01 - 0:00 /etc/init
root 32243912 1 0 11:19:15 - 0:00 /usr/sbin/vxnotify -g oradata_dg -icfspdvACLMSk
root 32374816 1 0 11:17:46 - 0:00 /bin/sh /etc/init.ohasd run
root 33095694 1 0 11:19:15 - 0:00 /usr/sbin/vxnotify -g crsdata_dg -icfspdvACLMSk
root 3211548 1 0 11:17:34 - 0:00 /opt/VRTSdbed/bin/vxdbd
root 5112296 1 0 11:17:46 - 0:00 /bin/sh /etc/init.tfa run
3.清理未释放lib对象
oracleplus01/#genkld | grep /u01/oracle/app/grid
900000004523000 252429f /u01/oracle/app/grid/lib/libclntsh.so
9000000012e7000 2ddd80d /u01/oracle/app/grid/lib/libttsh11.so
9000000040c5000 6c16 /u01/oracle/app/grid/lib/libskgxn2.so
9000000012da000 cb95 /u01/oracle/app/grid/lib/libocrutl11.so
9000000010cb000 20efa3 /u01/oracle/app/grid/lib/libocrb11.so
90000000102a000 a0f25 /u01/oracle/app/grid/lib/libocr11.so
900000000989000 6a0dc1 /u01/oracle/app/grid/lib/libhasgen11.so
9000000075ee000 b1cf /u01/oracle/app/grid/jdk/jre/bin/libnio.a
9000000075cd000 20c36 /u01/oracle/app/grid/jdk/jre/bin/libnet.a
9000000075b5000 17840 /u01/oracle/app/grid/jdk/jre/bin/libzip.a
900000007592000 21708 /u01/oracle/app/grid/jdk/jre/bin/libj9ute23.so
90000000757d000 14a1f /u01/oracle/app/grid/jdk/jre/bin/libiverel23.so
900000007513000 69b64 /u01/oracle/app/grid/jdk/jre/bin/libjclscar_23.so
9000000074ee000 243de /u01/oracle/app/grid/jdk/jre/bin/libj9vrb23.so
9000000074b9000 3404a /u01/oracle/app/grid/jdk/jre/bin/libj9jvmti23.so
90000000748a000 2ed44 /u01/oracle/app/grid/jdk/jre/bin/libj9dyn23.so
9000000073f0000 99873 /u01/oracle/app/grid/jdk/jre/bin/libj9gc23.so
9000000073d8000 17a91 /u01/oracle/app/grid/jdk/jre/bin/libj9bcv23.so
900000006f20000 4b7279 /u01/oracle/app/grid/jdk/jre/bin/libj9jit23.so
900000006f0f000 10f07 /u01/oracle/app/grid/jdk/jre/bin/libj9trc23.so
900000006ed0000 2cd1f /u01/oracle/app/grid/jdk/jre/bin/libj9dmp23.so
900000006efd000 11bb3 /u01/oracle/app/grid/jdk/jre/bin/libj9zlib23.so
900000006e96000 37b96 /u01/oracle/app/grid/jdk/jre/bin/libjava.a
900000006ece000 1d41 /u01/oracle/app/grid/jdk/jre/bin/libwrappers.a
900000006dcf000 70780 /u01/oracle/app/grid/jdk/jre/bin/libj9vm23.so
900000006e42000 534c0 /u01/oracle/app/grid/jdk/jre/bin/libj9prt23.so
900000006e40000 1d37 /u01/oracle/app/grid/jdk/jre/bin/libj9hookable23.so
900000006da6000 1cde3 /u01/oracle/app/grid/jdk/jre/bin/j9vm/libjvm.so
900000006dc3000 bf62 /u01/oracle/app/grid/jdk/jre/bin/libj9thr23.so
900000000464000 214b /u01/oracle/app/grid/jdk/jre/bin/libjsig.so
900000006d96000 f802 /u01/oracle/app/grid/jdk/jre/bin/classic/libjvm.so
oracleplus01/#
oracleplus01/#/usr/sbin/slibclean
oracleplus01/#/usr/sbin/slibclean
oracleplus01/#/usr/sbin/slibclean
oracleplus01/#/usr/sbin/slibclean
oracleplus01/#genkld | grep /u01/oracle/app/grid
oracleplus01/#genkld | grep /u01/oracle/app/grid
oracleplus01/#
继续打patch
oracleplus01/#su - grid
oracleplus01:/home/grid> cle/app/grid -local /oradata/sys/soft/18706472/18522515 <
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) , Oracle Corporation. All rights reserved.
Oracle Home : /u01/oracle/app/grid
Central Inventory : /u01/oracle/app/oraInventory
from : /u01/oracle/app/grid/oraInst.loc
OPatch version : 11.2.0.3.6
OUI version : 11.2.0.4.0
Log file location : /u01/oracle/app/grid/cfgtoollogs/opatch/opatch-10-17_13-07-20PM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 18522515
Do you want to proceed? [y|n]
y
User Responded with: Y
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 /support/policies.html for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: Y
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/oracle/app/grid')
Is the local system ready for patching? [y|n]
Y
User Responded with: Y
Backing up files...
Applying interim patch '18522515' to OH '/u01/oracle/app/grid'
Patching component oracle.crs, 11.2.0.4.0...
Verifying the update...
Patch 18522515 successfully applied.
Log file location: /u01/oracle/app/grid/cfgtoollogs/opatch/opatch-10-17_13-07-20PM_1.log
OPatch succeeded.
oracleplus01:/home/grid>
--------------------------------------ORACLE-DBA----------------------------------------
最权威、专业的Oracle案例资源汇总之【案例】Oracle补丁 数据库打patch报错OPatch failed with error code 73