Getting Error Dm_oracle Not Reconnecting On ORA-03114 After BRM 15 Upgrade (Doc ID 3064862.1)

Last updated on DECEMBER 31, 2024

Applies to:

Symptoms

On : 15.0.0.0.0 version, Infranet Install

getting error dm_oracle not reconnecting on ORA-03114 after BRM 15 upgrade

Getting this error while billing and other processes and because of this bill reject count is increasing.

this issue is occurring only with one schema <Schema 03> (out of multiple schema total 10)
At line 751: Error - OCI_ERROR ORA-03114: not connected to ORACLE

E Thu Aug 15 02:18:27 2024 <host_name> dm:3646952 dm_subr.c(186):2694 3:<host_name>:pin_bill_accts:3957100:427796224:110:1723683757726675:619:root.0.0.0.3::::-1

  ORACLE error: do_sql_insert: PINStmtExecute: code 3113, op 0

  =ORA-03113: end-of-file on communication channel

Session ID: 4136 Serial number: 11186
  "insert into journal_t ( poid_DB, poid_ID0, poid_TYPE, poid_REV, db_ar_net_amt, db_ar_disc_amt, amount_deferred, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, earned_start_t, earned_end_t, contract_obj_DB, contract_obj_ID0, contract_obj_TYPE, contract_obj_REV, contract_start_t, contract_end_t, tax_locales, tax_supplier, item_obj_DB, item_obj_ID0, item_obj_TYPE, item_obj_REV, effective_t, gl_id, resource_id, type, tax_code, db_ar_tax_amt, cr_ar_tax_amt, cr_ar_net_amt, cr_ar_disc_amt, created_t, mod_t, read_access, write_access, tax_exemption_code ) values ( :poid_DB, :poid_ID0, :poid_TYPE, :poid_REV, :db_ar_net_amt, :db_ar_disc_amt, :amount_deferred, :account_obj_DB, :account_obj_ID0, :account_obj_TYPE, :account_obj_REV, :earned_start_t, :earned_end_t, :contract_obj_DB, :contract_obj_ID0, :contract_obj_TYPE, :contract_obj_REV, :contract_start_t, :contract_end_t, :tax_locales, :tax_supplier, :item_obj_DB, :item_obj_ID0, :item_obj_TYPE, :item_obj_REV, :effective_t, :gl_id, :resource_id, :type, :tax_code, :db_ar_tax_amt, :cr_ar_tax_amt, :cr_ar_net_amt, :cr_ar_disc_amt, :created_t, :mod_t, :read_access, :write_access, :tax_exemption_code )"
E Thu Aug 15 02:18:27 2024 <host_name> dm:3646952 dm_do_ops.c(112):2096 3:<host_name>:pin_bill_accts:3957100:427796224:110:1723683757726675:619:root.0.0.0.3::::-1
ERROR do_create_create sql_insert err=43(PIN_ERR_STORAGE)
E Thu Aug 15 02:18:27 2024 <host_name> dm:3646952 dm_if_oracle.c(236):7244 3:<host_name>:pin_bill_accts:3957100:427796224:110:1723683757726675:619:root.0.0.0.3::::-1
DMbe dm_oracle_process_op(): update returning flist poid db_no failed. err=43(PIN_ERR_STORAGE)
E Thu Aug 15 02:18:27 2024 <host_name> dm:3646952 dm_if_oracle.c(236):5452 3:<host_name>:pin_bill_accts:3957100:427796224:110:1723683757726675:619:root.0.0.0.3::::-1
bad probe of ORACLE connection "PRSBRM_PIN03", PINStmtExecute rc 3114 errmsg "ORA-03114: not connected to ORACLE
"
E Thu Aug 15 02:18:27 2024 <host_name> dm:3646952 dm_if_oracle.c(236):4750 3:<host_name>:pin_bill_accts:3957100:427796224:110:1723683757726675:619:root.0.0.0.3::::-1
ORACLE error: try_logoff: OCITransRollback err = -1
W Thu Aug 15 02:18:27 2024 <host_name> dm:3646952 dm_if_oracle.c(236):5464 3:<host_name>:pin_bill_accts:3957100:427796224:110:1723683757726675:619:root.0.0.0.3::::-1
disconnected from database, attempting to reconnect

ERROR
-----------------------
 OCI_ERROR ORA-03114: not connected to ORACLE

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.