TES - Redundancy of oracle database

Ceceil Rufo · ‎09-30-2011

Hello:

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.

Joe Fletcher · ‎12-05-2011

Hi,

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.

Cheers

Joe

Jay Kish · ‎03-14-2012

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 11.2.0.2

Ceceil Rufo · ‎03-14-2012

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'.

Joe Fletcher · ‎03-14-2012

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.

Jay Kish · ‎03-14-2012

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

JdbcURL=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=yes)(FAILOVER=on)(ADDRESS=(PROTOCOL=TCP)(HOST=server1-vip.oracleoutsourcing.com)(PORT=10010))(ADDRESS=(PROTOCOL=TCP)(HOST=server2-vip.oracleoutsourcing.com)(PORT=10010)))(CONNECT_DATA=(SERVICE_NAME=PROD_DB)(FAILOVER_MODE=(TYPE=SELECT)(METHOD=BASIC)(RETRIES=20)(DELAY=20))))

mikefortuna · ‎03-14-2012

Jay,

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.