Oracle Technical Network (OTN) hosts Oracle software installation packages for developer / development use. These are the base level files, compressed and distributed in a ZIP format. Checksums are also provided for you to confirm your download’s accuracy.

Updates or patches are not available on OTN. They must be downloaded from Oracle support (MyOracleSupport, MOS) which is not available without a customer support identifier (CSI).

Some earlier releases are still available on OTN; but, they have removed most everything that is not current. All releases are available through MOS to customers owning a valid license.

OTN currently has three operating system distributions of interest to us. These are Linux, Solaris and Windows. While there are 32-bit versions available, there is very little sense these days to consider anything less than 64-bit.

The logical choice for those of us not using Oracle “Sun” hardware are Linux and Windows. The x86 Solaris is implementable; but, without a specific reason, we probably will not be doing so.

For each of these environments, OTN provides 10 downloads. For a non-grid database installation you only need the two database files. For a grid installation you will also need the two grid files… to be installed prior to the database.

There are also 32-bit and 64-bit client files. I usually grab both of them. Client files are normally not installed on the database server. There are reasons why one might install them there, for instance, if they are using a product like Quest Toad which does not currently work with a 64-bit client. I do not recommend either 1) installing a client on the server or 2) using Quest products.

In addition, there is a file named “ofm-webtier” for integration of your web server.

We never load the examples, gateways or global service manager (GSM), so these files are not downloaded. GSM may be finally coming of age. We’ll see.

In addition to the database files, there are nine additional files for each OS that are used to install Oracle Enterprise Manager (OEM). The most recent 11gR2 installation completed by me included OEM in the database package. Oracle obviously has different distributions for different customers.

More details on the OEM (also called just “EM”) files later.

When installing Oracle I usually copy all the compressed files to the server and save then in “Oracle Installation”. Then I decompress them in “Oracle Setup”, and install them into “Oracle”.

This way, all of the required files are on the server and may be used for re-installing a missing component or option; but, best used in an emergency by deleting when the OS or database stops due to a full device. They may be easily restored to the drive after the space emergency is over.

That’s all for now. The files are on the server in the software folder names “Oracle”. They are separated by database, enterprise manager and operating system, and further separated by platform.

Have a great day!

– David

Leave a Reply

Your email address will not be published.