My Oracle Support Banner

Customer Profile Engine: NOLOGGING Operations Causing ORA-01578 in Contact Center (Doc ID 1072607.1)

Last updated on FEBRUARY 06, 2022

Applies to:

Oracle Customer Care - Version and later
Information in this document applies to any platform.


Question 1:

In very rare situations, after the database has been recovered while the Customer Profile Engine concurrent program was running, users may face the following errors when searching a Customer in the Contact Center:

 ORA-01578: ORACLE data block corrupted (file # 396, block # 171694)
 ORA-01110: data file 396: '/u21/oradata/EB11SUP/a_summ01.dbf'
 ORA-26040: Data block was loaded using the NOLOGGING option
 FRM-40735: WHEN-NEW-ITEM-INSTANCE trigger raised unhandled exception ORA-01578.

Why is this happening?

Question 2:

What are the steps to run the Customer Profile Engine?


To view full details, sign in with your My Oracle Support account.

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

In this Document
 Question 1:
 Question 2:
 Answer 1:
 Answer 2:

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