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  |
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  |
John Watson
Messages: 8960
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 #594820 is a reply to message #594781] |
Tue, 03 September 2013 07:08 |
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 #594915 is a reply to message #594828] |
Tue, 03 September 2013 23:37 |
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 #594929 is a reply to message #594919] |
Wed, 04 September 2013 02:21 |
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 |
John Watson
Messages: 8960
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 #595019 is a reply to message #594966] |
Thu, 05 September 2013 02:22 |
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
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Fri Nov 29 10:22:16 CST 2024
|
] 
Blog
Search
Help
Members
Register
Login
Home
