ABOUT ME

-

Today
-
Yesterday
-
Total
-
  • Oracle 12c R2 RAC 설치 #1
    ORACLE/Installation 2017.11.09 11:10

    설치 환경


    Esxi 5.5, 

    Oracle Linux 6.9 x86_64

    Oracle 12c R2 (12.2.0.1)


    리눅스6 설치 옵션


    SWAP 4GB+

    방화벽 사용중지

    SELinux 설정 변경 (permissive or disabled)

    해당 패키지 그룹 설치

    • Base System > Base
    • Base System > Hardware monitoring utilities
    • Base System > Large Systems Performance
    • Base System > Network file system client
    • Base System > Performance Tools
    • Base System > Perl Support
    • Servers > Server Platform
    • Servers > System administration tools
    • Desktops > Desktop
    • Desktops > Desktop Platform
    • Desktops > Fonts
    • Desktops > General Purpose Desktop
    • Desktops > Graphical Administration Tools
    • Desktops > Input Methods
    • Desktops > X Window System
    • Applications > Internet Browser
    • Development > Additional Development
    • Development > Development Tools


    자동 설정


    # yum install oracle-database-server-12cR2-preinstall -y

    # yum install ntp -y



    직접 설정


    # groupadd oinstall

    # groupadd dba

    # useradd -g oinstall -G dba oracle

    # passwd oracle



    # vi /etc/sysctl.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


    # sysctl -p



    # vi /etc/security/limits.d/oracle-database-server-12cR2-preinstall.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


    # yum -y install ksh,libaio-devel,unixODBC, unixODBC-devel

    # yum -y update



    # vi /etc/hosts


    127.0.0.1       localhost.localdomain   localhost

    # Public

    192.168.56.201   ol6-122-rac1.localdomain        ol6-122-rac1

    192.168.56.202   ol6-122-rac2.localdomain        ol6-122-rac2

    # Private

    192.168.1.201   ol6-122-rac1-priv.localdomain   ol6-122-rac1-priv

    192.168.1.202   ol6-122-rac2-priv.localdomain   ol6-122-rac2-priv

    # Virtual

    192.168.56.203   ol6-122-rac1-vip.localdomain    ol6-122-rac1-vip

    192.168.56.204   ol6-122-rac2-vip.localdomain    ol6-122-rac2-vip

    # SCAN

    #192.168.56.205   ol6-122-scan.localdomain ol6-122-scan

    #192.168.56.206   ol6-122-scan.localdomain ol6-122-scan

    #192.168.56.207   ol6-122-scan.localdomain ol6-122-scan



    박화벽 중지


    # service iptables stop

    # chkconfig iptables off



    NTP 설정


    # vi /etc/sysconfig/ntpd

    OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid"


    # service ntpd restart

    # chkconfig ntpd on



    Grid 설치 폴더 생성


    # mkdir -p /u01/app/12.2.0.1/grid

    # mkdir -p /u01/app/oracle/product/12.2.0.1/db_1

    # chown -R oracle:oinstall /u01

    # chmod -R 775 /u01/



    Oracle user 접속 후 프로파일 설정


    $ vi .bash_profile


    # Oracle Settings

    export TMP=/tmp

    export TMPDIR=$TMP


    export ORACLE_HOSTNAME=ol6-122-rac1.localdomain

    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'


    $ vi 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


    $ vi 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



    공유 스토리지 Block device 설정


    # fdisk /dev/sdb

     n, p, 1, Enter, Enter, w 



    Udev 설정


    # vi /etc/scsi_id.config

    options=-g


    # /sbin/scsi_id -g -u -d /dev/sdb1

    36000c299ab492a9c2ff010df22555c9f


    # vi /etc/udev/rules.d/99-oracle-asmdevices.rules

    KERNEL=="sd?1", SUBSYSTEM=="block", PROGRAM=="/sbin/scsi_id -g -u -d /dev/$parent", RESULT=="36000c299ab492a9c2ff010df22555c9f", SYMLINK+="oracleasm/asm-disk1", OWNER="oracle", GROUP="dba", MODE="0660"



    Block Device 파티션 테이블 불러오기


    # partprobe /dev/sdb1



    Udev Rule 다시 불러오기


    # udevadm control --reload-rules


    # ls -al /dev/oracleasm/*

    lrwxrwxrwx. 1 root root 7 Mar  8 21:11 /dev/oracleasm/asm-disk1 -> ../sdb1




    2번 노드도 똑같이 설정.

    댓글 0

Designed by black7375.

티스토리 툴바