Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQLNET listener.ora syntax error
Please note you have not closed the ( before address list.
LISTENER_RAPID =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL = tcp) (HOST = rapid) (PORT = 1521) ) ) <-------This may fix it.
Stjeans007 wrote:
>
> I am trying to set up SQL*NET V2 (2.2.2) DB 7.2.2.3 on Solaris 2.5.1 when I try
> to start listener I get the following error:
>
> TNS-01150: The address of the specified listener name is incorrect
> NL-00303: syntax error in NV string
>
> This is what the listener.ora file looks like:
>
> LISTENER_RAPID =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = tcp)
> (HOST = rapid)
> (PORT = 1521)
> )
>
> STARTUP_WAIT_TIME_LISTENER_RAPID = 0
> CONNECT_TIMEOUT_LISTENER_RAPID = 10
> SID_LIST_LISTENER_RAPID =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = edmdb)
> (ORACLE_HOME = /oracle/oracle/product/7.2.2.3)
> )
> )
> TRACE_LEVEL_LISTENER_RAPID = OFF
> TRACE_FILE_LISTENER_RAPID = edmdb_listener.trc
> TRACE_DIRECTORY_LISTENER_RAPID = /oracle/oracle/product/7.2.2.3/network/log
> LOG_DIRECTORY_LISTENER_RAPID = /oracle/oracle/product/7.2.2.3/network/log
> LOG_FILE_LISTENER_RAPID = rapid_listener.log
>
> Any Help would be greatly appreciated
--
|-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-|
Glen Upreti
Senior Oracle DBA
Northern Arizona University
Phone (520)523-8393 Fax(520)523-7407
Glen.Upreti_at_NOSPAMnau.edu
Received on Fri Apr 09 1999 - 13:27:35 CDT