Re: Oracle RAC support & Clarify

From: <shweta.kaparwan_at_googlemail.com>
Date: Wed, 17 Dec 2008 06:07:23 -0800 (PST)
Message-ID: <dd2c3777-3cd9-4f04-bf79-54f97eee33a7@p29g2000vbn.googlegroups.com>


On Dec 17, 1:36 pm, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
> On Dec 16, 8:42 pm, shweta.kapar..._at_googlemail.com wrote:
>
>
>
>
>
> > On Dec 17, 1:33 am, Mark D Powell <Mark.Pow..._at_eds.com> wrote:
>
> > > On Dec 16, 8:22 pm, shweta.kapar..._at_googlemail.com wrote:
>
> > > > Hi All
>
> > > > Does Clarify CRM application supports Oracle Active-Active Real
> > > > Application Cluster?
>
> > > > Further, I will appreciate any refrence to documents/links.
>
> > > > Regards.
>
> > > > Shweta
>
> > > Vendor products do not really need to be written to support RAC.  You
> > > can set up the Oracle connection string such that the application
> > > always goes to a specific instance, group of instances, or is load
> > > balanced to any available instance.  The application has no idea where
> > > the database resides or which instance it goes to.
>
> > > That said it is possible to write RAC aware software that takes
> > > advantage of the ability to fail transactions over in the event of
> > > instance failure.
>
> > > For specific information about a specific vendor product I would check
> > > the vendor web site and sales literature.
>
> > > HTH -- Mark D Powell --
>
> > Many Thanks Mark.
> > True. We are setting the Oracle connection string in such a way that
> > all connections goes to Primary Instance.
> > Hence all the connection goes to the Primary database instance.
>
> > But recently there was a Primary instance failure and application
> > tried to connect to the other surviving instance.
> > Application got connected to other instance, but we got babdly hit by
> > OR-01861. Later in order to get rid of it we had to bounce the
> > application.
>
> > Additinal info :
> > RDBMS : 9.2.0.6
> > Weblogic : 8.1 sp5
> > Clarify CRM : 13.1
>
> > Regards
>
> > Shweta- Hide quoted text -
>
> > - Show quoted text -
>
> Being that an ORA-01861 is a date format string error that would seem
> to be an application issue.  We have a vendor application that does
> not seem to behave well when the database instance is bounced so we
> always have to bounce it after we bounce the database instance.   This
> is true if the instance is RAC or non-RAC.  The vendor is this case
> has their own web server related pieces.  We do not have this problem
> with our home-grown web applications.
>
> If you can fail your instances over and then duplicate the application
> problem you can go to the vendor and ask them to fix their issue and
> you can make it procedure that if an instance fails to bounce the
> application.  Not a perfect solution but often good enough as long as
> the application will shut down and start up in a short period of time
> since instance failure should be rare.
>
> HTH -- Mark D Powell --- Hide quoted text -
>
> - Show quoted text -

Thanks a lot! Mark. Received on Wed Dec 17 2008 - 08:07:23 CST

Original text of this message