I'm new to being an Oracle DBA and am having an issue where it is taking 20 seconds for our application to login to the DB server when specifying the service. Here are copies of my TNSNAMES.ora and LISTENER.ora files to start that are local to our server as it also happens when I specify the SID/Service in the conection string (ie sqlplus me/mypwd@myorcl):
LISTENER.ora:
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(PORT = 1521))
)
)
ADR_BASE_LISTENER = /db/oracle
TNSNAMES.ora:
MYORCL=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = MYORCL)
)
)
From a wireshark trace, we saw a 20sec latency when the inital request to connect via TNS and the response of the server. This was also show locally. We've added all of the approrpriate IP's to the /etc/hosts files as well for the application servers and our workstations that would connect via SQL Developer. We are connecting via IP, which is not generally a good practice but in this case as we are converting this from Oracle to another platform, it did not matter.
I'm a little lost as to where to look next. Our environment is Oracle 11g (11.2.0.1.0) running on Oracle Linux 6.3. Our application servers are also Linux RH (unknown version). My workstation is a Windows 7 box.