1. Introduction
This guide presents how to deploy Oracle
Database 12c (12.1.0.2.0) on CentOS 7.1 (64-bit) using quick installation
features.
Reference System:
|
[root@centos
Desktop]# hostnamectl
Static hostname: centos.oracle.com
Icon name: computer-laptop
Chassis: laptop
Machine ID:
e1d198070fec4aefad03b95c76fc9aa8
Boot ID:
9fcb006bf6b84405bdd7bcf379002a91
Operating System: CentOS Linux 7 (Core)
CPE OS Name: cpe:/o:centos:centos:7
Kernel: Linux
3.10.0-327.el7.x86_64
Architecture: x86-64
|
2. Prerequisites
After a successful OS installation, verify
the hostname and register it in your DNS. Alternatively add your hostname/IP to
the /etc/hosts.
|
[root@centos
Desktop]# cat /etc/hostname
centos.oracle.com
|
If you’ve not set your system hostname,
edit the system hosts file ‘/etc/hosts‘
and enter your hostname entry along with IP address as shown below:
|
$
vim /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4
localhost4.localdomain4
::1 localhost localhost.localdomain
localhost6 localhost6.localdomain6
127.0.0.1 centos.oracle.com
|
Now change the SELinux mode to permissive
and restart the system to make Permanent changes for selinux.
|
$
sudo vim /etc/sysconfig/selinux
$
sudo init 6
|
After Restart
|
[root@centos
Desktop]# sestatus
SELinux
status: enabled
SELinuxfs
mount: /sys/fs/selinux
SELinux
root directory: /etc/selinux
Loaded
policy name: targeted
Current
mode: permissive
Mode
from config file: permissive
Policy
MLS status: enabled
Policy
deny_unknown status: allowed
Max
kernel policy version: 28
|
|
[root@centos
Desktop]# firewall-cmd --state
Running
[root@centos
Desktop]# setenforce 1
|
Download the Oracle Database 12c for Linux
x86-64 software:
3. Installation Steps
Create required OS users and groups for
Oracle Database.
|
[root@centos
Desktop]# groupadd oinstall
[root@centos
Desktop]# groupadd dba
[root@centos
Desktop]# useradd -g oinstall -G dba oracle
[root@centos
Desktop]# passwd oracle
|
Add the following kernel parameters to the /etc/sysctl.conf
|
fs.aio-max-nr
= 1048576
fs.file-max
= 6815744
kernel.shmall
= 2097152
kernel.shmmax
= 4067047424
kernel.shmmni
= 4096
kernel.sem
= 250 32000 100 128
net.ipv4.ip_local_port_range
= 9000 65500
net.core.rmem_default
= 262144
net.core.rmem_max
= 4194304
net.core.wmem_default
= 262144
net.core.wmem_max
= 1048586
|
Check and apply the new values.
|
[root@centos
Desktop]# sysctl -p
[root@centos
Desktop]# sysctl -a
|
Specify limits for oracle user in the /etc/security/limits.conf
|
oracle
soft nproc 2047
oracle
hard nproc 16384
oracle
soft nofile 1024
oracle
hard nofile 65536
|
Extract the zipped Oracle Database Software
archives (linuxamd64_12102_database_1of2.zip,
linuxamd64_12102_database_2of2.zip) to
the /stage
folder.
|
[root@centos
Desktop]# yum install -y zip unzip
[root@centos
Desktop]# unzip linuxamd64_12102_database_1of2.zip -d /stage/
[root@centos
Desktop]# unzip linuxamd64_12102_database_2of2.zip -d /stage/
|
Modify permissions on /stage
|
[root@centos
Desktop]# chown -R oracle:oinstall /stage/
|
Create /u01
directory for Oracle software and /u02
for database files.
|
[root@centos Desktop]# mkdir /u01
[root@centos Desktop]# mkdir /u02
[root@centos Desktop]# chown -R oracle:oinstall /u01
[root@centos Desktop]# chown -R oracle:oinstall /u02
[root@centos Desktop]# chmod -R 775 /u01
[root@centos Desktop]# chmod -R 775 /u02
[root@centos Desktop]# chmod g+s /u01
[root@centos Desktop]# chmod g+s /u02
|
Install required packages:
|
[root@centos Desktop]#
yum install compat-gcc-44 compat-gcc-44-c++ gcc.x86_64 gcc-c++.x86_64
glibc.i686 glibc.x86_64 glibc-devel.i686 glibc-devel.x86_64 ksh.x86_64
libgcc.i686 libgcc.x86_64 libstdc++.i686 libstdc++.x86_64 libstdc++-devel.i686
libstdc++-devel.x86_64 libaio.i686 libaio.x86_64 libaio-devel.i686
libaio-devel.x86_64 libXext.i686 libXext.x86_64 libXtst.i686 libXtst.x86_64
libX11.x86_64 libX11.i686 libXau.x86_64 libXau.i686 libxcb.i686 libxcb.x86_64
libXi.i686 libXi.x86_64 make.x86_64 unixODBC unixODBC-devel sysstat.x86_64
binutils.x86_64 compat-libcap1.x86_64 compat-libstdc++-33.x86_64
compat-libstdc++-33.i686
|
Also, install the "X Window System" package group.
|
[root@centos Desktop]# yum groups mark
convert
[root@centos Desktop]# yum groupinstall -y
"X Window System
|
Unless
you are working from the console, or using SSH tunneling, login as root and
issue the following command.
|
[root@centos Desktop]#
xhost +<machine-name>
|
Log into the oracle user. If you are using X emulation, then set
the DISPLAY environmental variable.
|
[oracle@centos Desktop]$
DISPLAY=<machine-name>:0.0; export DISPLAY
|
Use a solution above to login as
"oracle" user and run the Oracle Installer:
|
[root@centos
Desktop]# su oracle
Password:
[oracle@centos
Desktop]$ /stage/database/runInstaller
Starting
Oracle Universal Installer..
|
4. Oracle Installer Screens
|
STEP 1 - Security Updates
|
If you don't wish to receive emails from
Oracle Support then deselect the check box and click Next.
Another window opens click YES on it.
|
STEP 2 - Installation Option
|
Select Create
and configure a database and click Next
|
STEP 3 - System Class
|
Select Desktop
Class for a simple default installation of the Oracle Database. \
NOTE: Here we are selecting Desktop Class,
we can also select server Class if required.
|
STEP 4 - Typical Installation
|
On the Typical Install Configuration
screen, specify the key features.
|
Oracle base
|
/u01/app/oracle
|
|
Software location
|
/u01/app/oracle/product/12.1.0/dbhome_1
|
|
Database file location
|
/u02
|
|
Global database name
|
orcl.example.com
|
Also specify the suitable Database edition as well as the Character set. Provide a strong password for database administration
and finally deselect the Create as
Container database option.
|
STEP 5 - Create Inventory
|
Accept the default /u01/app/oraInventory and click Next.
|
STEP 6 - Prerequisite Checks
|
The Installer automatically verifies all
required OS packages and OS kernel settings.
|
STEP 7 - Summary
|
Final chance to edit any installation
features. Click Install.
|
STEP 8 - Execute Configuration Scripts
|
When a request window appears, login as
root and execute two scripts:
|
[root@centos Desktop]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
|
|
[root@centos Desktop]#
/u01/app/oracle/product/12.1.0/dbhome_1/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/12.1.0/dbhome_1
Enter the full pathname of the local bin directory:
[/usr/local/bin]: <PRESS ENTER>
Copying dbhome to
/usr/local/bin ...
Copying oraenv to
/usr/local/bin ...
Copying coraenv to
/usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
You can follow the installation in a separated window.
|
Both scripts must run as root.
|
STEP 9 - Installation progress
|
Another window opens to show you the
installation progress. Do not close this window.
|
STEP 10 - Installation completed successfully
|
The last screen inform that the
installation is done and displays the Oracle Enterprise Manager URL.
5. Post Installation Tasks
5.1. Firewall
Login as root and verify the active zones
|
[root@centos Desktop]#
firewall-cmd --get-active-zones
public
interfaces: wlo1
[root@centos Desktop]# firewall-cmd --zone=public
--add-port=1521/tcp --add-port=5500/tcp --add-port=5520/tcp
--add-port=3938/tcp --permanent
success
[root@centos Desktop]# firewall-cmd --reload
success
[root@centos Desktop]# firewall-cmd --list-ports
1521/tcp 5520/tcp 3938/tcp 5500/tcp
|
5.2. Oracle Environment
Login as oracle user and add the following
values to the /home/oracle/.bash_profile
|
#Oracle Env Settings
export TMP=/tmp
export TMPDIR=$TMP
export ORACLE_HOSTNAME=centos.oracle.com
export ORACLE_UNQNAME=orcl
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12.1.0/dbhome_1
export ORACLE_SID=orcl
export PATH=$ORACLE_HOME/bin:$PATH
export
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/lib64
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
|
Now
Enable the Profile
|
[oracle@centos ~]$. .bash_profile
[oracle@centos ~]$source ~/.bash_profile
|
5.3. Login to the database
Finally login to the database:
|
[oracle@centos ~]$ sqlplus system@orcl
... output omitted ...
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 -
64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real
Application Testing options
SQL>
|
No comments:
Post a Comment