Re: Easy Configure a Port?

From: Ping Liu <LiuP_at_mail.dnb.com>
Date: 14 Apr 1998 15:46:24 GMT
Message-ID: <01bd67bd$75cb9cc0$2598899f@br004068.us.dbisna.com>

add the following section to TNSNAMES.ORA file in your %ORACLE_HOME%\network\admin directory:

connection_string_goes_here.world =
  (DESCRIPTION =
    (ADDRESS_LIST =

        (ADDRESS = 


          (COMMUNITY = tcp.world)


          (PROTOCOL = TCP)


          (Host = ip goes here)


          (Port = port # goes here)


        )

    )
    (CONNECT_DATA = (SID = instance name goes here)     )
  )

fill in:

connection_sting_goes_here
Host =
Prot =
SID = Hope this'll work for you.

Mark Aurit <mark_aurit_at_mail.northgrum.com> wrote in article <01bd672c$56f10560$74846380_at_NGW20072982.f18.masd.northgrum.com>...

> An admin gave me the ip address and instance name I need to configure
> SQL*NET Easy Configuration to recognize the database. Ive used this
> in the past with success, so I specified both and was unable to connect.
> The admin tells me I need to indicate the port, and that his Oracle8
> Easy Configure asks for it. Its a 7.3 database, and Im using a 7.x Easy
> Configure, 
> and it aint happening. There is no "Port" dialog, and when I tried an the
> ip of xxx.xxx.xxx.xxx:pppp where pppp=port, that did not work either.
> Any ideas would be greatly appreciated.
> Mark
> mark_aurit AT mail.northgrum.com
> 

Received on Tue Apr 14 1998 - 10:46:24 CDT