Re: starting listener at boot

There is note on Metalink
Doc ID: Note:1005041.6 HOW TO AUTOMATICALLY START THE LISTENER ON UNIX that explains how to do this.

Ron Chennells

"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.
Received on Sat Nov 17 2001 - 10:23:44 CST