Re: Help For Config The Oracle7.3 listener!

"KillWind" <killwind_at_yeah.net> wrote in message news:<a3t9d2$1h1$1_at_mail.cn99.com>...
> Hi :
> I am config the listener on the SCO_Unix 5.0.5!
> I got any problem for them ,when my using the command:
> $ lsnrctl start
> The Error Msg is :
> LSNRCTL for AT&T System V/386: Version 2.3.2.1.0 - Production on
> 07-FEB-02 15:12:05
>
> Copyright (c) Oracle Corporation 1994. All rights reserved.
>
> Starting /app/oracle/product/7.3.2/bin/tnslsnr: please wait...
>
> TNSLSNR for AT&T System V/386: Version 2.3.2.1.0 - Production
> System parameter file is /etc/listener.ora
> Log messages written to /app/oracle/product/7.3.2/network/log/listener.log
> Attempted to listen on:
> (DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)
> (KEY=ora7)))
> TNS-12533: TNS:illegal ADDRESS parameters
> TNS-12560: TNS:protocol adapter error
> TNS-00503: Illegal ADDRESS parameters
>
> my /etc/listener.ora file is :
> LISTENER=
> (ADDRESS_LIST=
> (ADDRESS=
> (PROTOCOL=TCP)
> (KEY=ora7)
> )
> )
>
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 10
>
> SID_LIST_LISTENER=
> (SID_LIST=
> (SID_DESC=
> (SID_NAME=ora7)
> (ORACLE_HOME=/app/oracle/product/7.3.2)
> (GLOBAL_DBNAME=ora7.wbkora))
> )
>
> TRACE_LEVEL_LISTENER = OFF
> USE_CKPFILE_LISTENER = true
> USE_PLUG_AND_PLAY_LISTENER = true
> PASSWORDS_LISTENER = (80E31BA5A08D02A6)
>
> my tnsnames.ora file is :
> ora7=
> (DESCRIPTION=
> (ADDRESS=(PROTOCOL=TCP)(Host=10.0.0.91)(Port=21111))
> (CONNECT_DATA=(SID=ora7))
> )
>
> Who could help me?
>
> Thanks!!!

protocol = tcp requires host = and port = instead of key = also the address definition in listener.ora needs to match the definition in tnsnames.ora

Hth
Sybrand Bakker
Senior Oracle DBA Received on Thu Feb 07 2002 - 04:26:56 CST