Re: Strange problem with OracleXE 10g listeners

From: mzielonka <marcin.zielonka_at_gmail.com>
Date: 25 Apr 2007 01:30:40 -0700
Message-ID: <1177489840.574021.116190@b40g2000prd.googlegroups.com>

On 24 Kwi, 11:32, Hole <h0lefor..._at_gmail.com> wrote:
> Hi there,
>
> When I'm connected to LAN (with or without Windows XP Firewall up) and
> I start OracleXE, the listeners come up in a strange behaviour.
>
> Summary table degli endpoint di ascolto...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe
> \EXTPROC_FOR_XEipc)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
>
> Starting the OracleServiceXE, the service HTTP for page administration
> doesn't start and I can reach the DB service only by SQLPLUS, while I
> am not able to talk with database via java connector.
>
> Instead, if I startlistenerservice and DB service while I'm not
> connected to a LAN, everything goes ok. Below, the output of LSNRCTL
> status after I started thelistenerservice and DB service while I was
> not connected to a LAN:
>
> Summary table degli endpoint di ascolto...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe
> \EXTPROC_FOR_XEipc)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ARCIBALDO)(PORT=1521)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ARCIBALDO)(PORT=8888))
> (Presentation=
> HTTP)(Session=RAW))
>
> ARCIBALDO is my computer name.
>
> What's the problem?
>
> Thanks in advance!
>
> --
> -d

You should check, what is in file listener.ora. If you have section:

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

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

    )
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = ARCIBALDO)(PORT = 1521))     )
  )
)

Oracle dont change the host ARCIBALDO. You can try to add also the:

(ADDRESS=(PROTOCOL=tcp)(HOST=ARCIBALDO)(PORT=8888)) (Presentation=
HTTP)(Session=RAW)

to ADDRESS_LIST if the first sequence will not work. Received on Wed Apr 25 2007 - 03:30:40 CDT