Re: TNS-01152: All addresses specified for the listener name, LISTENER, failed

"Steve N." <steven_nospam_at_yahoo.ca> wrote in message news:a7f2ae7e.0406020602.6383606c_at_posting.google.com...
> steven_nospam_at_yahoo.ca (Steve N.) wrote in message
news:<a7f2ae7e.0406011231.2ca2d4e0_at_posting.google.com>...
> > Has anyone seen this error message before when trying to start the
> > Oracle Listener on the local system?
> >
> > TNS-01152: All addresses specified for the listener name, LISTENER,
> > failed
>
> We have resolved the issue. Here is what we found out:
>
>
> The listener.log had no additional information in it. The log simply
> indicated the trace level, the parameter and log file paths, then gave
> the same error above.
>
> At trace level 16, the listener.trc was analyzed. It gave the same
> info as the log file, except with a hex dump instead.
>
> We compared a working system's listener.ora and tnsnames.ora files
> with the ones on the affected system and the only difference we noted
> was that the person who edited the file had not used the same spacing
> as we used on the working system.
>
> This was the working SID_LIST entry:
>
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME = orion)
> (ORACLE_HOME = /apps/oracle/app/oracle/product/8.1.6)
> (SID_NAME = l01)
> )
>
> This was the one that was not working (note the = sign spacing)
>
> (SID_LIST =
> (SID_DESC =
> (GLOBAL_DBNAME= orion)
> (ORACLE_HOME= /apps/oracle/app/oracle/product/8.1.6)
> (SID_NAME= l01)
> )
>
> When we correctly placed a space in front of the equals signs, the TNS
> error disappeared.
>
> Thanks to all who gave suggestions.
>
> Steve

What version of the database was this?

It sounds awfully like the first time I ever taught setting up Multu-Threaded Server, which I think was on 8.1.5. Four hours we plugged away at trying to get the thing to work. Then one of the students accidentally hit the space bar, and it all just magically sprang into life.

Those were the days. Last time I taught it on 9iR2, it was all working within about 45 seconds. Life's no fun any more.

:-)

Regards
HJR Received on Wed Jun 02 2004 - 09:32:02 CDT