Re: RAC environment patching and availability

Those are technically not database patches since they dont update binaries. They are still procedures / pl/sql code that update underlying DB tables. We conventionally call them DB patches to differentiate from application file system patches that update only the application code tree.

Here the differentiator is the patches applied using opatch.

Thanks
Suresh

On 9/11/07, Binh Pham <binhpham15_at_hotmail.com> wrote:
>
> Peter,
>
>
>
> What I meant was to apply a patch to Oracle Applications E-Business Suites
> such as OE, INV, PO, etc…
>
>
> ------------------------------
>
> *From:* Peter McLarty [mailto:p.mclarty_at_cqu.edu.au]
> *Sent:* Monday, September 10, 2007 8:32 PM
> *To:* binhpham15_at_hotmail.com
> *Cc:* Oracle-l List
> *Subject:* RE: RAC environment patching and availability
>
>
>
> This would depend on what you mean by the patches being applied to the
> database. If like peoplesoft that it updates stored procedures or stored
> code that is kept in the database for queries and functions, then there is
> no patches applied to the database in the sense of a dba patching Oracle.
>
> I guess, unless the patching applies an Oracle delivered patch like you
> would install with opatch, then you don't have anything to worry about
> as that is not patching.
>
>
>
> As for if you can keep the database open then that is up to the individual
> applications, If you are referring to Oracle Application Server, then I
> understand with later versions that in some cases this is possible, but you
> need to review the documentation for that patch or patch bundle.
>
>
>
> HTH
>
> Cheers
>
>
>
> Peter
>
>
>
>
> ------------------------------
>
> *From:* Binh Pham [mailto:binhpham15_at_hotmail.com]
> *Sent:* Tuesday, 11 September 2007 01:03 PM
> *To:* kaygopal_at_yahoo.com; litanli_at_gmail.com
> *Cc:* Oracle-l List
> *Subject:* RE: RAC environment patching and availability
>
> I have a question. Supposed if I want to apply an Application patch and
> keep the database available to the users during that time for concurrent
> updates, what will the process be? Remember the Application patch also
> apply updates to the database as well.
>
> Thanks.
>
>
>
> ------------------------------
>
> Date: Mon, 10 Sep 2007 11:05:26 -0700
> From: kaygopal_at_yahoo.com
> Subject: Re: RAC environment patching and availability
> To: kaygopal_at_yahoo.com; litanli_at_gmail.com
> CC: oracle-l_at_freelists.org
>
> Li Li,
>
> In current versions, JUST RAC alone can not provide the 24x7 availability.
> You need to have the combination of RAC+Dataguard (logical) to have REAL
> 24x7 availability. Also not all patches/upgrades are 'rolling upgrade'
> capable.
>
> Have a look at this presentation to undertand the issues in rolling
> upgrade.
>
>
> http://www.oracle.com/technology/deploy/availability/pdf/oow06/S281209_To.pdf
>
>
>
> -Gopal
>
>
>
> On 9/10/07, Li Li <litanli_at_gmail.com> wrote:
> > Hi, All,
> >
> > I recently patched our 2-node RAC (10.2.0.2 on RHEL AS 4 update 4) to
> > 10.2.0.3. I got the impression that you can do rolling upgrade in a RAC
> > environment, until I dig into the patch installation document and found
> out
> > that you can do rolling upgrade on the clusterware part but not on the
> RAC
> > database part. Fortunately we can afford the service to be down for a
> couple
> > of hours.
> >
> > My question is: is there a way to keep your RAC database up while you
> patch
> > it? RAC itself doesn't really provide 24x7 High Availability? Any
> comments?
> >
> > Thanks,
> > -Li
>
>
> --
> Best Regards,
> K Gopalakrishnan
> Co-Author: Oracle Wait Interface, Oracle Press 2004
> http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/
>
> Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
> http://www.amazon.com/gp/product/007146509X/
>
>
>
>
> ------------------------------
>
> Can you find the hidden words? Take a break and play Seekadoo! Play now!<http://club.live.com/seekadoo.aspx?icid=seek_wlmailtextlink>
>

--
http://www.freelists.org/webpage/oracle-l