Oracle Universal Installer (OUI)..

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
Links of Interest OTN: Download the Oracle Database 12cR1 installation .zip files
Installation Docs reference
Operating System Installation and Configuration
As root: Create the required groups and the "oracle" user $ /usr/sbin/groupadd oinstall
$ /usr/sbin/groupadd dba
$ /usr/sbin/groupadd oper
$ /usr/sbin/useradd -m -g oinstall -G dba oracle open
$id oracle

$passwd oracle
-- set the password to oracle1 for MLib classes

# Verify group membership
$ groups oracle

$ id nobody
-- if nobody does not exist then
$ /usr/sbin/useradd nobody
As root: Create Installation Directories mkdir -p /app/oracle
chown -R oracle:dba /app/oracle
chmod -R 775 /app/oracle

mkdir /stage
chown -R oracle:dba /stage
As root: Alter Kernel Parameters in sysctl.conf by appending the highlighted text. cd /etc

vi sysctl.conf

fs.file-max = 65536
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.ip_local_port_range = 1024 65000

-- activate the changes
/sbin/sysctl -p
As root: Set Shell Limits cd /etc/security

-- modify limits.conf

cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 4096
oracle hard nofile 65536

-- modify login
-- must NOT be the last line in the file
session required /lib/security/
As root: Change Default Profile cd /etc

-- for bash shell
cat >> /etc/profile <<EOF
if [ \$USER = "oracle" ]; then
  ulimit -u 16384 -n 65536
Verify ports in use # verify availability of port 1521

$ netstat -an | grep 15
As root: Append servers to hosts file cd /etc

vi hosts bigdog

-- ping all hosts (substitute actual node names for the "omega")
ping omega1
Prepare files for installation -- as Linux user oracle
$ cd /stage

$ ls -al

$ unzip l*zip

$ ls -al
Screen Shots
Start runInstaller program
Step 1a: Configure access to MOS for updates
Step 1b: Oracle's nag dialog box if you do not provide your email address
Step 2: Software Updates options
Step 3: Best practice is to choose the "software only" option and run netca and dbca as separate, independent, steps
Step 4: Unless you have a pathetically inadequate laptop or an archaic desktop machine choose "Server Class"
Step 5: For almost all demos at Morgan's Library choosing the "Single instance database" is the best choice.
Step 6: From the standpoint of learning Oracle ... always choose "Advanced install" as the advanced path provides maximum opportunity to interact with and configure the installation
Step 7: Installation Language Selection

Note that multiple languages can be selected on this screen
Step 8: Product Edition Selection.

All classes are always taught using Enterprise Edition.

Before clicking on [ Next ] click on [Select Options] and view those available.
Step 9a: A new 12c screen that asks you to identify the operating system user for the installation or to create one on-the-fly. In a Windows environment the user created is not a normal Windows user account so choose the name with great care to clearly identify its purpose as you will see below.
Step 9b: Trying to use the existing "oracle" operating system user account on a Windows box results in an error. It should be noted that in any other operating system environment this issue does not exist.
Step 9c: As you can see from the beta testing of I created a new user name "beta" to satisfy this built in unfeature. When I installed I just reused it.
Step 10: Specify the location of ORACLE_BASE and ORACLE_HOME. If, on *NIX, you have set these up already in .bash_profile or .bash_rc they should default to the correct values.

If what you entered is different from what is in your shell (.bash_profile and/or .bashrc) modify those file entries before continuing with the installation. Even though there is a browse button there is no reason to create the physical directories in advance: OUI will create them as long as the operating system user has permission on the selected location off the root file system.
Step 11: For all Morgan's Library classes choose "General Purpose". Only choose Data Warehouse if you are building one with a design involving fact and domain tables. The fact that you might be building something called a "data warehouse" but which is not based on a Star Schem, or similar, design is not a reason to choose "Data Warehouse."
Step 12: For all Morgan's Library demos check the "Create as Container database" checkmark.

The global database name used for demos on the website is "ORABASE" and the initial pluggable database (PDB) as shown at right as "PDBORCL" which contains the sample schemas SCOTT, HR, SH, PM, and OE.
Ster 13a: Memory, Character Sets, Security and Sample Schemas Selection

Be sure that you click on each tab and understand the options available. This first tab allows you to configure memory management. Do NOT enable AMM. AMM has major issues with hangs due to automated resizing. Configure ASMM.
Ster 13b: Memory, Character Sets, Security and Sample Schemas Selection

This second tab page allows the selection of the character set enabled during installation. For most classes choose the default but if the class involves globalization, or your database may be used to store multiple languages you will want to select Unicode (AL32UTF8).
Ster 13c: The recommendation is to check this and create the sample schemas. You can leave them expired and unlocked if you don't need them but they are a great place to work with Oracle's online demos and many of the examples here in the library.
Ster 14: Default practice is to make the primary location for database control files, redo logs, and CDB$ROOT datafiles directly under $ORACLE_BASE. My preference is $ORACLE_BASE/oradata/<container_database_name>. Oracle will create subdirectories under this location for the files required for PDBs.
Ster 15: There is no need to configure OEM for any materials in Morgan's Library. Perform this configuration if you wish to do so.
Ster 16: Default practice is to make the location of the FRA directly under $ORACLE_BASE. My preference is now  $ORACLE_BASE/fast_recovery_area which is slightly different what I used here during the Beta.

Only choose "Oracle Auotmatic Storage Management" if you have configured and installed Oracle Clusterware and ASM installation.
Ster 17: Management Password Screen

For any class use the single password recommended in the class book. Do not get creative as doing so may well cause other issues if the class involves multiple instances such as RAC, Data Guard, GoldenGate, or Advanced Queuing.

If this is for a production database by all means choose separate passwords and make sure they are complex ... both upper and lower case, at least one number, and at least one special character.
Ster 18a: Installation Prerequisite Checks.
Ster 18b: I intentionally created this issue to force a failure. Note that I clicked "Ignore All." This is something that may be appropriate but most of the time is a really bad idea.
Ster 18c: The nag screen that is raised when you select "Ignore All."
Ster 19: Installation Summary Screen

Review the components that will be installed. It is recommended that you save the response file so that you can easily duplicate a successful install without having to resort to the GUI.
Ster 20a: Installation Progress Screen
Ster 20b: Password Management Screen. For purposes of enhanced security do not unlock and enable schemas that do ont need to be opened.
Ster 21: Installation within OUI complete.
Installation complete after closing OUI.

Related Topics
Class Setup
Container Database
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved