Oracle8i - prespawning dediacated listener processes

From: Steve B <steve.bright_at_capgemini.co.uk>
Date: Tue, 13 Jul 1999 13:44:24 +0100
Message-ID: <7mfcbg$lmq$1@taliesin.netcom.net.uk>

Having read the Oracle8i documentation I'm a bit lost as to exactly how to prespawn
listener processes for a particular database instance....

The documentation requires that the prespawn_list parameter is embeded in the sid_list_<listener_name> part of the listener.ora file...

In oracle8i it also says that this parameter(s) is unnecessary for Oracle 8.1.5.....the instances will register themselves with the listener on startup.

I've configured out listener.ora file as suggested...only placing the entry for the instance I'd like to use prespawned servers for...By checking the listener services the listener creates 8 service handlers for the dev database...its seems that I have configured it correctly but will it cause any problems as Oracle now say that this is not necessary ?? Have I missed anything obvious out ??

Is there any other method of doing this in Oracle 8.1.5 apart from editing the listener.ora file as I have ??

I've included our listener.ora file....

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = beech)(PORT = 1521))
      )

    )
  )

SID_LIST_LISTENER =
(SID_DESC =
(GLOBAL_DBNAME = dev)
(ORACLE_HOME = D:\Oracle\Ora81)
(SID_NAME = DEV)
(PRESPAWN_MAX=10)

          (PRESPAWN_LIST=
                (PRESPAWN_DESC=(PROTOCOL=tcp)(POOL_SIZE=7)(TIMEOUT=300))
          )

    )
  )

Cheers

Steve Bright

steve.bright_at_capgemini.co.uk Received on Tue Jul 13 1999 - 07:44:24 CDT