There is a Windows Server 2008 R2. It has an Oracle database. The entry for tnsname.ora was simply copied, replacing loaclhost with the desired IP address. Ping between the machines passes. tnsping works on the machine itself. tnsping from another machine fails, an error occurs:

TNS-12541: TNS: no listener

I tried to open ports on the server. In the firewall, I created a rule for port 1521 for all programs (under Inbound Rules). Added oracle.exe and tnslsnr.exe to firewall exceptions.

I watched through resmon.exe. TNSLSNR.EXE listens on port 1521. Firewall Status - Allowed, not Restricted

Tell me where else to look and what to tweak?

  • one
    And he listens to 1521 on all ip? maybe he only listens to 127.0.0.1? - Mike
  • How and where to look? - Viktorov
  • one
    In the listener.ora file, see which host of the record is for TCP / 1521. Or the same via the lsnrctl status command - Mike
  • @Mike yes, the problem was this. Make a reply, accept. - Viktorov

1 answer 1

You need to check the settings of the listener Oralce. Settings are stored in the %DBHOME%/network/admin/listener.ora file. In the record (ADDRESS = (PROTOCOL = TCP)(HOST = HostName)(PORT = 1521)) , the HostName should be the name of the server resolvable by DNS into the external IP of the server or the IP itself. Most likely at the moment there is localhost, as a result, Oracle accepts connections only on the local machine.