Apply PSU 11.2.0.3.7 for Grid Infrastructure Standalone and DB with Oracle Restart

Patch 11gR2 Grid Infrastructure Standalone (Oracle Restart) (Doc ID 1089476.1)

Oracle Grid Infrastructure Patch Set Update 11.2.0.3.7 (Includes Database PSU 11.2.0.3.7) - 16742216

Upgrade OPatch:

[oracle@san PSU]$ unzip -o -qq p6880880_112000_Linux-x86-64.zip -d /u01/app/11.2.0.3/grid

[oracle@san PSU]$ unzip -o -qq p6880880_112000_Linux-x86-64.zip -d /u01/app/oracle/product/11.2.0.3/dbhome_1/

Validate Oracle Inventory

[oracle@san ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME

[oracle@san ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $GRID_HOME

Create ocm.rsp

[oracle@san:pdb01:~]$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp

Stop database home on the node

[oracle@san:pdb01:~]$ srvctl stop home -o $ORACLE_HOME -s /tmp/statefile.out

Save database home configuration

[oracle@san:pdb01:16742216]$ ./16619898/custom/server/16619898/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

Stop GI and unlock Grid Infrastructure home

oracle@san:+ASM:~]$ crsctl stop has

Patch Grid home

[oracle@san:+ASM:16742216]$ $GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -ocmrf /home/oracle/ocm.rsp

Validate GI_PSU for Grid home

Patch GI_PSU for database home

[oracle@san:pdb01:16742216]$ $ORACLE_HOME/OPatch/opatch napply 16619898/custom/server/ -oh $ORACLE_HOME -id 16619898 -ocmrf /home/oracle/ocm.rsp

Validate GI_PSU for database home

Patch DB_PSU for database home

[oracle@san:pdb01:16742216]$ $ORACLE_HOME/OPatch/opatch apply -local -oh $ORACLE_HOME 16619892 -ocmrf /home/oracle/ocm.rsp

Validate DB_PSU for database home

Restore database home configuration

[oracle@san:pdb01:16742216]$ ./16619898/custom/server/16619898/custom/scripts//postpatch.sh -dbhome $ORACLE_HOME

Re-lock Grid Infrastructure home and start GI

Start database home on the node

[oracle@san:pdb01:~]$ srvctl start home -o $ORACLE_HOME -s /tmp/statefile.out

Post patch installation for database

SQL> @?/rdbms/admin/catbundle.sql psu apply

SQL> @?/rdbms/admin/utlrp.sql

Upgrade Oracle Recovery Manager Catalog

Patch 11gR2 Grid Infrastructure Standalone (Oracle Restart) (Doc ID 1089476.1)

Oracle Grid Infrastructure Patch Set Update 11.2.0.3.7 (Includes Database PSU 11.2.0.3.7) - 16742216

[oracle@san tmp]$ cd 16742216

[oracle@san 16742216]$ ls

16619892  16619898  atp_lfp  bundle.xml  README.html  README.txt

[oracle@san 16742216]$

16742216 - GRID INFRASTRUCTURE PATCH SET UPDATE 11.2.0.3.7

16619892 (db_psu_patch_no)

16619898 (gi_psu_patch_no)

Upgrade OPatch:

[oracle@san PSU]$ ls

11.2.0.3.7  p16742216_112030_Linux-x86-64.zip  p6880880_112000_Linux-x86-64.zip

[oracle@san PSU]$ unzip -o -qq p6880880_112000_Linux-x86-64.zip -d /u01/app/11.2.0.3/grid

error:  cannot create /u01/app/11.2.0.3/grid/PatchSearch.xml

        Permission denied

[oracle@san PSU]$ unzip -o -qq p6880880_112000_Linux-x86-64.zip -d /u01/app/oracle/product/11.2.0.3/dbhome_1/

[oracle@san PSU]$ $ORACLE_HOME/OPatch/opatch version

OPatch Version: 11.2.0.3.5

OPatch succeeded.

[oracle@san PSU]$ $GRID_HOME/OPatch/opatch version

OPatch Version: 11.2.0.3.5

OPatch succeeded.

[oracle@san PSU]$

Validate Oracle Inventory

[oracle@san ~]$ echo $ORACLE_HOME $GRID_HOME

/u01/app/oracle/product/11.2.0.3/dbhome_1 /u01/app/11.2.0.3/grid/

[oracle@san ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME

Oracle Interim Patch Installer version 11.2.0.3.5

Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0.3/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0.3/dbhome_1/oraInst.loc

OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2013-08-24_19-25-07PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-08-24_19-25-07PM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (1):

Oracle Database 11g                                                  11.2.0.3.0

There are 1 products installed in this Oracle Home.

Installed Products (136):

Agent Required Support Files                                         10.2.0.4.3

Assistant Common Files                                               11.2.0.3.0

Bali Share                                                           1.1.18.0.0

Buildtools Common Files                                              11.2.0.3.0

Character Set Migration Utility                                      11.2.0.3.0

Cluster Verification Utility Common Files                            11.2.0.3.0

Database Configuration and Upgrade Assistants                        11.2.0.3.0

Database SQL Scripts                                                 11.2.0.3.0

Database Workspace Manager                                           11.2.0.3.0

Deinstallation Tool                                                  11.2.0.3.0

Enterprise Edition Options                                           11.2.0.3.0

Enterprise Manager Agent                                             10.2.0.4.3

Enterprise Manager Agent Core Files                                  10.2.0.4.4

Enterprise Manager Common Core Files                                 10.2.0.4.4

Enterprise Manager Common Files                                      10.2.0.4.3

Enterprise Manager Database Plugin -- Agent Support                  11.2.0.3.0

Enterprise Manager Database Plugin -- Repository Support             11.2.0.3.0

Enterprise Manager Grid Control Core Files                           10.2.0.4.4

Enterprise Manager plugin Common Files                               11.2.0.3.0

Enterprise Manager Repository Core Files                             10.2.0.4.4

Exadata Storage Server                                               11.2.0.1.0

Expat libraries                                                       2.0.1.0.1

Generic Connectivity Common Files                                    11.2.0.3.0

HAS Common Files                                                     11.2.0.3.0

HAS Files for DB                                                     11.2.0.3.0

Installation Common Files                                            11.2.0.3.0

Installation Plugin Files                                            11.2.0.3.0

Installer SDK Component                                              11.2.0.3.0

JAccelerator (COMPANION)                                             11.2.0.3.0

LDAP Required Support Files                                          11.2.0.3.0

OLAP SQL Scripts                                                     11.2.0.3.0

Oracle 11g Warehouse Builder Required Files                          11.2.0.3.0

Oracle Advanced Security                                             11.2.0.3.0

Oracle Application Express                                           11.2.0.3.0

Oracle Call Interface (OCI)                                          11.2.0.3.0

Oracle Clusterware RDBMS Files                                       11.2.0.3.0

Oracle Code Editor                                                   1.2.1.0.0I

Oracle Configuration Manager                                         10.3.5.0.1

Oracle Configuration Manager Client                                  10.3.2.1.0

Oracle Configuration Manager Deconfiguration                         10.3.1.0.0

Oracle Containers for Java                                           11.2.0.3.0

Oracle Core Required Support Files                                   11.2.0.3.0

Oracle Data Mining RDBMS Files                                       11.2.0.3.0

Oracle Database 11g                                                  11.2.0.3.0

Oracle Database 11g                                                  11.2.0.3.0

Oracle Database 11g Multimedia Files                                 11.2.0.3.0

Oracle Database Deconfiguration                                      11.2.0.3.0

Oracle Database Gateway for ODBC                                     11.2.0.3.0

Oracle Database User Interface                                       2.2.13.0.0

Oracle Database Utilities                                            11.2.0.3.0

Oracle Database Vault J2EE Application                               11.2.0.3.0

Oracle Database Vault option                                         11.2.0.3.0

Oracle DBCA Deconfiguration                                          11.2.0.3.0

Oracle Display Fonts                                                  9.0.2.0.0

Oracle Enterprise Manager Console DB                                 11.2.0.3.0

Oracle Extended Windowing Toolkit                                    3.4.47.0.0

Oracle Globalization Support                                         11.2.0.3.0

Oracle Globalization Support                                         11.2.0.3.0

Oracle Help For Java                                                  4.2.9.0.0

Oracle Help for the  Web                                             2.0.14.0.0

Oracle Ice Browser                                                    5.2.3.6.0

Oracle Internet Directory Client                                     11.2.0.3.0

Oracle Java Client                                                   11.2.0.3.0

Oracle JDBC Server Support Package                                   11.2.0.3.0

Oracle JDBC/OCI Instant Client                                       11.2.0.3.0

Oracle JDBC/THIN Interfaces                                          11.2.0.3.0

Oracle JFC Extended Windowing Toolkit                                4.2.36.0.0

Oracle JVM                                                           11.2.0.3.0

Oracle Label Security                                                11.2.0.3.0

Oracle LDAP administration                                           11.2.0.3.0

Oracle Locale Builder                                                11.2.0.3.0

Oracle Message Gateway Common Files                                  11.2.0.3.0

Oracle Multimedia                                                    11.2.0.3.0

Oracle Multimedia Annotator                                          11.2.0.3.0

Oracle Multimedia Client Option                                      11.2.0.3.0

Oracle Multimedia Java Advanced Imaging                              11.2.0.3.0

Oracle Multimedia Locator                                            11.2.0.3.0

Oracle Multimedia Locator RDBMS Files                                11.2.0.3.0

Oracle Net                                                           11.2.0.3.0

Oracle Net Listener                                                  11.2.0.3.0

Oracle Net Required Support Files                                    11.2.0.3.0

Oracle Net Services                                                  11.2.0.3.0

Oracle Netca Client                                                  11.2.0.3.0

Oracle Notification Service                                          11.2.0.3.0

Oracle Notification Service (eONS)                                   11.2.0.3.0

Oracle ODBC Driver                                                   11.2.0.3.0

Oracle ODBC Driverfor Instant Client                                 11.2.0.3.0

Oracle OLAP                                                          11.2.0.3.0

Oracle OLAP API                                                      11.2.0.3.0

Oracle OLAP RDBMS Files                                              11.2.0.3.0

Oracle One-Off Patch Installer                                       11.2.0.1.7

Oracle Partitioning                                                  11.2.0.3.0

Oracle Programmer                                                    11.2.0.3.0

Oracle Quality of Service Management (Client)                        11.2.0.3.0

Oracle RAC Deconfiguration                                           11.2.0.3.0

Oracle RAC Required Support Files-HAS                                11.2.0.3.0

Oracle Real Application Testing                                      11.2.0.3.0

Oracle Recovery Manager                                              11.2.0.3.0

Oracle Security Developer Tools                                      11.2.0.3.0

Oracle Spatial                                                       11.2.0.3.0

Oracle SQL Developer                                                 11.2.0.3.0

Oracle Starter Database                                              11.2.0.3.0

Oracle Text                                                          11.2.0.3.0

Oracle Text Required Support Files                                   11.2.0.3.0

Oracle UIX                                                           2.2.24.6.0

Oracle Universal Connection Pool                                     11.2.0.3.0

Oracle Universal Installer                                           11.2.0.3.0

Oracle USM Deconfiguration                                           11.2.0.3.0

Oracle Wallet Manager                                                11.2.0.3.0

Oracle XML Development Kit                                           11.2.0.3.0

Oracle XML Query                                                     11.2.0.3.0

Parser Generator Required Support Files                              11.2.0.3.0

Perl Interpreter                                                     5.10.0.0.2

Perl Modules                                                         5.10.0.0.1

PL/SQL                                                               11.2.0.3.0

PL/SQL Embedded Gateway                                              11.2.0.3.0

Platform Required Support Files                                      11.2.0.3.0

Precompiler Common Files                                             11.2.0.3.0

Precompiler Required Support Files                                   11.2.0.3.0

Provisioning Advisor Framework                                       10.2.0.4.3

RDBMS Required Support Files                                         11.2.0.3.0

RDBMS Required Support Files for Instant Client                      11.2.0.3.0

RDBMS Required Support Files Runtime                                 11.2.0.3.0

regexp                                                                2.1.9.0.0

Required Support Files                                               11.2.0.3.0

Sample Schema Data                                                   11.2.0.3.0

Secure Socket Layer                                                  11.2.0.3.0

SQL*Plus                                                             11.2.0.3.0

SQL*Plus Files for Instant Client                                    11.2.0.3.0

SQL*Plus Required Support Files                                      11.2.0.3.0

SQLJ Runtime                                                         11.2.0.3.0

SSL Required Support Files for InstantClient                         11.2.0.3.0

Sun JDK                                                             1.5.0.30.03

XDK Required Support Files                                           11.2.0.3.0

XML Parser for Java                                                  11.2.0.3.0

XML Parser for Oracle JVM                                            11.2.0.3.0

There are 136 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

--------------------------------------------------------------------------------

OPatch succeeded.

[oracle@san ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $GRID_HOME

Oracle Interim Patch Installer version 11.2.0.3.5

Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/11.2.0.3/grid

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/11.2.0.3/grid//oraInst.loc

OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : /u01/app/11.2.0.3/grid/cfgtoollogs/opatch/opatch2013-08-24_19-25-16PM_1.log

Lsinventory Output file location : /u01/app/11.2.0.3/grid/cfgtoollogs/opatch/lsinv/lsinventory2013-08-24_19-25-16PM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (1):

Oracle Grid Infrastructure                                           11.2.0.3.0

There are 1 products installed in this Oracle Home.

Installed Products (88):

Agent Required Support Files                                         10.2.0.4.3

Assistant Common Files                                               11.2.0.3.0

Automatic Storage Management Assistant                               11.2.0.3.0

Bali Share                                                           1.1.18.0.0

Buildtools Common Files                                              11.2.0.3.0

Character Set Migration Utility                                      11.2.0.3.0

Cluster Ready Services Files                                         11.2.0.3.0

Cluster Verification Utility Common Files                            11.2.0.3.0

Cluster Verification Utility Files                                   11.2.0.3.0

Database SQL Scripts                                                 11.2.0.3.0

Deinstallation Tool                                                  11.2.0.3.0

Enterprise Manager Common Core Files                                 10.2.0.4.4

Enterprise Manager Common Files                                      10.2.0.4.3

Enterprise Manager plugin Common Files                               11.2.0.3.0

Expat libraries                                                       2.0.1.0.1

HAS Common Files                                                     11.2.0.3.0

HAS Files for DB                                                     11.2.0.3.0

Installation Common Files                                            11.2.0.3.0

Installation Plugin Files                                            11.2.0.3.0

Installer SDK Component                                              11.2.0.3.0

LDAP Required Support Files                                          11.2.0.3.0

OLAP SQL Scripts                                                     11.2.0.3.0

Oracle Clusterware RDBMS Files                                       11.2.0.3.0

Oracle Configuration Manager Deconfiguration                         10.3.1.0.0

Oracle Containers for Java                                           11.2.0.3.0

Oracle Core Required Support Files                                   11.2.0.3.0

Oracle Database 11g                                                  11.2.0.3.0

Oracle Database 11g Multimedia Files                                 11.2.0.3.0

Oracle Database Deconfiguration                                      11.2.0.3.0

Oracle Database User Interface                                       2.2.13.0.0

Oracle Database Utilities                                            11.2.0.3.0

Oracle DBCA Deconfiguration                                          11.2.0.3.0

Oracle Extended Windowing Toolkit                                    3.4.47.0.0

Oracle Globalization Support                                         11.2.0.3.0

Oracle Globalization Support                                         11.2.0.3.0

Oracle Grid Infrastructure                                           11.2.0.3.0

Oracle Help For Java                                                  4.2.9.0.0

Oracle Ice Browser                                                    5.2.3.6.0

Oracle Internet Directory Client                                     11.2.0.3.0

Oracle Java Client                                                   11.2.0.3.0

Oracle JDBC/OCI Instant Client                                       11.2.0.3.0

Oracle JDBC/THIN Interfaces                                          11.2.0.3.0

Oracle JFC Extended Windowing Toolkit                                4.2.36.0.0

Oracle JVM                                                           11.2.0.3.0

Oracle LDAP administration                                           11.2.0.3.0

Oracle Locale Builder                                                11.2.0.3.0

Oracle Multimedia                                                    11.2.0.3.0

Oracle Multimedia Client Option                                      11.2.0.3.0

Oracle Multimedia Java Advanced Imaging                              11.2.0.3.0

Oracle Multimedia Locator                                            11.2.0.3.0

Oracle Multimedia Locator RDBMS Files                                11.2.0.3.0

Oracle Net                                                           11.2.0.3.0

Oracle Net Listener                                                  11.2.0.3.0

Oracle Net Required Support Files                                    11.2.0.3.0

Oracle Netca Client                                                  11.2.0.3.0

Oracle Notification Service                                          11.2.0.3.0

Oracle Notification Service (eONS)                                   11.2.0.3.0

Oracle One-Off Patch Installer                                       11.2.0.1.7

Oracle Quality of Service Management (Client)                        11.2.0.3.0

Oracle Quality of Service Management (Server)                        11.2.0.3.0

Oracle RAC Deconfiguration                                           11.2.0.3.0

Oracle RAC Required Support Files-HAS                                11.2.0.3.0

Oracle Recovery Manager                                              11.2.0.3.0

Oracle Security Developer Tools                                      11.2.0.3.0

Oracle Text Required Support Files                                   11.2.0.3.0

Oracle Universal Installer                                           11.2.0.3.0

Oracle USM Deconfiguration                                           11.2.0.3.0

Oracle Wallet Manager                                                11.2.0.3.0

Parser Generator Required Support Files                              11.2.0.3.0

Perl Interpreter                                                     5.10.0.0.2

Perl Modules                                                         5.10.0.0.1

PL/SQL                                                               11.2.0.3.0

PL/SQL Embedded Gateway                                              11.2.0.3.0

Platform Required Support Files                                      11.2.0.3.0

Precompiler Required Support Files                                   11.2.0.3.0

RDBMS Required Support Files                                         11.2.0.3.0

RDBMS Required Support Files for Instant Client                      11.2.0.3.0

RDBMS Required Support Files Runtime                                 11.2.0.3.0

Required Support Files                                               11.2.0.3.0

Secure Socket Layer                                                  11.2.0.3.0

SQL*Plus                                                             11.2.0.3.0

SQL*Plus Files for Instant Client                                    11.2.0.3.0

SQL*Plus Required Support Files                                      11.2.0.3.0

SSL Required Support Files for InstantClient                         11.2.0.3.0

Sun JDK                                                             1.5.0.30.03

Universal Storage Manager Files                                      11.2.0.3.0

XDK Required Support Files                                           11.2.0.3.0

XML Parser for Java                                                  11.2.0.3.0

There are 88 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

--------------------------------------------------------------------------------

OPatch succeeded.

[oracle@san ~]$

Note: I changed prompt so that I would know what home I am in, i.e. pldb01:DB / +ASM:GI

Create ocm.rsp

[oracle@san:pdb01:~]$ $ORACLE_HOME/OPatch/ocm/bin/emocmrsp

OCM Installation Response Generator 10.3.4.0.0 - Production

Copyright (c) 2005, 2010, Oracle and/or its affiliates.  All rights reserved.

Provide your email address to be informed of security issues, install and

initiate Oracle Configuration Manager. Easier for you if you use your My

Oracle Support Email address/User Name.

Visit http://www.oracle.com/support/policies.html for details.

Email address/User Name:

You have not provided an email address for notification of security issues.

Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]:  Y

The OCM configuration response file (ocm.rsp) was successfully created.

[oracle@san:pdb01:~]$ ls ocm.rsp

ocm.rsp

[oracle@san:pdb01:~]$

Stop database home on the node

[oracle@san:pdb01:~]$ srvctl stop home -o $ORACLE_HOME -s /tmp/statefile.out

[oracle@san:pdb01:~]$ cat /tmp/statefile.out

db-pdb01

[oracle@san:pdb01:~]$ sysresv

IPC Resources for ORACLE_SID "pdb01" :

Shared Memory

ID              KEY

No shared memory segments used

Semaphores:

ID              KEY

No semaphore resources used

Oracle Instance not alive for sid "pdb01"

[oracle@san:pdb01:~]$

Save database home configuration

gi_psu_patch_no/custom/server/gi_psu_patch_no/custom/scripts/prepatch.sh -dbhome <ORACLE_HOME>

[oracle@san:pdb01:16742216]$ ./16619898/custom/server/16619898/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME

./16619898/custom/server/16619898/custom/scripts/prepatch.sh completed successfully.

[oracle@san:pdb01:16742216]$

Stop GI and unlock Grid Infrastructure home

[oracle@san:+ASM:~]$ srvctl stop asm

PRCR-1065 : Failed to stop resource ora.asm

CRS-2529: Unable to act on 'ora.asm' because that would require stopping or relocating 'ora.DATA1.dg', but the force option was not specified

oracle@san:+ASM:~]$ crsctl stop has

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'san'

CRS-2673: Attempting to stop 'ora.DATA1.dg' on 'san'

CRS-2677: Stop of 'ora.DATA1.dg' on 'san' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'san'

CRS-2677: Stop of 'ora.asm' on 'san' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'san'

CRS-2677: Stop of 'ora.cssd' on 'san' succeeded

CRS-2673: Attempting to stop 'ora.evmd' on 'san'

CRS-2677: Stop of 'ora.evmd' on 'san' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'san' has completed

CRS-4133: Oracle High Availability Services has been stopped.

oracle@san:+ASM:~]$ ps -ef|grep [p]mon

oracle@san:+ASM:~]$

As root, execute

[root@san ~]# export GRID_HOME=/u01/app/11.2.0.3/grid

[root@san ~]# $GRID_HOME/crs/install/roothas.pl -unlock

Using configuration parameter file: /u01/app/11.2.0.3/grid/crs/install/crsconfig_params

Successfully unlock /u01/app/11.2.0.3/grid

[root@san ~]#

Patch Grid home

[oracle@san:+ASM:~]$ export GRID_HOME=$ORACLE_HOME

[oracle@san:+ASM:~]$ echo $GRID_HOME $ORACLE_HOME

/u01/app/11.2.0.3/grid /u01/app/11.2.0.3/grid

[oracle@san:+ASM:~]$ cd /tmp/16742216/

[oracle@san:+ASM:16742216]$ $GRID_HOME/OPatch/opatch napply -oh $GRID_HOME -ocmrf /home/oracle/ocm.rsp

Oracle Interim Patch Installer version 11.2.0.3.5

Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/11.2.0.3/grid

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/11.2.0.3/grid/oraInst.loc

OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : /u01/app/11.2.0.3/grid/cfgtoollogs/opatch/opatch2013-08-24_20-21-04PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   13343438  13696216  13923374  14275605  14727310  16056266  16619892  16619898

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/11.2.0.3/grid')

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying sub-patch '13343438' to OH '/u01/app/11.2.0.3/grid'

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 '/u01/app/11.2.0.3/grid'

ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ]  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.sdo.locator, 11.2.0.3.0...

Verifying the update...

Applying sub-patch '13923374' to OH '/u01/app/11.2.0.3/grid'

ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ 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...

Verifying the update...

Applying sub-patch '14275605' to OH '/u01/app/11.2.0.3/grid'

ApplySession: Optional component(s) [ oracle.precomp.common, 11.2.0.3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.client, 11.2.0.3.0...

Patching component oracle.network.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.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms.util, 11.2.0.3.0...

Verifying the update...

Applying sub-patch '14727310' to OH '/u01/app/11.2.0.3/grid'

ApplySession: Optional component(s) [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.oms.core, 10.2.0.4.4 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Verifying the update...

Applying sub-patch '16056266' to OH '/u01/app/11.2.0.3/grid'

ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ] , [ oracle.ovm, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.listener, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.rdbms.deconfig, 11.2.0.3.0...

Verifying the update...

Applying sub-patch '16619892' to OH '/u01/app/11.2.0.3/grid'

ApplySession: Optional component(s) [ oracle.marvel, 11.2.0.3.0 ] , [ oracle.precomp.common, 11.2.0.3.0 ] , [ oracle.precomp.lang, 11.2.0.3.0 ] , [ oracle.sysman.agent, 10.2.0.4.3 ] , [ oracle.sysman.console.db, 11.2.0.3.0 ] , [ oracle.sysman.repository.core, 10.2.0.4.4 ] , [ oracle.xdk, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.xdk.parser.java, 11.2.0.3.0...

Patching component oracle.xdk.rsf, 11.2.0.3.0...

Verifying the update...

Applying interim patch '16619898' to OH '/u01/app/11.2.0.3/grid'

Patching component oracle.crs, 11.2.0.3.0...

Patching component oracle.usm, 11.2.0.3.0...

Verifying the update...

Composite patch 16619892 successfully applied.

Patch 16619898 successfully applied.

Log file location: /u01/app/11.2.0.3/grid/cfgtoollogs/opatch/opatch2013-08-24_20-21-04PM_1.log

OPatch succeeded.

Validate GI_PSU for Grid home

[oracle@san:+ASM:16742216]$ $GRID_HOME/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.5

Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/11.2.0.3/grid

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/11.2.0.3/grid/oraInst.loc

OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : /u01/app/11.2.0.3/grid/cfgtoollogs/opatch/opatch2013-08-24_22-13-38PM_1.log

Lsinventory Output file location : /u01/app/11.2.0.3/grid/cfgtoollogs/opatch/lsinv/lsinventory2013-08-24_22-13-38PM.txt

--------------------------------------------------------------------------------

Installed Top-level Products (1):

Oracle Grid Infrastructure                                           11.2.0.3.0

There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch  16619898     : applied on Sat Aug 24 22:12:17 GMT-08:00 2013

Unique Patch ID:  16376391

Patch description:  "Grid Infrastructure Patch Set Update : 11.2.0.3.7 (16742216)"

   Created on 24 Jun 2013, 22:52:45 hrs PST8PDT

   Bugs fixed:

     16619898, 16315641, 15876003, 14275572, 13919095, 13696251, 13348650

     12659561, 14305980, 14277586, 13987807, 14625969, 13825231, 12794268

     13000491, 13498267, 15934834, 11675721, 14082976, 12771830, 14515980

     14085018, 13943175, 14102704, 14171552, 12594616, 13879428, 12897902

     12726222, 12829429, 13079948, 13090686, 12995950, 13251796, 13582411

     12990582, 13857364, 15856610, 13082238, 12947871, 13256955, 13037709

     14535011, 12878750, 14048512, 11772838, 13058611, 13001955, 13440962

     13727853, 13425727, 12885323, 12870400, 14212634, 14407395, 13332363

     13430626, 13811209, 12709476, 14168708, 14096821, 14626717, 13460353

     13694885, 12857064, 12899169, 13111013, 12558569, 13323698, 10260842

     13085732, 16555186, 10317921, 16077216, 13869978, 12914824, 13789135

     12730342, 12950823, 13355963, 13531373, 14268365, 13776758, 12720728

     13620816, 13023609, 16578706, 13024624, 13039908, 15911134, 13036424

     13938166, 13011520, 13569812, 12758736, 13001901, 13077654, 13430715

     13550689, 13806545, 13634583, 14271305, 12538907, 13947200, 12996428

     13066371, 13483672, 12897651, 13540563, 12896850, 13241779, 12728585

     12876314, 12925041, 12650672, 12398492, 12848480, 13652088, 16307750

     12917897, 12975811, 13653178, 13371153, 14800989, 10114953, 14001941

     11836951, 14179376, 12965049, 14773530, 12765467, 12950415, 15998768

     13339443, 13965075, 16210540, 14307855, 12784559, 14242977, 13955385

     12704789, 13745317, 13074261, 12971251, 13993634, 13523527, 13719731

     13396284, 12639013, 12867511, 12959140, 14748254, 13912274, 12829917

     12349553, 12849377, 12934171, 13843080, 14496536, 13899736, 13924431

     12680491, 13334158, 10418841, 12832204, 13838047, 13002015, 14639430

     15920201, 12791719, 13886023, 13821454, 12782756, 14100232, 14186070

     14569263, 12873909, 13845120, 14214257, 12914722, 12842804, 12772345

     12663376, 14059576, 13889047, 12695029, 13924910, 13146560, 14070200

     13820621, 14304758, 12996572, 13941934, 14711358, 13019958, 13888719

     16463033, 12823838, 13877508, 12983005, 12823042, 16436434, 14494305

     13582706, 13617861, 12825835, 13025879, 13853089, 13410987, 13570879

     13247273, 13255295, 14152875, 13912373, 13011182, 13243172, 15978267

     13045518, 12765868, 11825850, 15986571, 13345868, 13683090, 12932852

     13038806, 14588629, 14251904, 13396356, 13697828, 12834777, 13258062

     14371335, 13657366, 12810890, 15917085, 13502441, 14637577, 13880925

     13726162, 14153867, 13506114, 12820045, 13604057, 13506408, 13542331

     13263435, 14009845, 12827493, 13637590, 13068077

Patch  16619892     : applied on Sat Aug 24 22:11:31 GMT-08:00 2013

Unique Patch ID:  16346737

Patch description:  "Database Patch Set Update : 11.2.0.3.7 (16619892)"

   Created on 23 Jun 2013, 09:03:20 hrs PST8PDT

Sub-patch  16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"

Sub-patch  14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"

Sub-patch  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"

Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"

Sub-patch  13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"

Sub-patch  13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"

   Bugs fixed:

     13593999, 13566938, 10350832, 14138130, 12919564, 13561951, 13624984

     13588248, 13080778, 13914613, 13804294, 14258925, 12873183, 13645875

     14472647, 12880299, 14664355, 12998795, 14409183, 13719081, 14469008

     13492735, 14263036, 12857027, 13496884, 13015379, 14263073, 13742433

     13732226, 16314469, 16368108, 12905058, 6690853, 13742434, 12849688

     12950644, 13742435, 13464002, 13063120, 13534412, 12879027, 13958038

     14613900, 12585543, 13790109, 12535346, 16382448, 12588744, 11877623

     12395918, 13814739, 13786142, 12847466, 13649031, 13855490, 13981051

     12582664, 12797765, 14262913, 12923168, 16279401, 12912137, 13612575

     13384182, 13466801, 13484963, 14207163, 13724193, 13772618, 11063191

     16694777, 13070939, 12797420, 15869211, 13041324, 16279211, 16314467

     16314468, 12976376, 11708510, 13680405, 13742437, 13026410, 14589750

     13737746, 13742438, 14644185, 15841373, 13326736, 13596521, 14398795

     13579992, 13001379, 16344871, 13099577, 9873405, 13742436, 14275605

     9858539, 14841812, 11715084, 16231699, 14040433, 9703627, 12662040

     12617123, 16530565, 14207317, 12845115, 12764337, 13354082, 14459552

     13397104, 13913630, 12964067, 12983611, 13550185, 12780983, 13810393

     12583611, 14546575, 15862016, 13476583, 13489024, 11840910, 13903046

     15862017, 13572659, 16294378, 13718279, 14088346, 13657605, 13448206

     16314466, 14480676, 13419660, 13632717, 14668670, 14063281, 14110275

     13430938, 13467683, 13420224, 13812031, 14548763, 16299830, 12646784

     14512189, 12755116, 14035825, 13616375, 13427062, 12861463, 12834027

     15862021, 13632809, 13377816, 13036331, 14727310, 16619892, 13685544

     13499128, 15862018, 13584130, 16175381, 12829021, 15862019, 12794305

     14546673, 12791981, 13561750, 13503598, 13787482, 10133521, 12718090

     13848402, 13399435, 14023636, 9095696, 13860201, 12401111, 13257247

     13362079, 14176879, 12917230, 16014985, 13923374, 14220725, 13524899

     14480675, 16306019, 13559697, 12974860, 9706792, 12940620, 14480674

     13916709, 13098318, 14076523, 13773133, 15905421, 16794244, 13340388

     12731940, 13528551, 13366202, 12894807, 13343438, 13454210, 12748240

     14205448, 13385346, 14127231, 15853081, 14273397, 14467061, 12971775

     13923995, 14571027, 13582702, 13907462, 10242202, 13493847, 13857111

     13035804, 13544396, 16382353, 8547978, 14226599, 16794241, 14062795

     13035360, 12925089, 12693626, 13332439, 14038787, 11071989, 14062796

     16794243, 12913474, 14841409, 14390252, 16314470, 13370330, 13059165

     14062797, 14062794, 12959852, 12345082, 13358781, 12960925, 16703112

     9659614, 14546638, 13699124, 13936424, 14301592, 16794240, 13338048

     12938841, 12658411, 12620823, 12656535, 14062793, 12678920, 13038684

     14062792, 13807411, 16742095, 16794238, 15862022, 12594032, 13250244

     12612118, 9761357, 14053457, 13742464, 14052474, 13911821, 13457582

     7509451, 13527323, 13791364, 15862020, 13910420, 12780098, 13502183

     13696216, 13705338, 10263668, 14841558, 16794242, 15862023, 16056266

     16794239, 15862024, 13554409, 13645917, 13103913, 12772404, 13011409, 14063280

--------------------------------------------------------------------------------

OPatch succeeded.

[oracle@san:+ASM:16742216]$

Patch GI_PSU for database home

opatch napply gi_psu_patch_no/custom/server/ -oh <ORACLE_HOME> -id gi_psu_patch_no

[oracle@san:pdb01:16742216]$ $ORACLE_HOME/OPatch/opatch napply 16619898/custom/server/ -oh $ORACLE_HOME -id 16619898 -ocmrf /home/oracle/ocm.rsp

Oracle Interim Patch Installer version 11.2.0.3.5

Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0.3/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0.3/dbhome_1/oraInst.loc

OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2013-08-24_20-30-28PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   16619898

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/product/11.2.0.3/dbhome_1')

Is the local system ready for patching? [y|n]

y

User Responded with: Y

Backing up files...

Applying interim patch '16619898' to OH '/u01/app/oracle/product/11.2.0.3/dbhome_1'

Patching component oracle.rdbms, 11.2.0.3.0...

Verifying the update...

Patch 16619898 successfully applied.

Log file location: /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2013-08-24_20-30-28PM_1.log

OPatch succeeded.

Validate GI_PSU for database home

[oracle@san:pdb01:16742216]$ $ORACLE_HOME/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.5

Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0.3/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0.3/dbhome_1/oraInst.loc

OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2013-08-24_22-20-41PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-08-24_22-20-41PM.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  16619898     : applied on Sat Aug 24 22:20:00 GMT-08:00 2013

Unique Patch ID:  16376391

Patch description:  "Grid Infrastructure Patch Set Update : 11.2.0.3.7 (16742216)"

   Created on 24 Jun 2013, 22:52:45 hrs PST8PDT

   Bugs fixed:

     16619898, 16315641, 15876003, 14275572, 13919095, 13696251, 13348650

     12659561, 14305980, 14277586, 13987807, 14625969, 13825231, 12794268

     13000491, 13498267, 15934834, 11675721, 14082976, 12771830, 14515980

     14085018, 13943175, 14102704, 14171552, 12594616, 13879428, 12897902

     12726222, 12829429, 13079948, 13090686, 12995950, 13251796, 13582411

     12990582, 13857364, 15856610, 13082238, 12947871, 13256955, 13037709

     14535011, 12878750, 14048512, 11772838, 13058611, 13001955, 13440962

     13727853, 13425727, 12885323, 12870400, 14212634, 14407395, 13332363

     13430626, 13811209, 12709476, 14168708, 14096821, 14626717, 13460353

     13694885, 12857064, 12899169, 13111013, 12558569, 13323698, 10260842

     13085732, 16555186, 10317921, 16077216, 13869978, 12914824, 13789135

     12730342, 12950823, 13355963, 13531373, 14268365, 13776758, 12720728

     13620816, 13023609, 16578706, 13024624, 13039908, 15911134, 13036424

     13938166, 13011520, 13569812, 12758736, 13001901, 13077654, 13430715

     13550689, 13806545, 13634583, 14271305, 12538907, 13947200, 12996428

     13066371, 13483672, 12897651, 13540563, 12896850, 13241779, 12728585

     12876314, 12925041, 12650672, 12398492, 12848480, 13652088, 16307750

     12917897, 12975811, 13653178, 13371153, 14800989, 10114953, 14001941

     11836951, 14179376, 12965049, 14773530, 12765467, 12950415, 15998768

     13339443, 13965075, 16210540, 14307855, 12784559, 14242977, 13955385

     12704789, 13745317, 13074261, 12971251, 13993634, 13523527, 13719731

     13396284, 12639013, 12867511, 12959140, 14748254, 13912274, 12829917

     12349553, 12849377, 12934171, 13843080, 14496536, 13899736, 13924431

     12680491, 13334158, 10418841, 12832204, 13838047, 13002015, 14639430

     15920201, 12791719

--------------------------------------------------------------------------------

OPatch succeeded.

[oracle@san:pdb01:16742216]$

Patch DB_PSU for database home

opatch napply -oh <ORACLE_HOME> -id db_psu_patch_no - This step is not correct from the document

[oracle@san:pdb01:16742216]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -id 16619892

Oracle Interim Patch Installer version 11.2.0.3.5

Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0.3/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0.3/dbhome_1/oraInst.loc

OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2013-08-24_20-43-31PM_1.log

Verifying environment and performing prerequisite checks...

UtilSession failed:

Patch "16619892" is invalid (or) doesn't exist among the given individual patches.

Please specify a list of patch IDs separated by commas without spaces.

Log file location: /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2013-08-24_20-43-31PM_1.log

OPatch failed with error code 73

[oracle@san:pdb01:16742216]$

opatch apply -local -oh $ORACLE_HOME 16619892 -ocmrf /home/oracle/ocm.rsp

[oracle@san:pdb01:16742216]$ $ORACLE_HOME/OPatch/opatch apply -local -oh $ORACLE_HOME 16619892 -ocmrf /home/oracle/ocm.rsp

Oracle Interim Patch Installer version 11.2.0.3.5

Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0.3/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0.3/dbhome_1/oraInst.loc

OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2013-08-24_20-39-33PM_1.log

Verifying environment and performing prerequisite checks...

OPatch continues with these patches:   13343438  13696216  13923374  14275605  14727310  16056266  16619892

Do you want to proceed? [y|n]

y

User Responded with: Y

All checks passed.

Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.

(Oracle Home = '/u01/app/oracle/product/11.2.0.3/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 '/u01/app/oracle/product/11.2.0.3/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 '/u01/app/oracle/product/11.2.0.3/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 '/u01/app/oracle/product/11.2.0.3/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...

Applying sub-patch '14275605' to OH '/u01/app/oracle/product/11.2.0.3/dbhome_1'

ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.client, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.precomp.common, 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.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms.util, 11.2.0.3.0...

Verifying the update...

Applying sub-patch '14727310' to OH '/u01/app/oracle/product/11.2.0.3/dbhome_1'

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 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 '16056266' to OH '/u01/app/oracle/product/11.2.0.3/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.network.listener, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.ovm, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.rdbms.deconfig, 11.2.0.3.0...

Verifying the update...

Applying sub-patch '16619892' to OH '/u01/app/oracle/product/11.2.0.3/dbhome_1'

ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.marvel, 11.2.0.3.0...

Patching component oracle.precomp.common, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sysman.agent, 10.2.0.4.3...

Patching component oracle.sysman.console.db, 11.2.0.3.0...

Patching component oracle.sysman.repository.core, 10.2.0.4.4...

Patching component oracle.xdk, 11.2.0.3.0...

Patching component oracle.xdk.parser.java, 11.2.0.3.0...

Patching component oracle.xdk.rsf, 11.2.0.3.0...

Verifying the update...

OPatch found the word "warning" in the stderr of the make command.

Please look at this stderr. You can re-run this make command.

Stderr output:

ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'

/u01/app/oracle/product/11.2.0.3/dbhome_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'

/u01/app/oracle/product/11.2.0.3/dbhome_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'

/u01/app/oracle/product/11.2.0.3/dbhome_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'

OPatch found the word "warning" in the stderr of the make command.

Please look at this stderr. You can re-run this make command.

Stderr output:

ins_emagent.mk:113: warning: overriding commands for target `nmosudo'

ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'

/u01/app/oracle/product/11.2.0.3/dbhome_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'

/u01/app/oracle/product/11.2.0.3/dbhome_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'

Composite patch 16619892 successfully applied.

OPatch Session completed with warnings.

Log file location: /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2013-08-24_20-39-33PM_1.log

OPatch completed with warnings.

Validate DB_PSU for database home

[oracle@san:pdb01:16742216]$ $ORACLE_HOME/OPatch/opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.5

Copyright (c) 2013, Oracle Corporation.  All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0.3/dbhome_1

Central Inventory : /u01/app/oraInventory

   from           : /u01/app/oracle/product/11.2.0.3/dbhome_1/oraInst.loc

OPatch version    : 11.2.0.3.5

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2013-08-24_22-25-42PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-08-24_22-25-42PM.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 (2) :

Patch  16619892     : applied on Sat Aug 24 22:25:09 GMT-08:00 2013

Unique Patch ID:  16346737

Patch description:  "Database Patch Set Update : 11.2.0.3.7 (16619892)"

   Created on 23 Jun 2013, 09:03:20 hrs PST8PDT

Sub-patch  16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"

Sub-patch  14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"

Sub-patch  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"

Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"

Sub-patch  13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"

Sub-patch  13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"

   Bugs fixed:

     13593999, 13566938, 10350832, 14138130, 12919564, 13561951, 13624984

     13588248, 13080778, 13914613, 13804294, 14258925, 12873183, 13645875

     14472647, 12880299, 14664355, 12998795, 14409183, 13719081, 14469008

     13492735, 14263036, 12857027, 13496884, 13015379, 14263073, 13742433

     13732226, 16314469, 16368108, 12905058, 6690853, 13742434, 12849688

     12950644, 13742435, 13464002, 13063120, 13534412, 12879027, 13958038

     14613900, 12585543, 13790109, 12535346, 16382448, 12588744, 11877623

     12395918, 13814739, 13786142, 12847466, 13649031, 13855490, 13981051

     12582664, 12797765, 14262913, 12923168, 16279401, 12912137, 13612575

     13384182, 13466801, 13484963, 14207163, 13724193, 13772618, 11063191

     16694777, 13070939, 12797420, 15869211, 13041324, 16279211, 16314467

     16314468, 12976376, 11708510, 13680405, 13742437, 13026410, 14589750

     13737746, 13742438, 14644185, 15841373, 13326736, 13596521, 14398795

     13579992, 13001379, 16344871, 13099577, 9873405, 13742436, 14275605

     9858539, 14841812, 11715084, 16231699, 14040433, 9703627, 12662040

     12617123, 16530565, 14207317, 12845115, 12764337, 13354082, 14459552

     13397104, 13913630, 12964067, 12983611, 13550185, 12780983, 13810393

     12583611, 14546575, 15862016, 13476583, 13489024, 11840910, 13903046

     15862017, 13572659, 16294378, 13718279, 14088346, 13657605, 13448206

     16314466, 14480676, 13419660, 13632717, 14668670, 14063281, 14110275

     13430938, 13467683, 13420224, 13812031, 14548763, 16299830, 12646784

     14512189, 12755116, 14035825, 13616375, 13427062, 12861463, 12834027

     15862021, 13632809, 13377816, 13036331, 14727310, 16619892, 13685544

     13499128, 15862018, 13584130, 16175381, 12829021, 15862019, 12794305

     14546673, 12791981, 13561750, 13503598, 13787482, 10133521, 12718090

     13848402, 13399435, 14023636, 9095696, 13860201, 12401111, 13257247

     13362079, 14176879, 12917230, 16014985, 13923374, 14220725, 13524899

     14480675, 16306019, 13559697, 12974860, 9706792, 12940620, 14480674

     13916709, 13098318, 14076523, 13773133, 15905421, 16794244, 13340388

     12731940, 13528551, 13366202, 12894807, 13343438, 13454210, 12748240

     14205448, 13385346, 14127231, 15853081, 14273397, 14467061, 12971775

     13923995, 14571027, 13582702, 13907462, 10242202, 13493847, 13857111

     13035804, 13544396, 16382353, 8547978, 14226599, 16794241, 14062795

     13035360, 12925089, 12693626, 13332439, 14038787, 11071989, 14062796

     16794243, 12913474, 14841409, 14390252, 16314470, 13370330, 13059165

     14062797, 14062794, 12959852, 12345082, 13358781, 12960925, 16703112

     9659614, 14546638, 13699124, 13936424, 14301592, 16794240, 13338048

     12938841, 12658411, 12620823, 12656535, 14062793, 12678920, 13038684

     14062792, 13807411, 16742095, 16794238, 15862022, 12594032, 13250244

     12612118, 9761357, 14053457, 13742464, 14052474, 13911821, 13457582

     7509451, 13527323, 13791364, 15862020, 13910420, 12780098, 13502183

     13696216, 13705338, 10263668, 14841558, 16794242, 15862023, 16056266

     16794239, 15862024, 13554409, 13645917, 13103913, 12772404, 13011409, 14063280

Patch  16619898     : applied on Sat Aug 24 22:20:00 GMT-08:00 2013

Unique Patch ID:  16376391

Patch description:  "Grid Infrastructure Patch Set Update : 11.2.0.3.7 (16742216)"

   Created on 24 Jun 2013, 22:52:45 hrs PST8PDT

   Bugs fixed:

     16619898, 16315641, 15876003, 14275572, 13919095, 13696251, 13348650

     12659561, 14305980, 14277586, 13987807, 14625969, 13825231, 12794268

     13000491, 13498267, 15934834, 11675721, 14082976, 12771830, 14515980

     14085018, 13943175, 14102704, 14171552, 12594616, 13879428, 12897902

     12726222, 12829429, 13079948, 13090686, 12995950, 13251796, 13582411

     12990582, 13857364, 15856610, 13082238, 12947871, 13256955, 13037709

     14535011, 12878750, 14048512, 11772838, 13058611, 13001955, 13440962

     13727853, 13425727, 12885323, 12870400, 14212634, 14407395, 13332363

     13430626, 13811209, 12709476, 14168708, 14096821, 14626717, 13460353

     13694885, 12857064, 12899169, 13111013, 12558569, 13323698, 10260842

     13085732, 16555186, 10317921, 16077216, 13869978, 12914824, 13789135

     12730342, 12950823, 13355963, 13531373, 14268365, 13776758, 12720728

     13620816, 13023609, 16578706, 13024624, 13039908, 15911134, 13036424

     13938166, 13011520, 13569812, 12758736, 13001901, 13077654, 13430715

     13550689, 13806545, 13634583, 14271305, 12538907, 13947200, 12996428

     13066371, 13483672, 12897651, 13540563, 12896850, 13241779, 12728585

     12876314, 12925041, 12650672, 12398492, 12848480, 13652088, 16307750

     12917897, 12975811, 13653178, 13371153, 14800989, 10114953, 14001941

     11836951, 14179376, 12965049, 14773530, 12765467, 12950415, 15998768

     13339443, 13965075, 16210540, 14307855, 12784559, 14242977, 13955385

     12704789, 13745317, 13074261, 12971251, 13993634, 13523527, 13719731

     13396284, 12639013, 12867511, 12959140, 14748254, 13912274, 12829917

     12349553, 12849377, 12934171, 13843080, 14496536, 13899736, 13924431

     12680491, 13334158, 10418841, 12832204, 13838047, 13002015, 14639430

     15920201, 12791719

--------------------------------------------------------------------------------

OPatch succeeded.

[oracle@san:pdb01:16742216]$

Restore database home configuration

gi_psu_patch_no/custom/server/gi_psu_patch_no/custom/scripts/postpatch.sh -dbhome <ORACLE_HOME>

[oracle@san:pdb01:16742216]$ ./16619898/custom/server/16619898/custom/scripts//postpatch.sh -dbhome $ORACLE_HOME

Reading /u01/app/oracle/product/11.2.0.3/dbhome_1/install/params.ora..

Reading /u01/app/oracle/product/11.2.0.3/dbhome_1/install/params.ora..

Parsing file /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/racgwrap

Parsing file /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/srvctl

Parsing file /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/srvconfig

Parsing file /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/cluvfy

Verifying file /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/racgwrap

Verifying file /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/srvctl

Verifying file /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/srvconfig

Verifying file /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/cluvfy

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/racgwrap

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/srvctl

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/srvconfig

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/cluvfy

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/diskmon.bin

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/lsnodes

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/osdbagrp

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/rawutl

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/srvm/admin/ractrans

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/srvm/admin/getcrshome

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/gnsd

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/bin/crsdiag.pl

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/lib/libhasgen11.so

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/lib/libclsra11.so

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/lib/libdbcfg11.so

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/lib/libocr11.so

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/lib/libocrb11.so

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/lib/libocrutl11.so

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/lib/libuini11.so

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/lib/librdjni11.so

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/lib/libgns11.so

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/lib/libgnsjni11.so

Reapplying file permissions on /u01/app/oracle/product/11.2.0.3/dbhome_1/lib/libagfw11.so

[oracle@san:pdb01:16742216]$

Re-lock Grid Infrastructure home and start GI

[root@san ~]# $GRID_HOME/rdbms/install/rootadd_rdbms.sh

[root@san ~]# $GRID_HOME/crs/install/roothas.pl -patch

Using configuration parameter file: /u01/app/11.2.0.3/grid/crs/install/crsconfig_params

CRS-4123: Oracle High Availability Services has been started.

[root@san ~]# ps -ef|grep [p]mon

oracle    9424     1  0 21:53 ?        00:00:00 asm_pmon_+ASM

[root@san ~]#

Start database home on the node

[oracle@san:pdb01:~]$ srvctl start home -o $ORACLE_HOME -s /tmp/statefile.out

[oracle@san:pdb01:~]$ sysresv

IPC Resources for ORACLE_SID "pdb01" :

Shared Memory:

ID              KEY

14712846        0x00000000

14745616        0x00000000

14778385        0xfad8d294

Semaphores:

ID              KEY

5275653         0x7c6ffb80

Oracle Instance alive for sid "pdb01"

[oracle@san:pdb01:~]$

Post patch installation for database

[oracle@san:pdb01:~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Sat Aug 24 21:58:10 2013

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, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> @?/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:

/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_PDB01_GENERATE_2013Aug24_21_58_33.log

Apply script: /u01/app/oracle/product/11.2.0.3/dbhome_1/rdbms/admin/catbundle_PSU_PDB01_APPLY.sql

Rollback script: /u01/app/oracle/product/11.2.0.3/dbhome_1/rdbms/admin/catbundle_PSU_PDB01_ROLLBACK.sql

SQL>

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     7,

 10     'PSU',

 11     'PSU 11.2.0.3.7');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SPOOL off

SQL> SET echo off

Check the following log file for errors:

/u01/app/oracle/cfgtoollogs/catbundle/catbundle_PSU_PDB01_APPLY_2013Aug24_21_58_35.log

SQL> @?/rdbms/admin/utlrp.sql

TIMESTAMP

--------------------------------------------------------------------------------

COMP_TIMESTAMP UTLRP_BGN  2013-08-24 22:01:34

1 row selected.

DOC>   The following PL/SQL block invokes UTL_RECOMP to recompile invalid

DOC>   objects in the database. Recompilation time is proportional to the

DOC>   number of invalid objects in the database, so this command may take

DOC>   a long time to execute on a database with a large number of invalid

DOC>   objects.

DOC>

DOC>   Use the following queries to track recompilation progress:

DOC>

DOC>   1. Query returning the number of invalid objects remaining. This

DOC>      number should decrease with time.

DOC>         SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);

DOC>

DOC>   2. Query returning the number of objects compiled so far. This number

DOC>      should increase with time.

DOC>         SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;

DOC>

DOC>   This script automatically chooses serial or parallel recompilation

DOC>   based on the number of CPUs available (parameter cpu_count) multiplied

DOC>   by the number of threads per CPU (parameter parallel_threads_per_cpu).

DOC>   On RAC, this number is added across all RAC nodes.

DOC>

DOC>   UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallel

DOC>   recompilation. Jobs are created without instance affinity so that they

DOC>   can migrate across RAC nodes. Use the following queries to verify

DOC>   whether UTL_RECOMP jobs are being created and run correctly:

DOC>

DOC>   1. Query showing jobs created by UTL_RECOMP

DOC>         SELECT job_name FROM dba_scheduler_jobs

DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';

DOC>

DOC>   2. Query showing UTL_RECOMP jobs that are running

DOC>         SELECT job_name FROM dba_scheduler_running_jobs

DOC>            WHERE job_name like 'UTL_RECOMP_SLAVE_%';

DOC>#

PL/SQL procedure successfully completed.

TIMESTAMP

--------------------------------------------------------------------------------

COMP_TIMESTAMP UTLRP_END  2013-08-24 22:01:37

1 row selected.

DOC> The following query reports the number of objects that have compiled

DOC> with errors.

DOC>

DOC> If the number is higher than expected, please examine the error

DOC> messages reported with each object (using SHOW ERRORS) to see if they

DOC> point to system misconfiguration or resource constraints that must be

DOC> fixed before attempting to recompile these objects.

DOC>#

OBJECTS WITH ERRORS

-------------------

                  0

1 row selected.

DOC> The following query reports the number of errors caught during

DOC> recompilation. If this number is non-zero, please query the error

DOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errors

DOC> are due to misconfiguration or resource constraints that must be

DOC> fixed before objects can compile successfully.

DOC>#

ERRORS DURING RECOMPILATION

---------------------------

                          0

1 row selected.

Function created.

PL/SQL procedure successfully completed.

Function dropped.

PL/SQL procedure successfully completed.

SQL>

Upgrade Oracle Recovery Manager Catalog

$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;