My Oracle Support Banner

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

Last updated on MARCH 02, 2018

Applies to:

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


Goal

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?

Solution

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
Goal
 Question 1:
 Question 2:
Solution
 Answer 1:
 Answer 2:
References


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