ORACLE 19C-RAC GRID INSTALLATION
Environment Details:
No. of servers: 2 (node 1 ,node2).
Version : Oracle linux 7.9
Ssh and network configuration complted on both the node.
Follow the steps for configuring Network between two node RAC from below mentioned link:
https://www.linkedin.com/posts/umesh-shinde-989187209_oracle-linux-installation-activity-
7141727733537046528-OGsK?utm_source=share&utm_medium=member_desktop
--------------------------------------------------------------
1. Prerequisites:
Connect to OEL 7.9 server via putty and install the below packages
yum -y install oracleasm*
yum -y install kmod-oracleasm*
Add below OS groups
echo "password" | passwd --stdin grid
echo "password" | passwd --stdin oracle
groupadd -g 54327 asmdba
groupadd -g 54328 asmoper
groupadd -g 54329 asmadmin
usermod -u grid -g oinstall -G dba,asmdba,asmoper,asmadmin,racdba grid
usermod -u oracle -g oinstall -G dba,asmdba,asmoper,asmadmin,racdba grid
2. Configure Oracle ASM
oracleasm configure -i
Load / initiate Oracle ASM
oracleasm init
3. Create new virtual disk for ASM.
Click on virtual manager > create> select VHD> preallocate full size> give 20 gb size for asm data
>finish.
Then click on disk and select property.
Make type =shared
Again, create one more disk for OCR data.
And follow same thing.
Run below commands to create partitions on newly added disk:
fdisk -l | grep /dev/sd
printf "o\nn\np\n1\n\n\nw\n" | sudo fdisk /dev/sdb
printf "o\nn\np\n1\n\n\nw\n" | sudo fdisk /dev/sdc
4. Create separate ASM Disk for each
partition
oracleasm createdisk ASMDATA1 /dev/sdb1
oracleasm createdisk ASMOCR /dev/sdc1
oracleasm scandisks
oracleasm listdisks
To check asm disks
ls -lrt /dev/oracleasm/disks
configuaring swap using /swap mount point.
umount /swap
vi /etc/fstab
Edit swap filesystem.
/dev/mapper/ol-swap /swap swap defaults 12
Now run below commands.
mkswap -L swap /dev/mapper/ol-swap
swapon -a
swapon -s
5. Install Grid Software
Edit Grid user Bash_Profile but take .bash_profile backup before editing
it
su – grid
vi .bash_profile
Node 1:
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_SID=+ASM1; export ORACLE_SID
ORACLE_BASE=/grid/app/grid1; export ORACLE_BASE
ORACLE_HOME=/grid/app/grid/product/19.0.0/grid_home; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
JAVA_HOME=/usr/bin/java; export JAVA_HOME
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/local/bin
export PATH
umask 022
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
Node2:
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
ORACLE_SID=+ASM2; export ORACLE_SID
ORACLE_BASE=/grid/app/grid1; export ORACLE_BASE
ORACLE_HOME=/grid/app/grid/product/19.0.0/grid_home; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM
JAVA_HOME=/usr/bin/java; export JAVA_HOME
TNS_ADMIN=$ORACLE_HOME/network/admin; export TNS_ADMIN
PATH=.:${JAVA_HOME}/bin:${PATH}:$HOME/bin:$ORACLE_HOME/bin
PATH=${PATH}:/usr/bin:/bin:/usr/local/bin
export PATH
umask 022
PATH=$PATH:$HOME/.local/bin:$HOME/bin
export PATH
Create the Directories for Oracle Grid installation
mkdir -p /grid/app/grid
mkdir -p /grid/app/grid/product/19.0.0/grid_home
chown -R grid:asmadmin /grid/app/grid
mkdir -p /grid/app/grid1
chown -R grid:asmadmin /grid/app/grid1
mkdir -p /grid/app/oraInventory
Copy the grid software under grid home and unzip it
Unzip grid zip file using grid user
Run below command for CVU utility on below location/
/grid/app/grid/product/19.0.0/grid_home/cv/rpm
Using root user
rpm -Uvh cvuqdisk*
scp ./cvuqdisk* root@node2:/tmp
on node 2 run below command from /tmp location
rpm -Uvh cvuqdisk*
6. Pre-check for RAC Setup
Pre-check for CRS installation using Cluvfy
./runcluvfy.sh stage -pre crsinst -n node1,node2 -verbose
./sshUserSetup.sh -user oracle -hosts "node1 node2" -noPromptPassphrase -confirm -advanced
./runcluvfy.sh stage -pre crsinst -n node1,node2 -verbose -fixup
Start the gridSetup.sh which will install grid software.
Set display on your environment.
By root user:
Export display=:0.0
Xhost +
Then by grid user
Export display=:0.0
Xhost +
Cd $ORACLE_HOME
7. Start Installation
./gridSetup.sh
Select the Configure Oracle Grid Infrastructure for a New Cluster option, then
click the Next button
Accept the Configure an Oracle Standalone Cluster option by clicking
the Next button.
Enter the cluster name my-cluster, SCAN name db-scan and SCAN port 1521,
then click the Next button.
On the “Cluster Node Information” screen, click the Add button.
Enter the details of the second node in the cluster, then click the OK button.
Click the SSH connectivity button and enter the password for the oracle
user. Click the Setup button to configure SSH connectivity, and the Test
button to test it once it is complete. Once the test is complete, click the
Next button.
Check the public and private networks are specified correctly as ASM &
Private. Click the Next button.
Accept the Use Oracle Flex ASM for Storage option by clicking the Next
button.
Select the No option, as we don’t want to create a separate disk group for
the GIMR in this case. Click the Next button.
First Browse the path /dev/oracleasm/disks* using change discovery path
/dev/oracleasm/disks*
Enter the credentials and click the Next button.
Accept the default IPMI option by clicking the Next button.
Deselect EM. Click the Next button
Set the groups to oinstall and click the Next button. Accept the warnings
on the subsequent dialog by clicking the Yes button.
1. Asmadmin
2. Asmdba
3. asmdba
Click the Next button
Select base location to grid1 not grid.
Accept the default inventory directory by click the Next button
Click the Next button.
Check the Ignore All checkbox and click the Next button.
Double check and click the Install button
When prompted, run the configuration scripts on each node one by one
Root script ouput:
8. Configure ASM Diskgroups
The grid installer allows you to only create one diskgroup (CRS). We
need to start the asmca utility in order to create DATA and FRA
diskgroup which are required for database installation. Click on Create
================ END ===================
