Error while creating tables for DatabaseManagement

,
1

Hi Everyone

I am getting the below error while running database configurator to create tables:

[b]rror: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-04063: package body “SYSTEM.OPERATION_MGMT” has errors
ORA-06508: PL/SQL: could not find program unit being called: “SYSTEM.OPERATION_MGMT”
ORA-06512: at “SYSTEM.SWAPOPS”, line 1869
ORA-06512: at line 6

CREATE DATABASEMANAGEMENT [23.0] FAILED
CDC ERROR [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-04063: package body “SYSTEM.OPERATION_MGMT” has errors
ORA-06508: PL/SQL: could not find program unit being called: “SYSTEM.OPERATION_MGMT”
ORA-06512: at “SYSTEM.SWAPOPS”, line 1869
ORA-06512: at line 6

Suspending execution…[/b]

[b] Following components could not be installed:

DatabaseManagement 23.0[/b]

Due to this the MWS is not coming up. Could someone please help.

I am connecting to Oracle DB.

Please let me know if you need more information.

Thanks in Advance.

2

Can you share the below details:

1> IS version
2> OS
3> Oracle XE or enterprise edition
4> Components installed on IS

3

Hi Mahesh

Below are the details:

1> IS version : 9.6
2> OS : Windows
3> Oracle XE or enterprise edition : Oracle Database 10g Express Edition Release 10.2.0.1.0
4> Components installed on IS: IS, Broker,MWS,Adapters,DesignerOptimize and platform manager

Please let me know if you need more information.

Thanks in advance.

4

Regarding error: “UTL_SMTP” is an Oracle package, and it may be the permissions have not been granted on that package.

Grant privileges on the UTL_SMTP package to be able to Execute from the package.

I would suggest to use Oracle 11g or MSQL 2008/2008R2 or 2012. Refer system requirements guide for 9.6

5

I tried executing the below command:

Grant execute on util_smtp to public;

But it is throwing the below error:

ORA-04042: procedure, function, package, or package body does not exist

6

It worked with the below command:

Grant execute on utl_smtp to public;

Thank you for the help!!

7

Ok… :slight_smile:

8

Hi Tried it is working for one machine but in other version i was not able to install DatabaseManagement.

Version:9.8

9

Share the version and error details.