gregglarkin
Legendary Poster
Does anyone have experience setting up 9.0 with an Oracle RAC database? Any RAC experience is helpful, RAC with 11 G r2 is most helpful. Here is our problem:
We have have two Exadata servers (Sun Sunfire servers). The Exadatas have multiple compute nodes hosting Oracle 11 G r2 databases. We use RAC to keep the data in synch between the two nodes. Rac requires two different TNS host names for each server.
If both servers are up and listening, we can swing JDE back and forth between the nodes. If one or the other node is down, then either our login time is delayed (one minute of delay) in our best case scenario, or we can't log in at all.
The clients are weblogic servers on Linux. The batch servers are windows 2008. We also have this issue with linux based batch servers. (we are trying out both windows and linux for the batch server layer of our cloud of servers)
On the windows/sql world, we do not have this issue. When we swing from node to node, the MS cluster names and the SQL cluster names remain the same, just the server hosting them changes.
We have an open ticket with Oracle on this, but they are stumped. We would assume that there must be some other customers out there that are using 9.0 with RAC. We don't think this is an Exadata issue, we think that this is a Rac issue.
Any thoughts?
below is the latest TNS that oracle had us try out:
pxprod.na.praxair.com =
(DESCRIPTION_LIST=
(LOAD_BALANCE=OFF)(FAILOVER=on)
(DESCRIPTION =
(LOAD_BALANCE=on)(TRANSPORT_CONNECT_TIMEOUT=5)(CONNECT_TIMEOUT=10)(RETRY_COUNT=0)
(ADDRESS = (PROTOCOL = TCP)(HOST = jdedb1-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = jdedg.na.praxair.com)
)
)
(DESCRIPTION =
(LOAD_BALANCE=on)(TRANSPORT_CONNECT_TIMEOUT=5)(CONNECT_TIMEOUT=10)(RETRY_COUNT=0)
(ADDRESS = (PROTOCOL = TCP)(HOST = jdedb2-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = jdedg.na.praxair.com)
)
)
)
pxdev.na.praxair.com =
(DESCRIPTION_LIST=
(LOAD_BALANCE=OFF)(FAILOVER=on)
(DESCRIPTION =
(LOAD_BALANCE=on)(TRANSPORT_CONNECT_TIMEOUT=5)(CONNECT_TIMEOUT=10)(RETRY_COUNT=0)
(ADDRESS = (PROTOCOL = TCP)(HOST = jdedb1-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pxdevdg.na.praxair.com)
)
)
(DESCRIPTION =
(LOAD_BALANCE=on)(TRANSPORT_CONNECT_TIMEOUT=5)(CONNECT_TIMEOUT=10)(RETRY_COUNT=0)
(ADDRESS = (PROTOCOL = TCP)(HOST = jdedb2-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pxdevdg.na.praxair.com)
)
)
)
- Gregg
We have have two Exadata servers (Sun Sunfire servers). The Exadatas have multiple compute nodes hosting Oracle 11 G r2 databases. We use RAC to keep the data in synch between the two nodes. Rac requires two different TNS host names for each server.
If both servers are up and listening, we can swing JDE back and forth between the nodes. If one or the other node is down, then either our login time is delayed (one minute of delay) in our best case scenario, or we can't log in at all.
The clients are weblogic servers on Linux. The batch servers are windows 2008. We also have this issue with linux based batch servers. (we are trying out both windows and linux for the batch server layer of our cloud of servers)
On the windows/sql world, we do not have this issue. When we swing from node to node, the MS cluster names and the SQL cluster names remain the same, just the server hosting them changes.
We have an open ticket with Oracle on this, but they are stumped. We would assume that there must be some other customers out there that are using 9.0 with RAC. We don't think this is an Exadata issue, we think that this is a Rac issue.
Any thoughts?
below is the latest TNS that oracle had us try out:
pxprod.na.praxair.com =
(DESCRIPTION_LIST=
(LOAD_BALANCE=OFF)(FAILOVER=on)
(DESCRIPTION =
(LOAD_BALANCE=on)(TRANSPORT_CONNECT_TIMEOUT=5)(CONNECT_TIMEOUT=10)(RETRY_COUNT=0)
(ADDRESS = (PROTOCOL = TCP)(HOST = jdedb1-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = jdedg.na.praxair.com)
)
)
(DESCRIPTION =
(LOAD_BALANCE=on)(TRANSPORT_CONNECT_TIMEOUT=5)(CONNECT_TIMEOUT=10)(RETRY_COUNT=0)
(ADDRESS = (PROTOCOL = TCP)(HOST = jdedb2-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = jdedg.na.praxair.com)
)
)
)
pxdev.na.praxair.com =
(DESCRIPTION_LIST=
(LOAD_BALANCE=OFF)(FAILOVER=on)
(DESCRIPTION =
(LOAD_BALANCE=on)(TRANSPORT_CONNECT_TIMEOUT=5)(CONNECT_TIMEOUT=10)(RETRY_COUNT=0)
(ADDRESS = (PROTOCOL = TCP)(HOST = jdedb1-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pxdevdg.na.praxair.com)
)
)
(DESCRIPTION =
(LOAD_BALANCE=on)(TRANSPORT_CONNECT_TIMEOUT=5)(CONNECT_TIMEOUT=10)(RETRY_COUNT=0)
(ADDRESS = (PROTOCOL = TCP)(HOST = jdedb2-scan)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = pxdevdg.na.praxair.com)
)
)
)
- Gregg