Re: Problem In Accessing data Using Oracle Transparent gateway connectivity.

lovkeshanand_at_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. Received on Mon Dec 12 2005 - 12:15:47 CST