Re: Oracle listener.ora looks fine, but doesn't work

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Tue, 24 Aug 1999 22:51:03 +0200
Message-ID: <935527894.21045.0.pluto.d4ee154e@news.demon.nl>

Hi Andre
There needs to be at least one extra block
> LISTENER =
> (
> ADDRESS_LIST =

            (ADDRESS=(PROTOCOL=IPC)(KEY=shop))
            (ADDRESS= (PROTOCOL=TCP)(Host=localhost)(Port= 1521)) -- last )
was missing
       )

> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC = (ORACLE_HOME= /u01/app/oracle/product/8.0.5)
> (SID_NAME = shop)
> )
> )
>

Hth,

Sybrand Bakker, Oracle DBA

Andre Angelantoni <aangel_at_email.com> wrote in message news:7puksb$7ll$1_at_nnrp1.deja.com...
> Hi,
>
> I've installed Oracle 8.0.5 on RH 6.0 (which is working great) and am
> now trying to start the listener, which won't start. I can log in
> locally through SQLPlus or svrmgrl and startup the db, create accounts,
> etc.
>
> listener.ora looks like this:
>
> LISTENER =
> (
> ADDRESS_LIST = (ADDRESS= (PROTOCOL=TCP)(Host=localhost)(Port= 1521))
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC = (ORACLE_HOME= /u01/app/oracle/product/8.0.5)
> (SID_NAME = shop)
> )
> )
>
> The network file in /etc/sysconfig is
>
> NETWORKING=YES
> HOSTNAME=localhost
> DOMAINNAME=thecitylofts.com
>
> etc.
>
> The error is what everyone else gets but it turns out to be a typo:
>
> TNS-01150: The address of the specified listener name is incorrect
> NL-00303: syntax error in NV string
>
> I've pored through the Net8 admin guide, scoured the newsgroups, but
> have had no luck. This has got to be the least complicated setup there
> is!
>
> I must be missing something but what is it?
>
> Thanks in advance,
> Andre'
>
> --
> Andre Angelantoni
> aangel_at_emai
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Aug 24 1999 - 15:51:03 CDT