Home Linux Articles Log In Sign Up
Home / Articles / Database / oracle-rac / 12c / oracle-rac-12c-r2-gui-install

Oracle RAC 12c Install on Linux 7

Table of Contents

  • System Setup
  • Prerequisites Configuration
  • Create Oracle User & Groups
  • Setup Oracle User Environment
  • Setup ASM Disks
  • Prepare Oracle RAC Installer
  • Install Oracle RAC Software
  • Install Oracle Database Software
  • Create Oracle Database
  • Check Oracle RAC & Database Status

    • System Setup

    • System Configuration
      • Number of VMs2
      VM EnvironmentOracle VirtualBox
      OS VersionRHEL 7.6
      vCPU1
      RAM6 GB
      SWAP4 GB
      /u0130 GB
      Share Disks5 x 10 GB
      Primary Networkenp0s3 : 192.168.50.0/24
      Cluster Interconnectenp0s8 : 192.168.10.0/24
      Grid Infrastructure Packagelinuxx64_12201_grid_home.zip
      Oracle Database Packagelinuxx64_12201_database.zip
    • DNS Setup

      • DNS Records: 192.168.50.141 rac1.linuxtechspace.com 192.168.50.142 rac2.linuxtechspace.com 192.168.10.20 rac1-priv.linuxtechspace.com 192.168.10.21 rac2-priv.linuxtechspace.com 192.168.50.144 rac123-scan.linuxtechspace.com 192.168.50.145 rac123-scan.linuxtechspace.com 192.168.50.146 rac123-scan.linuxtechspace.com 192.168.50.147 rac1-vip.linuxtechspace.com 192.168.50.148 rac2-vip.linuxtechspace.com

    Prerequisites Configuration

    • Open a SSH terminal window and login to first node as root user or user with root sudo privileges
    • Prepare for Required Packages Install
      • # vi prereq_rpms binutils compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++ libstdc++-devel libaio libaio-devel libXext libXtst libX11 libXau libxcb libXi make sysstat unixODBC unixODBC-devel zlib-devel compat-libcap1 nfs-utils
    • Install the RPMs
      • # yum -y install $(cat prereq_rpms)
    • Disable Firewall
      • # systemctl stop firewalld # systemctl disable firewalld Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service. Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
    • Disable SELINUX
      • # vim /etc/sysconfig/selinux SELINUX=disabled
    • Disable SELINUX at current runtime
      • # setenforce 0 setenforce: SELinux is disabled
    • SYSCTL Parameters
      • # vi /etc/sysctl.d/99-oracle.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500
      Reload the configuration file to reflect changes
      # sysctl -p /etc/sysctl.d/99-oracle.conf fs.file-max = 6815744 kernel.sem = 250 32000 100 128 kernel.shmmni = 4096 kernel.shmall = 1073741824 kernel.shmmax = 4398046511104 kernel.panic_on_oops = 1 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 net.ipv4.conf.all.rp_filter = 2 net.ipv4.conf.default.rp_filter = 2 fs.aio-max-nr = 1048576 net.ipv4.ip_local_port_range = 9000 65500
    • LIMITS Parameter
      • # vi /etc/security/limits.d/ora12crac.conf oracle soft nofile 1024 oracle hard nofile 65536 oracle soft nproc 16384 oracle hard nproc 16384 oracle soft stack 10240 oracle hard stack 32768 oracle hard memlock 134217728 oracle soft memlock 134217728
    • Add /dev/shm mount point entry in /etc/fstab file
      • # vi /etc/fstab tmpfs /dev/shm tmpfs defaults,size=2G 0 0

    Create Oracle User & Groups

    • Create oracle user and groups
      • groupadd -g 54321 oinstall groupadd -g 54322 dba groupadd -g 54323 oper groupadd -g 54324 backupdba groupadd -g 54325 dgdba groupadd -g 54326 kmdba groupadd -g 54327 asmdba groupadd -g 54328 asmoper groupadd -g 54329 asmadmin groupadd -g 54330 racdba useradd -u 54321 -g oinstall -G dba,oper,backupdba,dgdba,kmdba,asmdba,asmoper,asmadmin,racdba oracle
    • Set password for oracle user
      • # passwd oracle Changing password for user oracle. New password: Retype new password: passwd: all authentication tokens updated successfully.

    Setup Oracle User Environment

    • Setup oracle user profile
      • # vi /home/oracle/.bash_profile # Oracle Settings export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=rac11.linuxtechspace.com export ORACLE_UNQNAME=CDBRAC export ORACLE_BASE=/u01/app/oracle export GRID_HOME=/u01/app/12.2.0.1/grid export DB_HOME=$ORACLE_BASE/product/12.2.0.1/db_1 export ORACLE_HOME=$DB_HOME export ORACLE_SID=cdbrac1 export ORACLE_TERM=xterm export BASE_PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$BASE_PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib alias grid_env='. /home/oracle/grid_env' alias db_env='. /home/oracle/db_env'
      Modify following two parameters on other cluster nodes.
      export ORACLE_SID=cdbrac2 export ORACLE_HOSTNAME=rac12.linuxtechspace.com
    • Setup Oracle Grid environment
      • # vi /home/oracle/grid_env export ORACLE_SID=+ASM1 export ORACLE_HOME=$GRID_HOME export PATH=$ORACLE_HOME/bin:$BASE_PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
    • Setup Oracle Database environment
      • # vi /home/oracle/db_env export ORACLE_SID=cdbrac1 export ORACLE_HOME=$DB_HOME export PATH=$ORACLE_HOME/bin:$BASE_PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
      Modify following SID parameters on other cluster nodes.
      export ORACLE_SID=cdbrac2

    Setup ASM Disks

    • Create partition on ASM disks
      • # bparted /dev/sdc mklabel gpt --script # parted /dev/sdc mkpart primary 0% 100% --script # parted /dev/sdd mklabel gpt --script # parted /dev/sdd mkpart primary 0% 100% --script # parted /dev/sde mklabel gpt --script # parted /dev/sde mkpart primary 0% 100% --script # parted /dev/sdf mklabel gpt --script # parted /dev/sdf mkpart primary 0% 100% --script # parted /dev/sdg mklabel gpt --script # parted /dev/sdg mkpart primary 0% 100% --script
    • Add the following parameter to file /etc/scsi_id.config
      • # vi /etc/scsi_id.config options=-g
    • View the SCSI id of all four disks
      • # /usr/lib/udev/scsi_id -g -u -d /dev/sdc1 1ATA_VBOX_HARDDISK_VB189c7a69-689f61b0 # /usr/lib/udev/scsi_id -g -u -d /dev/sdd1 1ATA_VBOX_HARDDISK_VBc4ae174e-fc756d12 # /usr/lib/udev/scsi_id -g -u -d /dev/sde1 1ATA_VBOX_HARDDISK_VBa4e03079-ae751cbd # /usr/lib/udev/scsi_id -g -u -d /dev/sdf1 1ATA_VBOX_HARDDISK_VBf00747dc-10252f06 # /usr/lib/udev/scsi_id -g -u -d /dev/sdg1 1ATA_VBOX_HARDDISK_VB0749872e-1edeb12b #
    • Edit the file /etc/udev/rules.d/99-oracle-asmdevices.rules and add following contents. Replace the SCSI ID with the value generated in previous command
      • # vi /etc/udev/rules.d/99-oracle-asmdevices.rules KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB189c7a69-689f61b0", SYMLINK+="oracleasm/asm-disk1", OWNER="oracle", GROUP="dba", MODE="0660" KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBc4ae174e-fc756d12", SYMLINK+="oracleasm/asm-disk2", OWNER="oracle", GROUP="dba", MODE="0660" KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBa4e03079-ae751cbd", SYMLINK+="oracleasm/asm-disk3", OWNER="oracle", GROUP="dba", MODE="0660" KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VBf00747dc-10252f06", SYMLINK+="oracleasm/asm-disk4", OWNER="oracle", GROUP="dba", MODE="0660" KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/usr/lib/udev/scsi_id -g -u -d /dev/$parent", RESULT=="1ATA_VBOX_HARDDISK_VB0749872e-1edeb12b", SYMLINK+="oracleasm/asm-disk5", OWNER="oracle", GROUP="dba", MODE="0660"
    • Run partprobe command to reflect the disk changes
      • # /sbin/partprobe /dev/sdc1 # /sbin/partprobe /dev/sdd1 # /sbin/partprobe /dev/sde1 # /sbin/partprobe /dev/sdf1 # /sbin/partprobe /dev/sdg1
    • Run partprobe command on remaining cluster nodes to reflect the disk changes
      • # /sbin/partprobe /dev/sdc # /sbin/partprobe /dev/sdd # /sbin/partprobe /dev/sde # /sbin/partprobe /dev/sdf # /sbin/partprobe /dev/sdg
    • Run following command to validate rules are working
      • # /sbin/udevadm test /block/sdb/sdc1 # /sbin/udevadm test /block/sdb/sdd1 # /sbin/udevadm test /block/sdb/sde1 # /sbin/udevadm test /block/sdb/sdf1 # /sbin/udevadm test /block/sdb/sdg1
    • Reload the UDEV rules
      • # /sbin/udevadm control --reload-rules
    • Check the disks configured are visible and with correct ownership
      • # ls -al /dev/oracleasm/* lrwxrwxrwx 1 root root 7 Jun 6 20:26 /dev/oracleasm/asm-disk1 -> ../sdc1 lrwxrwxrwx 1 root root 7 Jun 6 20:21 /dev/oracleasm/asm-disk2 -> ../sdd1 lrwxrwxrwx 1 root root 7 Jun 6 20:26 /dev/oracleasm/asm-disk3 -> ../sde1 lrwxrwxrwx 1 root root 7 Jun 6 20:26 /dev/oracleasm/asm-disk4 -> ../sdf1 lrwxrwxrwx 1 root root 7 Jul 10 22:40 /dev/oracleasm/asm-disk5 -> ../sdg1
      # ls -al /dev/sd*1 brw-rw---- 1 root disk 8, 1 Jun 6 18:47 /dev/sda1 brw-rw---- 1 oracle dba 8, 33 Jun 6 20:28 /dev/sdc1 brw-rw---- 1 oracle dba 8, 49 Jun 6 20:28 /dev/sdd1 brw-rw---- 1 oracle dba 8, 65 Jun 6 20:29 /dev/sde1 brw-rw---- 1 oracle dba 8, 81 Jun 6 20:29 /dev/sdf1 brw-rw---- 1 oracle dba 8, 97 Jul 10 22:41 /dev/sdg1

    Prepare Oracle RAC Installer

    • Create following directories for Oracle RAC and DB Install

      • Perform this step on first cluster node only.

      # mkdir -p /u01/app/12.2.0.1/grid # chown -R oracle:oinstall /u01 # chmod -R 775 /u01/
    • Download the Oracle Grid Installer from Official Oracle website. Copy the installer to /software directory

      • Perform this step on first cluster node only.

      # cd /u01/app/12.2.0.1/grid # unzip -q $SOFTWARE_LOCATION/linuxx64_12201_grid_home.zip # chown -R oracle:oinstall /u01
    • Install qdisk RPM

      • Perform this step on first cluster node only.

      # rpm -ivh /u01/app/12.2.0.1/grid/cv/rpm/cvuqdisk-1.0.10-1.rpm Preparing... ################################# [100%] Using default group oinstall to install package Updating / installing... 1:cvuqdisk-1.0.10-1 ################################# [100%]
    • Copy this RPM on all remaining cluster nodes and Install it.

    Install Oracle RAC Software

      Note: Perform this step on first cluster node only.

    • Login to the GUI window as oracle user


    • Open a terminal window and run the Oracle Grid Installer


    • Select the option "Configure Oracle Grid Infrastructure for a New Cluster"


    • Select Option "Configure an Oracle Standalone Cluster"


    • Enter the Cluster Name, SCAN Name and SCAN Port information


    • Enter all the RAC Node(s) Information

      • First node will be auto selected. Click on "Add" button to add other cluster nodes.


      Enter Hostname and Virtual Hostname for each cluster Node


    • Test Passwordless SSH connectivity between all Cluster Nodes

      • Click on "SSH Connectivity" button, enter oracle user credentials and click on "Test" button


      Wait for the confirmation that passwordless SSH connectivity is successful


    • Verify that Network Subnet Details


    • Select option "Configure ASM using block devices"


    • Select "No" for GIMR option


    • Select the ASM devices

      • Select Redundancy option "External"
      Click on on "Change Discovery Path" button and enter "/dev/oracleasm/*" and click OK button


    • Verify the details and click on "Next" button


    • "Select option "Use same password for these accounts"


    • Select option "Do not use IPMI"


    • Unselect the "Register" option


    • Enter the group details as shown below


    • Verify the Oracle Base information


    • Verify the "Oracle Inventory" information

      • Uncheck the Oracle support option


    • Unselect the automatic script execution option


    • Wait for Pre-Check to complete


    • Review the Pre-Check results. Click on the "Ignore Alerts" option and click on Next button

      • Following pre-check failures are fine and we can ignore the alerts since we are setting up a test environment.


    • Click on "Yes" button and then "Next" button


    • Verify the Install summary. Then click on the "Install" button to start Grid Infrastructure installation.


    • Monitor the Install process and wait for the prompt to execute the root scripts


    • Open a new SSH session and login as root user
    • Execute both the root scripts on first cluster node. Once these are completed successfully then only proceed to remaining cluster nodes.
    • Execute "orainstRoot.sh" script
      • # /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.
    • Execute "root.sh" script
      • # /u01/app/12.2.0.1/grid/root.sh Performing root user operation. The following environment variables are set as: ORACLE_OWNER= oracle ORACLE_HOME= /u01/app/12.2.0.1/grid Enter the full pathname of the local bin directory: [/usr/local/bin]: 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. Relinking oracle with rac_on option Using configuration parameter file: /u01/app/12.2.0.1/grid/crs/install/crsconfig_params The log of current session can be found at: /u01/app/oracle/crsdata/rac1/crsconfig/rootcrs_rac1_2021-07-09_08-02-45PM.log 2021/07/09 20:02:53 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'. 2021/07/09 20:02:53 CLSRSC-4001: Installing Oracle Trace File Analyzer (TFA) Collector. 2021/07/09 20:03:33 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector. 2021/07/09 20:03:33 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'. 2021/07/09 20:03:40 CLSRSC-363: User ignored prerequisites during installation 2021/07/09 20:03:40 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'. 2021/07/09 20:03:43 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'. 2021/07/09 20:03:46 CLSRSC-594: Executing installation step 5 of 19: 'SaveParamFile'. 2021/07/09 20:03:58 CLSRSC-594: Executing installation step 6 of 19: 'SetupOSD'. 2021/07/09 20:03:59 CLSRSC-594: Executing installation step 7 of 19: 'CheckCRSConfig'. 2021/07/09 20:03:59 CLSRSC-594: Executing installation step 8 of 19: 'SetupLocalGPNP'. 2021/07/09 20:04:42 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'. 2021/07/09 20:04:51 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'. 2021/07/09 20:04:51 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'. 2021/07/09 20:04:57 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'. 2021/07/09 20:05:13 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service' 2021/07/09 20:05:35 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'. 2021/07/09 20:05:41 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'. CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1' CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed CRS-4133: Oracle High Availability Services has been stopped. CRS-4123: Oracle High Availability Services has been started. 2021/07/09 20:06:03 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'. 2021/07/09 20:06:09 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'. CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1' CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed CRS-4133: Oracle High Availability Services has been stopped. CRS-4123: Oracle High Availability Services has been started. CRS-2672: Attempting to start 'ora.evmd' on 'rac1' CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1' CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeeded CRS-2676: Start of 'ora.evmd' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1' CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1' CRS-2672: Attempting to start 'ora.gipcd' on 'rac1' CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'rac1' CRS-2672: Attempting to start 'ora.diskmon' on 'rac1' CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded Disk groups created successfully. Check /u01/app/oracle/cfgtoollogs/asmca/asmca-210709PM080650.log for details. 2021/07/09 20:07:38 CLSRSC-482: Running command: '/u01/app/12.2.0.1/grid/bin/ocrconfig -upgrade oracle oinstall' CRS-2672: Attempting to start 'ora.crf' on 'rac1' CRS-2672: Attempting to start 'ora.storage' on 'rac1' CRS-2676: Start of 'ora.storage' on 'rac1' succeeded CRS-2676: Start of 'ora.crf' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'rac1' CRS-2676: Start of 'ora.crsd' on 'rac1' succeeded CRS-4256: Updating the profile Successful addition of voting disk 447153bcabe24f88bf7d788e68e2f56a. Successfully replaced voting disk group with +DATA. CRS-4256: Updating the profile CRS-4266: Voting file(s) successfully replaced ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE 447153bcabe24f88bf7d788e68e2f56a (/dev/oracleasm/asm-disk3) [DATA] Located 1 voting disk(s). CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'rac1' CRS-2673: Attempting to stop 'ora.crsd' on 'rac1' CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.storage' on 'rac1' CRS-2673: Attempting to stop 'ora.crf' on 'rac1' CRS-2673: Attempting to stop 'ora.gpnpd' on 'rac1' CRS-2673: Attempting to stop 'ora.mdnsd' on 'rac1' CRS-2677: Stop of 'ora.crf' on 'rac1' succeeded CRS-2677: Stop of 'ora.gpnpd' on 'rac1' succeeded CRS-2677: Stop of 'ora.storage' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.asm' on 'rac1' CRS-2677: Stop of 'ora.mdnsd' on 'rac1' succeeded CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1' CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1' CRS-2673: Attempting to stop 'ora.evmd' on 'rac1' CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.cssd' on 'rac1' CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded CRS-2673: Attempting to stop 'ora.gipcd' on 'rac1' CRS-2677: Stop of 'ora.gipcd' on 'rac1' succeeded CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'rac1' has completed CRS-4133: Oracle High Availability Services has been stopped. 2021/07/09 20:08:59 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'. CRS-4123: Starting Oracle High Availability Services-managed resources CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1' CRS-2672: Attempting to start 'ora.evmd' on 'rac1' CRS-2676: Start of 'ora.evmd' on 'rac1' succeeded CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1' CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.gipcd' on 'rac1' CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1' CRS-2676: Start of 'ora.cssdmonitor' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.cssd' on 'rac1' CRS-2672: Attempting to start 'ora.diskmon' on 'rac1' CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'rac1' CRS-2672: Attempting to start 'ora.ctssd' on 'rac1' CRS-2676: Start of 'ora.ctssd' on 'rac1' succeeded CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.asm' on 'rac1' CRS-2676: Start of 'ora.asm' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.storage' on 'rac1' CRS-2676: Start of 'ora.storage' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.crf' on 'rac1' CRS-2676: Start of 'ora.crf' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.crsd' on 'rac1' CRS-2676: Start of 'ora.crsd' on 'rac1' succeeded CRS-6023: Starting Oracle Cluster Ready Services-managed resources CRS-6017: Processing resource auto-start for servers: rac1 CRS-6016: Resource auto-start has completed for server rac1 CRS-6024: Completed start of Oracle Cluster Ready Services-managed resources CRS-4123: Oracle High Availability Services has been started. 2021/07/09 20:11:00 CLSRSC-343: Successfully started Oracle Clusterware stack 2021/07/09 20:11:00 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'. CRS-2672: Attempting to start 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac1' CRS-2676: Start of 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.asm' on 'rac1' CRS-2676: Start of 'ora.asm' on 'rac1' succeeded CRS-2672: Attempting to start 'ora.DATA.dg' on 'rac1' CRS-2676: Start of 'ora.DATA.dg' on 'rac1' succeeded 2021/07/09 20:27:25 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'. 2021/07/09 20:33:31 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
    • Return to the GUI Install window and click on the "OK" button.


    • Wait for the Install top complete


    Install Oracle Database Software

    • Extract Oracle Database Installer zip file under "/u01/app/12.2.0.1" directory
    • Create following directories for Oracle DB Install

      • Perform this step on first cluster node only.

      # mkdir -p /u01/app/oracle/product/12.2.0.1/db_1 # chown -R oracle:oinstall /u01/app/oracle # chmod -R 775 /u01/

      Note: Perform this step on first cluster node only.

    • Login to the GUI window as oracle user
    • Open a terminal window and run the Oracle Database Installer


    • Unselect the Oracle Support option


    • Select option "Install database software only"


    • Select option "Oracle Real Application Cluster database installation"


    • Verify that all cluster nodes are selected and then click on Next button


    • Select option "Enterprise Edition"


    • Verify that Database base and Software location are correct


    • Select "dba" option for all options


    • Wait for the pre-checks to complete

      • Click on "Ignore Alerts" option to ignore following failures as this is a test setup. Click on Next button and then click on "Yes" to confirm it.


    • Review the Install information and click on "Install" button to start database software install.


    • Wait for the Install to complete


    • Click on "Close" button to end the installer.


    Create Oracle Database

      Note: Perform this step on first cluster node only.

    • Login to the GUI window as oracle user
    • Run Oracle Database Configuration Assistant utility
      • # /u01/app/oracle/product/12.2.0.1/db_1/bin/dbca
    • Select option "Create a database"


    • Enter Database configuration Details


    • Wait for pre-checks to complete

      • Click on "Ignore Alerts" checkbox to ignore the swap size warnings. Then Click Next and confirm the selection.


    • Review the Database Install information. Then click on "Finish" button


    • Wait for the installer to complete


    • Click on "Close" button to close the Installer


    Check Oracle RAC & Database Statusk

    • Open SSH terminal
    • Check CRS and Database status
      • # /u01/app/12.2.0.1/grid/bin/crsctl status res -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.ASMNET1LSNR_ASM.lsnr ONLINE ONLINE rac1 STABLE ONLINE ONLINE rac2 STABLE ora.DATA.dg ONLINE ONLINE rac1 STABLE ONLINE ONLINE rac2 STABLE ora.LISTENER.lsnr ONLINE ONLINE rac1 STABLE ONLINE ONLINE rac2 STABLE ora.chad ONLINE ONLINE rac1 STABLE ONLINE ONLINE rac2 STABLE ora.net1.network ONLINE ONLINE rac1 STABLE ONLINE ONLINE rac2 STABLE ora.ons ONLINE ONLINE rac1 STABLE ONLINE ONLINE rac2 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE rac1 STABLE ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE rac2 STABLE ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE rac2 STABLE ora.MGMTLSNR 1 ONLINE ONLINE rac2 169.254.189.86 192.1 68.10.21,STABLE ora.asm 1 ONLINE ONLINE rac1 Started,STABLE 2 ONLINE ONLINE rac2 Started,STABLE 3 OFFLINE OFFLINE STABLE ora.cdbrac.db 1 ONLINE ONLINE rac1 Open,HOME=/u01/app/o racle/product/12.2.0 .1/db_1,STABLE 2 ONLINE ONLINE rac2 Open,HOME=/u01/app/o racle/product/12.2.0 .1/db_1,STABLE ora.cvu 1 ONLINE ONLINE rac2 STABLE ora.mgmtdb 1 ONLINE ONLINE rac2 Open,STABLE ora.qosmserver 1 ONLINE ONLINE rac1 STABLE ora.rac1.vip 1 ONLINE ONLINE rac1 STABLE ora.rac2.vip 1 ONLINE ONLINE rac2 STABLE ora.scan1.vip 1 ONLINE ONLINE rac1 STABLE ora.scan2.vip 1 ONLINE ONLINE rac2 STABLE ora.scan3.vip 1 ONLINE ONLINE rac2 STABLE --------------------------------------------------------------------------------

    Linux Tech Space © 2020