Shulou(Shulou.com)06/01 Report--

11.2.0.4 patching the rac database:

Environment description:

[oracle@dbrac1 ~] $cat / etc/issue

Red Hat Enterprise Linux Server release 6.7 (Santiago)

Kernel\ r on an\ m

[oracle@dbrac1 ~] $cat / etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

:: 1 localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.56.2 dbrac1

192.168.56.3 dbrac1-vip

10.10.10.10 dbrac1-priv

192.168.56.4 dbrac2

192.168.56.5 dbrac2-vip

10.10.10.11 dbrac2-priv

192.168.56.8 rac-scan

[oracle@dbrac1 ~] $

The patch to be made is: p27107360_112040_Linux-x86-64.zipDiopatch Toolkit: p6880880_112000_Linux-x86-64.zip

Nodes one and two put the above two packets under / tmp, and grant permission to chmod 777 * .zip

[root@dbrac1 tmp] # ll * .zip

-rwxrwxrwx 1 root root 779304336 Apr 2 17:12 p27107360_112040_Linux-x86-64.zip

-rwxrwxrwx 1 root root 52733900 Mar 14 2016 p6880880_112000_Linux-x86-64.zip

[root@dbrac1 tmp] #

One: upgrade OPatch

Download the latest opatch program and replace the OPatch directory under GI_HOME and ORACLE_HOME

Note: both grid and oracle of rac1 and rac2 nodes need to be upgraded to OPatch version

[grid@dbrac1 ~] $opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

[grid@dbrac1 ~] $

[oracle@dbrac1 ~] $opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

[oracle@dbrac1 ~] $

Oracle user replacement, backup the previous OPatch directory:

[oracle@dbrac1 ~] $cd $ORACLE_HOME

[oracle@dbrac1 dbhome_1] $

[oracle@dbrac1 dbhome_1] $mv OPatch/ OPatch.bak

-- decompression:

[oracle@dbrac1 tmp] $unzip p6880880_112000_Linux-x86-64.zip-d $ORACLE_HOME

Archive: p6880880_112000_Linux-x86-64.zip

Creating: / oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/

Inflating: / oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/opatchdiag

Inflating: / oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch.pl

Creating: / oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/jlib/

Ignore.

[oracle@dbrac1 dbhome_1] $opatch version

OPatch Version: 11.2.0.3.12

OPatch succeeded.

[oracle@dbrac1 dbhome_1] $

Grid user replacement, backup the previous OPatch directory:

[grid@dbrac1 ~] $env | grep ORACLE_HOME

ORACLE_HOME=/oracle/app/11.2.0/grid

[grid@dbrac1 ~] $exit

Logout

[root@dbrac1 tmp] #

[root@dbrac1 tmp] # cd / oracle/app/11.2.0/grid

[root@dbrac1 grid] #

[root@dbrac1 grid] # mv OPatch/ OPatch.bak

[root@dbrac1 grid] #

[root@dbrac1 tmp] # cd / tmp

[root@dbrac1 tmp] # ll * .zip

-rwxrwxrwx 1 root root 779304336 Apr 2 17:12 p27107360_112040_Linux-x86-64.zip

-rwxrwxrwx 1 root root 52733900 Mar 14 2016 p6880880_112000_Linux-x86-64.zip

[root@dbrac1 tmp] # unzip p6880880_112000_Linux-x86-64.zip-d / oracle/app/11.2.0/grid

Archive: p6880880_112000_Linux-x86-64.zip

Creating: / oracle/app/11.2.0/grid/OPatch/

Inflating: / oracle/app/11.2.0/grid/OPatch/opatchdiag

Inflating: / oracle/app/11.2.0/grid/OPatch/opatch.pl

Creating: / oracle/app/11.2.0/grid/OPatch/jlib/

Omit.

[root@dbrac1 grid] #

[root@dbrac1 grid] # chown-R grid:oinstall OPatch/

[root@dbrac1 grid] #

[root@dbrac1 grid] # su-grid

[grid@dbrac1 ~] $opatch version

OPatch Version: 11.2.0.3.12

OPatch succeeded.

[grid@dbrac1 ~] $

-- Node 2 has the same operation:

[root@dbrac2 tmp] # ll * .zip

-rwxrwxrwx 1 root root 779304336 May 15 09:45 p27107360_112040_Linux-x86-64.zip

-rwxrwxrwx 1 root root 52733900 May 15 09:45 p6880880_112000_Linux-x86-64.zip

[root@dbrac2 tmp] # su-oracle

[oracle@dbrac2 ~] $

[oracle@dbrac2 ~] $cd $ORACLE_HOME

[oracle@dbrac2 dbhome_1] $mv OPatch/ OPatch.bak

[oracle@dbrac2 dbhome_1] $

[oracle@dbrac2 dbhome_1] $unzip / tmp/p6880880_112000_Linux-x86-64.zip

Omit; omit.

[oracle@dbrac2 dbhome_1] $

[oracle@dbrac2 dbhome_1] $opatch version

OPatch Version: 11.2.0.3.12

OPatch succeeded.

[oracle@dbrac2 dbhome_1] $

[root@dbrac2 ~] # su-grid

[grid@dbrac2 ~] $env | grep ORACLE_HOME

ORACLE_HOME=/oracle/app/11.2.0/grid

[grid@dbrac2 ~] $

[grid@dbrac2 ~] $exit

Logout

[root@dbrac2 ~] # cd / tmp

[root@dbrac2 tmp] # cd / oracle/app/11.2.0/grid

[root@dbrac2 grid] # mv OPatch/ OPatch.bak

[root@dbrac2 grid] #

[root@dbrac2 grid] # unzip / tmp/p6880880_112000_Linux-x86-64.zip-d / oracle/app/11.2.0/grid

Omit; omit.

[root@dbrac2 grid] #

[root@dbrac2 grid] # chown grid:oinstall-R OPatch/

[root@dbrac2 grid] # su-grid

[grid@dbrac2 ~] $

[grid@dbrac2 ~] $opatch version

OPatch Version: 11.2.0.3.12

OPatch succeeded.

[grid@dbrac2 ~] $

Second: generate ocm files

Generate ocm.rsp files in rac1 and rac2 respectively.

Su-oracle

$ORACLE_HOME/OPatch/ocm/bin/emocmrsp-no_banner-output / home/oracle/ocm.rsp

[oracle@dbrac1 ~] $env | grep ORACLE_HOME

ORACLE_HOME=/oracle/app/oracle/product/11.2.0/dbhome_1

[oracle@dbrac1 ~] $

[oracle@dbrac1 ~] $ORACLE_HOME/OPatch/ocm/bin/emocmrsp-no_banner-output / home/oracle/ocm.rsp

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

The OCM configuration response file (/ home/oracle/ocm.rsp) was successfully created.

[oracle@dbrac1 ~] $

[oracle@dbrac2 ~] $ORACLE_HOME/OPatch/ocm/bin/emocmrsp-no_banner-output / home/oracle/ocm.rsp

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

The OCM configuration response file (/ home/oracle/ocm.rsp) was successfully created.

[oracle@dbrac2 ~] $ll

Total 4

-rw-r--r-- 1 oracle oinstall 623 May 15 20:15 ocm.rsp

[oracle@dbrac2 ~] $

Three: install patches for GRID_HOME

Note: although the opatch auto command must be executed with the root user, the relevant checks need to be performed through the root user su to the grid and oracle users.

-- back up the inventory_loc directory and the software directory of gird and oracle users, namely the home directory, before execution:

[root@dbrac1 tmp] # cat / etc/oraInst.loc

Inventory_loc=/oracle/app/oraInventory

Inst_group=oinstall

[root@dbrac1 tmp] #

[root@dbrac1 tmp] # cat / etc/oratab

+ ASM1:/oracle/app/11.2.0/grid:N # line added by Agent

Dbrac:/oracle/app/oracle/product/11.2.0/dbhome_1:N # line added by Agent

[root@dbrac1 tmp] #

-- then check the status before patching:

[grid@dbrac1] $crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.DATA.dg

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Ora.FRA.dg

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Ora.LISTENER.lsnr

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Ora.LISTENER_WANG.lsnr

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Ora.OCRVOTE.dg

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Ora.asm

ONLINE ONLINE dbrac1 Started

ONLINE ONLINE dbrac2 Started

Ora.gsd

OFFLINE OFFLINE dbrac1

OFFLINE OFFLINE dbrac2

Ora.net1.network

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Ora.ons

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Ora.registry.acfs

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE dbrac2

Ora.cvu

1 ONLINE ONLINE dbrac2

Ora.dbrac.abcde.svc

1 ONLINE ONLINE dbrac2

Ora.dbrac.db

1 ONLINE ONLINE dbrac2 Open

2 ONLINE ONLINE dbrac1 Open

Ora.dbrac.dmmservice.svc

1 ONLINE ONLINE dbrac2

Ora.dbrac1.vip

1 ONLINE ONLINE dbrac1

Ora.dbrac2.vip

1 ONLINE ONLINE dbrac2

Ora.oc4j

1 ONLINE ONLINE dbrac2

Ora.scan1.vip

1 ONLINE ONLINE dbrac2

[grid@dbrac1 ~] $

-- officially patch, first hit the node GI _ HOME

[grid@dbrac1 ~] $env | grep ORACLE_HOME

ORACLE_HOME=/oracle/app/11.2.0/grid

[grid@dbrac1 tmp] $which opatch

/ oracle/app/11.2.0/grid/OPatch/opatch

[grid@dbrac1 tmp] $

[grid@dbrac1 tmp] $exit

Logout

[root@dbrac1 grid] #

[root@dbrac1 grid] # cd / tmp

[root@dbrac1 tmp] # unzip p27107360_112040_Linux-x86-64.zip

Omit.

[root@dbrac1 tmp] # chown oracle:oinstall-R 27107360 /

[root@dbrac1 tmp] # ll

Total 812916

Drwxr-xr-x 5 oracle oinstall 4096 Dec 6 16:59 27107360

-rwxrwxrwx 1 root root 779304336 Apr 2 17:12 p27107360_112040_Linux-x86-64.zip

-rwxrwxrwx 1 root root 52733900 Mar 14 2016 p6880880_112000_Linux-x86-64.zip

[root@dbrac1 tmp] #

-- Patch under grid:

/ oracle/app/11.2.0/grid/OPatch/opatch auto / tmp/27107360/-oh / oracle/app/11.2.0/grid-ocmrf / home/oracle/ocm.rsp

[root@dbrac1 tmp] # / oracle/app/11.2.0/grid/OPatch/opatch auto / tmp/27107360/-oh / oracle/app/11.2.0/grid-ocmrf / home/oracle/ocm.rsp

Executing / oracle/app/11.2.0/grid/perl/bin/perl / oracle/app/11.2.0/grid/OPatch/crs/patch21203.pl-patchdir / tmp-patchn 27107360-oh / oracle/app/11.2.0/grid-ocmrf / home/oracle/ocm.rsp-paramfile / oracle/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: / oracle/app/11.2.0/grid/cfgtoollogs/opatchauto2018-05-15017-26-36.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/ oracle/app/11.2.0/grid/cfgtoollogs/opatchauto2018-05-15 October 17-26-36.report.log

2018-05-15 17:26:36: Starting Clusterware Patch Setup

Using configuration parameter file: / oracle/app/11.2.0/grid/crs/install/crsconfig_params

Stopping CRS...

Stopped CRS successfully

Patch / tmp/27107360/26925576 apply successful for home / oracle/app/11.2.0/grid

Patch / tmp/27107360/26609929 apply successful for home / oracle/app/11.2.0/grid

Patch / tmp/27107360/22502505 apply successful for home / oracle/app/11.2.0/grid

Starting CRS...

Installing Trace File Analyzer

CRS-4123: Oracle High Availability Services has been started.

Opatch auto succeeded.

[root@dbrac1 tmp] #

-- query the cluster status on node 2 during patching: stop the db and crs of node 1 when patching

[grid@dbrac2] $crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.DATA.dg

ONLINE ONLINE dbrac2

Ora.FRA.dg

ONLINE ONLINE dbrac2

Ora.LISTENER.lsnr

ONLINE ONLINE dbrac2

Ora.LISTENER_WANG.lsnr

ONLINE ONLINE dbrac2

Ora.OCRVOTE.dg

ONLINE ONLINE dbrac2

Ora.asm

ONLINE ONLINE dbrac2 Started

Ora.gsd

OFFLINE OFFLINE dbrac2

Ora.net1.network

ONLINE ONLINE dbrac2

Ora.ons

ONLINE ONLINE dbrac2

Ora.registry.acfs

ONLINE ONLINE dbrac2

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE dbrac2

Ora.cvu

1 ONLINE ONLINE dbrac2

Ora.dbrac.abcde.svc

1 ONLINE ONLINE dbrac2

Ora.dbrac.db

1 ONLINE ONLINE dbrac2 Open

2 ONLINE OFFLINE Instance Shutdown

Ora.dbrac.dmmservice.svc

1 ONLINE ONLINE dbrac2

Ora.dbrac1.vip

1 ONLINE INTERMEDIATE dbrac2 FAILED OVER

Ora.dbrac2.vip

1 ONLINE ONLINE dbrac2

Ora.oc4j

1 ONLINE ONLINE dbrac2

Ora.scan1.vip

1 ONLINE ONLINE dbrac2

[grid@dbrac2 ~] $

-- check

[root@dbrac1 tmp] # su-grid

[grid@dbrac1 ~] $

[grid@dbrac1 ~] $

[grid@dbrac1 ~] $opatch lspatches

22502505ACFs Patch Set Update: 11.2.0.4.160419 (22502505)

26609929 th OCW Patch Set Update: 11.2.0.4.170814 (26609929)

Database Patch Set Update: 11.2.0.4.180116 (26925576)

OPatch succeeded.

[grid@dbrac1 ~] $

Three: install patches for ORACLE_HOME

-- patch the ORACLE_HOME of the oracle user on node 1:

[oracle@dbrac1 ~] $env | grep HOME

HOME=/home/oracle

ORACLE_HOME=/oracle/app/oracle/product/11.2.0/dbhome_1

[oracle@dbrac1 ~] $

[oracle@dbrac1 ~] $exit

Logout

[root@dbrac1 soft] #

-- perform actions:

/ oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch auto / tmp/27107360/-oh / oracle/app/oracle/product/11.2.0/dbhome_1-ocmrf / home/oracle/ocm.rsp

[root@dbrac1 soft] # / oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch auto / tmp/27107360/-oh / oracle/app/oracle/product/11.2.0/dbhome_1-ocmrf / home/oracle/ocm.rsp

Executing / oracle/app/11.2.0/grid/perl/bin/perl / oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/patch21203.pl-patchdir / tmp-patchn 27107360-oh / oracle/app/oracle/product/11.2.0/dbhome_1-ocmrf / home/oracle/ocm.rsp-paramfile / oracle/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: / oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatchauto2018-05-150017-56-39.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/ oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatchauto2018-05-15 October 17-56-39.report.log

2018-05-15 17:56:39: Starting Clusterware Patch Setup

Using configuration parameter file: / oracle/app/11.2.0/grid/crs/install/crsconfig_params

Stopping RAC / oracle/app/oracle/product/11.2.0/dbhome_1...

Stopped RAC / oracle/app/oracle/product/11.2.0/dbhome_1 successfully

Patch / tmp/27107360/26925576 apply successful for home / oracle/app/oracle/product/11.2.0/dbhome_1

Patch / tmp/27107360/26609929/custom/server/26609929 apply successful for home / oracle/app/oracle/product/11.2.0/dbhome_1

Starting RAC / oracle/app/oracle/product/11.2.0/dbhome_1...

Started RAC / oracle/app/oracle/product/11.2.0/dbhome_1 successfully

Opatch auto succeeded.

[root@dbrac1 soft] #

[grid@dbrac2] $crsctl stat res-t

NAME TARGET STATE SERVER STATE_DETAILS

Local Resources

Ora.DATA.dg

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Ora.FRA.dg

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Ora.LISTENER.lsnr

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Ora.LISTENER_WANG.lsnr

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Ora.OCRVOTE.dg

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Ora.asm

ONLINE ONLINE dbrac1 Started

ONLINE ONLINE dbrac2 Started

Ora.gsd

OFFLINE OFFLINE dbrac1

OFFLINE OFFLINE dbrac2

Ora.net1.network

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Ora.ons

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Ora.registry.acfs

ONLINE ONLINE dbrac1

ONLINE ONLINE dbrac2

Cluster Resources

Ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE dbrac2

Ora.cvu

1 ONLINE ONLINE dbrac2

Ora.dbrac.abcde.svc

1 ONLINE ONLINE dbrac2

Ora.dbrac.db

1 ONLINE ONLINE dbrac2 Open

2 OFFLINE OFFLINE Instance Shutdown

Ora.dbrac.dmmservice.svc

1 ONLINE ONLINE dbrac2

Ora.dbrac1.vip

1 ONLINE ONLINE dbrac1

Ora.dbrac2.vip

1 ONLINE ONLINE dbrac2

Ora.oc4j

1 ONLINE ONLINE dbrac2

Ora.scan1.vip

1 ONLINE ONLINE dbrac2

[grid@dbrac2 ~] $

-- check:

[root@dbrac1 soft] # su-oracle

[oracle@dbrac1 ~] $opatch lspatches

26609929 th OCW Patch Set Update: 11.2.0.4.170814 (26609929)

Database Patch Set Update: 11.2.0.4.180116 (26925576)

OPatch succeeded.

[oracle@dbrac1 ~] $

Four: patch the GI_HOME and ORACLE_HOME of node 2 respectively, the steps are the same as the second and third steps

[root@dbrac2 tmp] # ll

Drwxr-xr-x 5 oracle oinstall 4096 Dec 6 16:59 27107360

-rwxrwxrwx 1 root root 779304336 May 15 09:45 p27107360_112040_Linux-x86-64.zip

-rwxrwxrwx 1 root root 52733900 May 15 09:45 p6880880_112000_Linux-x86-64.zip

[root@dbrac2 tmp] #

[root@dbrac2 tmp] #

Patch GI_HOME:

Report an error with the corresponding ocm.rsp file generated by ORACLE user: Argument (s) Error... Given 'ocmrf' file does not exists. Please check the arguments and try again. OPatch failed with error code 135

-- then use the grid user to generate the ocm.rsp response file, as follows:

[grid@dbrac2 ~] $/ oracle/app/11.2.0/grid/OPatch/ocm/bin/emocmrsp

OCM Installation Response Generator 10.3.7.0.0-Production

Copyright (c) 2005, 2012, Oracle and/or its affiliates. All rights reserved.

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

The OCM configuration response file (ocm.rsp) was successfully created.

[grid@dbrac2 ~] $ll

Total 8

-rw-r--r-- 1 grid oinstall 621 May 15 23:02 ocm.rsp

[grid@dbrac2 ~] $

[grid@dbrac2 ~] $

-- patching:

/ oracle/app/11.2.0/grid/OPatch/opatch auto / tmp/27107360/-oh / oracle/app/11.2.0/grid-ocmrf / home/grid/ocm.rsp

[root@dbrac2] # / oracle/app/11.2.0/grid/OPatch/opatch auto / tmp/27107360/-oh / oracle/app/11.2.0/grid-ocmrf / home/grid/ocm.rsp

Executing / oracle/app/11.2.0/grid/perl/bin/perl / oracle/app/11.2.0/grid/OPatch/crs/patch21203.pl-patchdir / tmp-patchn 27107360-oh / oracle/app/11.2.0/grid-ocmrf / home/grid/ocm.rsp-paramfile / oracle/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: / oracle/app/11.2.0/grid/cfgtoollogs/opatchauto2018-05-15 23-04-01.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/ oracle/app/11.2.0/grid/cfgtoollogs/opatchauto2018-05-15 October 23-04-01.report.log

2018-05-15 23:04:01: Starting Clusterware Patch Setup

Using configuration parameter file: / oracle/app/11.2.0/grid/crs/install/crsconfig_params

Stopping CRS...

Stopped CRS successfully

Patch / tmp/27107360/26925576 apply successful for home / oracle/app/11.2.0/grid

Patch / tmp/27107360/26609929 apply successful for home / oracle/app/11.2.0/grid

Patch / tmp/27107360/22502505 apply successful for home / oracle/app/11.2.0/grid

Starting CRS...

Installing Trace File Analyzer

CRS-4123: Oracle High Availability Services has been started.

Opatch auto succeeded.

[root@dbrac2 ~] #

-- check:

[root@dbrac2 ~] # su-grid

[grid@dbrac2 ~] $opatch lspatches

22502505ACFs Patch Set Update: 11.2.0.4.160419 (22502505)

26609929 th OCW Patch Set Update: 11.2.0.4.170814 (26609929)

Database Patch Set Update: 11.2.0.4.180116 (26925576)

OPatch succeeded.

[grid@dbrac2 ~] $

Patch ORACLE_HOME

/ oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch auto / tmp/27107360-oh / oracle/app/oracle/product/11.2.0/dbhome_1-ocmrf / home/oracle/ocm.rsp

[root@dbrac2 27107360] # / oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch auto / tmp/27107360-oh / oracle/app/oracle/product/11.2.0/dbhome_1-ocmrf / home/oracle/ocm.rsp

Executing / oracle/app/11.2.0/grid/perl/bin/perl / oracle/app/oracle/product/11.2.0/dbhome_1/OPatch/crs/patch21203.pl-patchdir / tmp-patchn 27107360-oh / oracle/app/oracle/product/11.2.0/dbhome_1-ocmrf / home/oracle/ocm.rsp-paramfile / oracle/app/11.2.0/grid/crs/install/crsconfig_params

This is the main log file: / oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatchauto2018-05-15-22-15-50.log

This file will show your detected configuration and all the steps that opatchauto attempted to do on your system:

/ oracle/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatchauto2018-05-15-22-15-50.report.log

2018-05-15 22:15:50: Starting Clusterware Patch Setup

Using configuration parameter file: / oracle/app/11.2.0/grid/crs/install/crsconfig_params

Stopping RAC / oracle/app/oracle/product/11.2.0/dbhome_1...

Stopped RAC / oracle/app/oracle/product/11.2.0/dbhome_1 successfully

Patch / tmp/27107360/26925576 apply successful for home / oracle/app/oracle/product/11.2.0/dbhome_1

Patch / tmp/27107360/26609929/custom/server/26609929 apply successful for home / oracle/app/oracle/product/11.2.0/dbhome_1

Starting RAC / oracle/app/oracle/product/11.2.0/dbhome_1...

Started RAC / oracle/app/oracle/product/11.2.0/dbhome_1 successfully

Opatch auto succeeded.

[root@dbrac2 27107360] #

-- check:

[root@dbrac2 27107360] # su-oracle

[oracle@dbrac2 ~] $opatch lspatches

26609929 th OCW Patch Set Update: 11.2.0.4.170814 (26609929)

Database Patch Set Update: 11.2.0.4.180116 (26925576)

OPatch succeeded.

[oracle@dbrac2 ~] $

Five: update dba_registry_history view information

-- execute the script @? / rdbms/admin/catbundle.sql psu apply, running on only one node

-- check before running the script:

SQL > select * from dba_registry_history

ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SER COMMENTS

24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0

16-OCT-17 10.12.28.771351 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0

07-MAR-18 06.07.41.694205 AM APPLY SERVER 11.2.0.4 161018 PSU PSU 11.2.0.4.161018

30-MAR-18 03.39.07.129649 PM APPLY SERVER 11.2.0.4 170718 PSU PSU 11.2.0.4.170718

SQL >

-- run script @? / rdbms/admin/catbundle.sql psu apply

SQL > @? / rdbms/admin/prvtblin.plb

SQL > CREATE OR REPLACE PACKAGE BODY dbms_logrep_exp wrapped

2 a000000

3 1

4 abcd

5 abcd

6 abcd

7 abcd

8 abcd

Omit.

SQL > SPOOL off

SQL > SET echo off

Check the following log file for errors:

/ oracle/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_DBRAC_APPLY_2018May15_23_32_19.log

SQL >

-- query again:

SQL > select * from dba_registry_history

ACTION_TIME ACTION NAMESPACE VERSION ID BUNDLE_SER COMMENTS

24-AUG-13 12.03.45.119862 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0

16-OCT-17 10.12.28.771351 PM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0

07-MAR-18 06.07.41.694205 AM APPLY SERVER 11.2.0.4 161018 PSU PSU 11.2.0.4.161018

30-MAR-18 03.39.07.129649 PM APPLY SERVER 11.2.0.4 170718 PSU PSU 11.2.0.4.170718

15-MAY-18 11.32.57.424765 PM APPLY SERVER 11.2.0.4 180116 PSU PSU 11.2.0.4.180116

SQL >

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.