Re: Starting Oracle Net Listener...forever!? Oracle XE

From: CS <cs_at_gryftechnologia.com>
Date: Thu, 5 Aug 2010 10:54:28 +0200
Message-ID: <4c5a7c54$0$19181$65785112_at_news.neostrada.pl>

# listener.ora Network Configuration File:

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /usr/lib/oracle/xe/app/oracle/product/10.2.0/server)
      (PROGRAM = extproc)

    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
      (ADDRESS = (PROTOCOL = TCP)(HOST = hpserwer)(PORT = 1521))

    )
  )

DEFAULT_SERVICE_LISTENER = (XE) # tnsnames.ora Network Configuration File:

XE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = hpserwer)(PORT = 1521))     (CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = XE)

    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))     )
    (CONNECT_DATA =

      (SID = PLSExtProc)
      (PRESENTATION = RO)

    )
  )

Uzytkownik "gazzag" <gareth_at_jamms.org> napisal w wiadomosci news:3ba0cbb3-e8f0-4b81-b875-e14edd884b82_at_c10g2000yqi.googlegroups.com... On 4 Aug, 14:33, "CS" <c..._at_gryftechnologia.com> wrote:
> Hi
>
> I reinstalled my database Oracle XE and now when I run it
> /etc/init.d/oracle-xe start,
> It hangs for a few minutes on : "Starting Oracle Net Listener... " and
> when
> trying to connectto database i get ORA-12505: TNS: listener could not
> resolve SID given in connection description.
>
> Any ideas ?

Can you post your ${ORACLE_HOME}/listener.ora and ${ORACLE_HOME}/ tnsnames.ora please?

-g Received on Thu Aug 05 2010 - 03:54:28 CDT