Oracle Linux Configuration for Database Installation
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.
Purpose  
Dependencies
     
     
     
 
Header
Note: Oracle has changed the nature of how they released this version and have made available at MyOracleSupport 7 zip files. Here are their descriptions:

Zip File # Description
1 Database 1 of 2
2 Database 2 of 2
3  
4  
5  
6  
7  
 
Operating System Oracle Enterprise Linux ??? Kernel
Installation Steps
  • Select language (English)
  • Select keyboard (U.S. English)
  • Install Oracle Linux Server
  • Click "Review and modify partitioning layout" checkbox
    - highlight LogVol01 - swap - default is 6GB ... leave it alone else click Edit and make changes
  • Radio button for "The GRUB boot loader will be installed on /dev/hda
  • Network devices ... set eth0 to 192.168.1.211 with netmask 255.255.255.0 ... disable IPv6 support
  • Manually set domain name to alpha1.mlib.org
  • Do not set gateway and DNS as server is stand-alone
  • Select timezone as America/Los_Angeles and system clock uses UTC
  • root password is rootalpha
  • Software select click "Customize now" radio button
    - Desktop environment GNOME
    - Applications Editors, Engineering and Scientific, Graphical Internet, Office Productivity (uncheck all others)
  • installation log file is /root/install.log
  • after installation completes acknowledge the prompt, remove DVD, and let it reboot

  • Click Forward
  • Choose "Yes I agree to the License Agreement" (Fwd)
  • Firewall: Disable (Fwd)
  • SELinux Disabled (Fwd)
  • Do not enable Kdump (Fwd)
  • Set date and time ... not on internet do not enabling time protocol (Fwd)
  • Do not create user (Fwd)
  • No additional CDs (Finish) and go for the reboot
 
Operating System Configuration
As root: Install missing RPMs --mount DVD as root

cd /media/O <tab>
cd /Server

rpm -Uvh kernel-headers-2.6.18-308.el5.x86-64.rpm
rpm -Uvh glibc-headers-2.5.81.x86-64.rpm
rpm -Uvh glibc-devel-2.5.81.x86-64.rpm
rpm -Uvh gcc-4.1.2-52.el5.x86_64.rpm
rpm -Uvh libstdc++-devel-4.1.2-52.el5.x86-64.rpm
rpm -Uvh gcc-c++-4.1.2-52.el5,x86_64.rpm
rpm -Uvh libaio-devel-0.3.106.5.x86_64.rpm
rpm -Uvh libstdc++-devel-4.1.2-52.el5.x86_64.rpm -- was already installed
rpm -Uvh sysstat-7.0.2-11.el5.x86_64.rpm

cd /

eject cdrom
As root: Create DBA Group and Oracle User /usr/sbin/groupadd -g 490 oinstall (54321 default with validated OEL package)
/usr/sbin/groupadd -g 491 dba
/usr/sbin/groupadd -g 492 oper
/usr/sbin/groupadd -g 493 backupdba
/usr/sbin/groupadd -g 494 dgdba
/usr/sbin/groupadd -g 495 kmdba

/usr/sbin/useradd -u 500 -m -g oinstall -G dba,oper oracle
id oracle

-- set the password to oracle1
passwd oracle
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: Set Appropriate Kernel Parameters cat >> /etc/sysctl.conf <<EOF
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.panic_on_oops = 1
kernel.sem = 250 32000 100 128
kernel.shmall = 2097152
kernel.shmmax = 4292967295
kernel.shmmni = 4096
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
net.ipv4.ip_local_port_range = 9000 65500
EOF

-- activate changes
/sbin/sysctl -p
Configure HugePages TBD
As root: Set Shell Limits cat >> /etc/security/limits.conf <<EOF
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240 - new 12.1
oracle hard stack 10240 - new 12.1
EOF

-- modify /etc/pam.d/ login
session required pam_limits.so (not found in 12.1 docs)
As root: Change Default Profile for the BASH shell cat >> /etc/profile <<EOF
if [ $USER = "oracle" ]; then
  ulimit -u 16384 -n 65536
  umask 022
fi
EOF
Optimize TCP/IP Stack Handling TBD
As root: Modify .bashrc # cd /home/oracle

vi .bashrc

-- append the following:
ORACLE_HOSTNAME=alpha1.mlib.org
ORACLE_BASE=/app/oracle/product
ORACLE_HOME=/app/oracle/product/12.2.0/dbhome_1
ORACLE_SID=orabase
LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH
TMP=/tmp
TEMP=/tmp
TMPDIR=/tmp
PATH=$ORACLE_HOME/bin:$PATH
export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH
export TMP TEMP TMPDIR

alias oh='cd $ORACLE_HOME'
alias sql='sqlplus "/ as sysdba"'

-- in a newly opened terminal window
$ su oracle
$ set

-- validate user oracle's environment

-- copy the two RDBMS zip files to the /stage directory and unzip them
$ cd /stage
$ unzip linux <tab> 1 <tab>
$ unzip linux <tab> 2 <tab>
$ ls -al
 
Oracle Universal Installer (OUI)
??? ./runInstaller
oui01
oui02
oui04
oui05
oui06
oui07
oui08
oui09
oui10
oui12
oui14
oui15
oui16
 
NETwork Configuration Assistant (NETCA)
netca01
netca02
netca03
netca04
netca05
netca06
netca07
netca08
netca09
netca10
netca11
netca12
netca13
netca14
netca15
netca16
netca17
netca18
netca19
netca20
 
DataBase Configuration Assistant (DBCA)
dbca01
dbca02
dbca03
dbca05
dbca06
dbca07
dbca08

Note that under Cause and Action they list "Fast Recovery Area" ... that has been renamed for the third time in my immediate memory but DBCA, it appears, didn't get that information. The new name is "Recovery Area."

I really wish Oracle's Senior VP of Product and Feature Renaming would retire.
dbca09
Note under status the listener is down. It is down because I didn't start it after creating it in NetCA. I did so intentionally so this would happen as it causes an issue for DBCA.
dbca10
Started the listener in the command shell with LSNRCTL start
dbca11
dbca12
dbca13
dbca14
dbca15
dbca16

Having select this checkbox you might expect to find SCOTT, PM, SH, and other sample schemas from past versions, and you would be incorrect. What you get is HR and some new sample schemas not available in previous versions.

If you want the tried and true, and think it insulting to the memory of Bruce Scott that they dropped SCOTT/TIGER you can find what you are looking for at github.
dbca17
dbca18
dbca19
dbca20
dbca21
dbca22
Make sure that you provide an audit_file_dest and that the db_block_size is 8192.
dbca23
Want to change the common_user_prefix from C## to something else ... do it here. Note that the control_management_pack_pack_access is set to DIAGNOSTIC+TUNING. This does not give you permission to use these options or run ASH and AWR reports if you have not purchased the appropriate licenses.
dbca24
Do not change db_writer_processes, or other processes, unless you have run tests in an QA environment, on similar infrastructure, and know the change will make things better: not worse.
dbca25
dbca26
dbca27
dbca28
dbca29
dbca30
dbca31
Always save a database template an always generate database creation scripts. There has been value for 50 years in have documented repeatable processes and Oracle has been making it easy for those of us that can check a box and push a button.
dbca33
dbca34

Then click [Finish]

Related Topics
Built-in Functions
Built-in Packages
Control Files
Dynamic Performance Views
Redo Log Files
RMAN
Security
Startup Parameters
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-2017 Daniel A. Morgan All Rights Reserved