반응형
지난번 Part 1, 2에 이은 Part 3이다. 아마 해당 포스팅은 작성이 오래 걸리긴 하겠지만 여러편에 나누어 이번주 중으로 모두 완성될 예정이다. 이번 장에서는 SSH설정 및 bash_profile 적용, 그리고 NTP(Network Time Protocol) 설정 방법 및 Grid 설치 전 체크사항에 대한 내용이다. 현재 NTP의 경우 OEL7에서 적용이 잘 되지 않는 것 같아 확인이 필요한 부분이다.
ORACLE 12cR2 RAC ASM Install On Linux 7.4 PART 1
ORACLE 12cR2 RAC ASM Install On Linux 7.4 PART 2
ORACLE 12cR2 RAC ASM Install On Linux 7.4 PART 4
ORACLE 12cR2 RAC ASM Install On Linux 7.4 PART 5
ORACLE 12cR2 RAC ASM Install On Linux 7.4 PART 6
친절한 아잇티에게 무엇이든 물어보세요!
글, 사진 ▶ 아잇티
# 사진을 제외한 제 블로그의 모든 글들은 공유 가능합니다.
# 공유 시 출처 및 댓글은 센스있게 부탁드립니다.
# 해당 포스팅 내용 외에 궁금한 점이나 추가사항은 댓글 부탁드립니다.
# 저는 친절합니다. 다가오세요... 해치지 않아요!
Step 1. SSH 설정
* SSH 설정#node 1, 2* SSH 설정(oracle, grid user 모두)[oracle@racdb1 ~]$ ssh-keygen -t rsaGenerating public/private rsa key pair.Enter file in which to save the key (/oracle/user/oracle/.ssh/id_rsa):Created directory '/oracle/user/oracle/.ssh'.Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /oracle/user/oracle/.ssh/id_rsa.Your public key has been saved in /oracle/user/oracle/.ssh/id_rsa.pub.The key fingerprint is:SHA256:vG2Y0YumJIBCG5Sf3cVOpIqzhveqjURG03Z2W52/0bo oracle@racdb1The key's randomart image is:+---[RSA 2048]----+| .. o. ||... .+. . || =.ooo.o+. o ||o.=o+.oooo . . ||o+.o . .S . o . ||+ ..o B . + || o +. . * + o ||. = .o o . . || o.o... E |+----[SHA256]-----+[oracle@racdb1 ~]$[oracle@racdb1 ~]$ ssh-keygen -t dsaGenerating public/private dsa key pair.Enter file in which to save the key (/oracle/user/oracle/.ssh/id_dsa):Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /oracle/user/oracle/.ssh/id_dsa.Your public key has been saved in /oracle/user/oracle/.ssh/id_dsa.pub.The key fingerprint is:SHA256:E85Q8dlm2A5g6/vpWmq95VtMHcEUd2iVB/uj+64J86Q oracle@racdb1The key's randomart image is:+---[DSA 1024]----+| =. +B*|| o + = o+=|| . o = =....|| = . = o.|| S . ..o|| o o. .|| ...o.oo || .+.+*.o || .oo=Eo*+o |+----[SHA256]-----+[oracle@racdb1 ~]$ cd .ssh[oracle@racdb1 .ssh]$ cat *.pub > authorized_keys[oracle@racdb1 .ssh]$ cat authorized_keys(oracle 계정의 racdb1 암호화키)[grid@racdb1 ~]$ ssh-keygen -t rsaGenerating public/private rsa key pair.Enter file in which to save the key (/grid/user/grid/.ssh/id_rsa):Created directory '/grid/user/grid/.ssh'.Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /grid/user/grid/.ssh/id_rsa.Your public key has been saved in /grid/user/grid/.ssh/id_rsa.pub.The key fingerprint is:SHA256:ZvswdwPZDUHGTDDWcGlqB6z+k+ygQzJg30lOul09ad4 grid@racdb1The key's randomart image is:+---[RSA 2048]----+| .=O*. || .o+*. || . +. || o o . oo.o || . o * oSooo. . || = =oo.=. || * .==.+o || . o. **.E. || .. .o. |+----[SHA256]-----+[grid@racdb1 ~]$ ssh-keygen -t dsaGenerating public/private dsa key pair.Enter file in which to save the key (/grid/user/grid/.ssh/id_dsa):Enter passphrase (empty for no passphrase):Enter same passphrase again:Your identification has been saved in /grid/user/grid/.ssh/id_dsa.Your public key has been saved in /grid/user/grid/.ssh/id_dsa.pub.The key fingerprint is:SHA256:oBeFGcGII8wYUIn0OyX4rdeu6yBidWENnPv+8TyqKZI grid@racdb1The key's randomart image is:+---[DSA 1024]----+|O=.o.++=. ||+o* .o*. || o + ++. || . *o.o || =.oo S || . +... ||.o o.... . ||o .Eo.... +. || o+++oo.o. |+----[SHA256]-----+[grid@racdb1 ~]$ cd .ssh/[grid@racdb1 .ssh]$ cat *.pub > authorized_keys(grid 계정의 racdb1의 암호화키)- 각 노드 계정의 authorized_keys 파일의 암호화키를 합쳐준다. racdb1 oracle user의 authorized_keys + racdb2 oracle user의 authorized_keys의 내용을 합침.* SSH 확인[oracle@racdb1 ~]$ ssh racdb2 dateThe authenticity of host 'racdb2 (192.168.10.212)' can't be established.ECDSA key fingerprint is SHA256:+viv4D/C8TL2NcUxEf7pG+GPUjkNBh2ro+yXvVOsCIU.ECDSA key fingerprint is MD5:94:8b:ba:04:42:11:62:0b:18:d8:2c:42:d7:54:19:9c.Are you sure you want to continue connecting (yes/no)? yesWarning: Permanently added 'racdb2,192.168.10.212' (ECDSA) to the list of known hosts.Fri Dec 8 23:31:08 KST 2017[oracle@racdb1 ~]$ ssh racdb1 date[grid@racdb1 ~]$ ssh racdb1 date[grid@racdb1 ~]$ ssh racdb2 date[oracle@racdb2 ~]$ ssh racdb1 date[oracle@racdb2 ~]$ ssh racdb2 date[grid@racdb2 ~]$ ssh racdb1 date[grid@racdb2 ~]$ ssh racdb2 date- grid, oracle 계정으로 1번, 2번 노드에서 위 명령 수행시 모두 패스워드 없이 date가 출력돼야 한다.
Step 2. 각 계정 .bash_profile 설정
#node 1, 2[oracle@racdb1 ~]$ vi .bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then. ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/.local/bin:$HOME/binexport PATHexport PATHumask 022export ORACLE_SID=orcl1 // 2번 노드의 경우 orcl2export ORACLE_BASE=/oracleexport ORACLE_HOME=$ORACLE_BASE/product/12cexport ORACLE_OWNER=oracleexport GRID_HOME=/grid/product/12cexport ORACLE_HOSTNAME=racdb1export ORACLE_UNQNAME=racdbexport ORACLE_TERM=vt100export TMPDIR=/oracle/tmpexport TEMP=/oracle/tmpexport PATH=$ORACLE_HOME/bin:$GRID_HOME/bin:$PATHexport PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/sbin:/usr/ccs/bin:/usr/ucb:/usr/local/bin:/opt/sfw/bin:$ORACLE_HOME/OPatch:$PATHexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/network/libexport LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/oracm/libexport SHLIB_PATH=$LD_LIBRARY_PATHexport DISPLAY=192.168.10.36:0.0export LANG=Cset -o vistty erase ^H- oracle 유저의 bash_profile
#node 1, 2[grid@racdb1 ~]$ vi .bash_profile# .bash_profile# Get the aliases and functionsif [ -f ~/.bashrc ]; then. ~/.bashrcfi# User specific environment and startup programsPATH=$PATH:$HOME/.local/bin:$HOME/binexport PATHexport ORACLE_SID=+ASM1 // 2번 노드의 경우 +ASM2export ORACLE_BASE=/oracleexport GRID_HOME=/grid/product/12cexport ORACLE_HOME=$ORACLE_BASE/product/12cexport LD_LIBRARY_PATH=$ORACLE_HOME/libexport PATH=$PATH:$ORACLE_HOME/bin:$PATH:$GRID_HOME/bin:/usr/bin:/sbin:/usr/sbin:$ORACLE_HOME/OPatchexport LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/libexport CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlibexport PS1="[${LOGNAME}@`hostname -s`:"'${PWD} [${ORACLE_SID}] ]$ 'export PERL_HOME=/usr/local/perlexport PERL5LIB=$PERL_HOME/libexport DISPLAY=192.168.10.201:1.0set -o viexport LANG=C- grid 유저의 bash_profile
Step 3. Grid 설치 전 Check 사항
[root@racdb1 /]# rpm -q binutils compat-libstdc++ gcc glibc libaio libgcc libstdc++ \ make sysstat unixodbc binutils-2.25.1-31.base.el7.x86_64 package compat-libstdc++ is not installed package gcc is not installed glibc-2.17-196.el7.x86_64 libaio-0.3.109-13.el7.x86_64 libgcc-4.8.5-16.el7.x86_64 libstdc++-4.8.5-16.el7.x86_64 make-3.82-23.el7.x86_64 sysstat-10.1.5-12.el7.x86_64 package unixodbc is not installed- rpm check. 필요한 rpm이 설치돼있지 않지만 requirement check시에 걸리지 않는다. Part 1번에서 requirement 자동 적용 rpm을 수행하면해당 절차는 무시해도 무관하다.##### NTP, CHRONY 부분은 보류. 아래 절차는 필자의 경우 무시하고 넘어감. ####[root@racdb1 ~]# systemctl list-units --type service --all |grep ntpd[root@racdb1 ~]# yum install ntp*[root@racdb1 ~]# vi /etc/sysconfig/ntpd# Drop root to id 'ntp:ntp' by default. OPTIONS="-x -u ntp:ntp -p /var/run/ntpd.pid" # Set to 'yes' to sync hw clock after successful ntpdate SYNC_HWCLOCK=no # Additional options for ntpdate NTPDATE_OPTIONS=""[root@racdb1 ~]# vi /etc/ntp.conf(중략)# Use public servers from the pool.ntp.org project. # Please consider joining the pool (http://www.pool.ntp.org/join.html). server 203.248.240.140 iburst #server 0.rhel.pool.ntp.org iburst #server 1.rhel.pool.ntp.org iburst #server 2.rhel.pool.ntp.org iburst #server 3.rhel.pool.ntp.org iburst(하략)[root@racdb2 grid]# service ntpd start Redirecting to /bin/systemctl start ntpd.service[root@racdb1 ~]# yum install chrony[root@racdb1 ~]# vi /etc/chrony.conf# Use public servers from the pool.ntp.org project. # Please consider joining the pool (http://www.pool.ntp.org/join.html). server 203.248.240.140 iburst #server 0.rhel.pool.ntp.org iburst #server 1.rhel.pool.ntp.org iburst #server 2.rhel.pool.ntp.org iburst #server 3.rhel.pool.ntp.org iburst(하략)[root@racdb1 ~]# systemctl start chronyd [root@racdb1 ~]# systemctl enable chronyd####################################################################* cvuqdisk RPM 설치# node 1, 2[root@racdb1 /]# cd /grid/product/12c/cv/rpm- 해당 경로에 cvuqdisk rpm이 존재한다.[root@racdb1 rpm]# rpm -Uvh cvuqdisk-1.0.10-1.rpm Preparing... ################################# [100%] Using default group oinstall to install package Updating / installing... 1:cvuqdisk-1.0.10-1 ################################# [100%]- cvuqdisk rpm 설치* runcluvfy를 통한 requirement 체크# node 1 진행[grid@racdb1:/grid/ora_cd [+ASM1] ]$ ./runcluvfy.sh stage -pre crsinst -n racdb1,racdb2 -verbose > 1.txt- Grid 설치 전 필수 requirement 체크 항목 중 문제가 되는 부분을 먼저 확인한다. -verbose 옵션을통해 보다 자세한 내용을 파악할 수 있고 1.txt라는 파일을 생성하여 해당 파일에 내용을 기록한다.
제 블로그의 내용이 도움이 되셨나요?
▼▼▼▼▼▼▼▼▼▼▼
여러분의 공감과 댓글이 아잇티에게 큰 힘이됩니다 :)
반응형
'Run? Learn! > Oracle - Engine' 카테고리의 다른 글
ORACLE 12cR2 RAC ASM Install On Linux 7.4 PART 6 (0) | 2017.12.13 |
---|---|
ORACLE 12cR2 RAC ASM Install On Linux 7.4 PART 5 (0) | 2017.12.13 |
ORACLE 12cR2 RAC ASM Install On Linux 7.4 PART 4 (0) | 2017.12.12 |
ORACLE 12cR2 RAC ASM Install On Linux 7.4 PART 2 (0) | 2017.12.12 |
ORACLE 12cR2 RAC ASM Install On Linux 7.4 PART 1 (1) | 2017.12.11 |