Re: Total Newbie 8i PE Listener Question

From: <nqaprjr_at_my-deja.com>
Date: 2000/03/11
Message-ID: <8ae419$kd1$1@nnrp1.deja.com>#1/1

You need to see what network protocols your machine is using. Most likely your using TCP/IP. You need to put an entry into listener.ora for the protocol.

LISTENER =
  (ADDRESS_LIST =

        (ADDRESS =


          (PROTOCOL = TCP)

          (Host = <Your host name or IP address>)

          (Port = 1521)

        )

   )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =

      (GLOBAL_DBNAME = <Your oracle sid>)
      (SID_NAME = <Your oracle sid>)

    )
   )

and a corresponding entry in the tnsnames.ora file

<Your oracle sid>.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS =


          (COMMUNITY = tcp.world)

          (PROTOCOL = TCP)

          (HOST = <Your host name>)

          (PORT = 1521)

        )

    )
    (CONNECT_DATA =

        (SID = <Your oracle sid>)
        (GLOBAL_NAME = <Your oracle sid>.world)

    )
  )

If your are connecting from a remote PC then that PC needs the Oracle client installed and a copy of your tnsnames.ora file.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Mar 11 2000 - 00:00:00 CST