Oracle 11g RAC manual gi psu patch (11.2.0.4.8)

Oracle 11g RAC manual gi psu patch (11.2.0.4.8)
I. Preparations 1. database environment

Operating system version: RedHat 6.5x64
Database Version: Oracle 11.2.0.4 x64 RAC
Grid: 11.2.0.4
Oracle database: 11.2.0.4

2. Prepare the content

Gi psu: p21523375_112040_Linux-x86-64.zip
OPatch: p6880880_112000_Linux-x86-64.zip
Db psu: The p21352635_112040_Linux-x86-64.zip is used only for a single instance.

OPatch:
Https://updates.oracle.com/download/6880880.html

Note: gi psu includes db psu and CPU.

2. Update the OPatch version.

Note: The OPatch version is updated on the two nodes respectively.

1. Update OPatch to 11.2.0.3.11. You can simply compress and replace OPatch.

(1) Upload p6880880_112000_linux-x86-64.zip to the/u01/software directory, and grant the/u01/software 777 permission. You can also use the/tmp directory.
(2) Rename the original OPatch directory under the root user.

Mv/u01/app/11.2.0/grid/OPatch/u01/app/11.2.0/grid/OPatchbk
Mv/u01/app/oracle/product/11.2.0/db_1/OPatch/u01/app/oracle/product/11.2.0/db_1/OPatchBK

2. Replace OPatch in the grid directory

(1) root User
Cd/u01/software/; chown grid: oinstall p6880880_112000_Linux-x86-64.zip

(2) grid user

Su-grid
Cd/u01/software/
Unzip p6880880_112000_Linux-x86-64.zip

(3) root User

Cd/u01/software/
Mv OPatch/u01/app/11.2.0/grid/

(4) grid user test

Su-grid
/U01/app/11.2.0/grid/OPatch/opatch version

OPatch Version: 11.2.0.3.11
OPatch succeeded.

3. Replace the oracle directory OPatch

(1) root User

Cd/u01/software/; chown oracle: oinstall p6880880_112000_Linux-x86-64.zip

(2) oracle users

Su-oracle
Cd/u01/software/
Unzip p6880880_112000_Linux-x86-64.zip

(3) root User

Cd/u01/software/
Mv OPatch/u01/app/oracle/product/11.2.0/db_1/

(4) oracle user test

Su-oracle

/U01/app/oracle/product/11.2.0/db_1/OPatch/opatch version

OPatch Version: 11.2.0.3.11
OPatch succeeded.

 

Iii. Start to upgrade gi psu Software Package 1. Prerequisites

(1) To create a grid as the root user, disable the grid (both nodes are executed)

Cd/u01/app/11.2.0/grid/bin
./Crsctl stop has

2. Solve the gi psu patch package under the grid user

(1) root user operations

Cd/u01/software/; chown grid: oinstall p21523375_112040_Linux-x86-64.zip

(2) grid user operations

Su-grid
Cd/u01/software/; unzip p21523375_112040_Linux-x86-64.zip

3. Test compatibility under the grid user. It is applicable to environments with multiple CPU hits.

$ ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail-phBaseDir/u01/software/21523375/21352649-oh $ ORACLE_HOME
$ ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail-phBaseDir/u01/software/21523375/21352642-oh $ ORACLE_HOME
$ ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail-phBaseDir/u01/software/21523375/21352635-oh $ ORACLE_HOME

----------------------------------------------------
Example:
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2015, 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.11
OUI version: 11.2.0.4.0
Log file location:/u01/app/11.2.0/grid/export toollogs/opatch/opatch2015-12-18_16-21-46PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

4. Upgrade GRID1. execute the command on node 1 and node 2.

Step 2: Execute the script. Make sure to execute the script. Otherwise, the operation fails. Make sure that the CRS is disabled.

You can also view the README file in the patch package first.

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

Using configuration parameter file:/grid/grid_home/crs/install/crsconfig_params
CRS-4544: Unable to connect to OHAS
CRS-4000: Command Stop failed, or completed with errors.
Successfully unlock/grid/grid_home

[Root @ db1 bin] #

Step 2: download the patch package (currently 11.2.0.4.8 PSU) and prepare for upgrade

Su-grid

/U01/app/11.2.0/grid/OPatch/opatch napply-oh $ ORACLE_HOME-local/u01/software/21523375/21352649
/U01/app/11.2.0/grid/OPatch/opatch napply-oh $ ORACLE_HOME-local/u01/software/21523375/21352642
/U01/app/11.2.0/grid/OPatch/opatch napply-oh $ ORACLE_HOME-local/u01/software/21523375/21352635

Process by three Y

 

2. Check the upgrade status

$/U01/app/11.2.0/grid/OPatch/opatch lsinv

Patch 21352635: applied on Fri Dec 18 17:38:24 CST 2015
Unique Patch ID: 19227862
Patch description: "Database Patch Set Update: 11.2.0.4.8 (21352635 )"
Created on 1 Sep 2015, 07:49:44 hrs
Sub-patch 20760982; "Database Patch Set Update: 11.2.0.4.7 (20760982 )"
Sub-patch 20299013; "Database Patch Set Update: 11.2.0.4.6 (20299013 )"
Sub-patch 19769489; "Database Patch Set Update: 11.2.0.4.5 (19769489 )"
Sub-patch 19121551; "Database Patch Set Update: 11.2.0.4.4 (19121551 )"
Sub-patch 18522509; "Database Patch Set Update: 11.2.0.4.3 (18522509 )"
Sub-patch 18031668; "Database Patch Set Update: 11.2.0.4.2 (18031668 )"
Sub-patch 17478514; "Database Patch Set Update: 11.2.0.4.1 (17478514 )"
Bugs fixed:
...

$/U01/app/11.2.0/grid/OPatch/opatch lspatches

21352635; Database Patch Set Update: 11.2.0.4.8 (21352635)
21352642; ACFS Patch Set Update: 11.2.0.4.8 (21352642)
21352649; OCW Patch Set Update: 11.2.0.4.8 (21352649)

OPatch succeeded.

3. Enable crs at two nodes

Note: Because PSU is manually typed, You need to manually close and start the operation.
# Cd/u01/app/11.2.0/grid/bin
#./Crsctl start has
CRS-4123: Oracle High Availability Services has been started.

V. Patch database PSU 1. Preparations

(1) grant the PSU patch package permission again under the Root user

Cd/u01/software/
Rm-rf 21523375.
Chown oracle: oinstall p21523375_112040_Linux-x86-64.zip

(2) oracle users

Su-oracle
Cd/u01/software/; unzip p21523375_112040_Linux-x86-64.zip

(3) Check the compatibility of Oracle users in the environment where multiple CPU hits occur.

$ ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail-phBaseDir/u01/software/21523375/21352635-oh $ ORACLE_HOME
----------------------------------------------------
Oracle Interim Patch Installer version 11.2.0.3.11
Copyright (c) 2015, 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.11
OUI version: 11.2.0.4.0
Log file location:/u01/app/oracle/product/11.2.0/db_1/export toollogs/opatch/opatch2015-12-21_09-25-57AM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
----------------------------------------------------

2. Patch oracle database, or use the same patch package

Su-oracle
/U01/app/oracle/product/11.2.0/db_1/OPatch/opatch napply-oh $ ORACLE_HOME-local/u01/software/21523375/21352635

Check patch patching:

/U01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinv
/U01/app/oracle/product/11.2.0/db_1/OPatch/opatch lspatches

 

6. Upgrade the database data dictionary 1. Start the database

(1) To create a grid as the root user, disable the grid (both nodes are executed)

Cd/u01/app/11.2.0/grid/bin
./Crsctl start has

Or directly execute the following command to close both nodes.
./Crs_start-all

$ Sqlplus/as sysdba

SQL * Plus: Release 11.2.0.4.0 Production on Fri Mar 15 13:40:39 2013

Copyright (c) 1982,201 1, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup

ORA-01565: error in identifying file '+ DATA/orcl/spfileorcl. ora'
ORA-17503: ksfdopn: 2 Failed to open file + DATA/orcl/spfileorcl. ora
ORA-15001: diskgroup "DATA" does not exist or is not mounted
ORA-15040: diskgroup is incomplete.
ORA-15040: diskgroup is incomplete.
ORA-15040: diskgroup is incomplete.

Note: The database cannot be started. The query result is that the oracle permission is changed to oracle: oinstall. Solve the problem as follows.
Run the following command to modify all nodes in the Cluster:
# Chown oracle: asmadmin/u01/app/oracle/product/11.2.0/db_1/bin/oracle
# Chmod 6751/u01/app/oracle/product/11.2.0/db_1/bin/oracle

SQL> startup
ORACLE instance started.

Total System Global Area 2505338880 bytes
Fixed Size 2255832 bytes
Variable Size 687866920 bytes
Database Buffers 1795162112 bytes
Redo Buffers 20054016 bytes
Database mounted.
Database opened.

SQL> @? /Rdbms/admin/catbundle. SQL psu apply
Intermediate waiting process.

After the execution, we can find the PSU update information:
SQL>

Set line 150
Col ACTION_TIME for a30
Col ACTION for a8
Col NAMESPACE for a8
Col VERSION for a10
Col BUNDLE_SERIES for a5
Col COMMENTS for a20
Select * from dba_registry_history;
 

ACTION_TIME ACTION NAMESPAC VERSION ID BUNDL COMMENTS
-------------------------------------------------------------------------------------------
24-AUG-13 12.03.45.119862 pm apply server 11.2.0.4 0 PSU Patchset 11.2.0.2.0
22-DEC-15 03.53.27.330912 pm apply server 11.2.0.4 0 PSU Patchset 11.2.0.2.0
24-DEC-15 04.58.29.381100 pm apply server 11.2.0.4 8 PSU 11.2.0.4.8

3 rows selected.

SQL>
SQL>