IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

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

webMethods 8.x on Oracle XE?

  • 1.  webMethods 8.x on Oracle XE?

    Posted Wed November 10, 2010 03:10 PM

    Has anyone gotten the dbConfigurator to successfully create schemas on Oracle XE?

    I just got a good install on SQL Server 2008 Express, but I get an error trying to install on XE running in UNIX.


    Summary of installation errors

    Error in executing file C:\wMethods8\common\db/scripts/oracle/databasemanagement/20/create/ora_dbm_c_dml.sql
    SQL error [wm-cjdbc40-0034][Oracle JDBC Driver][Oracle]ORA-04063: package body “WMUSER.OPERATION_MGMT” has errors
    ORA-06508: PL/SQL: could not find program unit being called: “WMUSER.OPERATION_MGMT”
    ORA-06512: at “WMUSER.SWAPOPS”, line 1869
    ORA-06512: at line 6

    Following components could not be installed:

    DatabaseManagement 20


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods
    #webMethods-Upgrade


  • 2.  RE: webMethods 8.x on Oracle XE?

    Posted Wed November 10, 2010 03:39 PM

    That’s not the problem with Oracle XE, it’s seems the DB scripts (installation image) you used have improper/corrupt SWAPOPS package… FYI… DB configuration works well with Oracle XE


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods
    #webMethods-Upgrade


  • 3.  RE: webMethods 8.x on Oracle XE?

    Posted Fri October 21, 2011 10:43 AM

    From other forum:

    In Oracle XE, the sys.UTL_SMTP is not granted for execution by default (referred in OPERATION_MGMT).
    To solve this, login to database as a sys and execute the following command:

    Grant execute on sys.utl_smtp to public;


    #Integration-Server-and-ESB
    #webMethods-Upgrade
    #webMethods
    #webMethods-General