My Oracle Support Banner

CCSCD1 DEL Fails With "ORA-00060: Deadlock Detected While Waiting For Resource" (Doc ID 2020954.1)

Last updated on MARCH 22, 2018

Applies to:

Oracle Communications Network Charging and Control - Version 5.0.2 to 5.0.3 [Release 5.0]
Information in this document applies to any platform.

Symptoms

The PImanager complains with "ORA-00060: deadlock detected while waiting for resource" when the following sequence of PI requests scenario is continuously requested over a pool of MSISDNs.

Create Subscriber → (delay 1.5 sec) → Change Profile Tags → Activate → Change MSISDN → Deactivate → Delete MSISDN (CCSCD1 DEL)

The Delete command reports the following deadlock error once in a while :

May 22 12:44:18 scch01prsms01 PIprocess:8007: [ID 438867 user.warning] PIprocess:8007(10806) WARNING Oracle=-60 CCSCD1_oracle.pcc@814: delete from ccs_acct_reference where id=:b0: ORA-00060: deadlock detected while waiting for resource

This happens with NCC 5.0.2.

It is expected that Delete commands always properly complete.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.