problem setting up sqlnet

From: Yuanhui Liu <liuyh_at_dragon.teleride.on.ca>
Date: 1995/08/01
Message-ID: <DCLwK3.6nC_at_teleride.on.ca>#1/1

Hi all,

I am a relatively inexperienced Oracle User, I am trying to set up a very simple sqlnet on an already existing database on a SPARC machine running Solaris 2.4, and ran into some problem(namely, can't get the listener process started). Can anyone give me some hint about it? The Oracle Version is 7.1.4(SQL*net ver. 2.1.4).

Please e-mail me if you have any suggestions, I cannot get up-to-date news at my site.

Thanks a lot!!!

-Yuanhui Liu

---

I have added these lines to the init file, and restarted the DB instance:

# set up multi-threaded server

mts_dispatchers = "TCP,1"
mts_dispatchers = "IPC,1"
mts_max_dispatchers = 5
mts_service = sid1.world
mts_servers = 1
mts_servers = 10
mts_listener_address = "(ADDRESS=(PROTOCOL=IPC)(KEY=sid1))"
mts_listener_address = "(ADDRESS=(PROTOCOL=TCP)(HOST=moe)(PORT=1521))"

When I try to start the listener, I always get the following errors:

---

moe:oracle$ lsnrctl start

LSNRCTL for SVR4: Version 2.1.4.1.0 - Production on 31-JUL-95 20:25:01  

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

Starting /home/dba/oracle/product/7.1.4.1/bin/tnslsnr: please wait...  

TNS-12545: TNS:name lookup failure
 TNS-12560: TNS:protocol adapter error
  TNS-00515: Name lookup failure
   SVR4 Error: 2: No such file or directory moe:oracle$

---

The error seems to point to a syntax error in listener.ora or tnsnames.ora, however I have failed to find anything. I have edited the configs by hand. since I do not have network manager. could this be a problem?

The configs. in /var/opt/oracle are:

"listener.ora":

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

LISTENER=
  (ADDRESS_LIST=

        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY=sid1)
        )
        (ADDRESS=
          (COMMUNITY=avlc.world)
          (PROTOCOL=TCP)
          (HOST=moe)
          (PORT=1521)
        )

  )
SID_LIST_LISTENER=
  (SID_LIST=
    (SID_DESC=

      (SID_NAME=sid1)
      (ORACLE_HOME=/home/dba/oracle/product/7.1.4.1)

    )
  )
# STARTUP_WAIT_TIME_LISTENER=0
# CONNECT_TIMEOUT_LISTENER=10
# TRACE_LEVEL_LISTENER=OFF
"tnsnames.ora":

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

sid1=
  (DESCRIPTION=
    (ADDRESS_LIST=

      (ADDRESS=
        (COMMUNITY=avlc.world)
        (PROTOCOL=TCP)
        (HOST=moe)
        (PORT=1521)
      )  

    )
    (CONNECT_DATA=
      (SID=sid1)
    )
  )

"tnsnav.ora"

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

LOCAL_COMMUNTIES=
  (COMMUNITY_LIST=
    (COMMUNITY = avlc.world)
  ) Received on Tue Aug 01 1995 - 00:00:00 CEST