Listener.ora is missing

[CaoCao]

I notice that when I rebooted my Solaris 8 machine with Oracle 9.0.1 the listener and Oracle can be started automatically. I have 2 instances. However, the listener.ora file is nowhere to be found. After I stop one of the listener for 1 of the 2 instances, I cannot start back. I enter -> 'lsnrctl start pro2'. Whas has happened? The listener is started after rebooting the machine but I cannot start it manually. Please help. Tks.

[davey23uk]

lets see the exact error message you get when you type that command in

[stmontgo]

are you configured for pmon to perform automatic instance registration thus negating need for a listener file?

steve

[CaoCao]

$ lsnrctl start wpl

LSNRCTL for Solaris: Version 9.0.1.0.0 - Production on 27-OCT-2003 09:21:02

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

Starting /u01/app/oracle/product/9.1.0/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 9.0.1.0.0 - Production
Log messages written to /u01/app/oracle/product/9.1.0/network/log/wpl.log
TNS-01151: Missing listener name, wpl, in LISTENER.ORA

Listener failed to start. See the error message(s) above...

$

[CaoCao]

How to check whether the machine has pmon to perform auto instance registration? I'm not sure about this.

[stecal]

http://download-west.oracle.com/docs...ec.htm#1044716

[davey23uk]

you dont have a listener called wpl

what happens if you type lsnrctl start on its own?

[CaoCao]

Here is what I got...

$ lsnrctl start

LSNRCTL for Solaris: Version 9.0.1.0.0 - Production on 27-OCT-2003 16:55:54

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

Starting /u01/app/oracle/product/9.1.0/bin/tnslsnr: please wait...

TNSLSNR for Solaris: Version 9.0.1.0.0 - Production
Log messages written to /u01/app/oracle/product/9.1.0/network/log/listener.log
Error listening on: (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
TNS-12542: TNS:address already in use
TNS-12560: TNSrotocol adapter error
TNS-00512: Address already in use
Solaris Error: 125: Address already in use

Listener failed to start. See the error message(s) above...

$ lsnrctl status

LSNRCTL for Solaris: Version 9.0.1.0.0 - Production on 27-OCT-2003 16:56:13

Copyright (c) 1991, 2001, Oracle Corporation. All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Solaris: Version 9.0.1.0.0 - Production
Start Date 20-OCT-2003 17:37:10
Uptime 6 days 23 hr. 19 min. 3 sec
Trace Level off
Security OFF
SNMP OFF
Listener Log File /u01/app/oracle/product/9.1.0/network/log/listener.log
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=db.wplink)(PORT=1521)))
Services Summary...
Service "wplp" has 1 instance(s).
Instance "wplp", status READY, has 1 handler(s) for this service...
The command completed successfully
$