Net8 Client Connection Performance

[Eric^2]

I have 5 machines. Three desktops with the Net8 client and TCP only, one server with Net8 C/S and Oracle 8.1.7 installed, and one development laptop with Net8 C/S and Oracle 8.1.7 installed. The three development machines connect to my laptop and the server quickly. (We are using hosts resolution, and that works fine.) My laptop is another issue. When I try to connect to the server or the database on my local machine, SQLPLUS hangs for about 10 seconds before connecting. Everything works great after it's connected. The symptoms indicate a configuration problem with Net8, but I can't figure out what it is. I've reconfigured Net8 with the GUI tool, with no luck. Ping works great from all machines to all machines. It's only a Net8 connection from my machine that exhibits the problem.

The problem happens with DOA, PL/SQL Developer, and SQL Plus, so I'm pretty sure it's not just an application issue.

Any suggestions? Reinstall Net8 Client? Sacrifice a rubber chicken?

 

[Marco Kalter]

First you should of course try the rubber chicken solution

. If for some strange reason that doesn't work, locate the sqlnet.ora file in your Net8 network directory (e.g. c:\ora817\network\admin\sqlnet.ora). Remove the line with the sqlnet.authentication_services key (if present) and retry.

This usually does the trick.

------------------
Marco Kalter
Allround Automations

 

[Eric^2]

The rubber chicken flailed wildly, but still produced no noticeable results.

Your other solution however worked marvelously! You rock! Thanks a bunch!