Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.stanford.edu!postnews.google.com!z14g2000cwz.googlegroups.com!not-for-mail
From: "hpuxrac" <johnbhurley@sbcglobal.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: Problem In Accessing data Using Oracle Transparent gateway connectivity.
Date: 12 Dec 2005 10:15:47 -0800
Organization: http://groups.google.com
Lines: 50
Message-ID: <1134411347.103074.125400@z14g2000cwz.googlegroups.com>
References: <1134378514.749135.133220@z14g2000cwz.googlegroups.com>
NNTP-Posting-Host: 208.44.49.5
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1134411352 19677 127.0.0.1 (12 Dec 2005 18:15:52 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 12 Dec 2005 18:15:52 +0000 (UTC)
In-Reply-To: <1134378514.749135.133220@z14g2000cwz.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 PROXY
Complaints-To: groups-abuse@google.com
Injection-Info: z14g2000cwz.googlegroups.com; posting-host=208.44.49.5;
   posting-account=Dz_3bQ0AAAC5LZNB2NPEJz1sl_a8qcDY
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:257571

lovkeshanand@gmail.com wrote:
> This gave a following error:-
>
> "WEB_30_SUM", "WEB_360_COUNT", "WEB_360_SUM", "WEB_90_COUNT",
> "WEB_90_SUM"
>                                                               *
> ERROR at line 48:
> ORA-28500: connection from ORACLE to a non-Oracle system returned this
> message:
> [Transparent gateway for MSSQL]
> ORA-02063: preceding 2 lines from DBL_GETGC1
>
>
> Elapsed: 00:01:01.04
>
> after this I set The paramater "HS_FDS_TRACE_LEVEL=ON" in INIt file of
> tg4msql Folder then in the trace File of tg4msql folder following error
> comes:-
>
> Oracle Corporation --- WEDNESDAY DEC 07 2005 02:57:51.966
>
>
> Heterogeneous Agent Release
> 9.2.0.1.0
>
>
> HS Agent received unexpected RPC disconnect
>    Network error 1003:  NCR-01003: NCRS: Read error.
>
> and few moments back it also gave the Following error:-
>
> Oracle Corporation --- THURSDAY  DEC 08 2005 12:24:00.593
>
>
> Heterogeneous Agent Release
> 9.2.0.1.0

Just a wild guess that your software may not be patched appropriately.
9.2.0.1 is missing a whole bunch of oracle patchsets.

It may have been fixed a long time ago by oracle software maintenance
but if you don't run the patched version ... you don't get possible
fixes.

> If any one has Faced the similar kind of problem and Can help me,Please
> let me Know where I am doing Wrong and How this error can be ractified.

Check with your dba and see if your system's are appropriately patched.
 If you get a reproducible problem work with oracle support.