Apply EBS patches on Oracle Exadata

Apply the EBS pre-requistes Patches on Exadata DB

To make exadata Database for EBS database.

 

Table of Contents


Table of Contents……………………………………………………………………………………………………… 3

1.      Introduction………………………………………………………………………………………………………………… 3

1.1      Patches………………………………………………………………………………………………………………. 3

1.2      Copy the EBSpatches to Oracle Solaris Server1…………………………………………………………… 4

1.3      Unzip the Patches………………………………………………………………………………………………… 4

2.1      Patch# 4247037……………………………………………………………………………………………………. 5

2.2      Patch# 13258936………………………………………………………………………………………………….. 7

2.3      Patch# 12960302………………………………………………………………………………………………….. 9

2.4      Patch# 12985184…………………………………………………………………………………………………. 12

2.5      Patch# 13366268…………………………………………………………………………………………………. 14

2.6      opatch lsinventory………………………………………………………………………………………………. 17

 

 

 

 

 

 

 

 

 

 

1.     Introduction

This document is delivered to be used by the  how to apply EBS mini patches on Oracle Database home.

 

 

 

 

1.1          Patches

 

1)      —4247037

2)      —12960302

3)      —12985184

4)      —13258936

5)      —13366268

 

1.2          Copy the EBSpatches to Oracle Solaris Server1

 

root@exadb01:/u01/app/dump/EBSpatches# ls -rlt

total 1538

-rwxrwxrwx   1 oracle   oinstall  191542 Jul  8 13:30 p12942119_1120317ExadataDatabase_Solaris86-64.zip

-rwxrwxrwx   1 oracle   oinstall  343459 Jul  8 13:30 p12960302_112030_Solaris86-64.zip

-rwxrwxrwx   1 oracle   oinstall   10413 Jul  8 13:30 p12985184_112030_Solaris86-64.zip

-rwxrwxrwx   1 oracle   oinstall    8280 Jul  8 13:30 p13258936_112030_Generic.zip

-rwxrwxrwx   1 oracle   oinstall   51377 Jul  8 13:30 p13366268_112030_Generic.zip

-rwxrwxrwx   1 oracle   oinstall   53641 Jul  8 13:30 p4247037_112030_Generic.zip

root@exadb01:/u01/app/dump/EBSpatches#

 

1.3          Unzip the Patches

 

root@exadb01:/u01/app/dump/EBSpatches# su – oracle

Oracle Corporation      SunOS 5.11      11.0    May 2012

-bash-4.1$ cd /u01/app/dump/EBSpatches/

-bash-4.1$ unzip p4247037_112030_Generic.zip

Archive:  p4247037_112030_Generic.zip

creating: 4247037/etc/

creating: 4247037/etc/config/

inflating: 4247037/etc/config/actions.xml

inflating: 4247037/etc/config/deploy.xml

inflating: 4247037/etc/config/inventory.xml

creating: 4247037/etc/xml/

inflating: 4247037/etc/xml/GenericActions.xml

inflating: 4247037/etc/xml/ShiphomeDirectoryStructure.xml

creating: 4247037/files/

creating: 4247037/files/md/

creating: 4247037/files/md/admin/

inflating: 4247037/files/md/admin/catmgdidcode.sql

inflating: 4247037/files/md/admin/catnomgdidcode.sql

inflating: 4247037/files/md/admin/mgdidcodetype.plb

inflating: 4247037/files/md/admin/mgdidcodetype.sql

inflating: 4247037/files/md/admin/mgdidcodeutl.plb

inflating: 4247037/files/md/admin/mgdidcodeutl.sql

inflating: 4247037/files/md/admin/mgdiddeinstall.sql

inflating: 4247037/files/md/admin/mgdidepctype.plb

inflating: 4247037/files/md/admin/mgdidepctype.sql

inflating: 4247037/files/md/admin/mgdidinstall.sql

inflating: 4247037/files/md/admin/mgdidmetadata.sql

inflating: 4247037/files/md/admin/mgdidmetatable.sql

inflating: 4247037/files/md/admin/mgdidprivs.plb

inflating: 4247037/files/md/admin/mgdsys.sql

inflating: 4247037/files/md/admin/prvtmgdidcodetypeb.plb

inflating: 4247037/files/md/admin/prvtmgdidcodeutlb.plb

inflating: 4247037/files/md/admin/prvtmgdidepctypeb.plb

creating: 4247037/files/md/support/

inflating: 4247037/files/md/support/patchset_mgdsys_validity.sql

inflating: 4247037/README.txt

-bash-4.1$

 

2.1  Patch# 4247037

 

-bash-4.1$ cd 4247037/

-bash-4.1$ ls

README.txt  etc         files

 

-bash-4.1$ export PATH=$PATH:/u01/app/oracle/product/11.2.0.3/dbhome_1/OPatch

-bash-4.1$ opatch apply

Oracle Interim Patch Installer version 11.2.0.3.4

Copyright (c) 2012, 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.4

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/4247037_Jul_08_2013_13_36_55/apply2013-07-08_13-36-55PM_1.log

 

Applying interim patch ‘4247037’ to OH ‘/u01/app/oracle/product/11.2.0.3/dbhome_1’

Verifying environment and performing prerequisite checks…

All checks passed.

Backing up files…

 

Patching component oracle.sdo.locator, 11.2.0.3.0…

 

Verifying the update…

 

Patching in rolling mode.

 

Updating nodes ‘exadb02’

Apply-related files are:

FP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/4247037_SEP_17_2009_09_52_00/rac/copy_files.txt”

DP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/4247037_SEP_17_2009_09_52_00/rac/copy_dirs.txt”

MP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/4247037_SEP_17_2009_09_52_00/rac/make_cmds.txt”

RC = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/4247037_SEP_17_2009_09_52_00/rac/remote_cmds.txt”

 

Instantiating the file “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/4247037_SEP_17_2009_09_52_00/rac/copy_files.txt.instantiated” by replacing $ORACLE_HOME in “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/4247037_SEP_17_2009_09_52_00/rac/copy_files.txt” with actual path.

Propagating files to remote nodes…

Instantiating the file “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/4247037_SEP_17_2009_09_52_00/rac/copy_dirs.txt.instantiated” by replacing $ORACLE_HOME in “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/4247037_SEP_17_2009_09_52_00/rac/copy_dirs.txt” with actual path.

Propagating directories to remote nodes…

Patch 4247037 successfully applied

Log file location: /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/4247037_Jul_08_2013_13_36_55/apply2013-07-08_13-36-55PM_1.log

 

OPatch succeeded.

-bash-4.1$

 

POST INSTALLATION

 

SQL> ALTER SESSION SET CURRENT_SCHEMA=CTXSYS

2  ;

 

Session altered.

 

SQL> @/u01/app/oracle/product/11.2.0.3/dbhome_1/ctx/admin/drisgp.plb

 

Package body created.

 

SQL> @/u01/app/oracle/product/11.2.0.3/dbhome_1/ctx/admin/drvddl.plb

 

Package body created.

 

SQL> @/u01/app/oracle/product/11.2.0.3/dbhome_1/ctx/admin/drvxtab.plb

 

Package body created.

 

SQL>

 

2.2  Patch# 13258936

 

-bash-4.1$ cd 13258936

-bash-4.1$ ls -rlt

total 3

drwxr-xr-x   3 oracle   oinstall       3 Dec  5  2011 files

drwxr-xr-x   4 oracle   oinstall       4 Dec  5  2011 etc

-rw-rw-r–   1 oracle   oinstall    5281 Jan 11  2012 README.txt

-bash-4.1$ opatch apply

Oracle Interim Patch Installer version 11.2.0.3.4

Copyright (c) 2012, 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.4

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/13258936_Jul_08_2013_14_03_35/apply2013-07-08_14-03-34PM_1.log

 

Applying interim patch ‘13258936’ to OH ‘/u01/app/oracle/product/11.2.0.3/dbhome_1’

Verifying environment and performing prerequisite checks…

All checks passed.

 

This node is part of an Oracle Real Application Cluster.

Remote nodes: ‘exadb02’

Local node: ‘exadb01’

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…

 

Patching component oracle.ctx, 11.2.0.3.0…

 

Verifying the update…

 

The local system has been patched.  You can restart Oracle instances on it.

 

 

Patching in rolling mode.

 

 

The node ‘exadb02’ will be patched next.

 

 

Please shutdown Oracle instances running out of this ORACLE_HOME on ‘exadb02’.

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

 

Is the node ready for patching? [y|n]

y

User Responded with: Y

Updating nodes ‘exadb02’

Apply-related files are:

FP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13258936_Dec_5_2011_02_41_32/rac/copy_files.txt”

DP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13258936_Dec_5_2011_02_41_32/rac/copy_dirs.txt”

MP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13258936_Dec_5_2011_02_41_32/rac/make_cmds.txt”

RC = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13258936_Dec_5_2011_02_41_32/rac/remote_cmds.txt”

 

Instantiating the file “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13258936_Dec_5_2011_02_41_32/rac/copy_files.txt.instantiated” by replacing $ORACLE_HOME in “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13258936_Dec_5_2011_02_41_32/rac/copy_files.txt” with actual path.

Propagating files to remote nodes…

Instantiating the file “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13258936_Dec_5_2011_02_41_32/rac/copy_dirs.txt.instantiated” by replacing $ORACLE_HOME in “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13258936_Dec_5_2011_02_41_32/rac/copy_dirs.txt” with actual path.

Propagating directories to remote nodes…

 

The node ‘exadb02’ has been patched.  You can restart Oracle instances on it.

 

Patch 13258936 successfully applied

Log file location: /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/13258936_Jul_08_2013_14_03_35/apply2013-07-08_14-03-34PM_1.log

 

OPatch succeeded.

-bash-4.1$

 

POST INSTALLATION

 

SQL> @?/ctx/admin/ctxpatch/ctxpatch11203.sql

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> conn / as sysdba

Connected.

SQL> alter session set current_schema=CTXSYS;

 

Session altered.

 

SQL>

SQL>

SQL> /*———————- validate_index_metadata —————————*/

SQL> /* validate index metadata after upgrade */

SQL> create or replace procedure validate_index_metadata

Procedure created.

 

SQL>

SQL> show errors;

No errors.

SQL>

SQL> — execute

SQL> exec validate_index_metadata;

 

PL/SQL procedure successfully completed.

 

SQL>

 

 

 

 

2.3  Patch# 12960302

-bash-4.1$ cd 12960302

-bash-4.1$ opatch apply

Oracle Interim Patch Installer version 11.2.0.3.4

Copyright (c) 2012, 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.4

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/12960302_Jul_08_2013_14_09_28/apply2013-07-08_14-09-28PM_1.log

 

Applying interim patch ‘12960302’ to OH ‘/u01/app/oracle/product/11.2.0.3/dbhome_1’

Verifying environment and performing prerequisite checks…

All checks passed.

 

This node is part of an Oracle Real Application Cluster.

Remote nodes: ‘exadb02’

Local node: ‘exadb01’

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…

 

Patching component oracle.rdbms, 11.2.0.3.0…

 

Patching component oracle.ctx.rsf, 11.2.0.3.0…

 

Patching component oracle.ctx, 11.2.0.3.0…

 

Verifying the update…

 

The local system has been patched.  You can restart Oracle instances on it.

 

 

Patching in rolling mode.

 

 

The node ‘exadb02’ will be patched next.

 

 

Please shutdown Oracle instances running out of this ORACLE_HOME on ‘exadb02’.

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

 

Is the node ready for patching? [y|n]

y

User Responded with: Y

Updating nodes ‘exadb02’

Apply-related files are:

FP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12960302_Nov_11_2011_10_55_25/rac/copy_files.txt”

DP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12960302_Nov_11_2011_10_55_25/rac/copy_dirs.txt”

MP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12960302_Nov_11_2011_10_55_25/rac/make_cmds.txt”

RC = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12960302_Nov_11_2011_10_55_25/rac/remote_cmds.txt”

 

Instantiating the file “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12960302_Nov_11_2011_10_55_25/rac/copy_files.txt.instantiated” by replacing $ORACLE_HOME in “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12960302_Nov_11_2011_10_55_25/rac/copy_files.txt” with actual path.

Propagating files to remote nodes…

Instantiating the file “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12960302_Nov_11_2011_10_55_25/rac/copy_dirs.txt.instantiated” by replacing $ORACLE_HOME in “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12960302_Nov_11_2011_10_55_25/rac/copy_dirs.txt” with actual path.

Propagating directories to remote nodes…

Instantiating the file “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12960302_Nov_11_2011_10_55_25/rac/make_cmds.txt.instantiated” by replacing $ORACLE_HOME in “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12960302_Nov_11_2011_10_55_25/rac/make_cmds.txt” with actual path.

Running command on remote node ‘exadb02’:

cd /u01/app/oracle/product/11.2.0.3/dbhome_1/rdbms/lib; /usr/ccs/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1 || echo REMOTE_MAKE_FAILED::>&2

 

 

The node ‘exadb02’ has been patched.  You can restart Oracle instances on it.

 

There were relinks on remote nodes.  Remember to check the binary size and timestamp on the nodes ‘exadb02’ .

The following make commands were invoked on remote nodes:

‘cd /u01/app/oracle/product/11.2.0.3/dbhome_1/rdbms/lib; /usr/ccs/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1

 

Patch 12960302 successfully applied

Log file location: /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/12960302_Jul_08_2013_14_09_28/apply2013-07-08_14-09-28PM_1.log

 

OPatch succeeded.

-bash-4.1$

 

 

2.4   Patch# 12985184

 

 

-bash-4.1$ cd 12985184

-bash-4.1$ ls -rlt

total 16

drwxr-xr-x   3 oracle   oinstall       3 Dec  1  2011 files

drwxr-xr-x   4 oracle   oinstall       4 Dec  1  2011 etc

-rw-rw-r–   1 oracle   oinstall    4401 Dec  1  2011 README.txt

-bash-4.1$ opatch apply

Oracle Interim Patch Installer version 11.2.0.3.4

Copyright (c) 2012, 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.4

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/12985184_Jul_08_2013_14_15_17/apply2013-07-08_14-15-17PM_1.log

 

Applying interim patch ‘12985184’ to OH ‘/u01/app/oracle/product/11.2.0.3/dbhome_1’

Verifying environment and performing prerequisite checks…

All checks passed.

 

This node is part of an Oracle Real Application Cluster.

Remote nodes: ‘exadb02’

Local node: ‘exadb01’

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…

 

Patching component oracle.ctx.rsf, 11.2.0.3.0…

 

Patching component oracle.rdbms, 11.2.0.3.0…

 

Verifying the update…

 

The local system has been patched.  You can restart Oracle instances on it.

 

 

Patching in rolling mode.

 

 

The node ‘exadb02’ will be patched next.

 

 

Please shutdown Oracle instances running out of this ORACLE_HOME on ‘exadb02’.

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

 

Is the node ready for patching? [y|n]

y

User Responded with: Y

Updating nodes ‘exadb02’

Apply-related files are:

FP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12985184_Nov_30_2011_19_01_18/rac/copy_files.txt”

DP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12985184_Nov_30_2011_19_01_18/rac/copy_dirs.txt”

MP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12985184_Nov_30_2011_19_01_18/rac/make_cmds.txt”

RC = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12985184_Nov_30_2011_19_01_18/rac/remote_cmds.txt”

 

Instantiating the file “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12985184_Nov_30_2011_19_01_18/rac/copy_files.txt.instantiated” by replacing $ORACLE_HOME in “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12985184_Nov_30_2011_19_01_18/rac/copy_files.txt” with actual path.

Propagating files to remote nodes…

Instantiating the file “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12985184_Nov_30_2011_19_01_18/rac/copy_dirs.txt.instantiated” by replacing $ORACLE_HOME in “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12985184_Nov_30_2011_19_01_18/rac/copy_dirs.txt” with actual path.

Propagating directories to remote nodes…

Instantiating the file “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12985184_Nov_30_2011_19_01_18/rac/make_cmds.txt.instantiated” by replacing $ORACLE_HOME in “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/12985184_Nov_30_2011_19_01_18/rac/make_cmds.txt” with actual path.

Running command on remote node ‘exadb02’:

cd /u01/app/oracle/product/11.2.0.3/dbhome_1/rdbms/lib; /usr/ccs/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1 || echo REMOTE_MAKE_FAILED::>&2

 

 

The node ‘exadb02’ has been patched.  You can restart Oracle instances on it.

 

There were relinks on remote nodes.  Remember to check the binary size and timestamp on the nodes ‘exadb02’ .

The following make commands were invoked on remote nodes:

‘cd /u01/app/oracle/product/11.2.0.3/dbhome_1/rdbms/lib; /usr/ccs/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1

 

Patch 12985184 successfully applied

Log file location: /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/12985184_Jul_08_2013_14_15_17/apply2013-07-08_14-15-17PM_1.log

 

OPatch succeeded.

-bash-4.1$

 

 

2.5  Patch# 13366268

 

-bash-4.1$ cd 13366268

-bash-4.1$ ls -rlt

total 16

drwxr-xr-x   3 oracle   oinstall       3 Dec  1  2011 files

drwxr-xr-x   4 oracle   oinstall       4 Dec  1  2011 etc

-rw-rw-r–   1 oracle   oinstall    4401 Dec  1  2011 README.txt

-bash-4.1$ opatch apply

Oracle Interim Patch Installer version 11.2.0.3.4

Copyright (c) 2012, 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.4

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/13366268_Jul_08_2013_14_15_17/apply2013-07-08_14-15-17PM_1.log

 

Applying interim patch ‘13366268’ to OH ‘/u01/app/oracle/product/11.2.0.3/dbhome_1’

Verifying environment and performing prerequisite checks…

All checks passed.

 

This node is part of an Oracle Real Application Cluster.

Remote nodes: ‘exadb02’

Local node: ‘exadb01’

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…

 

Patching component oracle.ctx.rsf, 11.2.0.3.0…

 

Patching component oracle.rdbms, 11.2.0.3.0…

 

Verifying the update…

 

The local system has been patched.  You can restart Oracle instances on it.

 

 

Patching in rolling mode.

 

 

The node ‘exadb02’ will be patched next.

 

 

Please shutdown Oracle instances running out of this ORACLE_HOME on ‘exadb02’.

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

 

Is the node ready for patching? [y|n]

y

User Responded with: Y

Updating nodes ‘exadb02’

Apply-related files are:

FP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13366268_Nov_30_2011_19_01_18/rac/copy_files.txt”

DP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13366268_Nov_30_2011_19_01_18/rac/copy_dirs.txt”

MP = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13366268_Nov_30_2011_19_01_18/rac/make_cmds.txt”

RC = “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13366268_Nov_30_2011_19_01_18/rac/remote_cmds.txt”

 

Instantiating the file “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13366268_Nov_30_2011_19_01_18/rac/copy_files.txt.instantiated” by replacing $ORACLE_HOME in “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13366268_Nov_30_2011_19_01_18/rac/copy_files.txt” with actual path.

Propagating files to remote nodes…

Instantiating the file “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13366268_Nov_30_2011_19_01_18/rac/copy_dirs.txt.instantiated” by replacing $ORACLE_HOME in “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13366268_Nov_30_2011_19_01_18/rac/copy_dirs.txt” with actual path.

Propagating directories to remote nodes…

Instantiating the file “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13366268_Nov_30_2011_19_01_18/rac/make_cmds.txt.instantiated” by replacing $ORACLE_HOME in “/u01/app/oracle/product/11.2.0.3/dbhome_1/.patch_storage/13366268_Nov_30_2011_19_01_18/rac/make_cmds.txt” with actual path.

Running command on remote node ‘exadb02’:

cd /u01/app/oracle/product/11.2.0.3/dbhome_1/rdbms/lib; /usr/ccs/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1 || echo REMOTE_MAKE_FAILED::>&2

 

 

The node ‘exadb02’ has been patched.  You can restart Oracle instances on it.

 

There were relinks on remote nodes.  Remember to check the binary size and timestamp on the nodes ‘exadb02’ .

The following make commands were invoked on remote nodes:

‘cd /u01/app/oracle/product/11.2.0.3/dbhome_1/rdbms/lib; /usr/ccs/bin/make -f ins_rdbms.mk ioracle ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1

 

Patch 13366268 successfully applied

Log file location: /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/13366268_Jul_08_2013_14_15_17/apply2013-07-08_14-15-17PM_1.log

 

OPatch succeeded.

-bash-4.1$

 

2.6  opatch lsinventory

 

-bash-4.1$ opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.4

Copyright (c) 2012, 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.4

OUI version       : 11.2.0.3.0

Log file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/opatch2013-07-08_14-21-18PM_1.log

 

Lsinventory Output file location : /u01/app/oracle/product/11.2.0.3/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2013-07-08_14-21-18PM.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 (8) :

 

Patch  12985184     : applied on Mon Jul 08 14:15:32 AST 2013

Unique Patch ID:  14321189

Created on 30 Nov 2011, 19:01:18 hrs PST8PDT

Bugs fixed:

12985184

 

Patch  12960302     : applied on Mon Jul 08 14:10:01 AST 2013

Unique Patch ID:  14254333

Created on 11 Nov 2011, 10:55:25 hrs UTC

Bugs fixed:

12960302

 

Patch  13258936     : applied on Mon Jul 08 14:03:47 AST 2013

Unique Patch ID:  14465000

Created on 5 Dec 2011, 02:41:32 hrs PST8PDT

Bugs fixed:

13258936

 

Patch  13366268     : applied on Mon Jul 08 13:54:59 AST 2013

Unique Patch ID:  14394336

Created on 21 Dec 2011, 08:14:06 hrs PST8PDT

Bugs fixed:

13366268

 

Patch  4247037      : applied on Mon Jul 08 13:37:05 AST 2013

Unique Patch ID:  14211388

Created on 17 SEP 2009, 09:52:00 hrs US/Pacific

Bugs fixed:

4247037

 

Patch  16475860     : applied on Mon Jun 24 15:15:05 AST 2013

Unique Patch ID:  16227802

Patch description:  “DISKMON PATCH FOR EXADATA (MAY 2013 – 11.2.0.3.18) : (16475860)”

Created on 11 Apr 2013, 06:16:10 hrs UTC

Bugs fixed:

14307915, 14050993, 16475860, 13688022, 16401300, 13350234, 14184077, 13513982

 

Patch  16315641     : applied on Mon Jun 24 15:14:45 AST 2013

Unique Patch ID:  16227802

Patch description:  “CRS PATCH FOR EXADATA (MAY 2013 – 11.2.0.3.18) : (16315641)”

Created on 11 Apr 2013, 04:14:36 hrs PST8PDT

Bugs fixed:

16315641, 15876003, 14275572, 13919095, 13696251, 13348650, 12659561

14305980, 14277586, 13987807, 14625969, 13825231, 12794268, 13000491

13498267, 11675721, 14082976, 12771830, 14515980, 14085018, 13943175

14102704, 14171552, 12594616, 13879428, 12897902, 12726222, 12829429

13079948, 13090686, 12995950, 13251796, 13582411, 12990582, 13857364

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

12914824, 13789135, 12730342, 12950823, 13355963, 13531373, 14268365

13776758, 12720728, 13620816, 13023609, 13024624, 13039908, 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, 13339443, 13965075

16210540, 14307855, 12784559, 14242977, 13955385, 12704789, 13745317

13074261, 12971251, 13993634, 13523527, 13719731, 13396284, 12639013

12867511, 12959140, 14748254, 12829917, 12349553, 12849377, 12934171

13843080, 14496536, 13924431, 12680491, 13334158, 10418841, 12832204

13838047, 13002015, 12791719

 

Patch  16539343     : applied on Mon Jun 24 15:11:45 AST 2013

Unique Patch ID:  16227802

Patch description:  “DATABASE PATCH FOR EXADATA (MAY 2013 – 11.2.0.3.18) : (16539343)”

Created on 11 Apr 2013, 05:54:11 hrs UTC

Bugs fixed:

13737746, 13580513, 14693434, 12594032, 13477790, 12583611, 14005749

13880971, 14366237, 12749597, 12748795, 13715680, 13022416, 13997862

12966665, 13470240, 15862016, 15862017, 15862018, 15862019, 12960925

14398795, 16344871, 13080778, 14174174, 12625563, 14653598, 13742433

13742434, 14402514, 13742435, 13742436, 13879579, 13742437, 13742438

13972394, 14314239, 13483354, 12890501, 12925089, 15862020, 13454210

15862021, 15862022, 11811297, 15862023, 15862024, 12876939, 13776598

12717125, 12964067, 13358781, 13399500, 13579992, 13036331, 9659614

12845115, 13399435, 12755231, 13958038, 14016187, 14285330, 13787307

12780098, 13998753, 13561951, 10387201, 12976376, 12656535, 13725395

14132953, 13942462, 13534412, 13927155, 14506175, 12350994, 14571027

14176879, 14459552, 12940620, 12944766, 14143451, 13910783, 12894807

14755945, 13871316, 11855445, 11715084, 15947246, 15873619, 13767790

14098509, 14050233, 11063191, 13772618, 12646784, 15853081, 14175146

12401111, 12709059, 13807411, 14023636, 14511876, 12917230, 12829021

16238044, 13533487, 13515918, 12411746, 12641849, 10133521, 13742464

12889054, 12974860, 13559697, 13849733, 13464002, 14607573, 13775960

13901039, 13929853, 12920172, 12794305, 14698700, 13457582, 13553883

13720544, 12939232, 14841558, 12953743, 12971388, 10287724, 14076523

10332676, 13089313, 13516727, 13256841, 14510149, 12588744, 13388104

13699124, 12899768, 13812031, 13345786, 9761357, 14063280, 14071518

14063281, 12662040, 13718279, 13716749, 14098382, 16455998, 13059165

12353494, 13146719, 12910565, 14095982, 11868640, 13911821, 13395403

13719081, 14144283, 14516040, 13811172, 14499293, 13642044, 13863326

14052871, 13063120, 14664355, 11840910, 12913987, 14508968, 12627504

15951085, 15987992, 13497523, 13499128, 14409183, 13506110, 15933374

13000553, 12772404, 13923995, 14008285, 13040331, 12312133, 14791477

13524698, 12620823, 13901133, 13111630, 13074706, 13413837, 13366202

14258925, 13769577, 13780816, 13686047, 13705338, 14191508, 14808639

12900964, 12325243, 14506367, 11877623, 12325317, 12929644, 14625601

10625145, 13035804, 13912642, 14299365, 12539239, 13887875, 14527701

7275052, 13440516, 13352237, 14292825, 13714302, 14218148, 14291951

13642207, 13032258, 15857552, 12328803, 9873405, 13810393, 13527323

14034244, 12780510, 13711695, 14548763, 13419660, 14112837, 13098318

14251170, 13397104, 14557588, 13001379, 12658411, 13466801, 12764337

15866520, 12922105, 13902963, 14841812, 12614359, 13687870, 13421009

13572659, 13253549, 12797765, 13503598, 12734325, 12905058, 13979519

14119388, 13259364, 12771704, 13814905, 13419747, 14668670, 11846902

13343438, 14540423, 13340960, 13961338, 12621588, 12905137, 14348839

13716797, 13588248, 13680405, 14801111, 12619529, 12748240, 13564720

14762511, 11717119, 16382353, 13420224, 13718476, 13801740, 13717748

13377816, 14521920, 14044105, 14671833, 13629469, 14828059, 12731940

14262913, 12718090, 10242202, 12912297, 12714023, 12628286, 13851078

14138130, 12861463, 13344323, 14775629, 13041324, 14207902, 13023541

12585543, 14215851, 13430938, 9906567, 13503766, 13936424, 12974145

6445864, 13871547, 13242070, 12904429, 13918644, 14113740, 13004894

13616375, 14751895, 13913630, 12791981, 13736413, 14511239, 12618817

12900077, 14734989, 13478060, 15905091, 12766987, 13524899, 13787482

14013094, 13719292, 13816397, 12959852, 13250244, 12672969, 12865902

13853916, 15935253, 14042380, 13584130, 12678920, 13976144, 14561651

14237793, 12837280, 14110275, 14472647, 12924835, 14153464, 12984935

13860201, 10350832, 13448206, 13632717, 13871495, 13989185, 14117976

13011409, 13917937, 12950644, 12391034, 14644185, 15910002, 14480674

13505390, 14480675, 13890080, 12848798, 13492735, 14480676, 13696023

13732226, 12834027, 13786778, 14062792, 13422949, 13596521, 13599864

14062793, 14062794, 14062795, 14062796, 14043417, 14062797, 13429702

12971775, 14182835, 13649031, 13496884, 12960279, 13575265, 13362079

13103913, 12979199, 14128555, 14218299, 13685544, 13632809, 16231699

13914613, 13582702, 12637294, 12998795, 15869211, 12849688, 13593999

13902316, 13910190, 13903046, 13645917, 13397256, 14775679, 13809288

13328193, 13326736, 13467683, 14220725, 14292987, 14601231, 13769887

12564614, 12938841, 12793917, 16530565, 12768840, 15909705, 13544396

14273397, 14467061, 13498646, 13923374, 12617123, 13495307, 15982436

13727644, 9847699, 13329145, 12899094, 12655301, 14222403, 13476583

12612118, 13722707, 14097127, 13448247, 13370330, 13621258, 13910420

14198511, 11708510, 13354082, 13700577, 12535346, 13338048, 13911083

13882317, 12748538, 13804294, 14125317, 14041920, 14301592, 13054713

11837095, 12953092, 12960455, 11841048, 13524237, 13427062, 13364795

13429678, 12685263, 12950694, 14007968, 12764658, 11929808, 13696216

13645875, 15881071, 14215134, 16314466, 16314467, 16314468, 16314469

16294378, 13384182, 14205448, 14038787, 11826751, 14512189, 12595606

15841373, 10305573, 13906496, 14609690, 16314470, 10109915, 12591252

13554409, 13502183, 13015754, 13724193, 12923168, 12913474, 16056266

13358531, 13997558, 12857027, 14651753, 10231014, 14589750, 14546638

14293031, 14624146, 12358083, 13483981, 8547978, 12879027, 13898864

14088346, 14301697, 12866794, 14280879, 10297948, 9706792, 13981051

10136532, 12757532, 12880299, 12842402, 14546575, 14287564, 14578331

12579446, 12833442, 13945708, 14029050, 13839641, 14226599, 14665745

13784384, 13528551, 13837105, 14263036, 14741727, 14469008, 11896575

14114792, 16175381, 13070939, 9782075, 13968438, 13026410, 12595561

13257247, 16357830, 12425262, 12831782, 9725536, 9858539, 10263668

12326708, 13471777, 13489024, 11071989, 12387467, 14317360, 13911422

14014434, 14587310, 13658087, 12596444, 12975420, 12918738, 13786142

13493847, 14523004, 14207163, 13332439, 14675388, 12345082, 14052474

13146182, 13340388, 14334353, 14473913, 14633213, 13426605, 13117043

12693626, 13612575, 9703627, 14342378, 14546673, 14781524, 13355095

13602883, 16165857, 14613900, 13040943, 13635440, 13484963, 12536287

15963137, 14207317, 14727310, 13790109, 14507915, 13986244, 12873183

9163477, 12898733, 13099577, 14390252, 12586845, 13743987, 12797420

8316255, 13652437, 10418524, 14356507, 14841409, 13773133, 14478870

13384397, 16194149, 14263073, 13550185, 14015403, 14654284, 12945290

12723359, 13038684, 12693573, 12847466, 12919564, 12983611, 14692460

12780983, 12755116, 13409719, 12978794, 13350245, 13548053, 16538299

13385346, 10248538, 12794025, 9876287, 13909322, 14193593, 12556843

12591399, 13608792, 14482905, 13657605, 13657460, 3522216, 13573203

13912192, 12780993, 13079417, 12675009, 14465787, 13440068, 14275605

13629056, 13147164, 14362875, 14393900, 12821418, 13624984, 12698747

16299830, 13879553, 14395293, 13035360, 14309390, 14618018, 14294123

14162791, 14153033, 10214323, 13566938, 14127231, 7276499, 10182005

14343501, 12582664, 13457537, 14744263, 14035825, 9095696, 12830174

12778873, 14040433, 13916709

 

 

 

Rac system comprising of multiple nodes

Local node = exadb01

Remote node = exadb02

 

——————————————————————————–

 

OPatch succeeded.

-bash-4.1$

 

 

 

 

Finished

 

 

 

About Sher khan

Senior Oracle DBA, Oracle 10g and 11g OCE and OCS, Oracle 11g OPN certified Specialist, OCP Certified in Oracle 9i,10g and 11g. I am working in Oracle technology since 2004. Currently working in U.A.E Email: sher487@hotmail.com
This entry was posted in Exadata. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s