Install Oracle Database 12c on CentOS 7 - CentLinux

Latest

Sunday, 7 February 2016

Install Oracle Database 12c on CentOS 7

Install Oracle Database 12c on CentOS 7The Oracle Database 12c is the latest stable release of Industry’s most famous Relational Database Management System (RDBMS). Oracle Database 12c is a multi-model database, that can organize data in various models. But it is commonly used in Online Transaction Processing (OLTP) and Online Analytical Processing (OLAP) models.

In this article, we will install Oracle Database 12c on a CentOS 7 server. We follow the Oracle database documentation to configure the Oracle Database 12c as per the best practices.

 

This Article Provides:

     

    Environment Specification:

    We are using a CentOS 7 minimal virtual machine with following specification.

    • CPU – 2.4 Ghz (2 Core)
    • Memory – 2 GB
    • Storage – “/” of 46 GB, Swap of 4GB
    • Operating System – CentOS 7.2

     

    Oracle Database 12c Post Installation Configurations:

    There is a good alternative to manual configuration, i.e. oracle-rdbms-server-12cR1-preinstall.x86_64.rpm package. But unfortunately, it required UEK (Unbreakable Enterprise Kernel) that is only shipped with OEL (Oracle Enterprise Linux) 6 or later. 

    Therefore, if you are planning to install on OEL 6 or later than you can download and install it to save your time, otherwise you have to configure prerequisites manually.

    Since, we are installing Oracle Database 12c on CentOS 7, therefore, we will perform everything manually for the sake of demonstration.

    Set hostname and add an entry in the Local DNS Resolver.

    [root@dbserver ~]# hostnamectl set-hostname dbserver.test.local [root@dbserver ~]# echo "192.168.229.50 dbserver.test.local dbserver" >> /etc/hosts

    Execute the following command to add these Kernel parameters in /etc/sysctl.conf file.

    [root@dbserver ~]# cat >> /etc/sysctl.conf << EOF >fs.file-max = 6815744 >kernel.sem = 250 32000 100 128 >kernel.shmmni = 4096 >kernel.shmall = 1073741824 >kernel.shmmax = 4398046511104 >net.core.rmem_default = 262144 >net.core.rmem_max = 4194304 >net.core.wmem_default = 262144 >net.core.wmem_max = 1048576 >fs.aio-max-nr = 1048576 >net.ipv4.ip_local_port_range = 9000 65500 >EOF [root@dbserver ~]# sysctl –p

    Set security limits for oracle user.

    [root@dbserver ~]# cat >> /etc/security/limits.conf << EOF >oracle soft nofile 1024 >oracle hard nofile 65536 >oracle soft nproc 2047 >oracle hard nproc 16384 >oracle soft stack 10240 >oracle hard stack 32768 >EOF

    Install prerequisite packages using yum command.

    [root@dbserver ~]# yum install binutils -y [root@dbserver ~]# yum install compat-libstdc++-33 -y [root@dbserver ~]# yum install compat-libstdc++-33.i686 -y [root@dbserver ~]# yum install gcc -y [root@dbserver ~]# yum install gcc-c++ -y [root@dbserver ~]# yum install glibc -y [root@dbserver ~]# yum install glibc.i686 -y [root@dbserver ~]# yum install glibc-devel -y [root@dbserver ~]# yum install glibc-devel.i686 -y [root@dbserver ~]# yum install ksh -y [root@dbserver ~]# yum install libgcc -y [root@dbserver ~]# yum install libgcc.i686 -y [root@dbserver ~]# yum install libstdc++ -y [root@dbserver ~]# yum install libstdc++.i686 -y [root@dbserver ~]# yum install libstdc++-devel -y [root@dbserver ~]# yum install libstdc++-devel.i686 -y [root@dbserver ~]# yum install libaio -y [root@dbserver ~]# yum install libaio.i686 -y [root@dbserver ~]# yum install libaio-devel -y [root@dbserver ~]# yum install libaio-devel.i686 -y [root@dbserver ~]# yum install libXext -y [root@dbserver ~]# yum install libXext.i686 -y [root@dbserver ~]# yum install libXtst -y [root@dbserver ~]# yum install libXtst.i686 -y [root@dbserver ~]# yum install libX11 -y [root@dbserver ~]# yum install libX11.i686 -y [root@dbserver ~]# yum install libXau -y [root@dbserver ~]# yum install libXau.i686 -y [root@dbserver ~]# yum install libxcb -y [root@dbserver ~]# yum install libxcb.i686 -y [root@dbserver ~]# yum install libXi -y [root@dbserver ~]# yum install libXi.i686 -y [root@dbserver ~]# yum install make -y [root@dbserver ~]# yum install sysstat -y [root@dbserver ~]# yum install unixODBC -y [root@dbserver ~]# yum install unixODBC-devel -y [root@dbserver ~]# yum install zlib-devel -y [root@dbserver ~]# yum install zlib-devel.i686 -y

    Create required OS user and groups.

    [root@dbserver ~]# groupadd -g 1101 oinstall [root@dbserver ~]# groupadd -g 1102 dba [root@dbserver ~]# groupadd -g 1103 oper [root@dbserver ~]# groupadd -g 1104 backupdba [root@dbserver ~]# groupadd -g 1105 dgdba [root@dbserver ~]# groupadd -g 1106 kmdba [root@dbserver ~]# groupadd -g 1107 asmdba [root@dbserver ~]# groupadd -g 1108 asmoper [root@dbserver ~]# groupadd -g 1109 asmadmin [root@dbserver ~]# useradd -u 1101 -g oinstall -G dba,oper oracle [root@dbserver ~]# echo “oracle” | passwd oracle –stdin

    Oracle Database 12c is currently not compatible with SELinux. Therefore, either we need to disable SELinux or put it into permissive mode.

    [root@dbserver ~]# sed -i 's/^SELINUX=.*/SELINUX=permissive/g' /etc/sysconfig/selinux [root@dbserver ~]# setenforce permissive

    Configure Linux Firewall to allow Oracle SQL* Net Listener to accept service requests on its default port.

    [root@dbserver ~]# firewall-cmd –-permanent –-add-port=1521/tcp [root@dbserver ~]# firewall-cmd –-reload

    Create directories for Oracle RDBMS Software.

    [root@dbserver ~]# mkdir -p /u01/app/oracle/product/12.1.0.2/db_1 [root@dbserver ~]# chown -R oracle:oinstall /u01 [root@dbserver ~]# chmod -R 775 /u01

    To redirect X-Server display to your client machine, execute following command (make sure you have a X-Server utility, e.g. XMing, running on the client to capture the X-Server display. Also set the display variable in the Putty)

    Set Linux environment variables for oracle user as follows.

    [root@dbserver ~]# xhost + [root@dbserver ~]# su – oracle [oracle@dbserver ~]$ cat >> vi ~/.bash_history << EOF ># Oracle Settings >export TMP=/tmp >export TMPDIR=$TMP >export DISPLAY=192.168.229.1:0.0 # Set your Client IP here >export ORACLE_HOSTNAME=dbserver.test.local >export ORACLE_UNQNAME=cdb1 >export ORACLE_BASE=/u01/app/oracle >export ORACLE_HOME=$ORACLE_BASE/product/12.1.0.2/db_1 >export ORACLE_SID=cdb1 >export PATH=/usr/sbin:$ORACLE_HOME/bin:$PATH >export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib >export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib >EOF

     

    Installing Oracle Database 12c on CentOS 7:

    Start Oracle Database 12c installation.

    [oracle@dbserver ~]$ cd /soft/12c/database [oracle@dbserver database]$ chmod u+x runInstaller [oracle@dbserver database]$ chmod u+x install/.oui [oracle@dbserver database]$ ./runInstaller

    oracle-12c-security-updates-01

    Uncheck I wish to receive security updates via My Oracle Support. Click on Next.

    oracle-12c-software-updates-01

    Click on Next.

    oracle-12c-install-option-01

    Select Install database software only. Click on Next.

    oracle-12c-grid-install-option-01

    Select Single instance database installation. Click on Next.

    oracle-12c-language-01

    Add your required languages. Click on Next.

    oracle-12c-database-edition-01

    Select Enterprise Edition. Click on Next.

    oracle-12c-install-location-01

    Installer automatically selects installation directories, based on ORACLE_BASE and ORACLE_HOME environment variables. Click on Next.

    oracle-12c-inventory-01

    Click on Next.

    oracle-12c-OS-groups-01

    Click on Next.

    oracle-12c-summary-01

    Click on Install.

    oracle-12c-database-install-01oracle-12c-config-scripts-01

    Login as root user on our CentOS 7 server and execute both scripts.

    oracle-12c-database-install-02

    Installation of Oracle Database 12c on CentOS 7 has been completed. Be noted that database services won’t start automatically. We have to either write a bash script or Install Oracle Grid Infrastructure 12c as Stand Alone Server for this purpose.

    No comments:

    Post a comment