This discussion is archived
2 Replies Latest reply: Mar 27, 2013 2:48 AM by Jos van den Oord RSS

RAC database patchset 10.2.0.5 on windows

998142 Newbie
Currently Being Moderated
HI,

I have 2 RAC environment having 13 Production database with version 10.2.0.4 of database, clusterware and ASM on Windows server 2008 64 bit.

Now I need to apply patchset 10.2.0.5 on ONLY one database due to BUG. Instead of apply patchset on all RAC database and upgrade planning for only one affected database. I need to below clarification -

1. I am planning to apply patchset 10.2.0.5 on clusterware and ASM only.

2. Planning to install 10.2.0.5 on new oracle home.

3. Planning to upgrade one affected database from 10.2.0.4 to 10.2.0.5.

QUESTION HERE -
1. Will above plan work for one database only.
2. Will clusterware and ASM (10.2.0.5)will support both ORACLE_HOME (10.2.0.4 and 10.2.0.5) databases
3. How we can setup clusterware for this new ORACLE_HOME (10.2.0.5) DATABASEs.

Anyone have any plan or suggestion please share.
  • 1. Re: RAC database patchset 10.2.0.5 on windows
    606331 Explorer
    Currently Being Moderated
    please refer below link .......topic 1.2.4 Shared Oracle Homes with Oracle Cluster File System

    http://docs.oracle.com/cd/B19306_01/install.102/b14203/intro.htm
    http://docs.oracle.com/cd/B19306_01/install.102/b14203/prelinux.htm#CIHFICFD

    i hope it may helpful to you.....
    my suggestion is consult through SR with support.oracle.com.......
  • 2. Re: RAC database patchset 10.2.0.5 on windows
    Jos van den Oord Newbie
    Currently Being Moderated
    Hi,

    Yes it is possible to have multiple ORACLE_HOMES inside a Oracle GRID infrastructure. To check the supported and compatibility My Oracle Support for this.

    1. check compatibility of the components and make the design for your listener
    2. Upgrade ASM en clusterware. to 10.2.0.5
    3. Install new oracle software tree 10.2.0.5
    4. upgrade one database to 10.2.0.5
    keep in mind the Oracle Cluster Registry for this database has to change

    Cheers,

    Jos van den Oord
    Blog : http://joordsblog.vandenoord.eu/
    Company : http://www.transfer-solutions.com/

    "Don't believe it, test it!"

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points