Re: Problem starting listener

From: Karsten Farrell <kfarrell_at_belgariad.com>
Date: Fri, 13 Dec 2002 00:45:52 GMT
Message-ID: <45aK9.252$Df4.25271434@newssvr13.news.prodigy.com>

Comments embedded.

Bobby Singh wrote:
> Hi,
>
> I am having problem starting listener with the following listener.ora
> file on 9i. Listener fails to start with error TNS-01150: the address of
> the specified listener name is incorrect. If I remove the first three
> lines, it starts up fine with each instance UNKNOWN and duplicate READY.
>
> My tns_admin path is fine. I don't know what else to do. I want to get
> rid of this UNKNOWN instance.
>
> Using red hat linux.
>
> Thanks
> Bobby
>
>
> LISTENER =
> (ADDRESS_LIST=
> (ADDRESS=(PROTOCOL=tcp)(HOST=<HOSTNAME>)(PORT=1521))
>

If this is an exact copy of what you have in your listener.ora, then you are missing a closing right paren here. You have 5 left parens and 4 right parens. You need to close the ADDRESS_LIST entry.

> STARTUP_WAIT_TIME_LSNR = 0
> CONNECT_TIMEOUT_LSNR = 10
>
> SID_LIST_LISTENER =
> (SID_LIST=
>
> (SID_DESC =
> (SID_NAME=Data)
> (ORACLE_HOME=/usr/oracle)
> )
>
> (SID_DESC =
> (SID_NAME=repo)
> (ORACLE_HOME=/usr/oracle)
> )
>
> (SID_DESC =
> (SID_NAME=galaxy)
> (ORACLE_HOME=/usr/oracle)
>
>
Received on Thu Dec 12 2002 - 18:45:52 CST