Oracle RAC and WebLogic

[78aspide78]

Is Oracle 11R2 RAC supported for 9.1 JD Edwards application running on WebLogic Server?

 

[franck_blettner]

Hi Bruno,

Yes Oracle RAC is supported with E1 9.1 and also with weblogic. You have to define your listener_scan into your tnsnames.ora on your web server.

Franck Blettner
http://www.nomana-it.fr

 

[78aspide78]

Thanks for your answer. Are you running this configuration?

In my test, when one node goes down WebClient is unable to reconnect to the live node until service restart. So scan works fine but the live connection (JDBC) to the killed node are still attached to the wrong node.

 

[franck_blettner]

Yes for a customer and it was working.

Did you define your tns like this :
JDE = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <node1>)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = <node2>)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = <transparent application failover service>) )
)

 

[78aspide78]

From you tnsnames (I assume it's from web client too) I see you are connected to a TAF service.
WLS doesn't support TAF (just because JDBC 4 doesn't support it). So it's very strange that this config works.

Another point is that you should use SCAN NAME but in your tnsnames your are putting two node (I was aspected only one HOST).

Are you sure you are on Oracle 11gR2 and WLS?

 

[franck_blettner]

Yes it was not the good one tnsnames.ora. Below, with WLS, Oracle 11gR2 but E1 9.0

JDE900 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = ORAJDE-scan)(PORT = 1521))
(LOAD_BALANCE = yes)
(FAILOVER = yes)
(CONNECT_DATA =
(SERVICE_NAME = JDE900_TAF)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)

 

[78aspide78]

Thanks Franck,
I'll test again.