Re: sqlnet2.1 & local instance connections

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/07/24
Message-ID: <33D6EE43.3705@postoffice.worldnet.att.net>#1/1

Is it possible that your TNSNAMES.ORA files on the two machines are identical, and therefore the service name used by your database links points to the same server (in this case machine 1), i.e. no matter on which machine you are, you always go to machine 1 ? When you are on machine 2, this is where you want to go, but not so when you are on machine 1.

Hope this helps.

Michael Serbanescu

---

Duncan Reed wrote:
>
> Wayne Linton (lintonw_at_cadvision.com) wrote:
> : if you do not specify the sqlnet string at all, the system will connect
> : you to the database where your VMS logicals are pointing (ie execute
> : ORA_DB_xxxxx and ORA_USER_xxxxx). You can override this by setting the
> : logical ORA_DFLT_HOSTSTR.
 

> : We run several databases on a single node. Which one is 'local'? Which
> : ever the current logicals point to.
 

> : Hope this is of help.
 

> : Wayne Linton
> : Shell Canada Ltd.
>
> Thats not quite what I had in mind. I wish to access another database
> via sqlnet2 after logging into a different database but I want it to connect
> to the instance (of a multiple instance) that is on the machine of the
> current instance. This is only a problem on a cluster using parallel query.
>
> machine 1 machine 2
> instance test instance test
> instance live instance live
>
> You are logged on to machine 2, test instance. You wish to get some data
> from the live instance. For performance and robustness reason you want
> to automatically work out what machine you are on and connect to that
> machines instance of the live database. So you say something like
>
> select * from sys.dual_at_cluster_live.
>
> but if you issued the same statement on machine 1 test instance you
> would connect to machine 1's live instance.
>
> Hope this makes it clearer.
>
> Duncan
> --
> -----------------------------------------------------------------------
> A1200T 060/50Mhz 18MB 2.3GB/SCSI2 JAZ x12-CDRom Whippet USR-Sportster
> Cat Weasel / OS 3.1 / Opus Magellan / AsimCDFS / NetBSD1.2 / PC-Task4.2
> PlayStation Psion 3c/2meg IBM PS/2 386/16
> Duncan Reed ** Team AMIGA ** der1004_at_cus.cam.ac.uk
> -----------------------------------------------------------------------
Received on Thu Jul 24 1997 - 00:00:00 CDT