OraFAQ Forum: Server Administration » Oracle 11g patch installation

Home » RDBMS Server » Server Administration » Oracle 11g patch installation (11.2.0.1.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 11g patch installation [message #492524]

Mon, 31 January 2011 23:43

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Hi,

I am using Oracle 11g (11.2.0.1.0) and I want to apply January patch on 11.2.0.1.0. I have applied 3 patches. I have single Instance with ASM and Grid.

Grid home: /opt/grid/11.2.0/grid
Oracle Home: /opt/oracle/product/11.2.0/db

1. Opatch (6880880)
2. Grid patch (9655006)
3. Oracle Patch (10248516)

I have followed the following steps.

1. Applied Opatch on grid.
unzip p6880880_112000_LINUX.zip -d /opt/grid/11.2.0/grid

2. Validated the Oracle Inventory.
/opt/grid/11.2.0/grid/OPatch/opatch lsinventory -detail -oh /opt/grid/11.2.0/grid

3. Shut down the databases.
4. Run the prepatch script
./9655006/custom/server/9655006/custom/scripts/prepatch.sh
5. Shutdown the ASM.
6. Ran the below command to stop CSS etc.
/opt/grid/11.2.0/grid/crs/install/roothas.pl -unlock

7. Applied grid patch.
/opt/grid/11.2.0/grid/OPatch/opatch napply -oh /opt/grid/11.2.0/grid -id 9655006

8. Applied Opatch on Oracle home
9. Applied Oracle patch
/opt/oracle/product/11.2.0/db/OPatch/opatch napply -oh /opt/oracle/product/11.2.0/db -id 10248516

8. Run the postpatch script
./9655006/custom/server/9655006/custom/scripts/postpatch.sh

9. Run the following script to enable CSS etc.
/opt/grid/11.2.0/grid/crs/install/roothas.pl -patch
/opt/grid/11.2.0/grid/bin/crsctl check has
/opt/grid/11.2.0/grid/bin/crsctl check css

10. If CSS is not online ran the below command.
/opt/grid/11.2.0/grid/bin/crsctl modify resource "ora.cssd" -attr "AUTO_START=1"
/opt/grid/11.2.0/grid/bin/crsctl modify resource "ora.diskmon" -attr "AUTO_START=1"
/opt/grid/11.2.0/grid/bin/crsctl stop has
/opt/grid/11.2.0/grid/bin/crsctl start has

11. Up the ASM and Databases. Ran the postinstall in GRID and Oracle.
@catbundle.sql psu apply

12. Ran the below command on grid and Oracle.
/opt/grid/11.2.0/grid/OPatch/opatch lsinventory
/opt/oracle/product/11.2.0/db/OPatch/opatch lsinventory

1. Let me know steps which are followed are right because I didnot see the version change after connecting to database? (for example 11.2.0.1.0 after applying I can see 11.2.0.1.4 but not changed the version). Please let me know How should I know the patch is applied properly?

2. Is the above steps are applicable to HA setup. If steps are different please provide the steps.

Please advice.

Report message to a moderator

Re: Oracle 11g patch installation [message #492671 is a reply to message #492524]

Tue, 01 February 2011 13:06

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

$ORACLE_HOME/OPatch/opatch lsinv

[Updated on: Wed, 02 February 2011 00:58] by Moderator

Report message to a moderator

Re: Oracle 11g patch installation [message #492701 is a reply to message #492671]

Tue, 01 February 2011 21:25

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Sorry I didn't get the answer.

Report message to a moderator

Re: Oracle 11g patch installation [message #492704 is a reply to message #492701]

Tue, 01 February 2011 22:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Oracle 11g patch installation [message #492813 is a reply to message #492701]

Wed, 02 February 2011 13:00

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

The answer to this question:
grpatwari wrote on Tue, 01 February 2011 00:43

Please let me know How should I know the patch is applied properly?

is to execute:

$ORACLE_HOME/OPatch/opatch lsinv

[Updated on: Wed, 02 February 2011 13:08] by Moderator

Report message to a moderator

Re: Oracle 11g patch installation [message #492946 is a reply to message #492524]

Thu, 03 February 2011 16:47

efierro
Messages: 2
Registered: February 2011
Location: Mexico/US

Junior Member

Dude, if you are installing the CPU then you will not see a change on the minor version#, if you are installing the PSU (patch set update) then you will have a new minor version # such as from 11.2.0.1.0 to 11.2.0.1.1.

Looking at your patch#, I think you are installing indeed the PSU, which should result in a new version. As mentioned check the output of OH/Opatch/opatch lsinventory and see if you have the 5th number changed.

Report message to a moderator

Re: Oracle 11g patch installation [message #493449 is a reply to message #492946]

Tue, 08 February 2011 01:07

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Hi,

I am seeing the output which I mentioned in Opatch lsinventory but when I connect to sqlplus I am seeing 11.2.0.1.0.

Will not be shown after connecting to sqlplus?

Please advice.

Report message to a moderator

Re: Oracle 11g patch installation [message #493533 is a reply to message #493449]

Tue, 08 February 2011 10:01

efierro
Messages: 2
Registered: February 2011
Location: Mexico/US

Junior Member

I just installed a bran new GI home (non RAC) and created a couple of ASM disk groups, then applied the PSU for GI, the latest available and got the same result, no change on the fifth version component... I guess it is normal but you may want to ask Oracle support.

Report message to a moderator

Previous Topic:	Manual DB Creation in UNIX
Next Topic:	Undo Tablespace Size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 08 01:42:33 CDT 2024