分类目录归档：数据库

在aix的11.2.0.4打psu之时,可能遇到由于tfa服务未停止导致部分lib未能够随着crs关闭而释放,从而导致升级升级失败,遇到这样的情况auto方式或者人工方式打patch都会失败,需要关闭tfa,并且使用slibclean释放lib对象,然后重新打patch
打11.2.0.4.3 psu中的18522515 patch失败

xifenf01:/home/grid> cle/app/grid -local /oradata/sys/soft/18706472/18522515                                                     <
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, 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/opatch2014-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 http://www.oracle.com/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 https://myoraclesupport.oracle.com.

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 https://myoraclesupport.oracle.com.

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 https://myoraclesupport.oracle.com.

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/2014-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/opatch2014-10-17_11-56-27AM_1.log

OPatch failed with error code 73

关闭tfa服务

xifenf01:/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/xifenf01/tfa_home/jar/RATFA.jar:/u01/oracle/app/grid/tfa/xifenf01/tfa_home/jar/je-4.0.103.jar:
/u01/oracle/app/grid/tfa/xifenf01/tfa_home/jar/ojdbc6.jar oracle.rat.tfa.TFAMain /u01/oracle/app/grid/tfa/xifenf01/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

xifenf01:/home/grid> exit

xifenf01/#/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..
xifenf01/#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

清理未释放lib对象

xifenf01/#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
xifenf01/#
xifenf01/#/usr/sbin/slibclean
xifenf01/#/usr/sbin/slibclean
xifenf01/#/usr/sbin/slibclean
xifenf01/#/usr/sbin/slibclean
xifenf01/#genkld | grep /u01/oracle/app/grid
xifenf01/#genkld | grep /u01/oracle/app/grid
xifenf01/#

继续打patch

xifenf01/#su - grid
xifenf01:/home/grid> cle/app/grid -local /oradata/sys/soft/18706472/18522515                                                     <
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, 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/opatch2014-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 http://www.oracle.com/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/opatch2014-10-17_13-07-20PM_1.log

OPatch succeeded.
xifenf01:/home/grid>