ABB ODA service in undefined (IM connection to third party lost)
All,
Since the installation of our new IM server version 6.0.1 we have some problems, after a few days the ABB ODA service in PAS Control will go in status undefined.
In the error log we see the following result:
Thu Apr 25 01:08:11 2019
Thread 1 advanced to log sequence 1275 (LGWR switch)
Current log# 3 seq# 1275 mem# 0: C:\ORACLE\ORADATA\ADVA\REDO03.LOG
Thu Apr 25 02:00:00 2019
Closing scheduler window
Restoring Resource Manager plan DEFAULT_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_PLAN via parameter
Thu Apr 25 04:26:47 2019
Thread 1 advanced to log sequence 1276 (LGWR switch)
Current log# 1 seq# 1276 mem# 0: C:\ORACLE\ORADATA\ADVA\REDO01.LOG
Thu Apr 25 05:38:40 2019
Thread 1 advanced to log sequence 1277 (LGWR switch)
Current log# 2 seq# 1277 mem# 0: C:\ORACLE\ORADATA\ADVA\REDO02.LOG
Thu Apr 25 08:30:14 2019
Error 28501 trapped in 2PC on transaction 5.15.82082. Cleaning up.
HS: Lost RPC connection to remote Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=WORM-P-IM11)(PORT=1521)
))(CONNECT_DATA=(SID=ABBODA))), NCR status = -2147385341
Error in cleaning up 2PC subordinates; error stack:
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=WORM-P-IM11)(PORT=1
521)))(CONNECT_DATA=(SID=ABBODA)))
ORA-02063: preceding line from EH
ORA-28501: communication error on heterogeneous database link
[ABB][ODBC ABB 800xA x64 ODBC Interface driver][ABB 800xA x64 ODBC Interface Client]Internal network error, session aborted, connection closed {08S01,NativeErr =
DISTRIB TRAN ADVA.NL-WORM-PLC.LOCAL.50616f5a.5.15.82082
Error received from EH.NL-WORM-PLC.LOCAL
Error stack returned to user:
ORA-28501: communication error on heterogeneous database link
[ABB][ODBC ABB 800xA x64 ODBC Interface driver][ABB 800xA x64 ODBC Interface Client]Internal network error, session aborted, connection closed {08S01,NativeErr = 2208}
ORA-02063: preceding 2 lines from EH
Can someone help us with this problem.
Thanks in advance.
Since the installation of our new IM server version 6.0.1 we have some problems, after a few days the ABB ODA service in PAS Control will go in status undefined.
In the error log we see the following result:
Thu Apr 25 01:08:11 2019
Thread 1 advanced to log sequence 1275 (LGWR switch)
Current log# 3 seq# 1275 mem# 0: C:\ORACLE\ORADATA\ADVA\REDO03.LOG
Thu Apr 25 02:00:00 2019
Closing scheduler window
Restoring Resource Manager plan DEFAULT_PLAN via scheduler window
Setting Resource Manager plan DEFAULT_PLAN via parameter
Thu Apr 25 04:26:47 2019
Thread 1 advanced to log sequence 1276 (LGWR switch)
Current log# 1 seq# 1276 mem# 0: C:\ORACLE\ORADATA\ADVA\REDO01.LOG
Thu Apr 25 05:38:40 2019
Thread 1 advanced to log sequence 1277 (LGWR switch)
Current log# 2 seq# 1277 mem# 0: C:\ORACLE\ORADATA\ADVA\REDO02.LOG
Thu Apr 25 08:30:14 2019
Error 28501 trapped in 2PC on transaction 5.15.82082. Cleaning up.
HS: Lost RPC connection to remote Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=WORM-P-IM11)(PORT=1521)
))(CONNECT_DATA=(SID=ABBODA))), NCR status = -2147385341
Error in cleaning up 2PC subordinates; error stack:
ORA-28511: lost RPC connection to heterogeneous remote agent using SID=ORA-28511: lost RPC connection to heterogeneous remote agent using SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=WORM-P-IM11)(PORT=1
521)))(CONNECT_DATA=(SID=ABBODA)))
ORA-02063: preceding line from EH
ORA-28501: communication error on heterogeneous database link
[ABB][ODBC ABB 800xA x64 ODBC Interface driver][ABB 800xA x64 ODBC Interface Client]Internal network error, session aborted, connection closed {08S01,NativeErr =
DISTRIB TRAN ADVA.NL-WORM-PLC.LOCAL.50616f5a.5.15.82082
Error received from EH.NL-WORM-PLC.LOCAL
Error stack returned to user:
ORA-28501: communication error on heterogeneous database link
[ABB][ODBC ABB 800xA x64 ODBC Interface driver][ABB 800xA x64 ODBC Interface Client]Internal network error, session aborted, connection closed {08S01,NativeErr = 2208}
ORA-02063: preceding 2 lines from EH
Can someone help us with this problem.
Thanks in advance.
Answers
To begin with, you should take the ORA errors listed and do a Google search. There are a number of suggestions associated with these. Next, you can look at the "alert_adva.log" file for any clues as to these issues. It can be found in the directory, "C:\oracle\diag\rdbms\adva\adva\trace\". One of the other questions would be, "What is accessing the ABBODA application when this is occurring?". There may also be some indications in the MS Event Viewer logs associated with this problem. Finally, examination of all the log files in the directory, "C:\ProgramData\ABB\IM\History\log", may also yield some information. Finally, if all else fails, you should open a Support Case with your local RAC so that effort in the resolution of this issue can be tracked.
Regards,
Geof Ledin
Regards,
Geof Ledin
Add new comment