Re: "select" query to remote database fails to retrieve data.
- From: "gidhin K. joy" <gidhin@xxxxxxxxx>
- To: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- Date: Wed, 12 May 2010 23:41:04 +0530
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
On 12 May 2010 19:29, Niall Litchfield <niall.litchfield@xxxxxxxxx> wrote:
> 1) How much free space is there in your clients temporary area of disk
> (%TEMP% or %TMP%) (and can you write to it as the os user you are logged in
> as)?
>
> I don't see how it can be network and yet some queries work.
>
> Niall
>
> On Wed, May 12, 2010 at 2:17 PM, gidhin K. joy <gidhin@xxxxxxxxx> wrote:
>
>> Hello everyone,
>>
>> I am facing a strange issue in oracle 11g. It may not be a database issue,
>> can be related to network also.
>>
>> In brief, Not able to execute sql statements from my workstation (oracle
>> 11g client) which returns more amount of data for ex: select * from
>> v$session,select * from dict; I can execute simple statements like select *
>> from version / some user tables with less number of data by limiting with
>> “where” clause.
>> This is not an issue when I am in a remote workstation which is located
>> in the same network as the database server (in a remote location). Issue is
>> only from local workstations/applicationserver alone.
>>
>> Enviornment is ,
>>
>> Server – Oracle 11.2.0.1.0 64bit on RHEL 5.4
>> Client - Oracle 11.1.0.6.0 32 bit on Windows Xp.
>>
>>
>>
>> C:\Documents and Settings>sqlplus system/******@XXXX
>>
>> SQL*Plus: Release 11.1.0.6.0 - Production on Wed May 12 11:11:39 2010
>>
>> Copyright (c) 1982, 2007, Oracle. All rights reserved.
>> Connected to:
>> Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit
>> Production
>> With the Partitioning, OLAP, Data Mining and Real Application Testing
>> options
>>
>> SQL>
>> SQL>
>> SQL> select * from v$session;
>>
>> It just stops there. Session won’t disconnect or any ORA-XXXX error.
>>
>> Done the following checks,
>>
>> -Initially thought of driver issue, so tried with multiple version of
>> oracle client,toad,oracle sql developer but issue persists.
>> - v$session shows that the above session in question is in status as
>> “INACTIVE” and state as “WAITING”
>> - tnsping from remote system and localsystem returns almost similar
>> response time (600 msec - 670 msec)
>> - Couldn’t find anything unusual in alert / trace also in listener log.
>> - Since I am able to run some queries, no need to bother about firewall
>> side.
>> - Done some basic analysis using wireshark packet analyzer - couldn’t see
>> any error. However could see that local system is getting “response data”
>> from the database server.
>> - MTU set to different size , 1500,1400,Default etc with no luck.
>>
>> I assume that it has something to do with network side. Your any inputs on
>> troubleshooting this kind of issue will be very helpful for me.
>>
>>
>> Thanks.
>> G
>>
>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>
Other related posts:
