webMethods 8.x on Oracle XE?

, , ,
1

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

2

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

3

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;