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 -> Re: [8i] priority rules between database

Re: [8i] priority rules between database

From: Thomas Hesse <thomas.hesse_at_team.xtra.co.nz>
Date: Wed, 27 Mar 2002 09:33:55 +1200
Message-ID: <3CA0E943.5C0A3CE8@team.xtra.co.nz>


Hi Frederic,

> a) Is this an established rule or just random ?

The RULE is:

sqlplus name/password_at_alias

  1. look in tnsnames.ora to resolve the alias name
  2. get the listener address and SID/SERVICE_NAME
  3. ask to listener to get a connection for SID/SERVICE_NAME
  4. listener starts server processes
  5. client connects to server process

> b) How can I reach my INST_1 on SERVER_A from SERVER_B ?

add an tnsnames entry ($ORACLE_HOME/network/admin or env variable TNS_ADMIN directory)

Cheers
Thomas Received on Tue Mar 26 2002 - 15:33:55 CST

Original text of this message

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