Help! SQL*Net version 2 problem starting dedicated server process

From: John Hutchin <jhutchin_at_bbn.com>
Date: 1996/10/11
Message-ID: <325E6F45.4251_at_bbn.com>#1/1

CAN ANYONE OFFER A SUGGESTION ON WHAT I'M DOING WRONG? I'm trying to do the loopback test on a Sun machine running Solaris 2.3, Oracle 7.1.3 and SQL*Net version 2.0.15.0.3 with the tcp/ip adaptor version 2.0.15.0.4. I'm able to start the listener process ok, with the following startup message:

oracle% lsnrctl start

LSNRCTL for SVR4: Version 2.1.3.0.0 - Production on 11-OCT-96 12:06:21

Copyright (c) Oracle Corporation 1994. All rights reserved.

Starting /u1/oracle/bin/tnslsnr: please wait...

TNSLSNR for SVR4: Version 2.1.3.0.0 - Production System parameter file is /var/opt/oracle/listener.ora Log messages written to /u1/oracle/network/log/listener.log Listening on:
(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=128) Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=128.89.3.216)(PORT=1521)) STATUS of the LISTENER

---

Alias                     LISTENER
Version                   TNSLSNR for SVR4: Version 2.1.3.0.0 - 
Production
Start Date                11-OCT-96 12:06:24
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  OFF
Listener Parameter File   /var/opt/oracle/listener.ora
Listener Log File         /u1/oracle/network/log/listener.log
Services Summary...
  bbno          has 1 service handlers

The command completed successfully
oracle%

When trying to do the loopback test, I get the following error message:

oracle% sqlplus ctdba/mypwd_at_spcsun14

SQL*Plus: Release 3.1.3.4.1 - Production on Fri Oct 11 12:08:08 1996

Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.

ERROR: ORA-12500: TNS:listener failed to start a dedicated server process

Here are my tnsnames.ora and listener.ora files:

listener.ora:

LISTENER=
 (ADDRESS_LIST=
  (ADDRESS=
(PROTOCOL=TCP)
(HOST=128.89.3.216)
(PORT=1521)))
SID_LIST_LISTENER =
 (SID_LIST =
  (SID_DESC =
(SID_NAME = bbno)
(ORACLE_HOME = /u1/oracle)))

tnsnames.ora :

################
# Filename......: tnsnames.ora
# Client Profile: tcp.us.oracle.com

# Date..........: 15-JUN-94 17:02:21

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

spcsun14 =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 
          (PROTOCOL = TCP)
          (Host = 128.89.3.216)
          (Port = 1521)
        )

    )
    (CONNECT_DATA = (SID = bbno))
  )

Any help would be greatly appreciated!
Thanks,
John Received on Fri Oct 11 1996 - 00:00:00 CEST