Oracle 12.1.0.2.0 - Applying Patch 18201352: ORA-7445 [QERTBSTART()+3105] CRASHES QUERY WITH DISTINCT AND PJE TRANSFORMATION
- Download Patch 18201352 (p18201352_121020_Linux-x86-64.zip)
- Ensure Oracle home has Oracle Database 12.1.0.2.0 installed
- Set environment variables, ensure latest opatch version available for 12c release is used,
- Unzip the patch
$ unzip p18201352_121020_Linux-x86-64.zip
- Check for patch conflicts
$ cd 18201352
$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Applying Patch 18201352 (Offline Patching)
- Shutdown all services (for offline patching)
- Run opatch apply
$ cd 18201352
$ opatch apply
- Verify patch
$ opatch lsinventory |grep 18201352
- Restart all services
Patch rollback steps (Offline)
If any issues after applying the patch and rollback is required, follow below steps:
- Stop all services
- Run opatch rollback
$ opatch rollback -id 18201352
- Restart all services
Related Posts
Oracle 12.1.0.2.0 - Applying Patch 20228093: MATERIALIZED VIEW DEFERRED MODE ORA-00918: COLUMN AMBIGUOUSLY DEFINED
Showing posts with label checkconflictagainstohwithdetail. Show all posts
Showing posts with label checkconflictagainstohwithdetail. Show all posts
Saturday, 6 February 2016
Thursday, 29 October 2015
Rollback Patch 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
Rollback Patch 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
If after Applying 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015), there are any post patching issues for which a patch rollback is needed, please follow below steps.
Please note these steps are for NON RAC. (For RAC, steps vary slightly, refer to patch README.TXT for details)
Patch rollback
- Start DB services including listener
- Run the roll back scripts
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle_PSU_<database SID>_ROLLBACK.sql
SQL> QUIT
- If the OJVM PSU was applied for a previous PSU patch, you may see invalid Java classes after execution of the catbundle.sql script in the previous step. If this is the case, run utlrp.sql to re-validate these Java classes.
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql
- Start all remaining services after patch roll back and do the health checks
Related Posts:
Applying 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
Checking for Patch conflicts - 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
libserver11.a:/qksbg.o Patch 12942119 conflicts when applying Oracle 11.2.0.3.0 Patch 20760997: DATABASE PATCH SET UPDATE 11.2.0.3.15 (INCLUDES CPUJUL2015)
If after Applying 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015), there are any post patching issues for which a patch rollback is needed, please follow below steps.
Please note these steps are for NON RAC. (For RAC, steps vary slightly, refer to patch README.TXT for details)
Patch rollback
- Start DB services including listener
- Run the roll back scripts
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle_PSU_<database SID>_ROLLBACK.sql
SQL> QUIT
- If the OJVM PSU was applied for a previous PSU patch, you may see invalid Java classes after execution of the catbundle.sql script in the previous step. If this is the case, run utlrp.sql to re-validate these Java classes.
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> @utlrp.sql
- Start all remaining services after patch roll back and do the health checks
Related Posts:
Applying 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
Checking for Patch conflicts - 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
libserver11.a:/qksbg.o Patch 12942119 conflicts when applying Oracle 11.2.0.3.0 Patch 20760997: DATABASE PATCH SET UPDATE 11.2.0.3.15 (INCLUDES CPUJUL2015)
Applying 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
Applying 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
- Download patch 21352635 (p21352635_112040_Linux-x86-64.zip) (chose zip file for relevant platform)
- Copy and unzip the patch onto the server at a location with appropriate permissions say PATCH_TOP
- Ensure all patch pre-requisites are met as documented in the patch README.TXT file
- Shutdown Mid-Tier and DB services and take a cold backup before applying the patch (recommended)
Check for patch conflicts:
Refer to Checking for Patch conflicts - 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015) for details.
Apply latest OPatch
- Backup existing OPatch directory
cd $ORACLE_HOME
mv OPatch OPatch_<ddmmyy>
- $ unzip /sid/PATCH_TOP/p6880880_112000_Linux-x86-64.zip
- $ copy /sid/PATCH_TOP/OPatch $ORACLE_HOME/
- $ export PATH=$ORACLE_HOME/OPatch:$PATH
- $ opatch version
Apply DB PSU Patch 21352635
- $ cd /sid/PATCH_TOP/21352635
- $ opatch apply
Any existing previous PSU patches will be rolledback by OPatch
- Start DB services including listener
Post patching steps
- $cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
- Run utlrp.sql
SQL> @utlrp.sql
SQL> QUIT
- Check the following log files in $ORACLE_HOME/cfgtoollogs/catbundle or $ORACLE_BASE/cfgtoollogs/catbundle for any errors:
catbundle_PSU_<database SID>_APPLY_<TIMESTAMP>.log
catbundle_PSU_<database SID>_GENERATE_<TIMESTAMP>.log
- Start all services and verify no post patching issues by doing quick post patching health checks
Related Posts:
Checking for Patch conflicts - 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
Rollback Patch 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
libserver11.a:/qksbg.o Patch 12942119 conflicts when applying Oracle 11.2.0.3.0 Patch 20760997: DATABASE PATCH SET UPDATE 11.2.0.3.15 (INCLUDES CPUJUL2015)
- Download patch 21352635 (p21352635_112040_Linux-x86-64.zip) (chose zip file for relevant platform)
- Copy and unzip the patch onto the server at a location with appropriate permissions say PATCH_TOP
- Ensure all patch pre-requisites are met as documented in the patch README.TXT file
- Shutdown Mid-Tier and DB services and take a cold backup before applying the patch (recommended)
Check for patch conflicts:
Refer to Checking for Patch conflicts - 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015) for details.
Apply latest OPatch
- Backup existing OPatch directory
cd $ORACLE_HOME
mv OPatch OPatch_<ddmmyy>
- $ unzip /sid/PATCH_TOP/p6880880_112000_Linux-x86-64.zip
- $ copy /sid/PATCH_TOP/OPatch $ORACLE_HOME/
- $ export PATH=$ORACLE_HOME/OPatch:$PATH
- $ opatch version
Apply DB PSU Patch 21352635
- $ cd /sid/PATCH_TOP/21352635
- $ opatch apply
Any existing previous PSU patches will be rolledback by OPatch
- Start DB services including listener
Post patching steps
- $cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
- Run utlrp.sql
SQL> @utlrp.sql
SQL> QUIT
- Check the following log files in $ORACLE_HOME/cfgtoollogs/catbundle or $ORACLE_BASE/cfgtoollogs/catbundle for any errors:
catbundle_PSU_<database SID>_APPLY_<TIMESTAMP>.log
catbundle_PSU_<database SID>_GENERATE_<TIMESTAMP>.log
- Start all services and verify no post patching issues by doing quick post patching health checks
Related Posts:
Checking for Patch conflicts - 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
Rollback Patch 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
libserver11.a:/qksbg.o Patch 12942119 conflicts when applying Oracle 11.2.0.3.0 Patch 20760997: DATABASE PATCH SET UPDATE 11.2.0.3.15 (INCLUDES CPUJUL2015)
Checking for Patch conflicts - 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
Checking for Patch conflicts - 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
Before applying patch 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015), check for patch conflicts with any existing patches on the Database where patch 21352635 is to be applied.
- cd /sid/PATCH_TOP/21352635
where PATCH_TOP is the directory where patch is copied
Check for conflicts with existing patches as below
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph .
- Rollback any conflicting patches highlighted during one-off patch conflict detection.
- Follow patch conflict resolution steps as necessary in the conflict report. Also refer to Section 3.1.4 for more details.
Related Posts:
Rollback Patch 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
Applying 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
libserver11.a:/qksbg.o Patch 12942119 conflicts when applying Oracle 11.2.0.3.0 Patch 20760997: DATABASE PATCH SET UPDATE 11.2.0.3.15 (INCLUDES CPUJUL2015)
Before applying patch 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015), check for patch conflicts with any existing patches on the Database where patch 21352635 is to be applied.
- cd /sid/PATCH_TOP/21352635
where PATCH_TOP is the directory where patch is copied
Check for conflicts with existing patches as below
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph .
- Rollback any conflicting patches highlighted during one-off patch conflict detection.
- Follow patch conflict resolution steps as necessary in the conflict report. Also refer to Section 3.1.4 for more details.
Related Posts:
Rollback Patch 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
Applying 21352635: DATABASE PATCH SET UPDATE 11.2.0.4.8 (INCLUDES CPUOCT2015)
libserver11.a:/qksbg.o Patch 12942119 conflicts when applying Oracle 11.2.0.3.0 Patch 20760997: DATABASE PATCH SET UPDATE 11.2.0.3.15 (INCLUDES CPUJUL2015)
Friday, 29 May 2015
Applying Patch 17747140 - QUARTERLY DATABASE PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22) and Patch 17992671 - CRS PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22)
Applying Patch 17747140 - QUARTERLY DATABASE PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22) and Patch 17992671 - CRS PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22)
- Login to server as proper OS user.
- cd to stage area where the patch is copied.
Check for conflicts:
===================
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17747140
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
Checks System Space
===================
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17747140
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
Applying the patches:
- Shutdown the services (Cold backup recommended before patching)
- Apply patch using the below steps
export ORACLE_HOME=/instance_name/oracle/product/112;
echo $ORACLE_HOME
Run prepatch.sh
/stage/17747147/17992671/custom/server/17992671/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
Apply patch
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /stage/17747147/17747140
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /stage/17747147/17992671/custom/server/17992671
Run postpatch.sh
/stage/17747147/17992671/custom/server/17992671/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
- Start services after applying the patches
- Execute catbundle.sql only on one node
sqlplus / as sysdba
@?/rdbms/admin/catbundle.sql exa apply
Verify if patches applied successfully.
=======================================
[orinstance_name@localhost ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -local | grep 17747140
Patch 17747140 : applied on date_timestamp
Patch description: "QUARTERLY DATABASE PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22) :
(17747140)"
[orinstance_name@localhost ~]$
[orinstance_name@localhost ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -local | grep 17992671
Patch 17992671 : applied on date_timestamp
Patch description: "QUARTERLY CRS PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22)
(17992671)"
[orinstance_name@localhost ~]$
Related Posts:
Oracle Database - Enterprise Edition - Applying Patch 21800477: QUARTERLY DATABASE PATCH FOR EXADATA (OCT2015 - 11.2.0.4.20)
- Login to server as proper OS user.
- cd to stage area where the patch is copied.
Check for conflicts:
===================
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17747140
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
Checks System Space
===================
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17747140
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
[orinstance_name@localhost 17747147]$
[orinstance_name@localhost 17747147]$ $ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseDir /stage/17747147/17992671/custom/server/17992671
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /instance_name/oracle/product/112
Central Inventory : /orgrid/grid_base/oraInventory
from : /instance_name/oracle/product/112/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location :
/instance_name/oracle/product/112/cfgtoollogs/opatch/opatch_timestamp_1.log
Invoking prereq "checksystemspace"
Prereq "checkSystemSpace" passed.
OPatch succeeded.
Applying the patches:
- Shutdown the services (Cold backup recommended before patching)
- Apply patch using the below steps
export ORACLE_HOME=/instance_name/oracle/product/112;
echo $ORACLE_HOME
Run prepatch.sh
/stage/17747147/17992671/custom/server/17992671/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
Apply patch
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /stage/17747147/17747140
$ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /stage/17747147/17992671/custom/server/17992671
Run postpatch.sh
/stage/17747147/17992671/custom/server/17992671/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
- Start services after applying the patches
- Execute catbundle.sql only on one node
sqlplus / as sysdba
@?/rdbms/admin/catbundle.sql exa apply
Verify if patches applied successfully.
=======================================
[orinstance_name@localhost ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -local | grep 17747140
Patch 17747140 : applied on date_timestamp
Patch description: "QUARTERLY DATABASE PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22) :
(17747140)"
[orinstance_name@localhost ~]$
[orinstance_name@localhost ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -local | grep 17992671
Patch 17992671 : applied on date_timestamp
Patch description: "QUARTERLY CRS PATCH FOR EXADATA (JAN 2014 - 11.2.0.3.22)
(17992671)"
[orinstance_name@localhost ~]$
Related Posts:
Oracle Database - Enterprise Edition - Applying Patch 21800477: QUARTERLY DATABASE PATCH FOR EXADATA (OCT2015 - 11.2.0.4.20)
Subscribe to:
Posts (Atom)