cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
2393
Views
0
Helpful
6
Replies

TES - Redundancy of oracle database

Ceceil Rufo
Level 1
Level 1

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.

6 Replies 6

Joe Fletcher
Level 1
Level 1

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
Level 1
Level 1

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

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

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.

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))))


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.

Getting Started

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: