Change Tracking Transfer Job Fails: error while executing SELECT instance_id FROM TICK_TARGET_PARAMETERS@TKBR1I_AM_AGENT_LINK ORA-12537: TNS:connection closed (Doc ID 1662588.1)

Last updated on OCTOBER 10, 2023

Applies to:

Symptoms

On : 5.5.1 version, Integra Apps

Change Tracking Transfer Job fails

the change tracking transfer job fails with the below error,

Checking for Changes Pending on all the enabled targets
that have at least one object change trackable ...
error while executing SELECT instance_id FROM TICK_TARGET_PARAMETERS@TKBR1I_AM_A
GENT_LINK ORA-12537: TNS:connection closed
Checking enabled instance TKBR1I
Check completed.
----------------------------------------------------------------------
Starting the Change Tracking Transfer process ...
...Skipping enabled instance "CCG Home",
due to no triggers enabled on this target.
error while executing SELECT instance_id FROM TICK_TARGET_PARAMETERS@TKBR1I_AM_A
GENT_LINK ORA-12537: TNS:connection closed
----------------------------------------------------------------------
Current Instance id on Home: 100 (TKBR1I)
Instance id on Target: -1
Unable to communicate to the target TKBR1I.
----------------------------------------------------------------------
Calling Alert Notifier ...
End of Alert Notifier.
End of Change Tracking Transfer process.

ERROR
-----------------------

error while executing SELECT instance_id FROM TICK_TARGET_PARAMETERS@TKBR1I_AM_A
GENT_LINK ORA-12537: TNS:connection closed



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to Jobs.
2. Select Change Tracking Transfer Program.
3. Check the status.


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

Cause

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