Re: SQL*Net: creating a seamless environment

From: John Peach <epeas_at_abds7.aberdeen.chevron.com>
Date: 19 Jan 93 09:32:22 GMT
Message-ID: <1993Jan19.093222_at_abds7.aberdeen.chevron.com>


In article <1993Jan18.212420.9517_at_ra.msstate.edu>, fwp_at_Jester.CC.MsState.Edu (Frank Peters) writes:
|> Hello,
|>
|> I hope I'm missing something obvious here and someone can help me.
|>
|> We have two sun4 servers, Ra and Isis. Ra has an oracle database
|> (version 6.0.33 if it matters) and sql*net running on it. From
|> Isis I can connect to the database on Ra using T:Ra:oracle_sid
|> with no problems.
|>
|> My goal is to make these two systems as seamlessly identical as
|> possible. That is, I would like to be able to configure a user's
|> environment on the two systems (which share common home directories)
|> so that a user can log on to either system, type sqlplus (or whatever)
|> and be connected to the academic database without worrying about
|> which host s/he is on and which host the database is on.
|>
|> I've played with ORACLE_SID values and /etc/oratab files and the
|> like to no availe and I can't find anything documented in the
|> administrator's guide or the Sun4 installation and users guide.
|>
|> Is there some combination of user environment variables that will
|> let me set this up? Or must I tell my users to invoke sqlplus
|> differently depending upon which host they connect to?
|>

try the environment variable TWO_TASK. I have it set to the alias for my default database as defined in my .sqlnet file. Does exactly what you want.

|> Thanks in advance for any suggestions.
|>
|> Frank Peters
|> --
|> Frank Peters - UNIX Systems Programmer - Mississippi State University
|> Internet: fwp_at_CC.MsState.Edu - Phone: (601)325-7030 - FAX: (601)325-8921
 

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
   Internet: epeas_at_aberdeen.chevron.com       Phone: +44 224 242637
Received on Tue Jan 19 1993 - 10:32:22 CET

Original text of this message