elvegaa_esp wrote:If you really understood how networking actually works you would not be here looking for answers.no remote client can ever connect to system listening on 127.0.0.1It's a production DB. All remote clients can connect with no problem, and there is no other listener running.
I saw this configuration in some other servers. They work too, so this can't be the source of the problem.
elvegaa_esp wrote:My mistake was with the listener and lsnrctl. I had to perform a 'stop'/'start' listener instead a 'reload'. 'reload' just refresh for added/removed static services in the listener.ora. It doesn't refresh the network configuration:
$ lsnrctl reload LISTENER_VCSBD
elvegaa_esp wrote:Your HOST parameter is specifying the IP address, thus is not dependent on whatever malformed information you have in your local hosts file. I think the tnsnames.ora you showed us was from the the server, not the remote client the above example was using.
OK. I know what was the problem.
---- REMOTE CONNECTION TEST---
TNS Ping Utility for 32-bit Windows: Version 18.104.22.168.0 - Production on 09-OCT-20
Copyright (c) 1997 Oracle Corporation. All rights reserved.
Archivos de parßmetros utilizados:
Adaptador TNSNAMES utilizado para resolver el alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 22.214.171.124)(PORT = 1521))) (CONNECT_DATA = (SID = vegaorcl) (SERVER =
a lookup of 'servervcs' will stop on the first occurrence, thus resolve to 127.0.0.1, as you yourself proved:
$ cat /etc/hosts: # Do not remove the following line, or various programs # that require network functionality will fail. 127.0.0.1 servervcs localhost.localdomain localhost 126.96.36.199 servervcs #188.8.131.52 servervcs ::1 localhost6.localdomain6 localhost6
Both of the above were taken from your original post.
$ ping servervcs PING servervcs (127.0.0.1) 56(84) bytes of data. 64 bytes from servervcs (127.0.0.1): icmp_seq=1 ttl=64 time=0.017 ms 64 bytes from servervcs (127.0.0.1): icmp_seq=2 ttl=64 time=0.013 ms
Realizado correctamente (20 mseg)
It was this little mistake.
Edited by: elvegaa_esp on 09-oct-2012 7:06