Oracle Database Discussions

Here is the listener.ora and the tnsnames.ora

# listener.ora Network Configuration File: C:\app\administrator\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = odb1.domain.com)(PORT = 1522))
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
)
)

ADR_BASE_LISTENER = C:\app\administrator



# tnsnames.ora Network Configuration File: C:\app\administrator\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ODB =
(ADDRESS = (PROTOCOL = TCP)(HOST = odb1.domain.com)(PORT = 1522))


ODB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = odb1.domain.com)(PORT = 1522))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = odb1.domain.com)
)
)


Symptoms:

1. the solution use to work like a breeze, until 10 days ago when problems started when after a windows update i restarted the machine.

2. The first time I do a tnsping, I get a response in 20 ms. After that every time I do the same it takes 5000 ms or more

3. Client can't connect anymore over the network (verified the tnsnames to be correct)

4. I can connect only using Local Bequeath connection.

I have seen several cases on the internet but nothing seems to match my case (windows OS)

steps already done: I did add the full name on the hosts file to expedite the resolution
restarted the listener after each change

Any help will be highly appreciated.

Thanks