Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> sqlnet2.1 & local instance connections

sqlnet2.1 & local instance connections

From: Duncan Reed <der1004_at_cus.cam.ac.uk>
Date: 1997/07/21
Message-ID: <5qvjd2$o6@lyra.csx.cam.ac.uk>#1/1

we are updating from sqlnet 1 to sqlnet 2.1.5.

We have a multinode vms cluster running parallel query.

We want to create some data base links which connect automatically connect to an instance on the current node.

e.g.
select * from sys.dual_at_current_node_db

instead of using one of the node names.
select * from sys.dual_at_machine1_db
select * from sys.dual_at_machine2_db

on sqlnet 1 you could do something like the folowing create public database link current_node_db using '2:512,<file>';

where <file> was the name of an sqlnet program file that worked out what node it was on and from that what the local instance was called and then connected to that instance.

How do I do something similar in SQLNet 2

Thanks,

Duncan

--
Received on Mon Jul 21 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US