Text box

Please note that the problems that i face may not be the same that exist on your environment so please test before applying the same steps i followed to solve the problem .

Wednesday, 29 August 2012

Applying patch set update 11.2.0.3.3 to 11.2.0.3.0 on linux86-64 with no grid infrastructure

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.


No comments:

Post a Comment

Post a Comment