Advanced Replication combined with Oracle Parallel Server

Hi

has anybody implemented Advanced Replication in an Oracle Parallel Server environment. If so I would be interested to know what problems if any you ran into and if there are any special considerations over and above Advanced Replication in a single instance environment.

We have a primary site running a Sun Cluster (2-nodes) with Solaris 2.6 and Oracle 8.0.5. running in OPS configuration. We have a failover site which also has a Sun Cluster running 8.0.5. The advice we are getting is that we should run Async Replication at 6 minute intervals.

We are an internet based business with most of our 'users' coming in over the web.

Questions

1. has anybody done anything like this before.
2. are you aware of any limitations in terms of Oracle which imposes the six minute intervals
3. What conflict resolutions strategies do you use to get around the possibility of users reentering a transaction after being kicked off because they believe it failed as they are connected to the secondary site which hasnt recieved the replicated data.
4. Are there any other limitations in an OPS configuration to be considered. For instance do I need to set my 'job' init.ora parameters on the master node of the cluster only or one or both.

Any advice, lessons learnt hints would be greatly apreciated

regards

Michael Walsh
mjwalsh_at_hotmail.com

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Aug 27 1999 - 09:11:32 CDT