Problems after moving to Oracle 10g Rac

, ,
1

Hi,
We have been running a TN for quite some time its only recently that we have moved to the Oracle 10g RAC configutation. Since then however every time that the IS starts up the connection to the TN is failing with the following error.

WmTN: Startup service (wm.tn.admin:startup)
2007-10-04 15:52:32 GMT [ISU.0000.9999C] TRANET: Starting webMethods Trading Networks
2007-10-04 15:52:32 GMT [ISU.0000.9999D] TRANET: Loading system configuration
2007-10-04 15:52:32 GMT [ISU.0000.9999C] com.wm.app.tn.db.DatastoreException: Trading Networks could not retrieve data from your database. Go to the JDBC Pools page in the Integration Server Administrator and make sure your database URL, user name, and password are set correctly. Also make sure you created the Trading Networks database tables as described in the webMethods Installation Guide.
(0) java.sql.SQLException: No suitable driver
(1) java.sql.SQLException: No suitable driver

The change here is that we are now pointing it through a RAC configuration. We are using the following URL for connecting. However once the IS up and we restart the jdbc pool and reload the WmTN package, everything is fine.

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS = (PROTOCOL = TCP)(HOST = host1)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = host2)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = serviceName)))

Is there any configuration we are missing?
Any help is greatly appreciated.

Thanks and regards
-jk

2

Did you take up this issue with wM tech support?? Any word from them or from DBA??

HTH,
RMG

3

The URL was provided by the DBA’s they stick by it and state they have no problem. The strange aspact about this is the same day we also migrated our regular JDBC adapter connections to the 10g RAC and they do not have the problem its only with the TN that we are facing this issue.

Just thought i will check out here before we excalate it to tech support.
Thanks
-jk

4

Hi Jerry?

Is your Issue has been resolved?

Thanks in Advance
Gouse.