starting listener at boot

From: Rusty Wright <rusty_at_socrates.Berkeley.EDU>
Date: 15 Nov 2001 18:06:25 -0800
Message-ID: <uie7ksro4f2.fsf@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

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

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

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 Thu Nov 15 2001 - 20:06:25 CST