Re: Same DB Names on Different Hosts

From: Joe Kazimierczyk <kazimiej_at_bms.com>
Date: Thu, 03 Jun 1999 08:25:18 -0400
Message-ID: <3756742E.F85AA09E@bms.com>

You can call the tnsname anything you want. That is, you can have tnsnames of A, B and C which all connect to a database called A. For example:

A =
  (DESCRIPTION =

        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = node1)


          (Port = 1521)


        )
    (CONNECT_DATA =
       (SID = A)

    )
  )
B =
  (DESCRIPTION =

        (ADDRESS =


          (PROTOCOL = TCP)


          (Host = node2)


          (Port = 1521)


        )
    (CONNECT_DATA =
       (SID = A)

    )
  )
etc...

stuco_at_mailcity.com wrote:

> 
> I have inherited 5 databases that are scattered on hosts throughout the
> country. But all the databases have the same database name and same
> connect string.
> 
> How in the world can I connect to each of these separately with unique
> TNS entries??
> 
> Thanks for your help, everyone
> 
> Stuart Cowen
> 
> Sent via Deja.com http://www.deja.com/

> Share what you know. Learn what you don't.

Received on Thu Jun 03 1999 - 07:25:18 CDT