Home » RDBMS Server » Networking and Gateways » Excel ODBC ora-03135 (10g on linux)
Excel ODBC ora-03135 [message #290759] Mon, 31 December 2007 09:09 Go to next message
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
Re: Excel ODBC ora-03135 [message #290761 is a reply to message #290759] Mon, 31 December 2007 09:25 Go to previous messageGo to next message
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?
Re: Excel ODBC ora-03135 [message #290762 is a reply to message #290759] Mon, 31 December 2007 09:26 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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?
Re: Excel ODBC ora-03135 [message #290763 is a reply to message #290762] Mon, 31 December 2007 09:32 Go to previous messageGo to next message
beezap
Messages: 5
Registered: December 2007
Junior Member
SQLNET.EXPIRE_TIME = 10
Re: Excel ODBC ora-03135 [message #290764 is a reply to message #290761] Mon, 31 December 2007 09:35 Go to previous messageGo to next message
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.
Re: Excel ODBC ora-03135 [message #290765 is a reply to message #290763] Mon, 31 December 2007 09:38 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: Excel ODBC ora-03135 [message #290769 is a reply to message #290765] Mon, 31 December 2007 11:07 Go to previous messageGo to next message
beezap
Messages: 5
Registered: December 2007
Junior Member
yes, i set it on the server, not the client
Re: Excel ODBC ora-03135 [message #290801 is a reply to message #290759] Mon, 31 December 2007 20:06 Go to previous messageGo to next message
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.
Re: Excel ODBC ora-03135 [message #290812 is a reply to message #290801] Mon, 31 December 2007 23:43 Go to previous messageGo to next message
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?
Re: Excel ODBC ora-03135 [message #290813 is a reply to message #290759] Mon, 31 December 2007 23:50 Go to previous message
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.
Previous Topic: Problem listener?
Next Topic: Establishing Connection with Oracle on a Remote Server
Goto Forum:
  


Current Time: Thu Mar 28 04:20:38 CDT 2024