To avoid the effects of dblink, a single instance of the company's set of 11.2.0.3.5, upgraded to 11.2.0.3.15 process records

To avoid the effects of dblink, a single instance of the company's set of 11.2.0.3.5, upgraded to 11.2.0.3.15 process records
1. Stop the database
Shutdown immediate;
2.root User Backup Db_home grid_home
tar-cvf/export/oracle20180602.tar/u01/app/oracle/product/11.2.0/db_1/*-p-p
tar-cvf/export/grid20180602.tar/u01/11.2.0/grid/*-p-p
tar-cvf/export/orainventory20180602.tar/u01/app/orainventory/*-p-p
3. Start Patching
4. Start the GI patch application
# Opatch AUTO/U01/SOFTWARE-OH/U01/11.2.0/GRID-OCMRF/HOME/GRID/OCM.RSP
[Email protected] opatch]#/opatch AUTO/U01/SOFTWARE-OH/U01/11.2.0/GRID-OCMRF/HOME/GRID/OCM.RSP
Executing/u01/11.2.0/grid/perl/bin/perl/u01/11.2.0/grid/opatch/crs/patch11203.pl-patchdir/u01-patchn Software- Oh/u01/11.2.0/grid-ocmrf/home/grid/ocm.rsp-paramfile/u01/11.2.0/grid/crs/install/crsconfig_params

This is the main log file:/u01/11.2.0/grid/cfgtoollogs/opatchauto2018-06-02_19-17-15.log

This file would show your detected configuration and all the steps, Opatchauto attempted to do on your system:
/u01/11.2.0/grid/cfgtoollogs/opatchauto2018-06-02_19-17-15.report.log

2018-06-02 19:17:15:starting Oracle Restart Patch Setup
Using configuration parameter file:/u01/11.2.0/grid/crs/install/crsconfig_params

Stopping CRS ...
Stopped CRS successfully

patch/u01/software/17592127 Apply successful for Home/u01/11.2.0/grid
patch/u01/software/20760997 Apply successful for Home/u01/11.2.0/grid

Starting CRS ...
Crs-4123:oracle High Availability Services have been started.

Opatch Auto succeeded.
[Email protected] opatch]#
5. Start the DB patch application
# Opatch AUTO/U01/SOFTWARE-OH/U01/APP/ORACLE/PRODUCT/11.2.0/DB_1-OCMRF/HOME/ORACLE/OCM.RSP
[Email protected] opatch]#/opatch auto/u01/software-oh/u01/app/oracle/product/11.2.0/db_1-ocmrf/home/oracle/ Ocm.rsp
Executing/u01/11.2.0/grid/perl/bin/perl/u01/app/oracle/product/11.2.0/db_1/opatch/crs/patch11203.pl-patchdir/ U01-patchn Software-oh/u01/app/oracle/product/11.2.0/db_1-ocmrf/home/oracle/ocm.rsp-paramfile/u01/11.2.0/grid/ Crs/install/crsconfig_params

This is the main log file:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2018-06-02_19-27-17.log

This file would show your detected configuration and all the steps, Opatchauto attempted to do on your system:
/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2018-06-02_19-27-17.report.log

2018-06-02 19:27:17:starting Oracle Restart Patch Setup
Using configuration parameter file:/u01/11.2.0/grid/crs/install/crsconfig_params

Stopping rac/u01/app/oracle/product/11.2.0/db_1 ...
Stopped Rac/u01/app/oracle/product/11.2.0/db_1 successfully

patch/u01/software/17592127/custom/server/17592127 Apply successful for home/u01/app/oracle/product/11.2.0/db_1
patch/u01/software/20760997 apply failed for home/u01/app/oracle/product/11.2.0/db_1 <<<<<<< <DB Patch Upgrade failed

Starting rac/u01/app/oracle/product/11.2.0/db_1 ...
Started Rac/u01/app/oracle/product/11.2.0/db_1 successfully

Opatch Auto succeeded.
[[email protected] opatch]
DB Patch upgrade failed. Check the log/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatchauto2018-06-02_19-27-17.log
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
2018-06-02 19:28:08:the Apply patch output is Oracle interim patch Installer version 11.2.0.3.19
Copyright (c) 2018, Oracle Corporation. All rights reserved.


Oracle Home:/u01/app/oracle/product/11.2.0/db_1
Central Inventory:/u01/app/orainventory
From:/u01/app/oracle/product/11.2.0/db_1/orainst.loc
Opatch version:11.2.0.3.19
OUI version:11.2.0.3.0
Log File Location:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-06-02_19-28-03pm_1.log

Verifying environment and performing prerequisite checks ...
Prerequisite Check "Checkactivefilesandexecutables" failed.
The details are:


Following executables is active:
/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1
Utilsession failed:prerequisite Check "Checkactivefilesandexecutables" failed.
Log File Location:/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-06-02_19-28-03pm_1.log

Opatch failed with error code 73

2018-06-02 19:28:08:patch/u01/software/20760997 apply failed for home/u01/app/oracle/product/11.2.0/db_1
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Check/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2018-06-02_19-28-03pm_1.log, Found that a Lib file for Oracle was occupied, causing failed
[June 2, 2018 7:28:08 PM] [INFO] Finish fuser command/sbin/fuser/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1 at Sat June 19:28:08 CST 2018
[June 2, 2018 7:28:08 PM] [INFO] Files in use by a process:/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1 PID (464) <<<<464 processes
[June 2, 2018 7:28:08 PM] [INFO] Following executables is active:
/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1
[June 2, 2018 7:28:08 PM] [INFO] Prerequisite Check "Checkactivefilesandexecutables" failed.
The details are:


Following executables is active:
/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1
[June 2, 2018 7:28:08 PM] [INFO] Start fuser Command/sbin/fuser/u01/app/oracle/product/11.2.0/db_1/bin/amdu at Sat June 19:28:08 CST 2018
[June 2, 2018 7:28:08 PM] [INFO] Finish fuser Command/sbin/fuser/u01/app/oracle/product/11.2.0/db_1/bin/amdu at Sat June 19:28:08 CST 2018
[June 2, 2018 7:28:08 PM] [INFO] Start fuser command/sbin/fuser/u01/app/oracle/product/11.2.0/db_1/bin/kfed at Sat June 19:28:08 CST 2018
[June 2, 2018 7:28:08 PM] [INFO] Finish fuser command/sbin/fuser/u01/app/oracle/product/11.2.0/db_1/bin/kfed at Sat June 19:28:08 CST 2018
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Check which processes are using the file libclntsh.so.11.1. There are two ggsci processes that occupy the file
[Email protected] ~]# Lsof|grep libclntsh.so.11.1
Ggsci 378 ggate mem REG 253,8 52693988 689586/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1 <<< <<<<<<<<<<
Ggsci 464 Oracle Mem REG 253,8 52693988 689586/u01/app/oracle/product/11.2.0/db_1/lib/libclntsh.so.11.1 <<< <<<<<<<<<<
Ohasd.bin 30906 grid mem REG 253,8 52735196 922358/u01/11.2.0/grid/lib/libclntsh.so.11.1
Oraagent. 32111 grid mem REG 253,8 52735196 922358/u01/11.2.0/grid/lib/libclntsh.so.11.1
Evmd.bin 32127 grid mem REG 253,8 52735196 922358/u01/11.2.0/grid/lib/libclntsh.so.11.1
Tnslsnr 32130 grid mem REG 253,8 52735196 922358/u01/11.2.0/grid/lib/libclntsh.so.11.1
Evmlogger 32175 grid mem REG 253,8 52735196 922358/u01/11.2.0/grid/lib/libclntsh.so.11.1
Cssdagent 32191 grid mem REG 253,8 52735196 922358/u01/11.2.0/grid/lib/libclntsh.so.11.1
Ocssd.bin 32215 grid mem REG 253,8 52735196 922358/u01/11.2.0/grid/lib/libclntsh.so.11.1
[Email protected] ~]# kill-9 464 378
Hit the db patch again. Application OK
6. Check for post-upgrade patches
[Email protected] opatch]$/opatch lspatches
20760997;database Patch Set update:11.2.0.3.15 (20760997)
17592127; Grid Infrastructure Patch Set update:11.2.0.3.9 (have components)

Opatch succeeded.
[Email protected] opatch]$

End of Patch

To avoid the effects of dblink, a single instance of the company's set of 11.2.0.3.5, upgraded to 11.2.0.3.15 process records