如果更新檔中有online目錄就是線上更新檔，不需要資料庫停機，線上的又分叢集和非叢集，如下
$ cat README.txt
Oracle Database 11g Release 11.2.0.3.0
ORACLE DATABASE Patch for Bug# 12834800 for Linux-x86 Platforms
(RAC Rolling Installable and Online Installable Patch)
(DG Rolling Installable)
Released: Sat Jan 28 10:03:32 2012
This document describes how you can install the ORACLE DATABASE combo patch for bug# 12834800 on your Oracle Database 11g Release 11.2.0.3.0.
A combo patch is a patch that can be applied either in offline mode or in online mode. For information about offline and online modes of patching, see My Oracle Support note 761111.1 available at:
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=761111.1
(1) Prerequisites
------------------
Before you install or deinstall the patch, ensure that you meet the following requirements:
Note: In case of an Oracle RAC environment, meet these prerequisites on each of the nodes.
1. Ensure that the Oracle Database on which you are installing the patch or from which you are rolling back the patch is Oracle Database 11g Release (11.2.0.3.0).
2. Oracle recommends you to use the latest version of OPatch.
If you do not have the latest version, then follow the instructions outlined in the My Oracle Support note 224346.1 available at:
https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=224346.1
3. Ensure that you set the ORACLE_HOME environment variable to the Oracle home of the Oracle Database.
4. Ensure that you set the PATH environment variable to include the location of the unzip executable, and the /bin and the /OPatch directories present in the Oracle home of the Oracle Database.
5. Ensure that you verify the Oracle Inventory because OPatch accesses it to install the patches. To verify the inventory, run the following command. If the command displays some errors, then contact Oracle Support and resolve the issue.
$ opatch lsinventory
6. (Only for Offline Patching) Ensure that you shut down all the services running from the Oracle home.
7. (Only for Online Patching) Ensure that all the services in the Oracle home are up and running.
8. (Only for Online Patching) Ensure that you maintain adequate memory on your system to apply this online patch. To calculate the amount of memory required for this online patch, use the following formula:
Memory Consumed = (Number of Oracle Processes + 1) X (Size of Patched .pch File)
Note:
- For UNIX, the number of Oracle processes is determined by checking the parameter "processes" in the database by querying v$parameter. For Microsoft Windows, the number of Oracle processes is always zero (0).
- The .pch file is available under /files/hpatch/ directory.
(2) Installation
-----------------
This section describes the following modes you can use to install the combo patch. Use the one that best suits your requirement.
- Installing in Offline Mode
- Installing in Online Mode
(2.1) Installing in Offline Mode
-----------------------------------
To install the patch in offline mode, follow these steps:
Note: In case of an Oracle RAC environment, perform these steps on each of the nodes.
1. Maintain a location for storing the contents of the patch ZIP file. In the rest of the document, this location (absolute path) is referred to as
.
2. Extract the contents of the patch ZIP file to the location you created in Step (1). To do so, run the following command:
$ unzip -d
p12834800_112030_LINUX.zip
3. Navigate to the
/12834800 directory:
$ cd
/12834800
4. Install the patch by running the following command:
$ opatch apply
Note:
When OPatch starts, it validates the patch and ensures that there are no conflicts with the software already installed in the ORACLE_HOME of the Oracle Database. OPatch categorizes conflicts
into the following types:
- Conflicts with a patch already applied to the ORACLE_HOME - In this case, stop the patch installation and contact Oracle Support Services.
- Conflicts with a patch already applied to the ORACLE_HOME that is a subset of the patch you are trying to apply - In this case, continue with the patch installation because the new patch
contains all the fixes from the existing patch in the ORACLE_HOME. The subset patch will automatically be rolled back prior to the installation of the new patch.
5. Start the services from the Oracle home.
(2.2) Installing in Online Mode
-----------------------------------
To install the patch in online mode, follow these steps:
Note: In case of an Oracle RAC environment, perform these steps on each of the nodes.
1. Maintain a location for storing the contents of the patch ZIP file. In the rest of the document, this location (absolute path) is referred to as
.
2. Extract the contents of the patch ZIP file to the location you created in Step (1). To do so, run the following command:
$ unzip -d
p12834800_112030_LINUX.zip
3. Navigate to the
/12834800 directory:
$ cd
/12834800
4. Install the patch by running the following command:
- For Non-RAC Environments (Standalone Databases):
$ opatch apply online -connectString ::
:
- For RAC Environments:
$ opatch apply online -connectString ::
:,::
:,::
:
Note:
- Run the previous command on the first node of the Oracle RAC system, and specify details of each node separated by a comma. In the command, NodeN refers to the different nodes of the
Oracle RAC system. Once the patch is applied on the first node, OPatch automatically moves over and patches the next node you have specified in the comamnd.
- When OPatch starts, it validates the patch and ensures that there are no conflicts with the software already installed in the ORACLE_HOME of the Oracle Database. OPatch categorizes conflicts
into the following types:
- Conflicts with a patch already applied to the ORACLE_HOME that is a subset of the patch you are trying to apply - In this case, continue with the patch installation because the new patch
contains all the fixes from the existing patch in the ORACLE_HOME. The subset patch will automatically be rolled back prior to the installation of the new patch.
- Conflicts with a patch already applied to the ORACLE_HOME - In this case, stop the patch installation and contact Oracle Support Services.
5. Start the services from the Oracle home.
(3) Deinstallation
--------------------
This section describes the following modes you can use to deinstall the combo patch. Use the one that best suits your requirement.
- Deinstalling in Offline Mode
- Deinstalling in Online Mode
(3.1) Deinstalling in Offline Mode
-------------------------------------
To deinstall the patch in offline mode, follow these steps:
Note: In case of an Oracle RAC environment, perform these steps on each of the nodes.
1. Navigate to the
/12834800 directory:
$ cd
/12834800
2. Deinstall the patch by running the following command:
$ opatch rollback -id 12834800
3. Start the services from the Oracle home.
(3.2) Deinstalling in Online Mode
--------------------------------------
To deinstall the patch in online mode, follow these steps:
Note: In case of an Oracle RAC environment, perform these steps on each of the nodes.
1. Navigate to the
/12834800 directory:
$ cd
/12834800
2. Deinstall the patch by running the following command:
- For Non-RAC Environments (Standalone Databases):
$ opatch rollback -id 12834800 -connectString ::
:
- For RAC Environments:
$ opatch rollback -id 12834800 -connectString ::
:,::
:,::
:
Note:
Run the previous command on the first node of the Oracle RAC system, and specify details of each node separated by a comma. In the command, NODEn refers to the different nodes of the
Oracle RAC system. Once the patch is rolled back from the first node, OPatch automatically moves over and rolls back the patch from the next node you have specified in the comamnd.
3. Start the services from the Oracle home.
(4) Bugs Fixed by This Patch
---------------------------------
The following are the bugs fixed by this patch:
12834800: ORA-7445 [QKXRPXFORMUNM()+92]
--------------------------------------------------------------------------
Copyright 2012, Oracle and/or its affiliates. All rights reserved.
打個更新檔
$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch apply online -connectString PROD4:sys:oracle:
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2019-04-01_16-45-58PM.log
The patch should be applied/rolled back in '-all_nodes' mode only.
Converting the RAC mode to '-all_nodes' mode.
Applying interim patch '12834800' to OH '/u01/app/oracle/product/11.2.0/db_1'
Verifying environment and performing prerequisite checks...
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Backing up files...
Patching component oracle.rdbms, 11.2.0.3.0...
The patch will be installed on active database instances.
Installing and enabling the online patch 'bug12834800.pch', on database 'PROD4'.
Patch 12834800 successfully applied
Log file location: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2019-04-01_16-45-58PM.log
OPatch succeeded.
$ /u01/app/oracle/product/11.2.0/db_1/OPatch/opatch lsinventory
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2019-04-01_16-48-44PM.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2019-04-01_16-48-44PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch (online) 12834800: applied on Mon Apr 01 16:47:17 CST 2019
Unique Patch ID: 14522435
Created on 28 Jan 2012, 10:16:59 hrs PST8PDT
Bugs fixed:
12834800
--------------------------------------------------------------------------------
OPatch succeeded.
作者：九命貓幺
部落格出處：http://www.cnblogs.com/yongestcat/
歡迎轉載，轉載請标明出處。
如果你覺得本文還不錯，對你的學習帶來了些許幫助，請幫忙點選右下角的推薦
![oracle中的start with connect by用法[圖]](data:image/gif;base64,R0lGODlhAQABAIAAAP///wAAACwAAAAAAQABAAACAkQBADs=)