Error Starting Sqlnet on an openVMS Host from a script

From: <ling_at_redash.qut.edu.au>
Date: Mon, 1 Jun 98 15:33:54 +1000
Message-ID: <6ktect$f3o$1@dove.qut.edu.au>

Hi Oracle DBAs,

Re: Error Starting Sqlnet on an openVMS Host from a script

I am running SQLNET v2.3.3 with RDBMS v7.3.3.4 on an openVMS 7.1 host. During booting up, I have a DCL script that installs oracle shared images and submits a batch job to start the SQLNET daemon. Another script then starts the database.

Since I upgraded RDBMS and openVMS (from v6.1) 3 weeks ago, the SQLNET startup failed each time during bootup with the error messages below. However, when I do LSNRCTL START online on the same account, I get no error. Please also note that the same startup script has been used on other machines successfully albeit the RDBMS are all v7.1.5.2.3

I tried to increase the process quota parameters in [.NETCONFIG]LSNRCTL.COM to the same values as per the UAF of the account, but it still gave me the same errors.

I talked to Oracle Hotline about it, but they haven't come up with any solution. Any suggestions?

Thanks in advance
How-Hie Ling
(h.ling_at_qut.edu.au)

LSNRCTL for VMS: Version 2.3.3.0.0 - Production on 28-MAY-98 14:00:38

Starting xxxxxxx:[DSKP.ZCPAORACLE7.NETWORK]tnslsnr: please wait...

TNS-12547: TNS:lost contact
TNS-12560: TNS:protocol adapter error
TNS-00517: Lost contact
VMS Error: 2280: nonexistent process

LISTENER.ORA

################


# Filename......: listener.ora

# Name..........: XXX.world
# Date..........: 18-May-98 13:38:28

################

LISTENER =
(ADDRESS_LIST =

        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= XXX.world)
        )
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= XXX)
        )
        (ADDRESS =
          (COMMUNITY = TCP.world)
          (PROTOCOL = TCP)
          (Host = nnn.nnn.nnn.nn)
          (Port = 1526)
        )

  )
STARTUP_WAIT_TIME_LISTENER = 10
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (SID_NAME = XXX)
      (PROGRAM = DSKP:[ZCPAORACLE7.NETWORK.ADMIN]ORASRV_NETV2_XXX.COM)
      (TIMEOUT = 0)
      (PRESPAWN_MAX = 10)

)
)

Received on Mon Jun 01 1998 - 00:33:54 CDT