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

i may be misunderstanding your setup, but Oracle tech support would immediately have you change the localhost (i am assuming a name here) to the actual IP address... we had the same problem a few months ago, and that fixed it...

we had same deal, from the server, we were fine, but just could not connect....

good luck!
brent

>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 Wed Aug 25 1999 - 14:18:11 CDT