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

From: Andre Angelantoni <aangel_at_email.com>
Date: Tue, 24 Aug 1999 17:30:50 GMT
Message-ID: <7puksb$7ll$1@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 - 12:30:50 CDT