What is the patch upgrade process?

This article shows you what the patch upgrade process is like, the content is concise and easy to understand, it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Record a patch upgrade process from 11.2.0.4.0 to 11.2.0.4.3

1 check the current database PSU number: cd/DBSoft/Product/11.2.4/db_1/OPatch/. / opatch version

OPatch Version: 11.2.0.3.4

Finally understand that the above is the version of the OPatch tool, not an indefinite version. Pay attention to the patch version and see OUI version.

OPatch version: 11.2.0.3.4 Patch tool version

OUI version: patch version 11.2.0.4.0

2 shutdown immediate

Host lsnrctl stop

3 upload and decompress the newly downloaded PSU patch pack

Download p6880880 and extract it

4 # # View the latest Opatch tool version number

. / opatch version

OPatch Version: 11.2.0.3.6

5 perform another pre-installation check

$/ home/oracle/OPatch/opatch prereqCheckConflictAgainstOHWithDetail

6 install PSU with the new version of Opatch

$/ home/oracle/OPatch/opatch apply

In the process of patching, you will be asked if the patch is installed locally; is there a mailbox?

7 check whether Opatch has been completed: $/ home/oracle/OPatch/opatch lsinventory

Oracle Interim Patch Installerversion 11.2.0.3.6

8 update the latest PSU information in dba_registry_history view

Start db, start listening

Alter system register;@?/rdbms/admin/catbundle.sqlpsu apply

9 confirm the updated dba_registry_history view information

Selectaction,comments from registry$history

SELECT * FROMPRODUCT_COMPONENT_VERSION

The above is what the patch upgrade process is like. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.