Re: listener issue on 9i

Carl Mercer wrote:

> I just started up a 9i listener for the first time and I am getting
> the following message (at startup and when I request status)...
>
> ora901> lsnrctl start VL_dev_LISTENER
>
> LSNRCTL for Solaris: Version 9.0.1.0.0 - Production on 26-SEP-2001
> 09:06:03
>
> Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.
>
> Starting /dev_tools/oracle/product/9.0.1/bin/tnslsnr: please wait...
>
> TNSLSNR for Solaris: Version 9.0.1.0.0 - Production
> System parameter file is /iv_devices/oracle/VL_dev/pfile/listener.ora
> .......
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=VL_dev_EXTPROC)))
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ivserv5)(PORT=10010)))
>
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=VL_dev_EXTPROC)))
> STATUS of the LISTENER
> ------------------------
> Alias VL_dev_LISTENER
> Version TNSLSNR for Solaris: Version 9.0.1.0.0 -
> Production
> Start Date 26-SEP-2001 09:06:03
> Uptime 0 days 0 hr. 0 min. 0 sec
> Trace Level support
> Security OFF
> SNMP OFF
> Listener Parameter File /iv_devices/oracle/VL_dev/pfile/listener.ora
> .....
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=VL_dev_EXTPROC)))
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ivserv5)(PORT=10010)))
> Services Summary...
> Service "PLSExtProc" has 1 instance(s).
> Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this
> service...
> Service "VL_dev" has 1 instance(s).
> Instance "VL_dev", status UNKNOWN, has 1 handler(s) for this
> service...
> The command completed successfully
>
> I have never seen the "status UNKNOWN" message. Is this something
> simple I am doing wrong?
>
> The following is my listener.ora file
>
> VL_dev_LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = VL_dev_EXTPROC))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = ivserv5)(PORT = 10010))
> )
> )
> )
>
> SID_LIST_VL_dev_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /dev_tools/oracle/product/9.0.1 )
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (ORACLE_HOME = /dev_tools/oracle/product/9.0.1 )
> (SID_NAME = VL_dev )
> )
> )
>
> Any help or ideas would be great....
>
> Carl
>
> cmercer_at_vibrant-1.com
>
> P.S. The listener is up and running, it just gives the "status
> UNKNOWN" message.

Carl,

Did you create database with SID=VL_dev?

If you did try to start the db and check again.

Trifon Anguelov
Senior Oracle DBA Received on Wed Sep 26 2001 - 14:27:12 CDT