Re: starting listener at boot

"Rusty Wright" <rusty_at_socrates.Berkeley.EDU> wrote in message news:uie7ksro4f2.fsf_at_socrates.Berkeley.EDU...
> I don't understand why I can't automatically start the listener at
> boot time. I'm on Solaris 8, Oracle 8.1.7.
>
> Step 1: From root I do "su - oracle" and then I type "lsnrctl start"
> and it starts ok with:
>
> LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 15-NOV-2001
17:35:44
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Starting /softdist_b/oracle/product/8.1.7/bin/tnslsnr: please wait...
>
> TNSLSNR for Solaris: Version 8.1.7.0.0 - Production
> System parameter file is

/softdist_b/oracle/product/8.1.7/network/admin/listener.ora
> Log messages written to

/softdist_b/oracle/product/8.1.7/network/log/listener.log
> Listening on:

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=softdist2)(PORT=1521)))
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
>
> Connecting to

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=softdist2)(PORT=1521)))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for Solaris: Version 8.1.7.0.0 -
Production
> Start Date 15-NOV-2001 17:35:44
> Uptime 0 days 0 hr. 0 min. 0 sec
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Parameter File

/softdist_b/oracle/product/8.1.7/network/admin/listener.ora
> Listener Log File

/softdist_b/oracle/product/8.1.7/network/log/listener.log
> Services Summary...
> PLSExtProc has 1 service handler(s)
> softdist has 1 service handler(s)
> The command completed successfully
>
> Step 2: I modified the $ORA_HOME/bin/dbstart script and added the
> following line:
>
> lsnrctl start ${ORACLE_SID}
>
> I added it just after these lines that start the database:
>
> case $VERSION in
> 6) sqldba command=startup ;;
> *) $SQLDBA <<EOF
> connect internal
> startup
> EOF
>
> Step 3: As root I run the command "/etc/dbora start" (which calls
> dbstart) and it starts the database but bombs on the listener part;
> here's the output:
>
> Oracle Server Manager Release 3.1.7.0.0 - Production
>
> Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.
>
> Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
> With the Partitioning option
> JServer Release 8.1.7.0.0 - Production
>
> SVRMGR> Connected.
> SVRMGR> ORACLE instance started.
> Total System Global Area 683319456 bytes
> Fixed Size 73888 bytes
> Variable Size 179888128 bytes
> Database Buffers 503177216 bytes
> Redo Buffers 180224 bytes
> Database mounted.
> Database opened.
> SVRMGR>
> Server Manager complete.
>
> LSNRCTL for Solaris: Version 8.1.7.0.0 - Production on 15-NOV-2001
17:56:32
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Starting /softdist_b/oracle/product/8.1.7/bin/tnslsnr: please wait...
>
> TNSLSNR for Solaris: Version 8.1.7.0.0 - Production
> System parameter file is

/softdist_b/oracle/product/8.1.7/network/admin/listener.ora
> Log messages written to

/softdist_b/oracle/product/8.1.7/network/log/softdist.log
> TNS-01151: Missing listener name, softdist, in LISTENER.ORA
>
> Here's my listener.ora file:
>
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = softdist2)(PORT = 1521))
> )
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
> )
> )
> )
>
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = /softdist_b/oracle/product/8.1.7)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = softdist)
> (ORACLE_HOME = /softdist_b/oracle/product/8.1.7)
> (SID_NAME = softdist)
> )
> )
>
> My oratab file says
>
> softdist:/softdist_b/oracle/product/8.1.7:Y
>
> Shutting down works fine; I added a "lsnrctl stop ${ORACLE_SID}" to
> the dbshut script.
>
> Any ideas it won't start at boot time?
>
> Thanks in advance.

If you look up the error that you are getting ('TNS-01151: Missing listener name, softdist, in LISTENER.ORA'), you'll find:

TNS-01151 Missing listener name, string, in LISTENER.ORA Cause: The listener could not find the listener name specified. Action: Make sure valid addresses on which to listen are specified for the listener name in LISTENER.ORA.

Now, what could be causing lsnrctl to think that the listener is named 'softdist', I wonder?

It is because the command-line you are executing is: lsnrctl start ${ORACLE_SID}

BUT, the listener is called 'LISTENER' (which is the default name) in the listener.ora file.

All you have to do is 'lsnrctl start' or to be pedantic 'lsnrctl start LISTENER'. You don't specify the ORACLE_SID to the lsnrctl command.

HTH, -LM Received on Thu Nov 15 2001 - 20:16:47 CST