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
- 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.
