Search code examples
oracleoracle11g

Connection to Oracle database is very slow, 20-30 seconds to open

When opening our VB application and it's pointing to an Oracle database, it takes 20-30 seconds for it to open. Oracle 11.2 is installed on a local server and I'm launching the application on a client, on the same domain.

I suspect it's an Oracle connection issue (maybe something to do with listener or tns), as when we open the application and it's pointing to a SQL database, it opens immediately.

I tried the below settings for the listner but it didn't help.

SQLNET.AUTHENTICATION_SERVICES= (NONE) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

Any ideas as to why it takes so long, or what I can try to get it to connect and open quicker?

Thanks

Solution

  • Looked to be a DNS issue, thanks to @kfinity and @TenH.

    What I did exactly to fix this was below:

    • Went to C:\Windows\System32\drivers\etc\hosts on my client.
    • Inserted my server name and server IP in here and saved.

    Voila. TNSping came back in 10ms, opposed to 22000ms :)