Install Oracle

From Outrun Wiki
Jump to: navigation, search

Note

The Oracle installation process has been rewritten and largely simplified. It is no longer needed to create an intermediate ISO image. The required version is now automagically detected from the uploaded ZIP files.

Overview

For installing and configuring an Oracle database, a number of steps need to be done:

  • Verify sizing requirements
  • Installing the outrun-oracle RPM package
  • Upload Oracle ZIP files using Anonymous FTP
  • Running make-oracle
  • running clusterware setup
  • Creating ASM volumes
  • Creating ASM diskgroups
  • Creating a database

Optional:

  • Setup autostart for databases
  • Configure DB console (11g only)

Installing Outrun Oracle package

To prepare Outrun for running Oracle, you need to install the RPM package outrun-oracle.

Via the menu, shortcut
Main menu ⟹ System ⟹ Oracle
Via the menu, manual package selection
Main menu ⟹ System ⟹ Install
Then select outrun-oracle
Via the CLI
yum install outrun-oracle

Note

The reason this package is not installed by default, is that Outrun may serve other purposes as well. One purpose is that it might be deployed as a PXE install server. In future versions there might be packages for other (non-database) purposes, such as running Enterprise Manager middleware.

Pre-install checks

Before you can run the install procedure, Outrun checks a number of things to make sure the Oracle installer does not abort due to not meeting certain requirements.

The Install menu shows the result of these checks - Preinstall: OK (or WARNING or FAILED)

Status
Checks:     OK     Version:         Free: 20438 MB
Installed:  -

You can run the checks procedure (menu "Checks" to see the result of testing the prerequisites. All checks should have "Status OK". Status "ERROR" means the install cannot proceed.

Check Description
/u01 free space /u01 must have at least 5500 MB free space
/tmp free space /tmp must have at least 100MB free space
Memory System must have at least 4GB memory. Note that depending on Oracle version you may get warnings during install if RAM is less than 8GB
Swap Swapspace should be at least the size of RAM or more than 16GB
shared memory (kernel.shmmax) Shared memory setting in sysctl should be at least half the RAM
NTP daemon NTPd should be running
NTP time drift NTP time drift should be less than 2000 seconds. If NTP is running but time drift is too large (usually shortly after reboot) then just wait a few minutes.
SCSI UUID SCSI devices should report their UUID (using scsi_id --whitelisted /dev/<disk>. Strictly not an Oracle requirement but is needed for asmdisks(1)

Installing Oracle

Downloading the ZIP files from Oracle

Note
We need certain patch sets from Oracle. The patch sets provide complete Oracle installation trees, you don't have to download the previous version as they are not needed.
Prerequisite
You need a valid user account and password for support.oracle.com.
Client
The ZIP files must be downloaded to your desktop first before uploading them to Outrun. Use your normal browser for this.
Download site
Log in to Oracle Support
Download location
  1. On My Oracle Support go to tab "Patches & Updates"
  2. Under "Oracle Server and Tools" click "Latest patchsets"
  3. Go to "Oracle Database - Linux x86-64 – <version>"

Supported versions in Outrun:

Oracle Patch Sets
Version Description Files notes
11.2.0.4.0 Oracle Database Patch Set 10404530 ZIP file #1, #2, #3 of 7 recommended
11.2.0.3.0 Oracle Database Patch Set 13390677 ZIP file #1, #2, #3 of 7 Obsolete
12.1.0.2.0 Oracle Database Patch Set 17694377 only if you need 12c Lacks DBconsole
12.2.0.1.4 Oracle Database Install files only if you need 12c Lacks DBconsole


Files overview:

ZIP files
Version Filename Filesize MD5 checksum
11.2.0.4.0 p13390677_112040_Linux-x86-64_1of7.zip 1395582860 1616f61789891a56eafd40de79f58f28
p13390677_112040_Linux-x86-64_2of7.zip 1151304589 67ba1e68a4f581b305885114768443d3
p13390677_112040_Linux-x86-64_3of7.zip 1205251894 04cef37991db18f8190f7d4a19b26912
11.2.0.3.0 p10404530_112030_Linux-x86-64_1of7.zip 1358454646 bdbf8e263663214dc60b0fdef5a30b0a
p10404530_112030_Linux-x86-64_2of7.zip 1142195302 e56b3d9c6bc54b7717e14b6c549cef9e
p10404530_112030_Linux-x86-64_3of7.zip 979195792 695cbad744752239c76487e324f7b1ab
12.1.0.2.0 p17694377_121020_Linux-x86-64_1of8.zip 1673517582 017d624abe5165406d3d7c7d2d3a834c
p17694377_121020_Linux-x86-64_2of8.zip 1014527110 7f93edea2178e425ff46fc8e52369ea3
p17694377_121020_Linux-x86-64_3of8.zip 1747021093 2de14609679233465796840c8393b66a
p17694377_121020_Linux-x86-64_4of8.zip 646969279 52395e136529510438165272978835fc
12.2.0.1.4 linuxx64_12201_database.zip 3453696911 1841f2ce7709cf909db4c064d80aae79
linuxx64_12201_grid_home.zip 2994687209 ac1b156334cc5e8f8e5bd7fcdbebff82

Uploading the ZIP files to Outrun

After installation, Outrun configures an embedded FTP server based on vsftpd. The server is only started when a connection is made so it's very lightweight.

The folder
/var/ftp/oracle
is configured as upload location and does not require a userid or password. It does however require an FTP client that can handle secure SSL connections (most Internet browsers can only download stuff). When connecting with FTP the upload folder shows as
/oracle

If you don't have an FTP client already, you can use Filezilla. For Windows users, Filezilla is available if you point your browser to Outrun FTP tools.

  • Upload the ZIP files for the required version to the Outrun system's FTP incoming folder


Running the Oracle Install

If the ZIP files are uploaded to FTP and the pre-install checks are OK, you may proceed to install Oracle.

This is done via an Oracle installer feature named "silent install" which means you don't need to enter details via a wizard, everything is pre-defined. The definitions are listed in what is called a "response file" - Outrun includes response files for the various Oracle versions.

You have the option to install from the command-line or via the menu. In both cases a Makefile script called 'make-oracle' will be executed.

Running from menu

  • From the main menu, select 'Install'
  • From the Install menu, select 'Install Database Server'


Running from CLI

If you want to run install from the CLI, use the command

make-oracle

Setup clusterware and ASM

After the software installation is complete, you need to setup Clusterware and Oracle ASM (even if you don't want to run multi-node clusters or Oracle RAC). Clusterware is a pre-requisite for Oracle ASM and manages starting/stopping/monitoring of server processes.

NOTE: Oracle RAC is not yet (fully) supported in Outrun. So you will only have the "single node" options available.

NOTE: The Clusterware setup options don't appear in the menu if Oracle was not installed properly.

Clusterware setup

clusterware setup

You should see the output of the setup process showing something like this:

Successfully configured Oracle Grid Infrastructure for a Standalone Server
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       

Local Resources

ora.LISTENER.lsnr
               ONLINE  ONLINE       outrun01                                     
ora.ons
               OFFLINE OFFLINE      outrun01                                     

Cluster Resources

ora.cssd
      1        OFFLINE OFFLINE                                                   
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  INTERMEDIATE outrun01                                     

At this point, clusterware services are starting and you may configure Oracle ASM. Choose "ASM" from the menu. CLI alternative: configure-asm

If ASM configured correctly, you have finished Outrun setup and the Oracle install phase and you're ready to create a database.

You may verify the status of Clusterware and ASM by running "Status" from the Install menu. CLI alternative: clusterware status

CRS-4638: Oracle High Availability Services is online

NAME           TARGET  STATE        SERVER                   STATE_DETAILS       

Local Resources

ora.LISTENER.lsnr
               ONLINE  ONLINE       outrun01                                     
ora.asm
               ONLINE  ONLINE       outrun01                 Started             
ora.ons
               OFFLINE OFFLINE      outrun01                                     

Cluster Resources

ora.cssd
      1        ONLINE  ONLINE       outrun01                                     
ora.diskmon
      1        OFFLINE OFFLINE                                                   
ora.evmd
      1        ONLINE  ONLINE       outrun01                               

Note that the resources "ora.ons" and "ora.diskmon" are OFFLINE - this is normal. The other resources should be in state ONLINE.

Creating RPM package

The install procedure can also create an RPM package containing the entire Oracle installation. This makes it possible to install multiple servers simply by running

yum install oracle-<version>

Creating the RPM requires the rpm-build package to be installed. You also need a lot of space on /var (usually at least 4-5 GB) and on /u01 (also at least 4-5 GB).

To crate the package, run:

make-oracle rpm

Troubleshooting

Troubleshooting

The Oracle installer is very sensitive to minor errors or preconditions. The Outrun Checks procedure attempts to catch the most common problems and Outrun in general is designed to make installation failproof due to locked down dependencies, dynamic system configuration (such as kernel settings, ulimits, memory tuning etc). However, the devil is in the details and the install might not finish without errors. To make things worse, the error messages are very obscure (especially using the silent installer) and log files tend to be very hard to digest and sometimes they are deleted before you get a chance to inspect them.

It is possible you run into such problems even when the preinstall checks shows OK status. I would like to hear such problems so I can catch the error before the installer gives up. If you feel adventurous you may attempt to run the graphical installer yourself as it is a little more useful in showing things that went wrong. Procedure for manual GUI install:

  1. install the "lightvnc" rpm package
  2. Open a VNC session on port 5900, login as "grid" (for clusterware) or as "oracle" (for database install)
  3. Open a shell (right mouse button)
  4. run make-oracle unzip
  5. run /uu1/tmp/staging/grid/runInstaller for grid/clusterware install (note for 12.2+ you need to manually unzip)
  6. run /u01/tmp/staging/database/runInstaller for database install
  7. work through the GUI and see why the install fails

Instead of installing lightvnc you can also remote connect with an X forwarding session from a Linux workstation:

ssh -X grid@<server>