Re: SQL*Net: creating a seamless environment

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

-- 

Try setting up an alias' file.
Assuming hostname=Ra, ORACLE_SID=A, alias="academic"
     and hostname=Isis, ORACLE_SID=B, alias="development", using TCP/IP for
remote machines and Pipes for local machine access.

In /etc/sqlnet on Ra,
   academic  P:A
   develpment T:Isis:B

In /etc/sqlnet on Isis,
   academic T:Ra:A
   devlopment P:B

Now, "sqlplus scott/tiger_at_devlopment", connects you to the development machine,
regardless of the machine they are logged onto.


Check out pp4-4 to 4-7 of SQL*Net TCP/IP User's Guide for more hints.

(Note that I'm writing this 'cause I love sqlnet aliases, not as an official
spokesperson for any organization or agency).
================================================================================
Scott Stephens				inet:	sstephen.us.oracle.com
Oracle WorldWide Support                Redwood City, California