WebMethods updates for Oracle Migration

, ,
1

Hi There,

We have our system in 7.1.2 with oracle 10G. As a part of migration the DB is getting an uplift to Oracle 11.

The configurations for the IS with the new ODBC URL’s is done. But while checking the MWS we are not able to see
any transactions . This could be due the MWS being still pointing to old DB environment.

We dropped the existing DB elements using the DB configurator in \webMethods7\common\db\bin where DB components was selected as MywebMethods server.

In order to confgure the new DB for MWS we have used the same DB configurator and used the create MWS DB compenents were selected with new Database connection URL.

this on clicking the execute button gives out the below error :

  • Scripts create

  •   Script(1): G:\webMethods7\common\db/scripts/oracle/componenttracker/20/create/ora_ctr_c_ddl.sql

  •   Script(2): G:\webMethods7\common\db/scripts/oracle/componenttracker/20/create/ora_ctr_c_ddl_view.sql

  •   Script(3): G:\webMethods7\common\db/scripts/oracle/componenttracker/migrate/10_to_20/ora_ctr_m_10_to_20.sql
  • Database Connection error: No suitable driver
    CDC Error: java.sql.SQLException: No suitable driver

Can some one help us on this ? All we need is MWS to point to the new DB in Oracle 11.

The server we have is Windows 2008 R2. Does this require any new driver or Fix to be deployed ?

Cheers,
Ragav J

2

Hi Ragav,
You are on your way to see the next problem once this driver issue is fixed… :slight_smile:

If you had ‘dropped’ tables of MWS using dbConfigurator, and recreated new set of tables, what happens to the data inside those old tables? Without that how can your existing MWS start? You got to reinstall a new instance of MWS and point it to this new DB, only then MWS will run…

I hope you did this in your Dev or Sandbox environment and not in Test/Prod.

Happy fixing… :slight_smile:

-Senthil

3

Thanks a lot for your response Senthil. (of course its our dev env :smiley:

Can you confirm that re-installing MWS is going to be only solution ?

how do we handle this Oracle Migration to version 11 from 10 ? Please confirm if our below understanding is correct

  • Configure IS JDBC pools to new environment

  • Uninstall MWS.

  • Re install MWS by pointing it to new DB

Also please advise how can we un install MWS alone

4
  1. Check for System Requirements document if Oracle 11G is supported by 7.1.2 server. The current documentation doesn’t have any details on 7.1.2 as it is already out of support

Link: http://techcommunity.softwareag.com/ecosystem/documentation/webmethods/wmsuites/wmsuite8-2_sp2/SysReqs_Installation_and_Upgrade/8-2_System_Requirements.pdf

  1. If you move from one oracle version to another, you have to move all schemas that exists in older version to newer version. Once schema’s are moved, edit mws.db.xml file or use putConfig/getConfig commands to update with new server details.

  2. If IS also uses the same database, edit all JDBC Pools definition and JDBC Adapters if required

  3. Restart MWS and IS.

You don’t have to uninstall MWS, or drop db tables in schema.

HTH
Senthil

5

Thanks a lot Senthil for explaining the process.

I will check if 7.1.2 has support for Oracle 11 G.

Regards,
Ragav J

6

Hi there,

I have searched across the net to find if version 7.1.2 supports Oracle 11G but not able to find a concrete answer.

I got the below link in SAG site which mentions that we need a fix to be deployed to connect to Oracle 11 env.


http://techcommunity.softwareag.com/ecosystem/communities/public/webmethods/products/suite/news/ead47180-8bec-11e2-83fb-cd8d7ef22065/?title=Announcing+the+general+availability+of+webMethods+7.1.2+Certification+on+AIX+6.1%2C+DB2+9.5%2C+Oracle+11.1%2C+and+DataDirect+Connect+4.0

Can some one from SAG please confirm if we need any fix/driver upgrades for 7.1.2 to connect to Oracle 11G.

Since its no longer supported is there any other alternatives available ?

The JDBC adapter we use is 6.5 - with JDBC_6.5_Fix23.

Thanks in advance,

Ragav J

7

Please check below sys requirement document…
[url]http://techcommunity.softwareag.com/ecosystem/documentation/webmethods/wmsuites/wmsuite7/Cross_Product/webMethods_System_Requirements_7x.pdf[/url]