The steps to do the patching is listed below:
1-The patch needs opatch utility
version 11.2.0.3.0 or later to apply this patch. Oracle recommends that you use the latest released OPatch 11.2, which is available for download from My Oracle Support patch 6880880 by selecting the 11.2.0.0.0 release.
For information about OPatch documentation, including any known issues, see My Oracle Support
Note 293369.1 OPatch documentation list.
After downloading the Opatch expand it using unzip utility and move the Opatch directory inside the database home to Opatch.original.now copy the folder you expanded to the oracle home drectory.
The steps:
[oracle@caisvoim02 ~]$ unzip p6880880_112000_Linux-x86-64.zip
Archive: p6880880_112000_Linux-x86-64.zip
creating: OPatch/
creating: OPatch/oplan/
inflating: OPatch/oplan/README.html
inflating: OPatch/oplan/README.txt
............................................................
creating: OPatch/oplan/jlib/
inflating: OPatch/crs/patch112.pl
inflating: OPatch/crs/s_crsconfig_defs
inflating: OPatch/crs/s_crsconfig_lib.pm
[oracle@caisvoim02 ~]$ ls
13923374 p10404530_112030_Linux-x86-64_2of7.zip
OPatch p13923374_112030_Linux-x86-64.zip
oradiag_oracle p6880880_112000_Linux-x86-64.zip
p10404530_112030_Linux-x86-64_1of7.zip
[oracle@caisvoim02 ~]$ mv $ORACLE_HOME/Opatch Opatch.original
[oracle@caisvoim02 ~]$ cp -rfp OPatch $ORACLE_HOME/
The patch 13923374 is for stand alone database only.
download the patch from metalink and unzip the patch using unzip utility. it should create a folder named 13923374 as shown below:
[oracle@caisvoim02 ~]$ unzip p13923374_112030_Linux-x86-64.zip
Archive: p13923374_112030_Linux-x86-64.zip
creating: 13923374/
inflating: 13923374/patchmd.xml
creating: 13923374/13923374/
creating: 13923374/13923374/files/
.........................................
creating: 13923374/13343438/etc/xml/
inflating: 13923374/13343438/etc/xml/ShiphomeDirectoryStructure.xml
inflating: 13923374/13343438/etc/xml/GenericActions.xml
inflating: 13923374/README.html
[oracle@caisvoim02 ~]$ ls
13923374 p10404530_112030_Linux-x86-64_2of7.zip
OPatch p13923374_112030_Linux-x86-64.zip
oradiag_oracle p6880880_112000_Linux-x86-64.zip
p10404530_112030_Linux-x86-64_1of7.zip
To apply the patch to stand alone database with no grid infrastructure make sure to shutdown the lisener and the database and follow below steps to apply PSU to the database:
[oracle@caisvoim02 dbhome_1]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Aug 29 13:12:50 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string OIMDB
db_unique_name string OIMDB
global_names boolean FALSE
instance_name string OIMDB
lock_name_space string
log_file_name_convert string
processor_group_name string
service_names string OIMDB
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
also we have to shutdown the listener:
[oracle@caisvoim02 dbhome_1]$ lsnrctl
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-AUG-2012 13:14:06
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=caisvoim02)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 29-AUG-2012 13:13:57
Uptime 0 days 0 hr. 0 min. 10 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /app/oracle/diag/tnslsnr/caisvoim02/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=caisvoim02)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
LSNRCTL>
To apply the patch:
[oracle@caisvoim02 ~]$ cd 13923374
[oracle@caisvoim02 13923374]$ /app/oracle/product/11.2.0/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Oracle Home : /app/oracle/product/11.2.0/dbhome_1
Central Inventory : /app/oraInventory
from : /app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.0
OUI version : 11.2.0.3.0
Log file location : /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-08-29_12-24-15PM_1.log
Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/app/oracle/product/11.2.0/dbhome_1/bin/tnslsnr
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-08-29_12-24-15PM_1.log
OPatch failed with error code 73
[oracle@caisvoim02 13923374]$ lsnrctl
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 29-AUG-2012 11:24:45
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Welcome to LSNRCTL, type "help" for information.
LSNRCTL> status
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=caisvoim02)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 27-AUG-2012 15:29:38
Uptime 1 days 19 hr. 55 min. 9 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
Listener Log File /app/oracle/diag/tnslsnr/caisvoim02/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=caisvoim02)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
LSNRCTL> stop
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=caisvoim02)(PORT=1521)))
The command completed successfully
LSNRCTL> LSNRCTL> LSNRCTL> LSNRCTL> LSNRCTL>
LSNRCTL> exit
[oracle@caisvoim02 13923374]$ /app/oracle/product/11.2.0/dbhome_1/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.0
Copyright (c) 2012, Oracle Corporation. All rights reserved.
Password (optional): Unable to establish connection to Oracle Configuration Manager server. Hostname (https://ccr.oracle.com) is unknown. Unable to establish a network connection to Oracle. Specify the URL for an Oracle Support Hub in this format: http[s]://<OracleSupportHubHost>:<OracleSupportHubPort> If you do not wish to configure OCM through an Oracle Support Hub, enter NONE Oracle Support Hub URL: NONE Unable to establish a network connection to Oracle. If your systems require a proxy server for outbound Internet connections, enter the proxy server details in this format: [<proxy-user>@]<proxy-host>[:<proxy-port>] If you want to remain uninformed of critical security issues in your configuration, enter NONE Proxy specification: NONE Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/app/oracle/product/11.2.0/dbhome_1')
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13343438' to OH '/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Verifying the update...
Applying sub-patch '13696216' to OH '/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.sdo.locator, 11.2.0.3.0...
Patching component oracle.sysman.console.db, 11.2.0.3.0...
Patching component oracle.sysman.oms.core, 10.2.0.4.4...
Verifying the update...
Applying sub-patch '13923374' to OH '/app/oracle/product/11.2.0/dbhome_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] not present in the Oracle Home or a higher version is found.
Patching component oracle.rdbms.rsf, 11.2.0.3.0...
Patching component oracle.rdbms, 11.2.0.3.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Patching component oracle.network.rsf, 11.2.0.3.0...
Patching component oracle.network.listener, 11.2.0.3.0...
Patching component oracle.sysman.console.db, 11.2.0.3.0...
Verifying the update...
Composite patch 13923374 successfully applied.
Log file location: /app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2012-08-29_12-24-59PM_1.log
OPatch succeeded.
After applying the patch we have to load modified SQL files into the database:
SQL> startup
ORACLE instance started.
Total System Global Area 534462464 bytes
Fixed Size 2230072 bytes
Variable Size 239077576 bytes
Database Buffers 285212672 bytes
Redo Buffers 7942144 bytes
Database mounted.
Database opened.
SQL> !ls $ORACLE_HOME/rdbms/admin/catbundle.sql
/app/oracle/product/11.2.0/dbhome_1/rdbms/admin/catbundle.sql
SQL> @$ORACLE_HOME/rdbms/admin/catbundle.sql psu apply
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Generating apply and rollback scripts...
Check the following file for errors:
/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/catbundle/catbundle_PSU_OIMDB_GENERATE_2012Aug29_11_31_10.log
Apply script: /app/oracle/product/11.2.0/dbhome_1/rdbms/admin/catbundle_PSU_OIMDB_APPLY.sql
Rollback script: /app/oracle/product/11.2.0/dbhome_1/rdbms/admin/catbundle_PSU_OIMDB_ROLLBACK.sql
PL/SQL procedure successfully completed.
Executing script file...
SQL> COLUMN spool_file NEW_VALUE spool_file NOPRINT
SQL> SELECT '/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/catbundle/' || 'catbundle_PSU_' || name || '_APPLY_' || TO_CHAR(SYSDATE, 'YYYYMonDD_hh24_mi_ss', 'NLS_DATE_LANGUAGE=''AMERICAN''') || '.log' AS spool_file FROM v$database;
SQL> SPOOL &spool_file
SQL> exec dbms_registry.set_session_namespace('SERVER')
PL/SQL procedure successfully completed.
SQL> PROMPT Processing Oracle Database Packages and Types...
Processing Oracle Database Packages and Types...
SQL> ALTER SESSION SET current_schema = sys;
Session altered.
SQL> @?/psu/scripts/bug9858539.sql
SQL> Rem
SQL> Rem $Header: rdbms/admin/bug9858539.sql /st_rdbms_11.2.0.3.0dbpsu/1 2012/04/19 06:42:27 mjangir Exp $
SQL> Rem
SQL> Rem bug9858539.sql
SQL> Rem
SQL> Rem Copyright (c) 2012, Oracle and/or its affiliates. All rights reserved.
SQL> Rem
SQL> Rem NAME
SQL> Rem bug9858539.sql - <one-line expansion of the name>
SQL> Rem
SQL> Rem DESCRIPTION
SQL> Rem <short description of component this file declares/defines>
SQL> Rem
SQL> Rem NOTES
SQL> Rem <other useful comments, qualifications, etc.>
SQL> Rem
SQL> Rem MODIFIED (MM/DD/YY)
SQL> Rem mjangir 04/18/12 - Created
SQL> Rem
SQL>
SQL> SET ECHO ON
SQL> SET FEEDBACK 1
SQL> SET NUMWIDTH 10
SQL> SET LINESIZE 80
SQL> SET TRIMSPOOL ON
SQL> SET TAB OFF
SQL> SET PAGESIZE 100
SQL>
SQL> -- load XSL stylesheets connect / as sysdba
SQL>
SQL> execute sys.dbms_metadata_util.load_stylesheets;
PL/SQL procedure successfully completed.
SQL> @?/rdbms/admin/prvsawr.plb
SQL> /* -------------------------------------------------------------------------
> * DBMS_SWRF_REPORT_INTERNAL PACKAGE
SQL> *
SQL> * This package will handle the reporting for AWR. The report main
SQL> * routine will be called by the dbms_workload_repository.awr_report
SQL> * function.
SQL> * ------------------------------------------------------------------------- */
SQL> /*
SQL> * -------------------------------------------------------------------------
SQL> * DBMS_SWRF_REPORT_INTERNAL error code summary
SQL> *
SQL> * -20001 : error in the report main, at the top of the error stack
SQL> * -20002: internal error in ith_displayable_child routine when passed
SQL> * invalid arg tree_idx
SQL> * -20003: internal error in ith_displayable child routine when passed
SQL> * invalid arg child_idx
SQL> * -20004: invalid argument passed to dflt_align_for_type, internally
SQL> * -20005: error initializing the report due to missing snapshot data
SQL> * -20006: missing start value for dba_hist_librarycache
SQL> * -20007: missing end value for dba_hist_librarycache
SQL> * -20008: missing init.ora param
SQL> * -20009: missing system stat
SQL> * -20010: missing start value for dba_hist_waitstat
SQL> * -20011: missing end value for dba_hist_waitstat
SQL> * -20012: missing start time wait value for dba_hist_system_event
SQL> * -20013: missing end time wait value for dba_hist_system_event
SQL> * -20014: missing start value for DBA_HIST_LATCH gets and misses
SQL> * -20015: missing end value for DBA_HIST_LATCH gets and misses
SQL> * -20016: missing value for SGASTAT
SQL> * -20017: Missing start value for DLM statistic
SQL> * -20018: Missing end value for DLM statistic
SQL> * -20019: invalid begin_snap/end_snap pair specified by user
SQL> * -20020: invalid dbid/inst_num pair specified by user
SQL> * -20021: missing start value for time model stat
SQL> * -20022: missing end value for time model stat
SQL> * -20023: missing start and end values for time model stat
SQL> * -20024: failed to reset time zone
SQL> *
SQL> * -20100: invalid flush level specified to create_snapshot
SQL> * -20101: no valid snapshots in range (bid, eid) for database id dbid
SQL> * -20102: user name 'schname' is invalid
SQL> * -20103: directory name 'dmpdir' is invalid
SQL> * -20104: not allowed to specify the 'SYS' user
SQL> * -20105: unable to move AWR data from schema to SYS
SQL> * -20106: cannot move data from newer AWR schema
SQL> * -20107: not allowed to move AWR data for local dbid
SQL> * -20108: cannot move data from newer AWR schema
SQL> * -20109: error encountered during move_to_awr
SQL> * -20110: invalid Top N SQL value. not allowed to specify 0 or 1.
SQL> * -20111: invalid Top N SQL string: topnsql
SQL> *
SQL> * -20500: Invalid input to generate ASH report
SQL> * -20501: Invalid input to helper function to create report
SQL> *
SQL> * -20600: Invalid (dbid, version) for DB Feature Usage
SQL> * -20601: Invalid (dbid, version) for High Water Mark
SQL> */
SQL> create or replace package dbms_swrf_report_internal wrapped
2 a000000
15 abcd
16 abcd
17 abcd
18 abcd
19 9
20 9738 206d
21 evIH7Hvw061aB+cWkM5JC6OuMFkwg1VMHscFYaeacjrVV7y3DcdJ3qL8THiQa1paBuxmiKyb
22 jA9XGGLG7MWn6vETn7ADqvjhj5mPHXsaiVXaHinNLqTk/61XlnZ2qRqw/eqSNj4oD7zNFVX+
135
136 /
Package created.
SQL> SHOW ERRORS;
No errors.
SQL> @?/rdbms/admin/prvtawr.plb
SQL> /* -------------------------------------------------------------------------
> * DBMS_SWRF_REPORT_INTERNAL PACKAGE BODY
SQL> *
SQL> * This package will handle the reporting for AWR. It will have the
SQL> * following interfaces:
SQL> * ------------------------------------------------------------------------- */
SQL> create or replace package body dbms_swrf_report_internal wrapped
2 a000000
3 1
12 abcd
13 abcd
14 abcd
15 abcd
16 abcd
17 abcd
18 abcd
19 b
20 8a8a7 1752c
21 kJdswIBy2atlN05e2rPpIOORqLYwg4pz9hL9eMIWXz/BZN3/owOhG6BW+qHJ4JWtrrd+oXpI
22 wilIJcIXZHOba2yDPIiT0sjDZYfau/nNWwK6hhl9GzItgEFfYvdna2lcTcWOngJSdxKIkNtN
23 EzOaUW2/TzwDgSwK/gM9Bk7ADVhMhyBvCh46lKtd8DnmpSw61mn1p9fCMG7JtzFwIXV0UZGl
.....................................................
......................................................
1329 ka1oEYTwlxs7hcqGoJE+iYdHcoIUQG0UE5W3H7WGtR0rVWgD
1330
1331 /
Package body created.
SQL> show errors;
No errors.
SQL> /* --------------------------------------------
> * DBMS_WORKLOAD_REPOSITORY package body
SQL> * -------------------------------------------- */
SQL> CREATE OR REPLACE PACKAGE BODY dbms_workload_repository wrapped
2 a000000
3 1
4 abcd
5 abcd
...............................
...............................
121 kDQP
122
123 /
Package body created.
SQL> SHOW ERRORS;
No errors.
SQL> @?/rdbms/admin/prvtawrs.plb
SQL> CREATE OR REPLACE PACKAGE BODY dbms_awr_report_layout wrapped
2 a000000
3 1
4 abcd
5 abcd
6 abcd
..............................................
..............................................
3114 ECNCCHK1wbVbMHoTLw==
3115
3116 /
Package body created.
SQL> SHOW ERRORS;
No errors.
SQL> ALTER SESSION SET current_schema = SYS;
Session altered.
SQL> PROMPT Updating registry...
Updating registry...
SQL> INSERT INTO registry$history
2 (action_time, action,
3 namespace, version, id,
4 bundle_series, comments)
5 VALUES
6 (SYSTIMESTAMP, 'APPLY',
7 SYS_CONTEXT('REGISTRY$CTX','NAMESPACE'),
8 '11.2.0.3',
9 3,
10 'PSU',
11 'PSU 11.2.0.3.3');
1 row created.
SQL> COMMIT;
Commit complete.
SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/catbundle/catbundle_PSU_OIMDB_APPLY_2012Aug29_11_31_11.log
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
To check the oracle logs for the loading the modified sql into the database :
[oracle@caisvoim02 13923374]$ cd $ORACLE_HOME/cfgtoollogs/catbundle
[oracle@caisvoim02 catbundle]$ ls
catbundle_PSU_OIMDB_APPLY_2012Aug29_11_31_11.log
catbundle_PSU_OIMDB_GENERATE_2012Aug29_11_31_10.log
References:
End of the steps.
