Re: oracle listener problems

Hi Karun,
"Karun" <karun_at_karun.net> wrote in message news:BC19C4E4.C3E%karun_at_karun.net...
> On 1/1/04 11:51 AM, in article jaKIb.42978$BQ5.26666_at_fed1read03, "Ana C.
> Dent" <anacedent_at_hotmail.com> wrote:
>
> > Karun wrote:
> >> Hi
> >> I keep receiving the following message when trying to start oracle
listener
> >> on Mac OS X 10.3
> >>
> >> TNS-01150: The address of the specified listener name is incorrect
> >>
> >
> > What happens when you "ping G4"?
> >
> > What is displayed when you "lsnrctl status"?
> >
> >
>
> 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
>
> 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
> 64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.262 ms
> 64 bytes from 127.0.0.1: icmp_seq=2 ttl=64 time=0.589 ms
> 64 bytes from 127.0.0.1: icmp_seq=3 ttl=64 time=0.264 ms
> 64 bytes from 127.0.0.1: icmp_seq=4 ttl=64 time=3.622 ms
>
> --- g4 ping statistics ---
> 5 packets transmitted, 5 packets received, 0% packet loss
> round-trip min/avg/max = 0.262/1.008/3.622 ms
>
> Karuns-Computer:~/v920/network/admin oracle$ ping -c 5 G4
> PING G4 (127.0.0.1): 56 data bytes
> 64 bytes from 127.0.0.1: icmp_seq=0 ttl=64 time=0.26 ms
> 64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.329 ms
> 64 bytes from 127.0.0.1: icmp_seq=2 ttl=64 time=0.266 ms
> 64 bytes from 127.0.0.1: icmp_seq=3 ttl=64 time=0.263 ms
> 64 bytes from 127.0.0.1: icmp_seq=4 ttl=64 time=0.377 ms
>
> --- G4 ping statistics ---
> 5 packets transmitted, 5 packets received, 0% packet loss
> round-trip min/avg/max = 0.26/0.298/0.377 ms
>

Looks like there are some syntax errors or has invalid information in the listener.ora file. Just give it a shot by backing up the file and then using the Net Configuration Assistant for creating a new listener.ora file.

HTH
TG Received on Thu Jan 01 2004 - 02:26:06 CST