Re: "select" query to remote database fails to retrieve data.
- From: "gidhin K. joy" <gidhin@xxxxxxxxx>
- To: mohammed bhatti <mohammed.bhatti1@xxxxxxxxx>, wbfergus@xxxxxxxxx, oracle-l-freelists <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 14 May 2010 11:43:28 +0530
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@xxxxxxxxx> wrote:
>
> On Wed, May 12, 2010 at 2:11 PM, gidhin K. joy <gidhin@xxxxxxxxx> 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
>
>
>
>
>
Other related posts:
