Home » Other » General » Applying CPU patch on version 11.2.0.3 (11.2.0.3, 11g, red hat 5)
Applying CPU patch on version 11.2.0.3 [message #594724] Mon, 02 September 2013 04:44 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

Recently, I have updated oracle version from 11.2.0.1 to 11.2.0.3. Now I am checking the probabilities of conflicts of CPU patching. While issuing below command -
oracle:/usr/upgrade/ora11.2.0.3/db_home4/OPatch>$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /usr/psu_patch/16056266

Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /usr/upgrade/ora11.2.0.3/db_home4
Central Inventory : /usr/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.2.0.1.7
OUI version       : 11.2.0.3.0
Log file location : /usr/upgrade/ora11.2.0.3/db_home4/cfgtoollogs/opatch/opatch2013-09-02_10-44-21AM.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
oracle:/usr/upgrade/ora11.2.0.3/db_home4/OPatch>
oracle:/usr/upgrade/ora11.2.0.3/db_home4/OPatch>oracle:/usr/upgrade/ora11.2.0.3/db_home4/OPatch>echo $ORACLE_HOME
/usr/upgrade/ora11.2.0.3/db_home4/



OPatch version is showing 11.2.0.1.7. I am little bit confused over here. Since i haven't done patching from 11.2.0.1 that's why its showing the oldest OPatch version?

Assist me to know the concept about it.

Regards,
Ishika
Re: Applying CPU patch on version 11.2.0.3 [message #594727 is a reply to message #594724] Mon, 02 September 2013 04:53 Go to previous messageGo to next message
John Watson
Messages: 4557
Registered: January 2010
Location: Global Village
Senior Member
opatch is a product, with a release number. There is no reason why the release of opatch should be the same as the release of anything else. You would usually download the latest release, it is always patch number 6880880 (a number that you will come to memorize).
Re: Applying CPU patch on version 11.2.0.3 [message #594781 is a reply to message #594727] Mon, 02 September 2013 23:35 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Mr. John,

Thank you very much.

This is the first time i am going to apply CPU patch on the database. So, just want to make sure about it.

Regards,
Ishika
Re: Applying CPU patch on version 11.2.0.3 [message #594820 is a reply to message #594781] Tue, 03 September 2013 07:08 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Mr. John,

According to the document,after setting the PATH. I ran optch apply but its shwing error.

oracle:/usr/psu_patch/16056266>export PATH=$PATH:/usr/ccs/bin
oracle:/usr/psu_patch/16056266>echo $PATH
/home/oracle/mono-1.9.1/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/usr/upgrade/ora11.2.0.3/db_home4//bin:/usr/ccs/bin
oracle:/usr/psu_patch/16056266>$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /usr/psu_patch/16056266
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /usr/upgrade/ora11.2.0.3/db_home4
Central Inventory : /usr/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.2.0.1.7
OUI version       : 11.2.0.3.0
Log file location : /usr/upgrade/ora11.2.0.3/db_home4/cfgtoollogs/opatch/opatch2013-09-03_16-45-38PM.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.
oracle:/usr/psu_patch/16056266>opatch apply
-bash: opatch: command not found


Please suggest me how to rectify it.

Regards,
Ishika
Re: Applying CPU patch on version 11.2.0.3 [message #594828 is a reply to message #594820] Tue, 03 September 2013 07:20 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
$ORACLE_HOME/OPatch is not in your PATH.
Why didn't you execute "opatch" with the same call in the second case when you see it works in the first one?

Regards
Michel
Re: Applying CPU patch on version 11.2.0.3 [message #594915 is a reply to message #594828] Tue, 03 September 2013 23:37 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

Thanks you. As per your suggestion, changes have done on the PATh

oracle:/usr/upgrade/ora11.2.0.3/db_home4/OPatch>echo $PATH
/home/oracle/mono-1.9.1/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/usr/upgrade/ora11.2.0.3/db_home4//bin:/usr/ccs/bin
oracle:/usr/upgrade/ora11.2.0.3/db_home4/OPatch>export PATH=/home/oracle/mono-1.9.1/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/b
in:/usr/upgrade/ora11.2.0.3/db_home4/OPatch
oracle:/usr/upgrade/ora11.2.0.3/db_home4/OPatch>echo $PATH
/home/oracle/mono-1.9.1/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/usr/upgrade/ora11.2.0.3/db_home4/OPatch
oracle:/usr/upgrade/ora11.2.0.3/db_home4/OPatch>opatch apply
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.  All rights reserved.


Oracle Home       : /usr/upgrade/ora11.2.0.3/db_home4
Central Inventory : /usr/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.2.0.1.7
OUI version       : 11.2.0.3.0
Log file location : /usr/upgrade/ora11.2.0.3/db_home4/cfgtoollogs/opatch/opatch2013-09-04_10-18-11AM.log

Failed to load the patch object.  Possible causes are:
  The specified path is not an interim Patch shiphome
  Meta-data files are missing from the patch area
  Patch location = /usr/upgrade/ora11.2.0.3/db_home4/OPatch
  Details = PatchObject constructor: Input file "/usr/upgrade/ora11.2.0.3/db_home4/OPatch/etc/config/actions" or "/usr/upgrade/ora11.2.0.3/db_home4/OPatch/etc/config/inventory" does not exist.

ApplySession failed: PatchObject constructor: Input file "/usr/upgrade/ora11.2.0.3/db_home4/OPatch/etc/config/actions" or "/usr/upgrade/ora11.2.0.3/db_home4/OPatch/etc/config/inventory" does not exist.
Log file location: /usr/upgrade/ora11.2.0.3/db_home4/cfgtoollogs/opatch/opatch2013-09-04_10-18-11AM.log

OPatch failed with error code 73
oracle:/usr/upgrade/ora11.2.0.3/db_home4/OPatch>



Now, opatch apply invoked with failed error.
Let me check the error at my end first then come back to you.

Regards,
Ishika

[Updated on: Tue, 03 September 2013 23:38]

Report message to a moderator

Re: Applying CPU patch on version 11.2.0.3 [message #594919 is a reply to message #594915] Wed, 04 September 2013 01:00 Go to previous messageGo to next message
John Watson
Messages: 4557
Registered: January 2010
Location: Global Village
Senior Member
You haven't installed the latest OPatch, as I told you to, have you?
Are you actually following the instructions that come with your CPU?
Re: Applying CPU patch on version 11.2.0.3 [message #594929 is a reply to message #594919] Wed, 04 September 2013 02:21 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Mr. John,

I have downloaded the patch "Patch 16056266 - 11.2.0.3.6 Patch Set Update". Which would make my database version from 11.2.0.3 to 11.2.0.3.7. Now, I have ran the Opatch apply through patch locations.
How do I know which one the patch for changing version from 11.2.0.3 to 11.2.0.3.6?

While running Opatch apply -

oracle:/usr/upgrade/ora11.2.0.3/db_home4/OPatch>cd /usr/psu_patch/16056266
oracle:/usr/psu_patch/16056266>opatch apply
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.  All rights reserved.


Oracle Home       : /usr/upgrade/ora11.2.0.3/db_home4
Central Inventory : /usr/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.2.0.1.7
OUI version       : 11.2.0.3.0
Log file location : /usr/upgrade/ora11.2.0.3/db_home4/cfgtoollogs/opatch/opatch2013-09-04_12-58-41PM.log

Verifying environment and performing prerequisite checks...
UtilSession failed:

Patch 13696216 requires OPatch version 11.2.0.3.0.
Patch 13923374 requires OPatch version 11.2.0.3.0.
Patch 14275605 requires OPatch version 11.2.0.3.0.
Patch 14727310 requires OPatch version 11.2.0.3.0.
Patch 16056266 requires OPatch version 11.2.0.3.0.
The OPatch version being used (11.2.0.1.7) doesn't meet the minimum version required by the patch(es). Please download latest OPatch from My Oracle Support.

Log file location: /usr/upgrade/ora11.2.0.3/db_home4/cfgtoollogs/opatch/opatch2013-09-04_12-58-41PM.log

OPatch failed with error code 73
oracle:/usr/psu_patch/16056266>



Regards,
Ishika
Re: Applying CPU patch on version 11.2.0.3 [message #594930 is a reply to message #594929] Wed, 04 September 2013 02:25 Go to previous messageGo to next message
John Watson
Messages: 4557
Registered: January 2010
Location: Global Village
Senior Member
I have told you, twice, to download the latest OPatch. The instructions with 16056266 also tell you to download the latest OPatch. Your error message tells you to download the latest version of OPatch.

Can you deduce a course of action from this?

Re: Applying CPU patch on version 11.2.0.3 [message #594959 is a reply to message #594930] Wed, 04 September 2013 07:49 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear John,

I got in read me, that -
"The new minimum OPatch version requirement for GI PSU 11.2.0.3.6 is OPatch 11.2.0.3.4"
Do I need to all the CPU patch from 11.2.0.3.1 to 11.2.0.3.6 ?


Regards,
Ishika

[Updated on: Wed, 04 September 2013 07:57]

Report message to a moderator

Re: Applying CPU patch on version 11.2.0.3 [message #594966 is a reply to message #594959] Wed, 04 September 2013 08:51 Go to previous messageGo to next message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is also mentioned in the readme file.
And in a general note about PSU in MOS.

Regards
Michel
Re: Applying CPU patch on version 11.2.0.3 [message #595019 is a reply to message #594966] Thu, 05 September 2013 02:22 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel / John,

With the help of MOS site and after doing Google, I have applied the patch number 13343438 on 11.2.0.3 version.

Below are my steps-

oracle:/usr/upgrade/ora11.2.0.3/db_home4/OPatch>echo $PATH
/home/oracle/mono-1.9.1/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/usr/upgrade/ora11.2.0.3/db_home4//bin:/usr/ccs/bin

oracle:/usr/upgrade/ora11.2.0.3/db_home4/OPatch>export PATH=/home/oracle/mono-1.9.1/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/b
in:/usr/upgrade/ora11.2.0.3/db_home4/OPatch

oracle:/usr/upgrade/ora11.2.0.3/db_home4/OPatch>echo $PATH
/home/oracle/mono-1.9.1/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/usr/upgrade/ora11.2.0.3/db_home4/OPatch


oracle:/usr/psu_patch/13343438>opatch apply
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.  All rights reserved.


Oracle Home       : /usr/upgrade/ora11.2.0.3/db_home4
Central Inventory : /usr/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.2.0.1.7
OUI version       : 11.2.0.3.0
Log file location : /usr/upgrade/ora11.2.0.3/db_home4/cfgtoollogs/opatch/opatch2013-09-04_19-13-48PM.log

Applying interim patch '13343438' to OH '/usr/upgrade/ora11.2.0.3/db_home4'
Verifying environment and performing prerequisite checks...

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 = '/usr/upgrade/ora11.2.0.3/db_home4')


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

Could not recognize input. Please re-enter.
y
User Responded with: Y
Backing up files...

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

Patching component oracle.rdbms, 11.2.0.3.0...
Copying file to "/usr/upgrade/ora11.2.0.3/db_home4/psu/11.2.0.3.1/catpsu.sql"
Copying file to "/usr/upgrade/ora11.2.0.3/db_home4/psu/11.2.0.3.1/catpsu_rollback.sql"

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Patch 13343438 successfully applied
Log file location: /usr/upgrade/ora11.2.0.3/db_home4/cfgtoollogs/opatch/opatch2013-09-04_19-13-48PM.log

OPatch succeeded.
oracle:/usr/psu_patch/13343438>

******************************************************************************************

oracle:/home/oracle>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 4 19:47:05 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 2042241024 bytes
Fixed Size                  1345968 bytes
Variable Size            1056966224 bytes
Database Buffers          973078528 bytes
Redo Buffers               10850304 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

oracle:/usr/upgrade/ora11.2.0.3/db_home4>cd rdbms/admin/

oracle:/usr/upgrade/ora11.2.0.3/db_home4/rdbms/admin>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Sep 5 10:09:28 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> @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:
/usr/upgrade/ora11.2.0.3/db_home4/cfgtoollogs/catbundle/catbundle_PSU_TAGI_GENERATE_2013Sep05_10_09_49.log
Apply script: /usr/upgrade/ora11.2.0.3/db_home4//rdbms/admin/catbundle_PSU_TAGI_APPLY.sql
Rollback script: /usr/upgrade/ora11.2.0.3/db_home4//rdbms/admin/catbundle_PSU_TAGI_ROLLBACK.sql

PL/SQL procedure successfully completed.

Executing script file...




SQL> COLUMN spool_file NEW_VALUE spool_file NOPRINT
SQL> SELECT '/usr/upgrade/ora11.2.0.3/db_home4/cfgtoollogs/catbundle/' || 'catbundle_PSU_' || name || '_APPLY_' || TO_CHAR(SYSDATE, 'YYYYMonDD_hh24_mi_ss', 

'NLS_DATE_LANGUAGE=''AMERICAN''') || '.log' AS spo


SQL> exec dbms_registry.set_session_namespace('SERVER')

PL/SQL procedure successfully completed.

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     1,
 10     'PSU',
 11     'PSU 11.2.0.3.1');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> SPOOL off
SQL> SET echo off
Check the following log file for errors:
/usr/upgrade/ora11.2.0.3/db_home4/cfgtoollogs/catbundle/catbundle_PSU_TAGI_APPLY_2013Sep05_10_09_50.log


SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


oracle:/usr/upgrade/ora11.2.0.3/db_home4/rdbms/admin>opatch lsinventory
Invoking OPatch 11.2.0.1.7

Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation.  All rights reserved.


Oracle Home       : /usr/upgrade/ora11.2.0.3/db_home4
Central Inventory : /usr/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 11.2.0.1.7
OUI version       : 11.2.0.3.0
Log file location : /usr/upgrade/ora11.2.0.3/db_home4/cfgtoollogs/opatch/opatch2013-09-05_10-11-34AM.log

Lsinventory Output file location : /usr/upgrade/ora11.2.0.3/db_home4/cfgtoollogs/opatch/lsinv/lsinventory2013-09-05_10-11-34AM.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  13343438     : applied on Wed Sep 04 19:14:39 IST 2013
Unique Patch ID:  14288831
Patch Description:  "Database Patch Set Update : 11.2.0.3.1 (13343438)"
   Created on 4 Jan 2012, 05:00:38 hrs PST8PDT
   Bugs fixed:
     12998795, 13466801, 13492735, 12834027, 12620823, 13035804, 13362079
     12718090, 13528551, 13041324, 13343438, 12917230, 12847466, 9703627
     12797765, 12950644, 12905058, 13499128, 12861463, 9873405, 12938841



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

OPatch succeeded.


oracle:/usr/upgrade/ora11.2.0.3/db_home4/cfgtoollogs/catbundle>cat catbundle_PSU_TAGI_APPLY_2013Sep05_10_09_50.log
SQL> exec dbms_registry.set_session_namespace('SERVER')

PL/SQL procedure successfully completed.

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     1,
 10     'PSU',
 11     'PSU 11.2.0.3.1');

1 row created.

SQL> COMMIT;

Commit complete.


In registry$history, it showed that patch is applied. I am having one doubt. Do version will update accordingly or not?
Because when i execute the below command as
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
PL/SQL Release 11.2.0.3.0 - Production
CORE    11.2.0.3.0      Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production


Do version will update as 11.2.0.3.1 or it will be as 11.2.0.3?

Regards,
Ishika
Re: Applying CPU patch on version 11.2.0.3 [message #595031 is a reply to message #595019] Thu, 05 September 2013 04:11 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

I got my answer. It will not reflect version in "v$version". It will always shows the release not the patch update. It can be seen from registry$history.

Below link is helpful to know about it -
https://forums.oracle.com/thread/2440582


Regards,
Ishika



CM: made the link an actual link

[Updated on: Thu, 05 September 2013 06:45] by Moderator

Report message to a moderator

Re: Applying CPU patch on version 11.2.0.3 [message #595036 is a reply to message #595031] Thu, 05 September 2013 05:04 Go to previous message
Michel Cadot
Messages: 59118
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks to let us know and for the link.

Regards
Michel
Previous Topic: Does Oracle give up the Stream and another?
Next Topic: Database Merging
Goto Forum:
  


Current Time: Wed Sep 17 22:49:49 CDT 2014

Total time taken to generate the page: 0.10214 seconds