Re: sqlnet2.1 & local instance connections

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
-----------------------------------------------------------------------