Re: Weird listener/ip interface problem

From: Álvaro Palma Aste <queria_direccion_at_el.perla.invalid>
Date: Sun, 11 Aug 2002 00:13:39 +0000 (UTC)
Message-ID: <aj4a7j$2ki$1@localhost.localdomain>

Ralph Everyman escribió:

[pretty good details deleted :-)]

First of all, is the listener "listening" in your internal NIC?

netstat -a -p -n | grep 1521 should show you something like

tcp 0 0 0.0.0.0:1521      0.0.0.0:*         LISTEN      28873/tnslsnr       
tcp 0 0 192.168.1.1:32923 192.168.1.1:1521  ESTABLISHED 19577/ora_pmon_mpw  
tcp 0 0 192.168.1.1:1521  192.168.1.1:32923 ESTABLISHED 28873/tnslsnr

i.e., you should have an opened socket between listener and PMON process.

2.- Do you add your internal address in the listener configuration?

The listener.ora should look like:

 LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS_LIST=


        (ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))

        (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.1)(PORT=1521))

        (ADDRESS=(PROTOCOL=TCP)(HOST=<external_ip>)(PORT=1521))

      )

    )
  )

PS: NEVER put real ip's on an article. Some stupid script kiddie can be looking at and choose you as a victim

-- 
Atte.
Álvaro Palma Aste
Grupo de Ing. Biomédica
Depto. de Ing. Eléctrica - U. de Chile
******************************************************
It's the only form of protest they're allowed 
I've seen their silent faces scream so loud 
If they were to speak these words they'd go missing too 
Another woman on a torture table what else can they do

Sting - They Dance Alone...

Received on Sat Aug 10 2002 - 19:13:39 CDT