HEEELP! TNS 12541 (no listener): Oracle, Hardware Firewalls & company!

From: RedEagle <andreabilli_at_iperbole.bologna.it>
Date: 7 Jun 2005 11:16:23 -0700
Message-ID: <a495c42e.0506071016.7c779089@posting.google.com>

Hi Guys!
A big hello to all readers here! I have been searching all the way into this newsgroup to find a solution to my problem, but it seems that no one has ever had it! Let's make it simple.

I have my server on a webfarm LAN, its ip address is: 192.168.0.1

My server is connected to a firewall. The ip address of the firewall is X.Y.Z.K and it's an internet address (a T3 connection).

I opened some ports on the firewall, so that (for instance) the port 1521, 5500, and 3389 are redirected to 192.168.0.1

I installed the Oracle 10g on our server (Windows 2000 Server), and the web oracle enterprise manager works fine (i can reach it at "http://X.Y.Z.K:5500/em").

I have another computer, my computer, veeery far away from the server. My computer is on another lan (not the webfarm LAN of course), and its ip address is 192.168.10.1

I have a DSL connection, NAT-tted, so NO ports are redirected to my computer, okay?

I installed on my pc the Oracle Enterprise Manager, client version, because I decided that I don't want to use the web oracle enterprise manager. I want to access my Oracle server directly.

When I try to connect to my server I get the 12541 error!!! I don't understand why!!! Isn't it enough to open the port 1521? This is the client "tnsnames.ora" file:

# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = X.Y.Z.K)(PORT = 1521))
(CONNECT_DATA =

      (SERVICE_NAME = orcl)
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))     )
(CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

    )
  )

If I ping my server it works.
If I try "tnsping" I get this message:

Attempting to contact
(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=vortiko))(ADDRESS =(PROTOCOL=TCP)(HOST=X.Y.Z.K)(PORT=1521))) OK (230 msec)

So the listener is alive and kicking!!!

A friend of mine read a message where they say I can't contact my oracle server if the ip destination address doesn't match with the machine address. This might be my case because the real ip address is 192.168.0.1, the internet address is X.Y.Z.K

But I don't wanna believe that I have to put my server on the internet without any kind of protection, nor I have to use another kind of firewall method. Come on! What I am doing wrong?

I hope you have been able to survive this message and surely your help will be VEEEERY much appreciated!

Best regards,
Red Eagle Received on Tue Jun 07 2005 - 13:16:23 CDT