ORACLE 12cR2 RAC ASM Install On Linux 7.4 PART 3

지난번 Part 1, 2에 이은 Part 3이다. 아마 해당 포스팅은 작성이 오래 걸리긴 하겠지만 여러편에 나누어 이번주 중으로 모두 완성될 예정이다. 이번 장에서는 SSH설정 및 bash_profile 적용, 그리고 NTP(Network Time Protocol) 설정 방법 및 Grid 설치 전 체크사항에 대한 내용이다. 현재 NTP의 경우 OEL7에서 적용이 잘 되지 않는 것 같아 확인이 필요한 부분이다.

친절한 아잇티에게 무엇이든 물어보세요!

글, 사진 ▶ 아잇티

# 사진을 제외한 제 블로그의 모든 글들은 공유 가능합니다.

# 공유 시 출처 및 댓글은 센스있게 부탁드립니다.

# 해당 포스팅 내용 외에 궁금한 점이나 추가사항은 댓글 부탁드립니다.

# 저는 친절합니다. 다가오세요... 해치지 않아요!

Step 1. SSH 설정

 * SSH 설정
#node 1, 2
 * SSH 설정(oracle, grid user 모두)

[oracle@racdb1 ~]$ ssh-keygen -t rsa
Generating 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@racdb1
The 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 dsa
Generating 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@racdb1
The 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 rsa
Generating 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@racdb1
The 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 dsa
Generating 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@racdb1
The 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 date
The 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)? yes
Warning: 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 functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

export PATH
umask 022
export ORACLE_SID=orcl1     // 2번 노드의 경우 orcl2
export ORACLE_BASE=/oracle
export ORACLE_HOME=$ORACLE_BASE/product/12c
export ORACLE_OWNER=oracle
export GRID_HOME=/grid/product/12c
export ORACLE_HOSTNAME=racdb1
export ORACLE_UNQNAME=racdb
export ORACLE_TERM=vt100
export TMPDIR=/oracle/tmp
export TEMP=/oracle/tmp
export PATH=$ORACLE_HOME/bin:$GRID_HOME/bin:$PATH
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/sbin:/usr/ccs/bin:/usr/ucb:/usr/local/bin:/opt/sfw/bin:$ORACLE_HOME/OPatch:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME/lib32:$ORACLE_HOME/network/lib
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/oracm/lib
export SHLIB_PATH=$LD_LIBRARY_PATH
export DISPLAY=192.168.10.36:0.0
export LANG=C
set -o vi
stty erase ^H

 - oracle 유저의 bash_profile

#node 1, 2
[grid@racdb1 ~]$ vi .bash_profile 
# .bash_profile

# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

export PATH

export ORACLE_SID=+ASM1  // 2번 노드의 경우 +ASM2
export ORACLE_BASE=/oracle
export GRID_HOME=/grid/product/12c
export ORACLE_HOME=$ORACLE_BASE/product/12c
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$PATH:$ORACLE_HOME/bin:$PATH:$GRID_HOME/bin:/usr/bin:/sbin:/usr/sbin:$ORACLE_HOME/OPatch
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export PS1="[${LOGNAME}@`hostname -s`:"'${PWD} [${ORACLE_SID}] ]$ '
export PERL_HOME=/usr/local/perl
export PERL5LIB=$PERL_HOME/lib
export DISPLAY=192.168.10.201:1.0
set -o vi
export 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라는 파일을 생성하여 해당 파일에 내용을 기록한다.

제 블로그의 내용이 도움이 되셨나요?

여러분의 공감과 댓글이 아잇티에게 큰 힘이됩니다 :)

▼▼▼▼▼▼▼▼▼▼▼

저작자표시 (새창열림)

'과거자료 > 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

Step 1. SSH 설정

Step 2. 각 계정 .bash_profile 설정

Step 3. Grid 설치 전 Check 사항

'과거자료 > Oracle - Engine' 카테고리의 다른 글

티스토리툴바