Re: Oracle RAC support & Clarify
Date: Wed, 17 Dec 2008 06:07:23 -0800 (PST)
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 : 188.8.131.52
> > 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