Re: ORA-28511: lost RPC
From: joel garry <joel-garry_at_home.com>
Date: Tue, 30 Oct 2012 08:40:09 -0700 (PDT)
Message-ID: <c6b09d71-bb62-4c09-9afc-e1b9ddff00b1_at_u4g2000pbo.googlegroups.com>
On Oct 30, 2:46 am, dba cjb <chris.br..._at_providentinsurance.co.uk> wrote:
> I have been trying to load data into an oracle 11.2.0.3 enterprise
> database from a sqlserver 2008 database ..using heterogenous
> services. ( os is windows )
>
> Test connection works ok....but when i try & load data it gives
> sporadic results ...sometimes loading data ...other times loosing
> connection with error ( see subject )
> ...although 1 table tends to fall over more than others & is quite
> long ( see below )
>
> Any suggestions or shared experience gratefully received
>
> regards
> Chris B
>
> PS I have raised a metalink ticket with oracle...but support is not
> available at the moment ..so thought i'd explore other avenues
> PPS params used are
> # HS init parameters
> #
> HS_FDS_CONNECT_INFO = RDTSQL
> HS_FDS_TRACE_LEVEL = DEBUG
> HS_RPC_FETCH_SIZE = 10000000
> HS_FDS_FETCH_ROWS = 1000
> HS_RPC_FETCH_REBLOCKING=OFF
> HS_FDS_WORKAROUNDS=16
> HS_FDS_DELAYED_OPEN=TRUE
> #
>
// *Action: Check for network problems and remote host crashes. The problem is
// probably in the agent software. If so, contact a customer support
// representative of the agent vendor. //
Date: Tue, 30 Oct 2012 08:40:09 -0700 (PDT)
Message-ID: <c6b09d71-bb62-4c09-9afc-e1b9ddff00b1_at_u4g2000pbo.googlegroups.com>
On Oct 30, 2:46 am, dba cjb <chris.br..._at_providentinsurance.co.uk> wrote:
> I have been trying to load data into an oracle 11.2.0.3 enterprise
> database from a sqlserver 2008 database ..using heterogenous
> services. ( os is windows )
>
> Test connection works ok....but when i try & load data it gives
> sporadic results ...sometimes loading data ...other times loosing
> connection with error ( see subject )
> ...although 1 table tends to fall over more than others & is quite
> long ( see below )
>
> Any suggestions or shared experience gratefully received
>
> regards
> Chris B
>
> PS I have raised a metalink ticket with oracle...but support is not
> available at the moment ..so thought i'd explore other avenues
> PPS params used are
> # HS init parameters
> #
> HS_FDS_CONNECT_INFO = RDTSQL
> HS_FDS_TRACE_LEVEL = DEBUG
> HS_RPC_FETCH_SIZE = 10000000
> HS_FDS_FETCH_ROWS = 1000
> HS_RPC_FETCH_REBLOCKING=OFF
> HS_FDS_WORKAROUNDS=16
> HS_FDS_DELAYED_OPEN=TRUE
> #
>
28511, 00000, "lost RPC connection to heterogeneous remote agent using SID=%s"
// *Cause: A fatal error occurred in one of the following places: // -- the connection between the ORACLE server and the agent // -- the heterogeneous services remote agent itself // -- the connection to the non-Oracle system // This error occurred after communication had been established // successfully.
// *Action: Check for network problems and remote host crashes. The problem is
// probably in the agent software. If so, contact a customer support
// representative of the agent vendor. //
I notice a bug Ora-28511 Error on a Select after 3 minutes Using Dg4ODBC [ID 1494888.1] for 11.2.0.3, the workaround is INBOUND_CONNECT_TIMEOUT_LISTENER = 0 Seems they can't ever get that timeout stuff right. Plenty of other bugs to look at too.
jg
-- _at_home.com is bogus. http://www.networkworld.com/news/2012/102912-schwartau-263776.htmlReceived on Tue Oct 30 2012 - 16:40:09 CET