PSU on 11.2.0.3 over GI & RDBMS Homes (StandAlone Server)

All posts relating to Oracle database administration.

Moderator: Tim...

PSU on 11.2.0.3 over GI & RDBMS Homes (StandAlone Server)

Postby niranjan626 » Sat Jun 08, 2013 2:45 pm

I am planning to apply the April 2013 PSU where standalone databases running on ASM.
I have confused with the steps.Can you please provide the steps.
Thanks,
Niranjan
niranjan626
Member
 
Posts: 10
Joined: Tue May 21, 2013 3:55 pm

Re: PSU on 11.2.0.3 over GI & RDBMS Homes (StandAlone Server

Postby Tim... » Sat Jun 08, 2013 3:48 pm

Hi.

Read the patch note. It tells you exactly what to do there.

Whenever you apply a patchset or PSU, you really need to read patch note and follow it exactly.

The database patch note is here:

https://updates.oracle.com/Orion/Servic ... u=15962803

Just work your way through the document. I think the only thing of note here is that you are using ASM, which means you will have a Grid Infrastructure installation. the patch note says,

"If you are installing the PSU to an environment that has a Grid Infrastructure home, note the following: Grid Infrastructure PSU 11.2.0.3.6 Patch 16083653 should be applied to the Grid Infrastructure home and Database home using the readme instructions provided with the patch."

So you need to patch the GI with the specified patch, before moving on to do this database patch.

There are no shortcuts or clever things you can do with these patches. Every time (and I do mean every time) I have to apply a patch I follow the patch notes exactly. Without deviation!

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17966
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: PSU on 11.2.0.3 over GI & RDBMS Homes (StandAlone Server

Postby niranjan626 » Tue Jun 11, 2013 6:05 pm

when we are applyng the psu patch on DBMS HOME we are getting below error. Please suggest.
/u03/oradata/backup/src/16056266>opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.4
Copyright (c) 2012, Oracle Corporation. All rights reserved.

PREREQ session

Oracle Home : /u01/app/oracle/product/11.2.0.3/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.3/db_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/db_1/cfgtoollogs/opatch/opatch2013-06-11_13-37-40PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

/u03/oradata/backup/src/16056266>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/db_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0.3/db_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/db_1/cfgtoollogs/opatch/opatch2013-06-11_13-54-45PM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:


Following executables are active :
/u01/app/oracle/product/11.2.0.3/db_1/lib/libclntsh.so.11.1
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2013-06-11_13-54-45PM_1.log

OPatch failed with error code 73
Thanks,
Niranjan
niranjan626
Member
 
Posts: 10
Joined: Tue May 21, 2013 3:55 pm

Re: PSU on 11.2.0.3 over GI & RDBMS Homes (StandAlone Server

Postby Tim... » Tue Jun 11, 2013 8:45 pm

Hi.

Well, the patch note would have told you to stop all Oracle services related to the home before applying the patch. The failure you are listing is the utility telling you you have not done that as there are still active files in the home. I suggest you follow what the patch note tells you to do and you won't get this problem.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17966
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: PSU on 11.2.0.3 over GI & RDBMS Homes (StandAlone Server

Postby niranjan626 » Wed Jun 12, 2013 8:53 pm

Hi,

yes we find one Sqlplus session still running, we kill the session and it worked fine.Thank You.
Thanks,
Niranjan
niranjan626
Member
 
Posts: 10
Joined: Tue May 21, 2013 3:55 pm

Re: PSU on 11.2.0.3 over GI & RDBMS Homes (StandAlone Server

Postby Tim... » Thu Jun 13, 2013 6:22 am

Cool.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 17966
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Database Administration

Who is online

Users browsing this forum: No registered users and 2 guests

cron