More

    Oracle Database 19c ASM installation-Step-By-Step process

    With the advancement of various versions and releases by Oracle for as part of RDBMS, Oracle has released recent database version 19c on 13th Feb,2019. It offers market-leading performance, scalability and security both on-premise and in the cloud. As this is a Long Term Release of the Oracle database 12c and 18c family of products, it provides the highest level of release stability and longest time frame for support and bug fixes.

    I tried to collect and put together all the commands required for ASM setup for Oracle 19c environment with all its pre-requisites and installation steps.

    • RHEL 7.5+ is needed for Oracle 19c
    • 2. Following rpm packages should be installed in Linux server.

    bc
    binutils
    elfutils-libelf
    elfutils-libelf-devel
    fontconfig-devel
    glibc
    glibc-devel
    ksh
    libaio
    libaio-devel
    libXrender
    libX11
    libXau
    libXi
    libXtst
    libgcc
    libnsl
    librdmacm
    libstdc++
    libstdc++-devel
    libxcb
    libibverbs
    make
    smartmontools
    sysstat

    • User and group creation using following scripts.

    [[email protected] ~]# groupadd oinstall

    [[email protected] ~]# groupadd asmadmin

    [[email protected] ~]# groupadd dba

    [[email protected] ~]# groupadd oper

    [[email protected] ~]# groupadd asmdba

    [[email protected] ~]# groupadd asmoper

    Grid/Oracle BASE,HOME

    ======================

    [[email protected] ~]# mkdir -p /oragrid/app/product/                     

    [[email protected] ~]# mkdir -p /oragrid/app/product/12.2.0.1/grid 

    [[email protected] ~]# chown -R grid:oinstall /oragrid

    [[email protected] ~]# chmod -R 775 /oragrid

    [[email protected] ~]# mkdir -p /oracle/app/oracle/                         

    [[email protected] ~]# mkdir -p /oracle/app/oracle/product/19.3.0/dbhome_1

    [[email protected] ~]# chown -R oracle:oinstall /oracle

    [[email protected] ~]# chmod -R 775 /oracle

    [[email protected] ~]# useradd -g oinstall -G dba,asmadmin,asmdba,asmoper -d /home/grid -m grid

    [[email protected] ~]#passwd grid

    [[email protected] ~]#useradd -g oinstall -G dba,oper,asmdba -d /home/oracle -m oracle

    [[email protected] ~]#passwd oracle

    • Disable set Linux parameter using following and set all other parameters in linux

     [[email protected] ~]# vi /etc/sysconfig/selinux

    [[email protected] ~]# vi /etc/sysctl.conf

    kernel.shmmax = 68719476736

    kernel.shmall = 4294967296

    kernel.shmmni = 4096
    kernel.sem = 250 32000 100 128
    fs.file-max = 6815744
    fs.aio-max-nr = 1048576
    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 = 1048576

    [[email protected] ~]# /sbin/sysctl -p

    [[email protected] ~]#cat /etc/security/limits.conf

    • Unzip following grid binary zip file

    LINUX.X64_193000_grid_home.zip

    • Install following oracleasm rpm package for oracleasm disk creation.

    [[email protected] ~]# rpm -ivh oracleasm-support-2.1.11-2.el7.x86_64.rpm

    [[email protected] ~]# rpm -ivh oracleasmlib-2.0.12-1.el7.x86_64.rpm

    • Export LUN space and create oracleasm disk using following commands for DATA, REDO, VOTE and ARCH diskgroups.

    [[email protected] ~]# oracleasm createdisk DATA01 /dev/mapper/sda1

    [[email protected] ~]# oracleasm createdisk ARCH01 /dev/mapper/sdb1

    [[email protected] ~]# oracleasm createdisk REDO01 /dev/mapper/sdc1

    [[email protected] ~]# oracleasm createdisk REDO02 /dev/mapper/sdd1

    [[email protected] ~]# oracleasm createdisk VOTE01 /dev/mapper/sde1

    • Scan all the disks using following command.

    [[email protected] ~]# oracleasm scandisks

    • List all the disks to check whether created disks are showing.

    [[email protected] ~]# oracleasm listdisks

    1. Run the following script available in the unzipped folder in step 5 from grid user. There follow all the steps mentioned in the screenshot.

    [[email protected] ~]# su – gird

    [[email protected] ~]# ./gridSetup.sh

    Your disk paths and their name might be different.

    Click Ok and run the above mentioned 2 scripts using root user which completes the installation process.

    • Run the following command using root user to check status of ASM.

    [[email protected] ~]#  cd /oragrid/app/product/19.3.0/grid/bin

    [[email protected] ~]#  ./crsctl stat res -t -init

    Note: Please check my post on Database binary installation to complete installation process.

    Oracle Database 19c ASM installation-Step-By-Step process

    Recent Articles

    spot_img

    Related Stories

    Leave A Reply

    Please enter your comment!
    Please enter your name here

    Stay on op - Ge the daily news in your inbox