Oracle Upgrade PSU Patch

Oracle database Opatch Patch Operation flow
1. Confirm Database Version
Sql> select * from V$version;

2. Query patch Installation Information
Sql> select * from Dba_registry_history;

Oracle database patches are generally divided into two CPU and PSU patches.
The full name of the Oracle PSU is patch Set update,oracle, which contains bug fixes for every quarterly release of its product.
Oracle picks up the number of downloads that have been downloaded by the user and has been validated with a lower-risk patch placed in the PSU for each quarter. Not only bug fixes but also the latest CPUs are included in each PSU. PSUs are usually released with the CPU.
The PSU is usually incremental, most of the PSU can be installed directly, but some PSU must require the installation of the previous version of the PSU before continuing the installation, carefully looking at each PSU's Readme document.

The full name of the Oracle CPU is the critical patch Update, which Oracle releases a security fix pack for each quarter of its product, often to fix security concerns in the product. The CPU is cumulative (cumulative),
That is, the latest CPU patches already contain previous CPU patches, so just install the latest CPU patches. We are installing a CPU patch when the security bug is rectified.

5. Query Patch Information
Login to Oracle Website security topic http://www.oracle.com/technetwork/topics/security Click Learn More to find critical Path Update Advisory

Upgrade process:
1. Upgrade Opatch Tools
[Email protected] opatch]$./opatch version
Opatch version:11.2.0.3.4
Opatch succeeded.

View Installed Patches
[Email protected] db_1]$ $ORACLE _home/opatch/opatch LSINV

P26031190_112040_linux-x86-64.zip

Patching process

Directory structure

1.26031190

2.|

3. |-README.txt

4.|

5. |-readme.html

6.|

7. |- 25879656/

8.| --readme.html

9.| --<other files and directories>

. |

One by one . |- 26027154/

.       | --readme.html

.       | --<other files and directories>

Upgrade process:

1 , upgrade Opatch tools

[Email protected] opatch]$./opatch version

Opatch version:11.2.0.3.4

Opatch succeeded.

View Installed Patches

[Email protected] db_1]$ $ORACLE _home/opatch/opatch LSINV

which 25879656 Patching Process Process

Upgrading applications

$ORACLE _home/opatch/opatch Napply-skip_subset-skip_duplicate

Upgrade Database

CD $ORACLE _home/rdbms/admin

Sqlplus/nolog

Sql> Connect/as SYSDBA

Sql> STARTUP

sql> @catbundle. SQL CPU Apply

Sql> QUIT

CD $ORACLE _home/rdbms/admin

Sqlplus/nolog

Sql> Connect/as SYSDBA

sql> @utlrp. sql

which 26027154 Patching Process Process

Upgrade your App

$ CD <patch_top_dir>/26027154

$ opatch prereq checkconflictagainstohwithdetail-ph./

----- Check for Conflicts

$ oracle_home/opatch/ opatchapply------------------ installation ---- Note in the Patch directory

$ oracle_home/opatch/opatchlsinventory------------- Check the patch installation situation

Upgrade data

CD $ORACLE _home/sqlpatch/26027154

Sqlplus/nolog

Sql> Connect/as SYSDBA

Sql> Startup upgrade

sql> @postinstall. sql

sql> shutdown

Sql> Startup

CD $ORACLE _home/sqlpatch/26027154

Sqlplus/nolog

Sql> Connect/as SYSDBA

Sql> STARTUP

Sql> alter system set CLUSTER_DATABASE=FALSE Scope=spfile;

Sql> SHUTDOWN

Sql> STARTUP UPGRADE

sql> @postinstall. sql

Sql> alter system set CLUSTER_DATABASE=TRUE Scope=spfile;

Sql> SHUTDOWN

Sql> STARTUP

CD $ORACLE _home/rdbms/admin

Sqlplus/nolog

Sql> Connect/as SYSDBA

sql> @utlrp. sql

This article is from the "11300506" blog, please be sure to keep this source http://11310506.blog.51cto.com/11300506/1972370

Oracle Upgrade PSU Patch