SQL*Net: creating a seamless environment

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