Error starting SQLNET on an OpenVMS Host from a Script

From: H Ling <h.ling_at_qut.edu.au>
Date: Tue, 07 Jul 1998 15:27:47 +1000
Message-ID: <35A1B1D3.D1B0EDAA@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) a few 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 can

start SQLNET everytime. 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 Copyright (c) Oracle Corporation 1994. All rights reserved. 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

---

Listing of LISTENER.ORA below:

 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 Tue Jul 07 1998 - 00:27:47 CDT