Re: Address already in use

r.arunmca_at_gmail.com schreef:

> The following is my "listener.ora" settings
> # listener.ora Network Configuration File: /glotam/Oracle10g/network/
> admin/listener.ora
> # Generated by Oracle configuration tools.
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /glotam/Oracle10g)
> (PROGRAM = extproc)
> )
> )
> (SID_LIST=
> (SID_DESC=
> (GLOBAL_DBNAME=rbtt)
> (SID_NAME=rbtt)
> (ORACLE_HOME=/glotam/Oracle10g)
> )
> )
> (SID_LIST=
> (SID_DESC=
> (GLOBAL_DBNAME=T24PRD)
> (SID_NAME=T24PRD)
> (ORACLE_HOME=/glotam/Oracle10g)
> )
> )
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
> (ADDRESS = (PROTOCOL = TCP)(HOST = loopback)(PORT = 1520))
> )
> )
>
>
>
> LISTENER2 =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
> (ADDRESS = (PROTOCOL = TCP)(HOST = loopback)(PORT = 1521))
> )
> )
>
> SID_LIST_LISTENER2 =
>
> (SID_LIST =
>
> (SID_DESC =
>
> (GLOBAL_DBNAME = T24PRD)
>
> (ORACLE_HOME = /glotam/Oracle9i)
>
> (SID_NAME = T24PRD)
>
> )
>
> )
>
> Thanks in advance
> R.Arun
>

Don't know where you got the idea to screw up your config data, but it sure as hell is not a generated file, contrary to what the first two lines tell:
- you have two listeners defined; listener (the default name, the   on you started) and listener2
- loopback is a tricky word to use in a network environmen, I'm   quite sure your server is not called loopback; change it. - loose the extra (SID_LIST entries; you only have one SID list   per listener.
- loose the double spaced lines (or extra white space at the end)   on your listener2 sid list.
- while you're at it: loose the extproc lines in the listener, unless   you really, really use external procedures. Extproc still is a   security hazard.

Why two listeners anyway? Did you once make a typing error, and type "lsnrctl start listener" instead of "lsnrctl start listener2"? You are aware of the fact, that any listener, not called "listener" must be started explicitly? And stopped in the same way? Meaning:
- start the listener LISTENER:
lsnrctl start
lsnrctl start listener
Stop it:
lsnrctl stop
lsnrctl stop listener

• start the listener LISTENER2: lsnrctl start listener2 Stop it: lsnrctl stop listener2

When you used "lsnrctl start listener" and now start as you described - that explains the error

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...