|Oracle Universal Installer (OUI)..
|Links of Interest||OTN: Download the Oracle Database 12cR1 installation .zip files|
|Installation Docs||http://docs.oracle.com 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
-- 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
chown -R oracle:dba /stage
|As root: Alter Kernel Parameters in sysctl.conf by appending the highlighted text.||cd /etc
-- activate the changes
|As root: Set Shell Limits||cd /etc/security
-- modify limits.conf
-- modify login
|As root: Change Default Profile||cd /etc
-- for bash shell
|Verify ports in use||# verify availability of port 1521
$ netstat -an | grep 15
|As root: Append servers to hosts file||cd /etc
-- ping all hosts (substitute actual node names for the "omega")
|Prepare files for installation||-- as Linux user oracle
$ cd /stage
$ ls -al
$ unzip l*zip
$ ls -al
|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 220.127.116.11 I created a new user name "beta" to satisfy this built in unfeature. When I installed 18.104.22.168 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.|
|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-2017 Daniel A. Morgan All Rights Reserved|