{"id":3842,"date":"2018-04-23T10:03:17","date_gmt":"2018-04-23T01:03:17","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3842"},"modified":"2023-04-14T16:15:29","modified_gmt":"2023-04-14T07:15:29","slug":"oracle-12c-rac-%ea%b5%ac%ec%b6%95-guide-linux-7-rac-2-node","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3842","title":{"rendered":"Oracle 12c RAC \uad6c\ucd95 Guide (LINUX 7 \/ RAC 2 Node)"},"content":{"rendered":"
    \n
  1. \n
    Requirements For Installing Oracle Linux x86-64
    \n<\/strong><\/span><\/div>\n

    This document describes the installation of Oracle 12c r1 database on Red-Hat Enterprise Linux\/Oracle Enterprise Linux 7 (x86).
    \n<\/span><\/p>\n

      \n
    1. \n
      Hardware Requirements
      \n<\/strong><\/span><\/div>\n
        \n
      1. \n
        Physical Memory
        \n<\/strong><\/span><\/div>\n

        At least 4GB of physical RAM is required. To determine the physical RAM size, enter the following command
        \n<\/span><\/p>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

        \n\n\n<\/colgroup>\n\n\n
        \n

        # grep MemTotal \/proc\/meminfo<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

          \n
        1. \n
          Swap Space
          \n<\/strong><\/span><\/div>\n

          The following table describes the relationship between installed RAM and the configured swap space requirement.
          \n<\/span><\/p>\n

          \n<\/li>\n<\/ol>\n

          \n\n\n\n<\/colgroup>\n\n\n\n\n
          \n

          RAM<\/strong><\/span><\/p>\n<\/td>\n

          		\n

          Swap Space<\/strong><\/span><\/p>\n<\/td>\n<\/tr>\n

          Between 4 GB and 16 GB<\/strong><\/span><\/td>\nEqual to the size of RAM<\/span><\/td>\n<\/tr>\n
          More than 16 GB<\/strong><\/span><\/td>\n16 GB<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

          To determine the size of the configured swap space, enter the following command
          \n<\/span><\/p>\n

          \n\n\n<\/colgroup>\n\n\n
          \n

          # grep MemTotal \/proc\/meminfo
          \n<\/span><\/p>\n

          # grep SwapTotal \/proc\/meminfo<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

            \n
          1. \n
            Disk space Requirement
            \n<\/strong><\/span><\/div>\n

            1 GB of disk space in the \/tmp directory
            \n<\/span><\/p>\n

            \u2022At least 8 GB of space for the Oracle Grid Infrastructure for a cluster home (Grid home). Oracle recommends that you allocate 100 GB to allow additional space for patches.
            \n<\/span><\/p>\n

            \u2022At least 12 GB of space for the Oracle base of the Oracle Grid Infrastructure installation owner (Grid user). The Oracle base includes Oracle Clusterware and Oracle ASM log files.
            \n<\/span><\/p>\n

            \u2022At least 10 GB of additional space in the Oracle base directory of the Grid Infrastructure owner for diagnostic collections generated by Trace File Analyzer (TFA) Collector.
            \n<\/span><\/p>\n

            \u2022For Linux x86-64 platforms, if you intend to install Oracle Database, then allocate 6.4 GB of disk space for the Oracle home (the location for the Oracle Database software binaries)
            \n<\/span><\/p>\n

            To determine the amount of free disk space on the system, enter the following command
            \n<\/span><\/p>\n<\/li>\n<\/ol>\n

            \n\n\n<\/colgroup>\n\n\n
            \n

            # df -h<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

              \n
            1. \n
              Kernel Requirements
              \n<\/strong><\/span><\/div>\n
                \n
              1. \n
                Version
                \n<\/strong><\/span><\/div>\n

                The system must be running the following kernel version (or a later version)
                \n<\/span><\/p>\n

                3.10.0-123.el7.x86_64 or later
                \n<\/strong><\/span><\/p>\n

                To determine whether the required kernel is installed, enter the following command:
                \n<\/span><\/p>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

                \n\n\n<\/colgroup>\n\n\n
                \n

                # uname \u2013r
                \n<\/span><\/p>\n

                # cat \/etc\/redhat-release<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                  \n
                1. \n
                  SELinux
                  \n<\/strong><\/span><\/div>\n

                  \uc544\ub798\uc758 \uba85\ub839\uc73c\ub85c \ud574\ub2f9 \uc124\uc815\ud30c\uc77c\uc744 \ud3b8\uc9d1\ud569\ub2c8\ub2e4.
                  \n<\/span><\/p>\n<\/li>\n<\/ol>\n

                  \n\n\n<\/colgroup>\n\n\n
                  \n

                  # vi \/etc\/selinux\/config<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                  \uc544\ub798\uc640 \uac19\uc774 SELINUX \uc124\uc815\uc744 disabled \ub85c \uc124\uc815\ud569\ub2c8\ub2e4.
                  \n<\/span><\/p>\n

                  \n\n\n<\/colgroup>\n\n\n
                  \n

                  SELINUX=disabled<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                    \n
                  1. \n
                    Installing required packages
                    \n<\/strong><\/span><\/div>\n

                    \uc544\ub798\uc758 \uba85\ub839\uc744 \uc774\uc6a9\ud558\uc5ec \uc624\ub77c\ud074 \uc124\uce58\uc2dc \ud544\uc694\ud55c OS \ud328\ud0a4\uc9c0\ub97c \uc124\uce58\ud569\ub2c8\ub2e4.
                    \n<\/span><\/p>\n<\/li>\n<\/ol>\n

                    \n\n\n<\/colgroup>\n\n\n
                    \n

                    # yum -y install binutils compat-libcap1 gcc gcc-c++ glibc glibc-devel
                    \n<\/span><\/p>\n

                    # yum -y install ksh libaio libaio-devel libgcc libstdc++
                    \n<\/span><\/p>\n

                    # yum -y install libstdc++-devel libXi libXtst make sysstat
                    \n<\/span><\/p>\n

                    # yum -y install unzip<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                      \n
                    1. \n
                      Set the kernel parameters
                      \n<\/strong><\/span><\/div>\n

                      \uc544\ub798\uc758 \uba85\ub839\uc73c\ub85c Kernel Parameter \uc124\uc815 \ud30c\uc77c\uc744 \ud3b8\uc9d1\ud569\ub2c8\ub2e4
                      \n<\/span><\/p>\n<\/li>\n<\/ol>\n

                      \n\n\n<\/colgroup>\n\n\n
                      \n

                      # vi \/etc\/sysctl.conf<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                      \uc544\ub798\uc758 \ub0b4\uc6a9\uc73c\ub85c \uc218\uc815\ud569\ub2c8\ub2e4.
                      \n<\/span><\/p>\n

                      \n\n\n<\/colgroup>\n\n\n
                      \n

                      kernel.shmall = 10523004
                      \n<\/span><\/p>\n

                      kernel.shmmax = 6465333657
                      \n<\/span><\/p>\n

                      kernel.shmmni = 4096
                      \n<\/span><\/p>\n

                      kernel.sem = 250 32000 100 128
                      \n<\/span><\/p>\n

                      fs.aio-max-nr = 1048576
                      \n<\/span><\/p>\n

                      fs.file-max = 6815744
                      \n<\/span><\/p>\n

                      net.ipv4.ip_local_port_range = 9000 65500
                      \n<\/span><\/p>\n

                      net.core.rmem_default = 262144
                      \n<\/span><\/p>\n

                      net.core.rmem_max = 4194304
                      \n<\/span><\/p>\n

                      net.core.wmem_default = 262144
                      \n<\/span><\/p>\n

                      net.core.wmem_max = 1048576<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                      \uc544\ub798\uc758 \uba85\ub839\uc744 \uc774\uc6a9\ud558\uc5ec \ubcc0\uacbd\ub41c Kernel Parameter \uc744 \uc801\uc6a9\ud569\ub2c8\ub2e4.
                      \n<\/span><\/p>\n

                      \n\n\n<\/colgroup>\n\n\n
                      \n

                      # sysctl -p<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                        \n
                      1. \n
                        Create Oracle user and groups
                        \n<\/strong><\/span><\/div>\n

                        \uc544\ub798\uc758 \uba85\ub839\uc744 \uc774\uc6a9\ud558\uc5ec \uc0ac\uc6a9\uc790 \uadf8\ub8f9\uacfc \uacc4\uc815\uc744 \uc0dd\uc131\ud569\ub2c8\ub2e4.
                        \n<\/span><\/p>\n<\/li>\n<\/ol>\n

                        \n\n\n<\/colgroup>\n\n\n
                        \n

                        # groupadd oinstall
                        \n<\/span><\/p>\n

                        # groupadd dba
                        \n<\/span><\/p>\n

                        # useradd -g oinstall -G dba oracle
                        \n<\/span><\/p>\n

                        # useradd -g oinstall -G dba grid
                        \n<\/span><\/p>\n

                        # passwd oracle
                        \n<\/span><\/p>\n

                        # passwd grid<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                          \n
                        1. \n
                          Create the required directories for Oracle\u00a0Base and change the ownership
                          \n<\/strong><\/span><\/div>\n

                          \uc544\ub798\uc758 \uba85\ub839\uc744 \uc774\uc6a9\ud558\uc5ec oracle \uc124\uce58 \ub514\ub809\ud1a0\ub9ac\ub97c \uc0dd\uc131\ud55c \ud6c4 \uad8c\ud55c\uc744 \ubd80\uc5ec\ud569\ub2c8\ub2e4.
                          \n<\/span><\/p>\n<\/li>\n<\/ol>\n

                          \n\n\n<\/colgroup>\n\n\n
                          \n

                          For example
                          \n<\/span><\/p>\n

                          # mkdir -p \/oracle
                          \n<\/span><\/p>\n

                          # chown -R oracle:oinstall \/oracle
                          \n<\/span><\/p>\n

                          # mkdir -p \/grid
                          \n<\/span><\/p>\n

                          # chown -R grid:oinstall \/grid<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                            \n
                          1. \n
                            Set the session limits for Oracle user
                            \n<\/strong><\/span><\/div>\n

                            Add the following lines to the \/etc\/security\/limits.conf file
                            \n<\/span><\/p>\n<\/li>\n<\/ol>\n

                            \n\n\n<\/colgroup>\n\n\n
                            \n

                            oracle soft nproc 2047
                            \n<\/span><\/p>\n

                            oracle hard nproc 16384
                            \n<\/span><\/p>\n

                            oracle soft nofile 1024
                            \n<\/span><\/p>\n

                            oracle hard nofile 65536<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                            Add the following line in the \/etc\/pam.d\/login file
                            \n<\/span><\/p>\n

                            \n\n\n<\/colgroup>\n\n\n
                            \n

                            session required pam_limits.so<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                            Add the following lines to the \/etc\/profile.
                            \n<\/span><\/p>\n

                            \n\n\n<\/colgroup>\n\n\n
                            \n

                            if [ $USER = “oracle” ]; then
                            \n<\/span><\/p>\n

                            ulimit -u 16384
                            \n<\/span><\/p>\n

                            ulimit -n 65536
                            \n<\/span><\/p>\n

                            fi<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                              \n
                            1. \n
                              Configure the Oracle user’s environment
                              \n<\/strong><\/span><\/div>\n

                              oracle \uc0ac\uc6a9\uc790\uc758 \ud658\uacbd \ubcc0\uc218\ub97c \ud3b8\uc9d1\ud569\ub2c8\ub2e4.
                              \n<\/span><\/p>\n<\/li>\n<\/ol>\n

                              \n\n\n<\/colgroup>\n\n\n
                              \n

                              # vi \/oracle\/.profile<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                              \uc544\ub798\uc758 \ub0b4\uc6a9\uc744 \uc785\ub825\ud569\ub2c8\ub2e4.
                              \n<\/span><\/p>\n

                              \n\n\n<\/colgroup>\n\n\n
                              \n

                              export TMP=\/tmp
                              \n<\/span><\/p>\n

                              export TMPDIR=$TMP
                              \n<\/span><\/p>\n

                              export ORACLE_BASE=\/oracle
                              \n<\/span><\/p>\n

                              export ORACLE_HOME=$ORACLE_BASE\/12102
                              \n<\/span><\/p>\n

                              export GRID_HOME=\/grid\/12102
                              \n<\/span><\/p>\n

                              export ORACLE_SID=EBOR1
                              \n<\/span><\/p>\n

                              export TNS_ADMIN=$ORACLE_HOME\/network\/admin
                              \n<\/span><\/p>\n

                              export LD_LIBRARY_PATH=$ORACLE_HOME\/lib
                              \n<\/span><\/p>\n

                              export NLS_LANG=American_America.KO16MSWIN949
                              \n<\/span><\/p>\n

                              export NLS_DATE_FORMAT=’YYYY-MM-DD:HH24:MI:SS’
                              \n<\/span><\/p>\n

                              export PATH=$ORACLE_HOME\/bin:$ORACLE_HOME\/OPatch:$GRID_HOME\/bin:.:$PATH<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                              grid \uc0ac\uc6a9\uc790\uc758 \ud658\uacbd \ubcc0\uc218\ub97c \ud3b8\uc9d1\ud569\ub2c8\ub2e4.
                              \n<\/span><\/p>\n

                              \n\n\n<\/colgroup>\n\n\n
                              \n

                              # vi \/grid\/.profile<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                              \uc544\ub798\uc758 \ub0b4\uc6a9\uc744 \uc785\ub825\ud569\ub2c8\ub2e4.
                              \n<\/span><\/p>\n

                              \n\n\n<\/colgroup>\n\n\n
                              \n

                              export TMP=\/tmp
                              \n<\/span><\/p>\n

                              export TMPDIR=$TMP
                              \n<\/span><\/p>\n

                              export LANG=C
                              \n<\/span><\/p>\n

                              export ORACLE_BASE=\/grid\/base
                              \n<\/span><\/p>\n

                              export ORACLE_HOME=\/grid\/12101
                              \n<\/span><\/p>\n

                              export ORACLE_SID=+ASM1
                              \n<\/span><\/p>\n

                              export TNS_ADMIN=$ORACLE_HOME\/network\/admin
                              \n<\/span><\/p>\n

                              export LD_LIBRARY_PATH=$ORACLE_HOME\/lib
                              \n<\/span><\/p>\n

                              export NLS_LANG=American_America.KO16MSWIN949
                              \n<\/span><\/p>\n

                              export ORA_NLS10=$ORACLE_HOME\/nls\/data
                              \n<\/span><\/p>\n

                              export NLS_DATE_FORMAT=’YYYY-MM-DD:HH24:MI:SS’
                              \n<\/span><\/p>\n

                              export PATH=$ORACLE_HOME\/bin:$ORACLE_HOME\/OPatch:$PATH:\/sbin<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                                \n
                              1. \n
                                SSH Setup
                                \n<\/strong><\/span><\/div>\n

                                grid, oracle \uc0ac\uc6a9\uc790 \uac01\uac01\uc758 \uc124\uce58\ud30c\uc77c \ub514\ub809\ud1a0\ub9ac\uc5d0\uc11c \uc544\ub798\uc758 \ub0b4\uc6a9\uc744 \uc218\ud589 \ud569\ub2c8\ub2e4.
                                \n<\/span><\/p>\n<\/li>\n<\/ol>\n

                                \n\n\n<\/colgroup>\n\n\n
                                \n

                                –grid
                                \n<\/span><\/p>\n

                                # .\/sshUserSetup.sh \u2013user grid \u2013hosts “node1 node2” –<\/span> noPromptPassphrase \u2013advanced
                                \n<\/span><\/p>\n

                                — oracle
                                \n<\/span><\/p>\n

                                # .\/sshUserSetup.sh \u2013user oracle \u2013hosts “node1 node2” –<\/span> noPromptPassphrase \u2013advanced<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                                  \n
                                1. \n
                                  Grid Infrastructure Installation Tasks
                                  \n<\/strong><\/span><\/div>\n
                                    \n
                                  1. \n
                                    Unzip Grid Source
                                    \n<\/strong><\/span><\/div>\n

                                    Oracle \uc124\uce58\ud30c\uc77c\uc758 \uc555\ucd95\uc744 \ud574\uc81c\ud569\ub2c8\ub2e4.
                                    \n<\/span><\/p>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n

                                    \n\n\n<\/colgroup>\n\n\n
                                    \n

                                    # su – grid
                                    \n<\/span><\/p>\n

                                    $ unzip linuxamd64_12102_grid_1of2.zip
                                    \n<\/span><\/p>\n

                                    $ unzip linuxamd64_12102_grid_2of2.zip<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                                    \uc555\ucd95\uc744 \ud574\uc81c\ud55c \ud6c4 \uc124\uce58 \ub514\ub809\ud1a0\ub9ac\ub85c \uc774\ub3d9\ud569\ub2c8\ub2e4.
                                    \n<\/span><\/p>\n

                                    \n\n\n<\/colgroup>\n\n\n
                                    \n

                                    $ cd grid<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                                      \n
                                    1. \n
                                      Run the Oracle Universal Installer
                                      \n<\/strong><\/span><\/div>\n

                                      \uc544\ub798\uc758 \uba85\ub839\uc744 \uc774\uc6a9\ud558\uc5ec Oracle Universal Installer \ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4.
                                      \n<\/span><\/p>\n<\/li>\n<\/ol>\n

                                      \n\n\n<\/colgroup>\n\n\n
                                      \n

                                      $.\/runInstaller<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                                      \uc815\uc0c1\uc801\uc73c\ub85c \uc624\ub77c\ud074 \uc778\uc2a4\ud1a8\ub7ec\uac00 \uc2e4\ud589\ub418\uba74 \uc544\ub798\uc640 \uac19\uc740 \uba54\uc2dc\uc9c0\uac00 \ucd9c\ub825\ub41c \ud6c4, \uc124\uce58 \ud654\uba74\uc774 \ub098\ud0c0\ub0a9\ub2c8\ub2e4.
                                      \n<\/span><\/p>\n

                                      \n\n\n<\/colgroup>\n\n\n
                                      \n

                                      Starting Oracle Universal Installer…
                                      \n<\/span><\/p>\n

                                      Checking Temp space: must be greater than 415 MB. Actual 3976 MB Passed
                                      \n<\/span><\/p>\n

                                      Checking swap space: must be greater than 150 MB. Actual 3074 MB Passed
                                      \n<\/span><\/p>\n

                                      Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
                                      \n<\/span><\/p>\n

                                      Preparing to launch Oracle Universal Installer from \/tmp\/OraInstall2015-06-08_10-44-02AM. Please wait …<\/span><\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n

                                        \n
                                      1. \n
                                        Software Updates
                                        \n<\/strong><\/span><\/div>\n<\/li>\n<\/ol>\n

                                        \"\"
                                        \n<\/span><\/p>\n

                                        \uc18c\ud504\ud2b8\uc6e8\uc5b4 \ubc0f \ud328\uce58 \uc138\ud2b8(PSU) \ubc0f \uae30\ud0c0 \uad8c\uc7a5 \ud328\uce58\uc5d0 \ub300\ud574 \uac31\uc2e0\uc744 \ud560 \uac83\uc778\uac00\ub97c \uacb0\uc815
                                        \n<\/span><\/p>\n

                                        \uae30\uc874\uc758 \uc124\uce58 \ud30c\uc77c\uc774 \uc788\uc73c\ubbc0\ub85c \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uac31\uc2e0 \uac74\ub108\ub6f0\uae30 \ud074\ub9ad \ud6c4 Next<\/strong><\/span>\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4.
                                        \n<\/span><\/p>\n

                                          \n
                                        1. \n
                                          Installation Option
                                          \n<\/strong><\/span><\/div>\n<\/li>\n<\/ol>\n

                                          \"\"
                                          \n<\/span><\/p>\n

                                          \uc18c\ud504\ud2b8\uc6e8\uc5b4 \uc124\uce58 \ud6c4 Cluster \uad6c\uc131\uc744 \ud560 \uac83 \uc774\ubbc0\ub85c Next<\/strong><\/span>\ub97c \ud074\ub9ad\ud569\ub2c8\ub2e4.
                                          \n<\/span><\/p>\n