Re: How to configure tnsnames.ora

From: <satar_at_my-dejanews.com>
Date: Fri, 18 Sep 1998 16:53:19 GMT
Message-ID: <6tu35v$2m1$1@nnrp1.dejanews.com>

Here's mine:
#
# Installation Generated NetV2 Configuration
# Version Date: Sep-30-97
# Filename: Tnsnames.ora
#

y2k =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL= TCP)(Host= y2k)(Port= 1521))     (CONNECT_DATA = (SID = y2k))
  )

sakti =

   (DESCRIPTION =

     (ADDRESS = (PROTOCOL= TCP)(Host= sakti)(Port= 1521))
     (CONNECT_DATA = (SID = sakti))

)

coredb =

   (DESCRIPTION =

      (ADDRESS = (PROTOCOL= TCP)(Host= coredb)(Port= 1521))
      (CONNECT_DATA = (SID = coredb))

)

I would use the IP address for the "Host" field, instead of the Host Name.

Good Luck,
Satar Naghshineh
In article <36020F3A.557DFA90_at_egs.ericsson.se>,   Karin <karin.anjou_at_egs.ericsson.se> wrote:

> Hi!
> I have a problem that probably is due to wrongly configured tnsnames.ora
> file. My db is in one solaris machine and when I run my program with OCI
> there it all works just fine. But I want to run it on a different
> Solaris machine. When I do that  I receive this error  message:
> TNS-12545.
> I think that my problem is that my Connect_DATA (SID,
> GLOBAL_DATA)parameters are wrongly configured. What is supposed to be in
> those? And what relation to the service-name should they have?
> Most thankful for answers!
> /Karin
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 18 1998 - 11:53:19 CDT