webMethods

webMethods

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
  • 1.  Problems after moving to Oracle 10g Rac

    Posted Thu October 04, 2007 07:53 PM

    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


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration


  • 2.  RE: Problems after moving to Oracle 10g Rac

    Posted Thu October 04, 2007 11:10 PM

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

    HTH,
    RMG


    #B2B-Integration
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: Problems after moving to Oracle 10g Rac

    Posted Fri October 05, 2007 12:54 AM

    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


    #Integration-Server-and-ESB
    #B2B-Integration
    #webMethods


  • 4.  RE: Problems after moving to Oracle 10g Rac

    Posted Mon October 22, 2007 01:28 PM

    Hi Jerry?

    Is your Issue has been resolved?

    Thanks in Advance
    Gouse.


    #webMethods
    #Integration-Server-and-ESB
    #B2B-Integration