1. Grid Infrastructure 및 Oracle Database 설치 시 GUI를 이용할 계획이므로, 화면 해상도를 변경한다.
2. 리눅스 설치정보를 확인한다.
1 2 | uname -a cat /etc/oracle-release | cs |
3. 일부 서비스를 종료시킨다.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | ## 방화벽 중지 systemctl stop firewalld systemctl disable firewalld ## 시간 동기화 중지 systemctl stop chronyd systemctl disable chronyd ## ntp 중지, 실제 사용 환경에서는 ntp나 chrony과 같은 시간 동기화 서비스 사용 설정 권장 systemctl stop ntpdate systemctl disable ntpdate ## AVAHI 중지 systemctl stop avahi-daemon.socket systemctl disable avahi-daemon.socket systemctl stop avahi-daemon systemctl disable avahi-daemon | cs |
4. 리눅스 관련 패키지를 다운로드받는다.
(1) https://www.oracle.com/linux/downloads/linux-asmlib-v8-downloads.html
(2) https://yum.oracle.com/repo/OracleLinux/OL8/addons/x86_64/index.html 에서 oracleasm-support-2.1.12-1.el8.rpm 다운로드
1 | # rpm -ivh oracleasm* | cs |
5. yum으로 oracle preinstall을 진행한다.
1 2 3 | # yum list | grep preinstall # yum -y install oracle-database-preinstall-19c* | cs |
6. 기타 환경설정
1 2 3 | # vi /etc/selinux/config SELINUX=permissive | cs |
# vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
### Public
192.168.43.55 srv1 srv1.localdomain
192.168.43.56 srv2 srv2.localdomain
### Private
192.168.56.10 srv1-priv srv1-priv.localdomain
192.168.56.11 srv2-priv srv2-priv.localdomain
### Virtual
192.168.43.70 srv1-vip srv1-vip.localdomain
192.168.43.71 srv2-vip srv2-vip.localdomain
### SCAN
192.168.43.200 srv-scan srv-scan.localdomain
192.168.43.201 srv-scan srv-scan.localdomain
192.168.43.202 srv-scan srv-scan.localdomain
1 2 3 4 | /etc/resolv.conf # Generated by NetworkManager nameserver 127.0.0.1 | cs |
dnsmasq: 경량의 리눅스 DNS 캐시 서버(또한 스스로 사설 DNS 서버이자 DHCP 서버로도 작동)
1 2 3 4 | vi /etc/dnsmasq.conf local=/localdomain/ | cs |
1 2 3 4 5 6 7 8 9 10 11 | ## 재부팅 [root@srv1 ~]# nslookup srv-scan.localdomain Server: 127.0.0.1 Address: 127.0.0.1#53 Name: srv-scan.localdomain Address: 192.168.56.200 Name: srv-scan.localdomain Address: 192.168.56.201 Name: srv-scan.localdomain Address: 192.168.56.202 | cs |
7. 유저 Grid 생성
1 2 3 4 5 6 7 | [root@srv1 ~]# groupadd asmadmin [root@srv1 ~]# groupadd asmdba [root@srv1 ~]# groupadd asmoper [root@srv1 ~]# useradd -g oinstall -G dba,oper,backupdba,dgdba,kmdba,racdba,asmadmin,asmdba,asmoper grid [root@srv1 ~]# [root@srv1 ~]# passwd grid | cs |
1 2 3 4 | [root@srv1 ~]# mkdir -p /u01/app/oracle [root@srv1 ~]# chown -R oracle:oinstall /u01/ [root@srv1 ~]# chmod -R 755 /u01 [root@srv1 ~]# mkdir -p /u01/app/19c/grid | cs |
8. 사용자 환경 설정
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 | su - oracle $ vi .bash_profile export TMP=/tmp export TMPDIR=$TMP export EDITOR=vi export ORACLE_HOSTNAME=srv1 # 호스트명에 맞게 변경 export ORACLE_UNQNAME=racdb export ORACLE_BASE=/u01/app/oracle export GRID_HOME=/u01/app/19c/grid export DB_HOME=$ORACLE_BASE/product/19c/db_1 export ORACLE_HOME=$DB_HOME export ORACLE_SID=racdb1 # 2번 노드 racdb2 export ORACLE_TERM=xterm export BASE_PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$GRID_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 export NLS_LANG=JAPANESE_JAPAN.AL32UTF8 su - grid $ vi .bash_profile export TMP=/tmp export TMPDIR=$TMP export EDITOR=vi export ORACLE_HOSTNAME=srv1 export ORACLE_HOME=/u01/app/19c/grid export ORACLE_SID=+ASM1 export BASE_PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$GRID_HOME/bin:$BASE_PATH export ORACLE_TERM=xterm export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib export NLS_LANG=JAPANESE_JAPAN.AL32UTFi8 | cs |
9. openssh 설정
1 2 3 | # cp -p /usr/bin/scp /usr/bin/scp-original # echo "/usr/bin/scp-original -T \$*" > /usr/bin/scp # cat /usr/bin/scp | cs |
