wM 10.7 issue in trial version

[gphimanshu]

Greetings,

I have installed webMethods 10.7 trial version, but I am getting below error -

1.) Analytic Engine Host and Task Engine are missing(PFA Screenshot)

2.) While installing the component : DatabaseManagement via dbConfiguratorUI got error
script : 9
file : E:\SoftwareAG107\common\db\Optimize\DatabaseManagement\scripts\9.0.1\oracle\create_9.sql
status : executing
error: java.sql.SQLException: [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 1851
ORA-06512: at line 6

Can anyone please help.

Regards
Hims

[John_Carter4 (John Carter)]

This sounds like an issue with your local oracle installation.
Have you checked it independently from webMethods ?
John.

[gphimanshu]

PFA

[gphimanshu]

Hi John,

I am trying to run the script manually, but getting below error:

• Error: PL/SQL: Compilation unit analysis terminated
• Error: PLS-00905: object SYS.SWAPOPS is invalid
• Error: PLS-00304: cannot compile body of ‘SWAPOPS’ without its specification

Regards
Hims

[templar (Grigor Lekarov)]

Could you please try to execute the following before running DB Configurator:

GRANT EXECUTE ON SYS.UTL_SMTP TO &user;
GRANT EXECUTE ON SYS.DBMS_ALERT TO &user;
GRANT EXECUTE ON SYS.DBMS_JOB TO &user;
GRANT EXECUTE ON SYS.PLITBLM TO &user;
GRANT SELECT ON SYS.V_$PARAMETER TO &user;

[gphimanshu]

Thank You!!

Its worked. But below issues are still persisting.

1.) Analytic Engine Host and Task Engine are missing(PFA Screenshot)

[Holger_von_Thomsen]

Remember that this needs to be performed as DBA-User SYS as only SYS is allowed to grant these rights.

It is possible to run the configurator for this part two times:
first to create the user while using SYSTEM account for creation of user and schema.
Now grant the rights by SYS and then run the same creation command again to complete the schema.

We are using this as we usually do not have access to the SYS account and are asking our DBA to perform the grants as SYS and we rerun the configurator to complete the creation.

Regards,
Holger