Error during IdM database creation on Oracle

[Former Member]

Hi,

We sometimes encounter the following error when creationg IDM database on Oracle (mxmc-install.sh) :

********************************************************************************
*** Updates installed
********************************************************************************
*** Creating language generation procedures
mxp_init_ids_onelang
mxp_init_ids_lang

Warning: Procedure created with compilation errors.

*** Creating procedures
mc_schemaversion
mc_version
mxpv_job_tasklink

And then we have errors on other procedures and initial load of the database :

[...]
mxp_init_ids
Warning: Procedure created with compilation errors.
[...]
mc_reset_ids
Warning: Procedure created with compilation errors.
[...]
mxp_init_all_ids
Warning: Procedure created with compilation errors.
[...]
mxp_Xcreate_ids
Warning: Procedure created with compilation errors.
[...]
mxp_create_ids
Warning: Procedure created with compilation errors.

BEGIN mxp_init_all_ids(:vStatus,:vStatusText); END;
 
      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object IP3_OPER.MXP_INIT_ALL_IDS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
 
 
BEGIN mxp_create_ids(:IsId,:Status,:StatusText); END;
 
      *
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00905: object IP3_OPER.MXP_CREATE_IDS is invalid
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

During first installation of IDM database there was no problem. So it seems it's a environnement parameter or Oracle parameter issue. Has anyone encountered the same problem ?

We were told there were no changes either on Oracle or on the system. But there must have been a change somehow impacting the language.

Do you have any idea on the Oracle parameters that could be involved ?

Thanks in advance,

Regards,

Herve.

[PI]

Hi,

I was facing the same problem and it was not possible to create an identity store.

The solution for me was increasing the oracle sga_max_size and shared_pool_size parameters.

They had the initial value fom installation of AS Java and setting shared_pool_size to 400MB fixed the procedure compilation problem.

After that I rerun the mxmc-update.cmd script and no more errors show up.

Creating idenitiy stores also works now.

Regards...Philipp