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:
Oracle Configuration Controls Governor - Version 5.5.1 and laterInformation in this document applies to any platform.
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
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
Symptoms |
Cause |
Solution |