Cannot Start dm_oracle Using AES Encryption (Doc ID 1269552.1)

Last updated on SEPTEMBER 24, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.0 and later
Information in this document applies to any platform.
***Checked for relevance on 18-Dec-2013***
***Checked for relevance on 27-May-2015***

Goal

Cannot startup dm_oracle using AES encryption, but can do the same with md5 encryption.

The following error is logged in the dm_oracle.pinlog file:

SQL_STMT do_sql_select: cmd="select count (unique parent_element_id) from dd_objects_fields_t where obj_id0 = :1"
M Tue Aug 20 02:16:14 2013 dev-brm dm:12914 sm_ora_dd_sql.c(21):8171:dev-brm:dm:12913:1:0:1289558065:0
fetch_keys_from_db: PINStmtFetch key count is 5
E Tue Aug 20 02:16:14 2013 dev-brm dm:12914 sm_ora_dd_sql.c(21):9341:dev-brm:dm:12913:1:0:1289558065:0
ORACLE error: fetch_keys_from_db: PINStmtFetch: code 1405, op 0
=ORA-01405: fetched column value is NULL
E Tue Aug 20 02:16:14 2013 dev-brm dm:12914 sm_ora_dd_sql.c(21):10131:dev-brm:dm:12913:1:0:1289558065:0
dm_load_crypt_keys: scan_crypt_key returned error 43
E Tue Aug 20 02:16:14 2013 dev-brm dm:12914 sm_dd.c(3):1331:dev-brm:dm:12913:1:0:1289558065:0
dm_init_schema: dm_load_crypt_keys failed, err=43
E Tue Aug 20 02:16:14 2013 dev-brm dm:12914 dm_if_oracle.c(102):32821:dev-brm:dm:12913:1:0:1289558065:0
bad init_schema: err=43(PIN_ERR_STORAGE)
E Tue Aug 20 02:16:14 2013 dev-brm dm:12914 dm_back.c(22):4551:dev-brm:dm:12913:1:0:1289558065:0
be #0 can't do dm_if_init_process(), err 43
E Tue Aug 20 02:16:14 2013 dev-brm dm:12914 dm_main.c(39):26001:dev-brm:dm:12913:1:0:1289558065:0
DM back end [0] dm_die: "", errno 0
E Tue Aug 20 02:16:14 2013 dev-brm dm:12913 dm_main.c(39):23721:dev-brm:dm:12913:1:0:1289558065:0
DMm be #0 init failed, exiting

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms