Ccg Agent Configure compile target packages job keeps restarting and throws ORA-01920. ORA-7445 found in trace file. (Doc ID 2041167.1)

Last updated on AUGUST 07, 2015

Applies to:

Oracle Configuration Controls Governor - Version 5.5.1 and later
Information in this document applies to any platform.

Symptoms

On :  5.5.1 version, Integra Apps

When attempting to configure Agent Component for EBS
the following error occurs.

ERROR
-----------------------
ORA-01920: user name 'AM_AGENT' conflicts with another user or role name


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. ERP workbench  > Agent component > configure
2. Compile target packages job never completes, status remains as running.
3. Agent job restarts and tries to create new Agent which results in the ORA-01920.


 

Changes

 Customer  recently applied database patch which caused the issue :  ORA-7445 [eosize()+125] Errors After JAVAVM Patch 19282021 DATABASE PSU (OCT2014) (Doc ID 1951362.1)

Cause

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