Re: lsnrctl - incorrect name/address

Mike,

What I would do is compare my listener.ora & tnsnames.ora on your NT box with your UNIX box. Also, make sure in your hosts file "/etc/hosts" has the right IP & alaias. Good Luck and I hope this helps.

Patrcik

mikimoore_at_my-deja.com wrote:

> I am having trouble with sqlnet on my
> UNIX server. Actually the sqlplus connection
> between my NT box and the server works fine.
> However, when I try and get
> the status of the listener on the unix box I get:
>
> >> lsnrctl status
>
> LSNRCTL for Solaris: Version 2.3.4.0.0 - Production on 27-APR-00
> 08:40:16
>
> Copyright (c) Oracle Corporation 1994. All rights reserved.
>
> TNS-01150: The address of the specified listener name is incorrect
> NL-00305: the specified path name does not exist
>
> This is a copy of the listener.ora:
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = oldercu)(PORT = 1521))
> )
> )
> )
>
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 30
> LOG_DIRECTORY_LISTENER = /ERC/oracle/ora_dump/netv2
> LOG_FILE_LISTENER = listener.log
> TRACE_LEVEL_LISTENER = none
> TRACE_DIRECTORY_LISTENER = /ERC/oracle/ora_dump/netv2
> TRACE_FILE_LISTENER = listener.trc
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /ERC/oracle/app/oracle/product/8.1.5)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = oldercu.llnl.gov)
> (ORACLE_HOME = /ERC/oracle/app/oracle/product/8.1.5)
> (SID_NAME = oldercu)
> )
> )
>
> Thanks for any help,
> Miki Moore
>
> miki_at_llnl.gov
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Apr 28 2000 - 00:00:00 CDT