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
Expand all | Collapse all

During migration from 10.1 to 10.5 , MWS unable to connect to the DB

  • 1.  During migration from 10.1 to 10.5 , MWS unable to connect to the DB

    Posted Mon June 14, 2021 08:25 AM

    HI team ,

    I am doing migration from 10.1 to 10.5 , initially started for MWS

    Do you want to use your live database for server instance “default”? [Y] Yes to use the live database or [N] No to use a clone of the live database:Y

    Unable to connect to the supplied database. Reason: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-12514 Connection refused, the specified service name (sd_spt) was not recognized by the Oracle server.
    14:08:39.530 [main] ERROR Migration - Unable to connect to the supplied database. Reason: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-12514 Connection refused, the specified service name (sd_spt) was not recognized by the Oracle server.

    But i can connect my DB from oracle.

    can anyone please guide to further ?

    Thanks


    #webMethods-io-Integration
    #MWS-CAF-Task-Engine
    #Oracle
    #Integration-Server-and-ESB
    #migration
    #webMethods


  • 2.  RE: During migration from 10.1 to 10.5 , MWS unable to connect to the DB

    Posted Mon June 14, 2021 09:11 AM

    check the db configuration in <MWS_Home>/server/default/config/mws.db.xml and check if this configuration is correct.

    Please compare this config with the config you are using


    #webMethods
    #MWS-CAF-Task-Engine
    #migration
    #Integration-Server-and-ESB
    #Oracle
    #webMethods-io-Integration


  • 3.  RE: During migration from 10.1 to 10.5 , MWS unable to connect to the DB

    Posted Mon June 14, 2021 11:37 AM

    Yes , that’s the problem. Updated the correct info and migration is successful.

    Thank you :slight_smile:


    #MWS-CAF-Task-Engine
    #migration
    #webMethods
    #Integration-Server-and-ESB
    #webMethods-io-Integration
    #Oracle