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

1. Download patches and the latest OPatch

GI PSU: p25869727_112040_Linux-x86-64.zip

OPatch: p6880880_112000_Linux-x86-64.zip

Description: GI PSU includes DB PSU,CPU. Stand-alone and RAC's opatch are common, stand-alone and rac's psu are not common.

two。 Check the current OPatch version of the database

The GI home and DB home of all RAC nodes need to be checked.

$$ORACLE_HOME/OPatch/opatch version

3. Update OPatch,RAC the GI home and DB home of all nodes need to be updated.

3.1 Update the OPatch of grid users

-- grid user actions

Node1- > echo $ORACLE_HOME

/ u01/app/11.2.0/grid

-- executed by root users. / u01/app/11.2.0/grid/ is the $ORACLE_HOME path under grid users.

[root@node1 tmp] # mv / u01/app/11.2.0/grid/OPatch / u01/app/11.2.0/grid/OPatch_bak

[root@node1 tmp] # ll p6880880_112000_Linux-x86-64.zip

-rw-r--r--. 1 grid oinstall 99065778 Aug 3 03:07 p6880880_112000_Linux-x86-64.zip

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

[root@node1 tmp] # chown-R grid:oinstall / u01/app/11.2.0/grid/OPatch

-- grid user actions

Node1- > $ORACLE_HOME/OPatch/opatch version

OPatch Version: 11.2.0.3.16

OPatch succeeded.

Note: you need to pay attention to the grid user $ORACLE_HOME permission.

3.2 Update the OPatch of oracle users

-- oracle user execution

Node1- > echo $ORACLE_HOME

/ u01/app/oracle/product/11.2.0/db_1

-- executed by root users. / u01/app/oracle/product/11.2.0/db_1 is the $ORACLE_HOME path under oracle users.

[root@node1 tmp] # mv / u01/app/oracle/product/11.2.0/db_1/OPatch / u01/app/oracle/product/11.2.0/db_1/OPatch_bak

[root@node1 tmp] # unzip p6880880_112000_Linux-x86-64.zip-d / u01/app/oracle/product/11.2.0/db_1/

[root@node1 tmp] # chown-R oracle:oinstall / u01/app/oracle/product/11.2.0/db_1/OPatch

-- oracle user actions

Node1- > $ORACLE_HOME/OPatch/opatch version

OPatch Version: 11.2.0.3.16

OPatch succeeded.

4. Extract the patch file (unzip the psu file for the grid,oracle of all nodes)

-- root user execution

[root@node1 tmp] # unzip p26030799_112040_Linux-x86-64.zip-d / tmp/grid_psu/

[root@node1 tmp] # chown-R grid:oinstall / tmp/grid_psu/

[root@node1 tmp] # unzip p26030799_112040_Linux-x86-64.zip-d / tmp/ora_psu/

[root@node1 tmp] # chown-R oracle:oinstall / tmp/ora_psu/

5. All nodes should check for conflicts between patches.

5.1 Node1 Node grid user check

Grid user execution result:

Node1- > cd 26030799 /

Node1- > $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail-ph. /

Oracle Interim Patch Installer version 11.2.0.3.16

Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home: / u01/app/11.2.0/grid

Central Inventory: / u01/app/oraInventory

From: / u01/app/11.2.0/grid/oraInst.loc

OPatch version: 11.2.0.3.16

OUI version: 11.2.0.4.0

Log file location: / u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch3017-08-03 / 03-53-17AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

5.2 Node1 node oracle user check

Oracle execution result:

Node1- > cd 26030799 /

Node1- > $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail-phBaseDir / tmp/grid_psu/26030799/-oh $ORACLE_HOME

Oracle Interim Patch Installer version 11.2.0.3.16

Copyright (c) 2017, Oracle Corporation. All rights reserved.

PREREQ session

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.16

OUI version: 11.2.0.4.0

Log file location: / u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch3017-08-03 05-39-28AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

6. Make a cold backup for the database (if security is not considered, this step can be omitted, which is a little risky)

RMAN > run {

Shutdown immediate

Startup mount

Allocate channel c1 type disk

Allocate channel c2 type disk

Backup full tag='db_full_bak' database format'/ home/oracle/rmanbak/full_cold_%d_%s.bak'

Alter database open

}

Use root users to back up oracle_home (back up the entire # ORACLE_HOME parent directory)

Tar-zcvpf db_20170802.tar.gz dbhome_1/

7. Stop the node1 database instance and node1 crs service

Root user login node 1

-- executed by root user, / u01/app/11.2.0/grid/ is the $ORACLE_HOME of grid user

[root@node1 bin] #. / srvctl stop instance-d devdb-I devdb1 (stop the database instance of node1)

[root@node1 bin] # / u01/app/11.2.0/grid/crs/install/rootcrs.pl-unlock

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

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'node1'

.

Successfully unlock / u01/app/11.2.0/grid

8. Update the patch manually

8.1 Node 1 grid user execution

Node1- > $ORACLE_HOME/OPatch/opatch napply-oh $ORACLE_HOME-local / tmp/grid_psu/26030799/

The output is slightly..

OPatch succeeded.

8.2 Node 1 oracle user execution

[oracle@jyracdb1 ~] $ORACLE_HOME/OPatch/opatch napply-oh $ORACLE_HOME-local / tmp/grid_psu/26030799/25869727/

The output is slightly..

OPatch succeeded.

8.3 execute rootadd_rdbms.sh, rootcrs.pl-patch

Su-root

[root@node1 26030799] # / u01/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh

[root@node1 26030799] # / u01/app/11.2.0/grid/crs/install/rootcrs.pl-patch

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

Installing Trace File Analyzer

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

Start the node1 database instance and the node1 crs service (in fact, the previous execution of rootcrs.pl-patch has already enabled the crs of node1)

[root@node1 bin] #. / srvctl start instance-d devdb-I devdb1

8.5 then repeat the Node 1 (stop Node 2 database and Node 2 CRS service, grid, oracle patch, rootadd_rdbms.sh, rootcrs.pl-patch) on Node 2

9. Upgrade dictionary operation (upgrade database dictionary, stop business. If you patch before DBCA, you do not need to upgrade the database dictionary, otherwise you need to upgrade the database dictionary)

Because RAC actually has only one database, any node can log in to the database and execute it once. Finally, restart the database.

9.1 shut down database instances and related processes (static monitoring, dynamic monitoring, EOM, related services)

-- stop the external process of the database

[root@11g ~] # ps-ef | grep-v grep | grep LOCAL=NO | awk'{print $2}'| xargs kill-9

[oracle@11g rmanbak] $cat / home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora

[root@node1 bin] #. / srvctl stop listener

[root@node1 bin] #. / srvctl status listener

[oracle@11g rmanbak] $ps-ef | grep ora_ | grep-v grep

[oracle@11g rmanbak] $netstat-an | grep 1521

[oracle@11g rmanbak] $netstat-an | grep 1158

[root@node1 bin] #. / srvctl stop database-d devdb

9.2 formally upgrade the database data dictionary

[root@node1 bin] #. / srvctl start database-d devdb

Node1- > sqlplus / as sysdba

SQL > @ $ORACLE_HOME/rdbms/admin/catbundle.sql psu apply

SQL > @ $ORACLE_HOME/rdbms/admin/utlrp.sql

[root@node1 bin] #. / srvctl stop database-d devdb

[root@node1 bin] #. / srvctl start database-d devdb

10. Verify the patch update result

Both the GI HOME and ORACLE HOME of each node perform verification.

-- grid user

Node1- > $ORACLE_HOME/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.16

Copyright (c) 2017, Oracle Corporation. All rights reserved.

Oracle Home: / u01/app/11.2.0/grid

Central Inventory: / u01/app/oraInventory

From: / u01/app/11.2.0/grid/oraInst.loc

OPatch version: 11.2.0.3.16

OUI version: 11.2.0.4.0

Log file location: / u01/app/11.2.0/grid/cfgtoollogs/opatch/opatch3017-08-03 / 07-27-26AM_1.log

Lsinventory Output file location: / u01/app/11.2.0/grid/cfgtoollogs/opatch/lsinv/lsinventory2017-08-03 / 07-27-26AM.txt

Local Machine Information::

Hostname: node1.localdomain

ARU platform id: 226

ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Grid Infrastructure 11g 11.2.0.4.0

There are 1 products installed in this Oracle Home.

Interim patches (3):

Patch 25920335: applied on Thu Aug 03 06:30:47 CST 2017

Unique Patch ID: 21279331

Patch description: "OCW Patch Set Update: 11.2.0.4.170718 (25920335)"

Created on 27 Jun 2017, 05:40:19 hrs PST8PDT

OPatch succeeded.

-- oracle user

Node1- > sqlplus / as sysdba

SQL >

Col ACTION_TIME for a30

Col COMMENTS for a20

Col BUNDLE_SERIES for a10

Select ACTION_TIME,BUNDLE_SERIES,COMMENTS from dba_registry_history

ACTION_TIME BUNDLE_SER COMMENTS

24-AUG-13 12.03.45.119862 PM PSU Patchset 11.2.0.2.0

24-FEB-17 05.51.27.427073 AM PSU Patchset 11.2.0.2.0

03-AUG-17 07.16.37.247390 AM PSU PSU 11.2.0.4.170718

-- View invalid objects

Select count (*) from dba_objects where status'VALID'

COUNT (*)

-

0

11. Start monitoring and provide services to check whether the monitoring is normal.

[root@node1 bin] #. / srvctl start listener

[root@node1 bin] #. / srvctl status listener

Add: update the latest patch p26610246_112040_Linux-x86-64.zip cluster patch, db patch is 26609445

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.