Networks

Ask something
Discussion Locked

Connecting Oracle Remotely

0 helpful
2 replies

by ahmedyousufuddin

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I am connecting oracle remotely through dial up.
It is coneecting Successfully. But it is taking
25-35 seconds to connect. Where as I test
with SQL Server, it is taking lessthan 3 seconds
to connect. And we have Windows environment.
Can anyone tell me how i can minimize this delay
time.
Thanks in Advance.

2 replies

by hewittm

Sometimes it can take longer for an Oracle client to look up the network connection details for a database than it takes to connect to that database.

So you might want to check that your Oracle connection uses a local TNSNAMES.ORA file on your client PC to look up the database name / server / port that you are connecting to.

The Windows registry entry TNS_ADMIN will control which TNSNAMES.ORA file is used. This reg entry will be somewhere in HKLM\SOFTWARE\ORACLE - but exactly where will depend on your Oracle version / client installation details.

If your TNS_ADMIN entry points to a Network server then this could explain your delay.

[If you have no TNS_ADMIN setting then a local TNSNAMES.ORA file will be used].

Hope this helps.

by astephens

One other thing to check is the host entry in your tnsnames file. It will connect faster if you fully qualify the host name because it does not need to do a dns search every time you connect. Example: Use HOST=myserver.mydomain.com instead of HOST-myserver.

Hope this helps.

This discussion is closed to new replies.