Re: oracle listener problems

On Thu, 1 Jan 2004 2:36:52 +0100, Karun wrote (in message <BC19C4E4.C3E%karun_at_karun.net>):

> Below is the output from the following commands
>
> Karuns-Computer:~/v920/network/admin oracle$ lsnrctl start
>
> LSNRCTL for MacOS X Server: Version 9.2.0.1.0 - Beta on 01-JAN-2004 12:29:51
>
> Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
>
> Starting /Users/oracle/v920/bin/tnslsnr: please wait...
>
> TNSLSNR for MacOS X Server: Version 9.2.0.1.0 - Beta
> System parameter file is /Users/oracle/v920/network/admin/listener.ora
> Log messages written to /Users/oracle/v920/network/log/listener.log
> TNS-01150: The address of the specified listener name is incorrect
>
> Listener failed to start. See the error message(s) above...
>
>
> Karuns-Computer:~/v920/network/admin oracle$ lsnrctl status
>
> LSNRCTL for MacOS X Server: Version 9.2.0.1.0 - Beta on 01-JAN-2004 12:30:03
>
> Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
>
> TNS-01150: The address of the specified listener name is incorrect
> NL-00303: syntax error in NV string

There is a syntax error in the address string. Try to simplify. On my config it works fine with
listener=(address=(host=g4)(port=1521)(protocol=tcp))

Take a look at tahiti for the exact syntax and don't forget it's a beta.

>
> PING g4 (127.0.0.1): 56 data bytes
> 64 bytes from 127.0.0.1: icmp_seq=0 ttl=64 time=0.304 ms

Nothing wrong with the name.

-- 
With kind regards,
Ronald
http://ronr.nl/unix-dba