SQLNet/Oracle 2.1 Installer Docs

by Scott McGuire (smcguire@mit.edu)
February 25, 1996


Table of Contents:

Packages

Guide to Files Table

What the Installer Does

Other Notes


Packages

There are three packages that the user can install:

Easy Install:

Installs all files.

Custom Install:

* Oracle 2.1 - installs all files (does the same thing as Easy Install package, but if you add any files, you'll have to add them to each package individually).

* tnsnames - backs up the current tnsnames.ora file, and downloads a new one. This is also done in the other packages, but this single file will need to be updated in the future, so we're providing a way to get a new copy of just it without reinstalling everything.

Guide to Files Table

No files have any settings for "Before install" or "Gestalts".

File

Install to:

Packages

Replace

After installing

Find Action Item:
Oracle 1.5 (on selected disk)

---

Easy Install
Oracle 2.1

---

Message Action Item:
OK to delete Oracle 1.5?

---

Easy Install
Oracle 2.1

---

Move Action Item:
Oracle 1.5 (folder to trash)

---

Easy Install
Oracle 2.1

if Newer

Oracle Folder (folder)

Preferences

Easy Install
Oracle 2.1

if Newer

Oracle Preferences

Install Folder

Easy Install
Oracle 2.1

if Newer

ftp

Oracle 2.1 (folder)

Install Folder

Easy Install
Oracle 2.1
tnsnames

if Newer

Applications (folder)

Install Folder

Easy Install
Oracle 2.1

if Newer

Networking (folder)

Install Folder

Easy Install
Oracle 2.1

if Newer

Easy Config
Easy Config ReadMe
NetTest
NetTest ReadMe
Oracle NetTest Comments

Install Folder

Easy Install
Oracle 2.1

if Newer

ftp

Set Oracle Home

Install Folder

Easy Install
Oracle 2.1

if Newer

ftp

Rename Action Item:
config.ora (to config.ora.bak)

---

Easy Install
Oracle 2.1

if Newer

config.ora

Install Folder

Easy Install
Oracle 2.1

Always

ftp
SetHome21

Libraries (folder)

Install Folder

Easy Install
Oracle 2.1

if Newer

OracleCore23Lib
OracleNetNLLib
OracleNetTNSLib
OracleNetTNSTCPLib
OracleNLS23Lib
OracleOci71Lib
OracleOra71Lib
OraclePcc16App
OraclePlsql21Lib
OraclePstd21Lib
OracleRuntime13Lib
OracleSql16Lib

Install Folder

Easy Install
Oracle 2.1

if Newer

ftp

Messages (folder)

Install Folder

Easy Install
Oracle 2.1

if Newer

CPYUS.MSB
LCDUS.MSB
NLUS.MSB
NMCUS.MSB
NMOUS.MSB
NMPUS.MSB
NMRUS.MSB
NMZUS.MSB
NNCUS.MSB
NNFUS.MSB
NNLUS.MSB
NNOUS.MSB
NPLUS.MSB
OPWUS.MSB
ORAUS.MSB
OSNQUS.MSB
PCMUS.MSB
PGOUS.MSB
PLSUS.MSB
PROUS.MSB
PXUS.MSB
SNLUS.MSB
SOSDUS.MSB
SP1US.MSB
SP2US.MSB

Install Folder

Easy Install
Oracle 2.1

if Newer

ftp

Network (folder)

Install Folder

Easy Install
Oracle 2.1
tnsnames

if Newer

Admin (folder)

Install Folder

Easy Install
Oracle 2.1
tnsnames

if Newer

Rename Action Item:
sqlnet.ora (to sqlnet.ora.back)

Install Folder

Easy Install
Oracle 2.1

if Newer

sqlnet.ora

Install Folder

Easy Install
Oracle 2.1

Always

ftp
SqlnetEncryptionSeed

Rename Action Item:
tnsnames.ora (to tnsnames.ora.bak)

Install Folder

Easy Install
Oracle 2.1
tnsnames

if Newer

tnsnames.ora

Install Folder

Easy Install
Oracle 2.1
tnsnames

if Newer

ftp

Debug (folder)

Install Folder

Easy Install
Oracle 2.1

if Newer

Log (folder)

Install Folder

Easy Install
Oracle 2.1

if Newer

Mesg (folder)

Install Folder

Easy Install
Oracle 2.1

if Newer

OracleNetTNSLib (without SNS)

Install Folder

Easy Install
Oracle 2.1

if Newer

ftp

Trace (folder)

Install Folder

Easy Install
Oracle 2.1

if Newer

Delete Action Item:
Oracle Libraries (if in Extensions Folder)

---

Easy Install
Oracle 2.1

---

Alias Action Item:
Oracle Libraries (to Extensions Folder)ö

---

Easy Install
Oracle 2.1

---

What the Installer Does

(1) The first thing the installer does is look for a folder named "Oracle 1.5" on the disk the user has chosen to install to (with a Find action item). If it finds one, it displays a message (with a Message action item) asking the user if they want to delete the older version; the default answer is "No". If the user answers "OK", VISE moves the Oracle 1.5 folder to the Trash (it doesn't actually delete the files right then and there).

There is no real conflict between 1.5 and 2.1, and some applications/databases still require 1.5, which is why we offer a chance to remove the older version, but don't force it on the user. Our detection method will fail if the user has renamed the 1.5 version's folder from its default name, but there's not a lot else we can do.

(2) The installer will place a folder called "Oracle Folder" into the Preferences folder, and inside that put an "Oracle Preferences" file.

(3) Then the main Oracle folder and files are installed. Special actions are performed for several files:

config.ora -

The installer checks for an existing "config.ora" file on the users's drive and will rename it to "config.ora.bak" (with a Rename action item). This is because this file is marked to Always Install, so we want to backup the user's current file just in case they made modifications to it (unlikely).

The config.ora file is set to Always Install because this is the only way to guarantee that the SetHome21 code resource, which the installer is told to run after installing "config.ora", will always be run. The SetHome21 code resource puts the path to this file into the "Oracle Preferences" file installed earlier.

sqlnet.ora -

Like "config.ora", this file is backed up (to "config.ora.bak") because it's marked to Always Install.

The sqlnet.ora file is set to Always Install because this is the only way to guarantee that the SqlnetEncryptionSeed code resource, which the installer is told to run after installing "sqlnet.ora", will always be run. The SqlnetEncryptionSeed code resource replaces the encryption seed line in the installed sqlnet.ora file with a new, randomly-generated one.

tnsnames.ora -

Like "config.ora" and "sqlnet.ora", this file is backed up (to "tnsnames.ora.bak") because it's marked to Always Install. However, this time this is because we expect users may reinstall this file from time-to-time as updated versions of it are released.

All other files in the installer are marked to run the FTP code resource after installation to fetch the real files.

(4) Finally, the installer creates an alias to the installed "Libraries" folder and places it in the user's Extensions folder with the name "Oracle Libraries" (with an Alias action item). This is necessary so that Oracle can find the shared libraries it uses. (First a Delete action item is run to get rid of any existing alias because the Alias action item won't create a new one if one already exists.)

Other Notes

The SIZE resource of the installer is set to 1200K, since in testing we discovered that the default allocation of 640K wasn't enough on some machines.