[225] in installers
Re: Oracle files
daemon@ATHENA.MIT.EDU (Mohammad Sharari)
Mon Feb 1 10:01:34 1999
Date: Mon, 01 Feb 1999 10:00:30 -0500
To: Regina Gogol <rlgogol@MIT.EDU>, ds-ask@MIT.EDU
From: Mohammad Sharari <sharari@MIT.EDU>
Cc: ops@MIT.EDU, azary@MIT.EDU, installers@MIT.EDU, network@MIT.EDU,
sharari@MIT.EDU, repa@MIT.EDU, sendpubs@MIT.EDU, warehouse@MIT.EDU
Hi all,
The current Oracle client installers build sqlnet.ora as part of it
and generates the random seeds when you run the installer. Tnsnames.ora file
is the additional ftp file that is "separate" from the installer due to the
updates DBase team make to the file. As far as I know and, please correct me
if I'm wrong, we don't change/update the sqlnet.ora until we have another
Oracle version. At least that was my experience since I released the Oracle
installer mid 97 for the Win platform, and the same goes for the Mac I believe.
Otherwise I have to re-write the installers on both Win and Mac platforms.
To update the tnsnames.ora file we should provide an easier way for
users to get the updated file than logon to athena/ds locker.
I wrote small Vise installer to ftp/net-dist the tnsnames.ora file only, and
would be better yet to have web access to the document if we don't consider
the file to be MIT ONLY ( This Option will work better for monolithic
installers)
At 04:33 PM 1/29/99 -0500, Regina Gogol wrote:
>Hello,
>
>Jim Repa wrote a nice Perl program platform_edit.pl which allows you to
convert a text file with platform specific line-end characters to another
platform "format". Thank you, Jim.
>I prepared a new tnsnames.ora file to publish in the db services athena
locker and used Jim's program to generate *.ora files for three platforms:
mac, windows and unix. The program is located in the ds directory:
/afs/athena.mit.edu/astaff/project/ds/dbms/oracle/netdist. The program uses
the configuration file platform_edit.conf which is in the same directory.
There is a Readme file in that directory with instructions as well.
>
>Three sub-directories were created for the final platform specific files:
>
>/afs/athena.mit.edu/astaff/project/ds/dbms/oracle/public/macora
>/afs/athena.mit.edu/astaff/project/ds/dbms/oracle/public/unixora
>/afs/athena.mit.edu/astaff/project/ds/dbms/oracle/public/winora
>
>The new procedure of publishing a new version of any of Oracle files will
be as following:
>
>1. The database group prepares a new tnsnames.ora or sqlnet.ora or both
files and places
> them in the /afs/athena.mit.edu/astaff/project/ds/dbms/oracle/netdist
directory.
>2. The config file platform_edit.conf is checked and updated if needed.
>3. The platform_edit.pl program is executed. It places a new version of an
oracle file in three
> appropriate directories and sends e-mail to ds-ask@mit.edu & netreq@mit.edu
> with notifications:
>
>We've got new Oracle-related files:
>
> /afs/athena.mit.edu/astaff/project/ds/dbms/oracle/public/unixora/tnsnames.ora
> /afs/athena.mit.edu/astaff/project/ds/dbms/oracle/public/macora/tnsnames.ora
> /afs/athena.mit.edu/astaff/project/ds/dbms/oracle/public/winora/tnsnames.ora
>
>
>The network services updates files on the netdist server for Oracle installers.
>
>Note for Publications.
>Please update web pages with the reference to the old oracle files
locations. I know only one page "Basic FAQS About SQL*Net at MIT". Possibly
there are other. Please feel free to call me or other database group members
if there are questions.
>
>
>
>
>
>
>
>
>
>Regina Gogol
>MIT, Information Systems
>Database Services
>Phone: (617)253-0553
>Fax: (617)253-7661
>rlgogol@mit.edu
>
