Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

HS: Lost RPC connection to remote Agent...

518466Jun 15 2006
Hi

We are using HS on Oracle 9206 on aix 5.1 to remotely connect to Informix also on aix 5.1 but another box. We are using Data Direct Wire Protocol drivers. The links are working fine. We use an application created from HTML DB which makes heavy use of HS.

The problem is we are getting...

HS: Lost RPC connection to remote Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=51.1.20.6)(PORT=1523)))(CONNECT_DATA=(SID=prd01))), NCR status = -2147385341

In our alert log as the connections time out. This is "normal" behaviour but I wonder if anyone has any suggestions on how to minimise these? Typically we have c20-30 remote HS links open.

oraprd 614464 1 0 15:16:20 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 745660 1 67 15:26:16 - 1:22 hsodbcprd01 (LOCAL=NO)
oraprd 782562 1 0 15:29:36 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 811226 1 0 14:45:45 - 0:04 hsodbcprd01 (LOCAL=NO)
oraprd 815186 1 0 15:29:12 - 0:01 hsodbcprd01 (LOCAL=NO)
oraprd 839692 1 0 15:16:51 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 852192 1 0 15:25:38 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 954506 1 0 15:29:23 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 983040 1 0 15:26:55 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 987340 1 0 14:33:48 - 0:05 hsodbcprd01 (LOCAL=NO)
oraprd 1024086 1 0 15:15:21 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 1065210 1 0 15:07:46 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 1130638 1 0 15:28:10 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 1245202 1 0 13:54:39 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 1323022 1 0 14:42:16 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 1368176 1 0 15:21:21 - 0:01 hsodbcprd01 (LOCAL=NO)
oraprd 1437840 1 0 15:20:00 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 1552532 1 0 15:15:31 - 0:02 hsodbcprd01 (LOCAL=NO)
oraprd 1646708 1 0 15:17:50 - 0:01 hsodbcprd01 (LOCAL=NO)
oraprd 1683676 1 0 14:35:33 - 0:01 hsodbcprd01 (LOCAL=NO)
oraprd 1720494 1 0 14:56:19 - 0:02 hsodbcprd01 (LOCAL=NO)
oraprd 1736852 1 0 15:19:49 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 1749052 1 0 15:28:36 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 1785892 1 0 15:21:27 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 1851430 1 0 15:27:50 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 1978478 1 0 15:08:24 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 1982710 1 0 14:27:26 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 1986654 1 0 14:44:05 - 0:00 hsodbcprd01 (LOCAL=NO)
oraprd 2015424 1 0 15:29:35 - 0:00 hsodbcprd01 (LOCAL=NO)
29

I have read a metalink article about an undocumented HS timeout parameter. HS_FDS_CONNECT_PROPERTIES="timeout='120'"

Has anyone any suggestions on this subject please.

Thanks

Richard Patterson
richard_patterson@mspltd.com
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2006
Added on Jun 15 2006
0 comments
3,740 views