Home » Server Options » RAC & Failsafe » OLTP and DSS in 3-nodes RAC can't work
OLTP and DSS in 3-nodes RAC can't work [message #391084] Tue, 10 March 2009 21:18 Go to next message
win3vin
Messages: 35
Registered: April 2007
Location: Malaysia
Member
Hi,

i have recently setup a 3-nodes RAC, 1st and 2nd nodes for OLTP application and the 3rd node is for DSS.

I want to configure a setup that enable load balance between node 1 and 2. Then node 3 only for datawarehouse where it can't perform load balance to node 1/2. But somehow when i configure the tns entry as below, the OLTP connection will still connect to node 3 and DSS connection still connect to node 1/2. How do I properly configure it? is there any vip or crs configuration file i need to change?

OLTP:
Node_1-2 =
DESCRIPTION =
(ADDRESS = (PROTOCOL=TCP)(HOST = 1-vip.test.com)(PORT = 1521))
(ADDRESS = (PROTOCOL=TCP)(HOST = 2-vip.test.com)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = abc.test.com)
)
)

DSS:
Node_3 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL=TCP)(HOST = 3-vip.test.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = abc.test.com)
)
)
Re: OLTP and DSS in 3-nodes RAC can't work [message #391255 is a reply to message #391084] Wed, 11 March 2009 09:53 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
May be, server side load balancing is turned on.

>>Then node 3 only for datawarehouse where it can't perform load balance to node 1/2
What if node3 went down?
That puts the question of using the RAC.

One method for doing this is properly is to create specific services for the jobs that will utilize the specific nodes.
With this,
Node3 will be preferred for Datwarehousing operations and if it is not available, nodes 1&2 will be used.
It is accounted in documentation and very precise example on
usage is here
http://www.oracle-base.com/articles/10g/Services10g.php

[Updated on: Wed, 11 March 2009 09:54]

Report message to a moderator

Previous Topic: cluster failure in oracle RAC in RH linux AS2.1 version
Next Topic: Views problems in RAC
Goto Forum:
  


Current Time: Thu Mar 28 04:58:14 CDT 2024