Re: "select" query to remote database fails to retrieve data.

From: gidhin K. joy <gidhin_at_gmail.com>
Date: Fri, 14 May 2010 11:43:28 +0530
Message-ID: <AANLkTilo9QD1e3bhnr7J38x4MDAxSmr9F6WstAu_2_bb_at_mail.gmail.com>

Well, sqlnet trace doesn't give much details, trace just stops at this stage.

Thanks Bill, I got the MOS doc that you were referring to. I am sure that something fishy about network config. Now working with n/w folks.

[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: packet dump
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 00 9C 00 00 06 00 00 00
|........|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 00 00 03 5E 11 61 80 00
|...^.a..|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 00 00 00 00 00 01 45 00
|......E.|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 00 00 01 0D 00 00 00 01
|........|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 01 00 00 00 00 01 00 00
|........|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 00 00 00 00 00 00 00 00
|........|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 00 00 00 01 00 01 01 01
|........|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 00 00 00 00 00 00 00 00
|........|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 01 01 00 00 00 00 00 00
|........|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 00 00 00 00 00 00 00 00
|........|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 17 73 65 6C 65 63 74 20
|.select.|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 2A 20 66 72 6F 6D 20 76* *
|*.from.v|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 24 73 65 73 73 69 6F 6E* *
|$session|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 01 00 00 00 00 00 00 00
|........|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 00 00 00 00 00 00 00 00
|........|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 00 00 00 00 00 00 00 00
|........|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 00 00 00 00 01 00 00 00
|........|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 00 00 00 00 00 00 00 00
|........|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 00 00 00 00 00 00 00 00
|........|
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: 00 00 00 00
|.... |
[000002 14-MAY-2010 11:28:19:597] nsbasic_bsd: exit (0)
[000002 14-MAY-2010 11:28:19:597] nsbasic_brc: entry: oln/tot=0

Thanks,
G

On 12 May 2010 23:59, mohammed bhatti <mohammed.bhatti1_at_gmail.com> wrote:

>
>  On Wed, May 12, 2010 at 2:11 PM, gidhin K. joy <gidhin_at_gmail.com> wrote:
>
>> I could confirm that enough free space is available in c:
>>
>> Why I am thinking it is network related is, other workstations on the same
>> network as mine also facing the similar issue.
>>
>> If I do select * from <an application table>, just hangs but If I do
>> select query on the first 27 columns of the same table it returns records.
>> Also select * from <an application table> where empid=1, will retrieve data
>> as there is single record involved, there by less amount of data.
>>
>> Really strange.
>>
>> Thanks.
>> G
>>
>>
>
> If you suspect a network issue, turn on SQL*Net trace on the client and
> look at the trace output.  Something like this in sqlnet.ora:
> TRACE_DIRECTORY_CLIENT = /opt/app/oracle/product/10.2.0/db_1/network/log
> TRACE_FILE_CLIENT = CLIENT
> LOG_FILE_CLIENT = CLIENT
> TRACE_LEVEL_CLIENT = SUPPORT
>
> Look at the trace file output for net errors.
>
> Faced a similar issue with streams over a WAN and got around it by setting
> SQLNET.EXPIRE_TIME = 1000 and SQLNET.INBOUND_CONNECT_TIMEOUT = 1000 or some
> appropriately large value.
>
> --
> mohammed
>
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri May 14 2010 - 01:13:28 CDT