Oracle RAC support & Clarify

On Dec 17, 1:33 am, Mark D Powell wrote:
> On Dec 16, 8:22 pm, shweta.kapar....DeleteThis@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
 >> Stay informed about: Oracle RAC support & Clarify 

On Dec 16, 8:42 pm, shweta.kapar... RemoveThis @googlemail.com wrote:
> On Dec 17, 1:33 am, Mark D Powell wrote:
>
>
>
>
>
> > On Dec 16, 8:22 pm, shweta.kapar... RemoveThis @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 --
 >> Stay informed about: Oracle RAC support & Clarify 

On Dec 17, 1:36 pm, Mark D Powell wrote:
> On Dec 16, 8:42 pm, shweta.kapar....RemoveThis@googlemail.com wrote:
>
>
>
>
>
> > On Dec 17, 1:33 am, Mark D Powell wrote:
>
> > > On Dec 16, 8:22 pm, shweta.kapar....RemoveThis@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.
 >> Stay informed about: Oracle RAC support & Clarify