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

Operation flow of opatch patch for oracle database

1. Confirm the 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 types: CPU and PSU patches.

The full name of Oracle PSU is Patch Set Update,Oracle 's quarterly fix pack for its products, which includes fixes for bug.

Oracle selects patches that are downloaded by a large number of users and have been verified to have a low risk and put them into the quarterly PSU. Each PSU contains not only fixes for Bug but also the latest CPU. PSU is usually released with CPU.

PSU is usually incremental, and most PSU can be installed directly, but some PSU must require the previous version of PSU to be installed before continuing with the installation. Read the Readme documentation of each PSU carefully.

The full name of Oracle CPU is Critical Patch Update, and Oracle releases a quarterly security patch pack for its products, usually to fix security vulnerabilities in the product. CPU is cumulative (Cumulative)

That is, the latest CPU patch already contains the previous CPU patch, so just install the latest CPU patch. When we correct the security vulnerabilities, we need to install the CPU patch.

5. Query patch information

Log in to the security topic on oracle's official website http://www.oracle.com/technetwork/topics/security and click learn More to find Critical Path Update Advisory.

Upgrade process:

1. Upgrade the OPatch tool

[oracle@oggtarget OPatch] $. / opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

View installed patches

[oracle@oggtarget 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. |--

10. |

11. |-26027154 /

12. |-- README.html

13. |--

Upgrade process:

1. Upgrade the OPatch tool

[oracle@oggtarget OPatch] $. / opatch version

OPatch Version: 11.2.0.3.4

OPatch succeeded.

View installed patches

[oracle@oggtarget db_1] $$ORACLE_HOME/OPatch/opatch lsinv

Among them, 25879656 of the patching process

Upgrade the application

$ORACLE_HOME/OPatch/opatch napply-skip_subset-skip_duplicate

Upgrade the 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

Among them, 26027154 of the patching process

Upgrade application

$cd / 26027154

Opatch prereq CheckConflictAgainstOHWithDetail-ph. /

-check for conflicts

$ORACLE_HOME/OPatch/opatchapply- installation-pay attention to the patch directory

$ORACLE_HOME/OPatch/opatchlsinventory- check patch installation

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

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.