TNS Listeners with multi-instance

From: Hong Zhou <hzhou_at_icarus.cc.uic.edu>
Date: 1997/01/16
Message-ID: <Pine.SOL.3.93.970116172914.2790A-100000@icarus.cc.uic.edu>#1/1

I installed Oracle 7.3 on NT4.0 server, I created threee instances. There are running, but why my TNS listener just list on service, ORCL. The other two were not listed. When I made alises for the other two, their names can not resolved. I got error message 12204. My listener.ora have the following entries:

################
# Filename......: listener.ora
# Node..........: local.world

# Date..........: 24-MAY-94 13:23:20

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

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS=


          (PROTOCOL= IPC)

          (KEY= oracle.world)

        )
        (ADDRESS=


          (PROTOCOL= IPC)

          (KEY= ORCL)

        )
        (ADDRESS=


          (COMMUNITY= NMP.world)

          (PROTOCOL= NMP)

          (SERVER= ORACLE)

          (PIPE= ORAPIPE)

        )
        (ADDRESS= 


          (COMMUNITY= TCP.world)

          (PROTOCOL= TCP)

          (Host= oracle)

          (Port= 1521)

        )
        (ADDRESS= 


          (COMMUNITY= TCP.world)

          (PROTOCOL= TCP)

          (Host= oracle)

          (Port= 1526)

        )

  )
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 10
TRACE_LEVEL_LISTENER = ADMIN
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = ORCL)
    )
  )
PASSWORDS_LISTENER = (oracle)

• End of file----- There are no other SIDs, I have other two instance called TEST, REPO.

Any help will be appreciatted.

Thanks Received on Thu Jan 16 1997 - 00:00:00 CST