09-30-2011 09:23 AM
I am interested in hearing what type of redundancy setup people have on Tidal Enterprise Scheduler (TES) database, specifically with oracle. Although any information will be greatly appreciated.
We are planning the possibility of setting op an oracle RAC yet realize that this is not true 'replication', if anyone is using this setup I'd be interested in hearing about that as well.
Thanks in advance for your replies.
12-05-2011 02:55 AM
We've got Dataguard under our TES installation. Its worked pretty well so far.
A recent discussion with an Oracle rep suggests Goldengate may be worth a look too.
03-14-2012 08:34 AM
We utilize ORACLE RAC. We have a 2 node configuration for TES. We have been able to apply db changes without having outages. We are on ORACLE 126.96.36.199
03-14-2012 08:43 AM
Thank you for the answers.
Could I ask are there any specifics we would need to know to install in an Oracle RAC environment? Looking for any 'gotchas'.
03-14-2012 09:22 AM
RAC is effectively within a single data centre unless you have two buildings fairly close together. In our case our DCs are too far apart to run RAC in a reliable way hence Dataguard.
03-14-2012 10:30 AM
The only exception to the configuration you need to make is the JDBC connect. Make sure the string utlizes the VIP addresses to the databases. If you use the scan addresses you will not get compelte foilover and back capabilities. We had some initial challenges setting up the conect string so I just offer it up to you.
I am running TES 5.3.1
03-14-2012 11:46 AM
Why do you use the VIP addresses? Is this only for failover? I ask because I am running TES 5.3.1 off of an Oracle database, and am currently having issues holding the connection, and Tidal proceses causing locks in the database. Never had these issues in other environments where TES is running off of MSSQL database.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: