Deploy Change Tracking Error In Creating Triggers ORA-04052 ORA-00604 ORA-12514 (Doc ID 2129770.1)

Last updated on APRIL 22, 2016

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

error- Status Message: Error in creating triggers

Re-deployed change tracking definition however still getting the error- Status Message: Error in creating triggers.

Log file attached.

ERROR
-----------------------
 error- Status Message: Error in creating triggers.

amlog:

create_triggers routine failed ORA-04052: error occurred when looking up remote
object AM_AGENT.DBMS_SQL@CSEBSP_AM_AGENT_LINK
ORA-00604: error occurred at recursive SQL level 2
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Error in creating triggers


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to CCG
2. Deploy Change Tracking job


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run change tracking setup reports.

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