ORA-28511: lost RPC connection to heterogeneous remote agent

A client has been seeing this error when holding sessions open over HS for lengthy periods of time (greater than an hour or so).

Some workarounds that have worked are:

  • when possible, issue, alter session close database link, and re-open it for subsequent queries

 

  • Set INBOUND_CONNECT_TIMEOUT_<listener_name>=0 in listener.ora
  • Set SQLNET.INBOUND_CONNECT_TIMEOUT=0 in sqlnet.ora

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s