Friday, 7 June 2019

opatchauto apply -analyze Check error



opatchauto apply -analyze

Grid version 12.1.0.2.0

  • Here we are having two example one who got succeed and another show error for anlyzing patch..


Grid Patch number : p28980120_121020_Linux-x86-64.zip

Always use analyze before applying grid patch


  • srv1:/u01/24412235 # opatchauto apply -analyze

OPatchauto session is initiated at Wed Apr  7 13:21:45 2021

System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2021-04-07_01-21-53PM.log.

Session log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2021-04-07_01-22-36PM.log
The id for this session is 9TIB

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/dbhome_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

Patch applicability verified successfully on home /u01/app/12.1.0/grid


Verifying SQL patch applicability on home /u01/app/oracle/product/12.1.0/dbhome_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Analysis for applying patches has completed successfully:

Host:srv1
RAC Home:/u01/app/oracle/product/12.1.0/dbhome_1
Version:12.1.0.2.0


==Following patches were SKIPPED:

Patch: /u01/24412235/21436941
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /u01/24412235/24007012
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /u01/24412235/23854735
Log: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-23-07PM_1.log

Patch: /u01/24412235/24006101
Log: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-23-07PM_1.log


Host:srv1
CRS Home:/u01/app/12.1.0/grid
Version:12.1.0.2.0


==Following patches were SUCCESSFULLY analyzed to be applied:

Patch: /u01/24412235/21436941
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-23-04PM_1.log

Patch: /u01/24412235/23854735
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-23-04PM_1.log

Patch: /u01/24412235/24006101
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-23-04PM_1.log

Patch: /u01/24412235/24007012
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-23-04PM_1.log



OPatchauto session completed at Wed Apr  7 13:24:05 2021
Time taken to complete the session 2 minutes, 21 seconds
srv1:/u01/24412235 #


srv1:/u01/24412235 # opatchauto apply

OPatchauto session is initiated at Wed Apr  7 13:55:27 2021

System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2021-04-07_01-55-31PM.log.

Session log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2021-04-07_01-56-01PM.log
The id for this session is U9F8

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/dbhome_1
Patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

Patch applicability verified successfully on home /u01/app/12.1.0/grid


Verifying SQL patch applicability on home /u01/app/oracle/product/12.1.0/dbhome_1
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/dbhome_1


Preparing to bring down database service on home /u01/app/oracle/product/12.1.0/dbhome_1
Successfully prepared home /u01/app/oracle/product/12.1.0/dbhome_1 to bring down database service


Bringing down CRS service on home /u01/app/12.1.0/grid

Prepatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_srv1_2021-04-07_01-57-26PM.log
CRS service brought down successfully on home /u01/app/12.1.0/grid


Performing prepatch operation on home /u01/app/oracle/product/12.1.0/dbhome_1
Perpatch operation completed successfully on home /u01/app/oracle/product/12.1.0/dbhome_1


Start applying binary patch on home /u01/app/oracle/product/12.1.0/dbhome_1
Binary patch applied successfully on home /u01/app/oracle/product/12.1.0/dbhome_1


Performing postpatch operation on home /u01/app/oracle/product/12.1.0/dbhome_1
Postpatch operation completed successfully on home /u01/app/oracle/product/12.1.0/dbhome_1


Start applying binary patch on home /u01/app/12.1.0/grid


Binary patch applied successfully on home /u01/app/12.1.0/grid


Starting CRS service on home /u01/app/12.1.0/grid



Postpatch operation log file location: /u01/app/12.1.0/grid/cfgtoollogs/crsconfig/crspatch_srv1_2021-04-07_02-15-49PM.log
CRS service started successfully on home /u01/app/12.1.0/grid


Preparing home /u01/app/oracle/product/12.1.0/dbhome_1 after database service restarted
No step execution required.........


Trying to apply SQL patch on home /u01/app/oracle/product/12.1.0/dbhome_1

SQL patch applied successfully on home /u01/app/oracle/product/12.1.0/dbhome_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:srv1
RAC Home:/u01/app/oracle/product/12.1.0/dbhome_1
Version:12.1.0.2.0
Summary:

==Following patches were SKIPPED:

Patch: /u01/24412235/21436941
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /u01/24412235/24007012
Reason: This patch is not applicable to this specified target type - "rac_database"


==Following patches were SUCCESSFULLY applied:

Patch: /u01/24412235/23854735
Log: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-59-52PM_1.log

Patch: /u01/24412235/24006101
Log: /u01/app/oracle/product/12.1.0/dbhome_1/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_13-59-52PM_1.log


Host:srv1
CRS Home:/u01/app/12.1.0/grid
Version:12.1.0.2.0
Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /u01/24412235/21436941
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_14-03-48PM_1.log

Patch: /u01/24412235/23854735
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_14-03-48PM_1.log

Patch: /u01/24412235/24006101
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_14-03-48PM_1.log

Patch: /u01/24412235/24007012
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2021-04-07_14-03-48PM_1.log



OPatchauto session completed at Wed Apr  7 14:30:48 2021
Time taken to complete the session 35 minutes, 20 seconds
srv1:/u01/24412235 #


#############################################################################

  • Failed Example of opatchauto analyze
[grid@srv1 28813884]$ opatchauto apply -analyze

OPatchauto session is initiated at Thu Jun  6 20:09:05 2019
OPATCHAUTO-72046: Wallet option is not provided.
OPATCHAUTO-72046: Wallet option is required during patching as non-root user.
OPATCHAUTO-72046: Please provide a wallet option or execute as root user.

OPatchauto session completed at Thu Jun  6 20:09:12 2019
Time taken to complete the session 0 minute, 7 seconds

opatchauto bootstrapping failed with error code 255.
[grid@srv1 28813884]$ pwd
/u01/28980120/28813884
[grid@srv1 28813884]$ su root
Password:
[root@srv1 28813884]# export PATH=$PATH:/u01/app/12.1.0/grid/OPatch/
[root@srv1 28813884]# . oraenv
ORACLE_SID = [+ASM1] ?
The Oracle base remains unchanged with value /u01/app/grid

[root@srv1 28813884]# opatchauto apply -analyze

OPatchauto session is initiated at Thu Jun  6 20:09:54 2019

System initialization log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchautodb/systemconfig2019-06-06_08-10-01PM.log.

Session log file is /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/opatchauto2019-06-06_08-10-52PM.log
The id for this session is BZBD

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.1.0/grid

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.1.0/dbhome_2
Patch applicability verified successfully on home /u01/app/12.1.0/grid

Patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/dbhome_2


Verifying SQL patch applicability on home /u01/app/oracle/product/12.1.0/dbhome_2
SQL patch applicability verified successfully on home /u01/app/oracle/product/12.1.0/dbhome_2

OPatchAuto successful.

--------------------------------Summary--------------------------------

Analysis for applying patches has failed:

Host:srv1
CRS Home:/u01/app/12.1.0/grid
Version:12.1.0.2.0
Analysis for patches has failed.


==Following patches FAILED in analysis for apply:

Patch: /u01/28980120/28813884/26983807
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-06-06_20-11-18PM_1.log
Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Required amount of space(13991.83MB) is not available.]


Patch: /u01/28980120/28813884/28729169
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-06-06_20-11-18PM_1.log
Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Required amount of space(13991.83MB) is not available.]


Patch: /u01/28980120/28813884/28729213
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-06-06_20-11-18PM_1.log
Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Required amount of space(13991.83MB) is not available.]


Patch: /u01/28980120/28813884/28729220
Log: /u01/app/12.1.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2019-06-06_20-11-18PM_1.log
Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Required amount of space(13991.83MB) is not available.]



Host:srv1
RAC Home:/u01/app/oracle/product/12.1.0/dbhome_2
Version:12.1.0.2.0
Analysis for patches has failed.


==Following patches FAILED in analysis for apply:

Patch: /u01/28980120/28813884/28729169
Log: /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatchauto/core/opatch/opatch2019-06-06_20-11-25PM_1.log
Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Required amount of space(3556.51MB) is not available.]


Patch: /u01/28980120/28813884/28729213
Log: /u01/app/oracle/product/12.1.0/dbhome_2/cfgtoollogs/opatchauto/core/opatch/opatch2019-06-06_20-11-25PM_1.log
Reason: Failed during Analysis: CheckSystemSpace Failed, [ Prerequisite Status: FAILED, Prerequisite output:
The details are:
Required amount of space(3556.51MB) is not available.]



==Following patches were SKIPPED:

Patch: /u01/28980120/28813884/26983807
Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /u01/28980120/28813884/28729220
Reason: This patch is not applicable to this specified target type - "rac_database"


OPATCHAUTO-72053: Analysis for the patches failed.
OPATCHAUTO-72053: Command execution failed.
OPATCHAUTO-72053: Please check the summary for more details.

OPatchauto session completed at Thu Jun  6 20:13:04 2019
Time taken to complete the session 3 minutes, 10 seconds
[root@srv1 28813884]#

No comments:

Post a Comment