OraFAQ Forum: Networking and Gateways

Home » RDBMS Server » Networking and Gateways » Excel ODBC ora-03135 (10g on linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Excel ODBC ora-03135 [message #290759]

Mon, 31 December 2007 09:09

beezap
Messages: 5
Registered: December 2007

Junior Member

I have an msquery script that runs against my oracle database from my workstation across two seprate vpn's. One vpn has 60ms delay, and the other has 177ms delay. When on the 60ms vpn, I can download the data into excel without an issue, but on the slower vpn connection, I get an ora-03135. Same query, and I have verified that data is being sent from the database to the odbc connection. No firewall is dropping the connection. It doesn't seem like a networking issue, from a pure non-oracle networking point of view. I have tried suggestions like modifying the sqlnet.ora parameters, to no avail. I can run the query from sql plus on either vpn and recieve all 95000 plus rows. I have a trace:

ntt2err: soc 1904 error - operation=5, ntresnt[0]=517, ntresnt[1]=54, ntresnt[2]=0
(4428) [30-DEC-2007 23:34:56:906] ntt2err: exit
(4428) [30-DEC-2007 23:34:56:906] nttrd: exit
(4428) [30-DEC-2007 23:34:56:906] nsprecv: error exit
(4428) [30-DEC-2007 23:34:56:906] nserror: entry
(4428) [30-DEC-2007 23:34:56:906] nserror: nsres: id=0, op=68, ns=12547, ns2=12560; nt[0]=517, nt[1]=54, nt[2]=0; ora[0]=0, ora[1]=0, ora[2]=0
(4428) [30-DEC-2007 23:34:56:906] nsrdr: error exit
(4428) [30-DEC-2007 23:34:56:906] snsbitts_ts: entry
(4428) [30-DEC-2007 23:34:56:906] snsbitts_ts: acquired the bit
(4428) [30-DEC-2007 23:34:56:906] snsbitts_ts: normal exit
(4428) [30-DEC-2007 23:34:56:906] snsbitcl_ts: entry
(4428) [30-DEC-2007 23:34:56:906] snsbitcl_ts: normal exit
(4428) [30-DEC-2007 23:34:56:906] snsbitts_ts: entry
(4428) [30-DEC-2007 23:34:56:906] snsbitts_ts: acquired the bit
(4428) [30-DEC-2007 23:34:56:906] snsbitts_ts: normal exit
(4428) [30-DEC-2007 23:34:56:906] nsdo: nsctxrnk=0
(4428) [30-DEC-2007 23:34:56:906] snsbitcl_ts: entry
(4428) [30-DEC-2007 23:34:56:906] snsbitcl_ts: normal exit
(4428) [30-DEC-2007 23:34:56:906] nsdo: error exit
(4428) [30-DEC-2007 23:34:56:906] nioqrc: wanted 1 got 0, type 0
(4428) [30-DEC-2007 23:34:56:906] nioqper: error from nioqrc
(4428) [30-DEC-2007 23:34:56:906] nioqper: ns main err code: 12547
(4428) [30-DEC-2007 23:34:56:906] nioqper: ns (2) err code: 12560
(4428) [30-DEC-2007 23:34:56:906] nioqper: nt main err code: 517
(4428) [30-DEC-2007 23:34:56:906] nioqper: nt (2) err code: 54
(4428) [30-DEC-2007 23:34:56:906] nioqper: nt OS err code: 0
(4428) [30-DEC-2007 23:34:56:906] nioqer: entry
(4428) [30-DEC-2007 23:34:56:906] nioqer: incoming err = 12151
(4428) [30-DEC-2007 23:34:56:906] nioqce: entry
(4428) [30-DEC-2007 23:34:56:906] nioqce: exit
(4428) [30-DEC-2007 23:34:56:906] nioqer: returning err = 3135
(4428) [30-DEC-2007 23:34:56:906] nioqer: exit

HELP

Report message to a moderator

Re: Excel ODBC ora-03135 [message #290761 is a reply to message #290759]

Mon, 31 December 2007 09:25

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

12515, 00000, "TNS:listener could not find a handler for this presentation"
// *Cause:  None of the listener's known service handlers are registered
// as supporting the presentation protocol required by the connecting client.
// *Action: Check that the destination service is configured to accept the
// presentation protocol.

Does the listener.log file show any activity for the connection attempts which are failing?

I could be mistaken but I suspect that having multiple VPNs implies that multiple IP#s are involved.

Which Oracle versions to 4 decimal places are involved?

Report message to a moderator

Re: Excel ODBC ora-03135 [message #290762 is a reply to message #290759]

Mon, 31 December 2007 09:26

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

I have tried suggestions like modifying the sqlnet.ora parameters, to no avail.

Which parameters did you change? What were their original and new values?

Report message to a moderator

Re: Excel ODBC ora-03135 [message #290763 is a reply to message #290762]

Mon, 31 December 2007 09:32

beezap
Messages: 5
Registered: December 2007

Junior Member

SQLNET.EXPIRE_TIME = 10

Report message to a moderator

Re: Excel ODBC ora-03135 [message #290764 is a reply to message #290761]

Mon, 31 December 2007 09:35

beezap
Messages: 5
Registered: December 2007

Junior Member

10.2.0.0 is the client and server version

The vpn's are connected one at a time. I am only connected to one vpn at a time. My ip is 192.189.10.x on one vpn, which is the working connection.

192.168.3.x is the non-working.

SQL plus can connect and run the query from either vpn. Excel can receive the entire data set from 10.x, but times out on 3.x after receiving about 10,000 rows.

Report message to a moderator

Re: Excel ODBC ora-03135 [message #290765 is a reply to message #290763]

Mon, 31 December 2007 09:38

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

SQLNET.EXPIRE_TIME must be set on a database server. Did you do that? Because, if you did it on a client, there was no affect.

Report message to a moderator

Re: Excel ODBC ora-03135 [message #290769 is a reply to message #290765]

Mon, 31 December 2007 11:07

beezap
Messages: 5
Registered: December 2007

Junior Member

yes, i set it on the server, not the client

Report message to a moderator

Re: Excel ODBC ora-03135 [message #290801 is a reply to message #290759]

Mon, 31 December 2007 20:06

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>SQL plus can connect and run the query from either vpn.
Then, IMO, the problem is NOT with Oracle but with ODBC config.

Report message to a moderator

Re: Excel ODBC ora-03135 [message #290812 is a reply to message #290801]

Mon, 31 December 2007 23:43

beezap
Messages: 5
Registered: December 2007

Junior Member

I agree the problem is with ODBC. It works from a low latency connection, but fails from a high latency connection. Now the question is, why, and how do I fix it?

Report message to a moderator

Re: Excel ODBC ora-03135 [message #290813 is a reply to message #290759]

Mon, 31 December 2007 23:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Now the question is, why, and how do I fix it?
Submit same questions on ODBC author's (Micro$soft?) forum.

Report message to a moderator

Previous Topic:	Problem listener?
Next Topic:	Establishing Connection with Oracle on a Remote Server

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 16 18:57:09 CST 2025