| OLTP and DSS in 3-nodes RAC can't work [message #391084] |
Tue, 10 March 2009 21:18  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
