메뉴 건너뛰기

Korea Oracle User Group

Install/Configuration

19c RAC 2Node 설치 -2 [ 환경, GRID ]

우뽕 2020.04.21 16:16 조회 수 : 484

1. GRID 환경 변수 설정 

.bash_profile
####################################################################
### ------------ 1Node grid
####################################################################
umask 022
export EDITOR=vi
export LANG=C
export ORACLE_TERM=xterm
export TMOUT=0
##-- ORACLE Enviroment
export ORACLE_OWNER=grid
export ORACLE_SID=+ASM1
export ORACLE_BASE=/dg/app/grid_base
export DB_HOME=/dg/app/product/gihome
export GRID_BASE=/dg/app
export GRID_HOME=$GRID_BASE/product/gihome
export NLS_LANG=American_America.AL32UTF8
##--export TNS_ADMIN=$GRID_HOME/network/admin
export PATH=$PATH:$HOME:$GRID_HOME/bin:$GRID_HOME/perl/bin:$GRID_HOME/dcm/bin:$GRID_HOME/opmn/
bin:$GRID_HOME/OPatch:$GRID_HOME/jdk/bin:$GRID_HOME/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/
bin;
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/oracm/lib:$GRID_HOME/rdbms/lib:$GRID_HOME/ctx
/lib:/lib:/usr/local/lib;
export DB_NAME=+ASM1
export ORACLE_HOME=$GRID_HOME
export ORACLE_HOME_TYPE=GR_HOME
#PS1='[`hostname`-$ORACLE_OWNER] $PWD>'
export PS1='[\u@\h($ORACLE_SID):$PWD] '
stty erase ^H


####################################################################
### ------------ 2Node grid
####################################################################
umask 022
export EDITOR=vi
export LANG=C
export ORACLE_TERM=xterm
export TMOUT=0
##-- ORACLE Enviroment
export ORACLE_OWNER=grid
export ORACLE_SID=+ASM2
export ORACLE_BASE=/dg/app/grid_base
export DB_HOME=/dg/app/product/gihome
export GRID_BASE=/dg/app
export GRID_HOME=$GRID_BASE/product/gihome
export NLS_LANG=American_America.AL32UTF8
##--export TNS_ADMIN=$GRID_HOME/network/admin
export PATH=$PATH:$HOME:$GRID_HOME/bin:$GRID_HOME/perl/bin:$GRID_HOME/dcm/bin:$GRID_HOME/opmn/bin:$GRID_HOME/OPatch
:$GRID_HOME/jdk/bin:$GRID_HOME/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin;
export LD_LIBRARY_PATH=$GRID_HOME/lib:$GRID_HOME/oracm/lib:$GRID_HOME/rdbms/lib:$GRID_HOME/ctx/lib:/lib:/usr/local/
lib;
export DB_NAME=+ASM2
export ORACLE_HOME=$GRID_HOME
export ORACLE_HOME_TYPE=GR_HOME
#PS1='[`hostname`-$ORACLE_OWNER] $PWD>'
export PS1='[\u@\h($ORACLE_SID):$PWD] '
stty erase ^H
 

 

2. Oracle 환경변수

##############################################################################################
######
####------------------------ 1Node DB
##############################################################################################
######
umask 022
export EDITOR=vi
export LANG=C
export ORACLE_TERM=xterm
export TMOUT=0

# ORACLE Enviroment
export ORACLE_OWNER=oracle
export ORACLE_SID=DBRAC1
export ORACLE_BASE=/db/app               
export DB_HOME=$ORACLE_BASE/product/dbhome

export GRID_BASE=/dg/app
export GRID_HOME=$GRID_BASE/product/gihome

###--- export NLS_LANG=American_America.AL32UTF8

export PATH=$PATH:$DB_HOME/bin:$DB_HOME/perl/bin:$DB_HOME/dcm/bin:$DB_HOME/opmn/bin:$DB_HOME/O
Patch:$DB_HOME/jdk/bin:$DB_HOME/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:
export LD_LIBRARY_PATH=$DB_HOME/lib:$DB_HOME/oracm/lib:$DB_HOME/rdbms/lib:$DB_HOME/ctx/lib:/li
b:/usr/local/lib;


export DB_NAME=DBRAC
export ORACLE_HOME=$DB_HOME
export ORACLE_HOME_TYPE=DB_HOME
export PS1='[\u@\h($ORACLE_SID):$PWD]'

stty erase ^H

export DIAG_HOME=/LOGS


####################################################################################################
####------------------------ 2Node DB
####################################################################################################
umask 022
export EDITOR=vi
export LANG=C
export ORACLE_TERM=xterm
export TMOUT=0

# ORACLE Enviroment
export ORACLE_OWNER=oracle
export ORACLE_SID=DBRAC2
export ORACLE_BASE=/db/app               
export DB_HOME=$ORACLE_BASE/product/dbhome

export GRID_BASE=/dg/app
export GRID_HOME=$GRID_BASE/product/gihome

###--- export NLS_LANG=American_America.AL32UTF8

export PATH=$PATH:$DB_HOME/bin:$DB_HOME/perl/bin:$DB_HOME/dcm/bin:$DB_HOME/opmn/bin:$DB_HOME/OPatch:$DB_HOME/jdk/bi
n:$DB_HOME/bin:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin:
export LD_LIBRARY_PATH=$DB_HOME/lib:$DB_HOME/oracm/lib:$DB_HOME/rdbms/lib:$DB_HOME/ctx/lib:/lib:/usr/local/lib;


export DB_NAME=DBRAC
export ORACLE_HOME=$DB_HOME
export ORACLE_HOME_TYPE=DB_HOME
export PS1='[\u@\h($ORACLE_SID):$PWD]'

stty erase ^H

export DIAG_HOME=/LOGS

 

3. 디렉토리 생성 및 압축 해제

[root@db19c1(+ASM1):/dg] echo $GRID_HOME
/dg/app/product/gihome
[root@db19c1(+ASM1):/dg]

[root@db19c1(+ASM1):/dg] mkdir -p /dg/app/product/gihome
[root@db19c1(+ASM1):/dg] chown -R grid:oinstall /dg
[root@db19c1(+ASM1):/dg] su - grid
[grid@db19c1(+ASM1):[root@db19c1(+ASM1):/dg] echo $GRID_HOME
/dg/app/product/gihome
[root@db19c1(+ASM1):/dg]

[root@db19c1(+ASM1):/dg] mkdir -p /dg/app/product/gihome
[root@db19c1(+ASM1):/dg] chown -R grid:oinstall /dg
[root@db19c1(+ASM1):/dg] su - grid
[grid@db19c1(+ASM1):/dg] 
[grid@db19c1(+ASM1):/dg] cd $GRID_HOME
[grid@db19c1(+ASM1):/dg/app/product/gihome] unzip LINUX.X64_193000_grid_home.zip


[grid@db19c1(+ASM1):/dg/app/product/gihome] exit
logout
[root@db19c1(+ASM1):/dg] 
[root@db19c1(+ASM1):/dg] 
[root@db19c1(+ASM1):/dg] 
[root@db19c1(+ASM1):/dg] cd /db
[root@db19c1(+ASM1):/db] . ./.bash_profile 
[root@db19c1(DBRAC1):/db]echo $ORACLE_HOME
/db/app/product/dbhome
[root@db19c1(DBRAC1):/db]mkdir -p /db/app/product/dbhome
[root@db19c1(DBRAC1):/db]chown -R oracle:dba /db 
[root@db19c1(DBRAC1):/db]su - oracle
[oracle@db19c1(DBRAC1):/db]cd $ORACLE_HOME
[oracle@db19c1(DBRAC1):/db/app/product/dbhome]unzip LINUX.X64_193000_db_home.zip

 

4. ssh 설정 하기

[grid@db19c2(+ASM2):/dg] cat /etc/hosts
#127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4
#::1         localhost localhost.localdomain localhost6 localhost6.localdomain6

127.0.0.1      loopback localhost 

######  1Node #########
192.168.0.55  db19C1         ## public
192.168.0.56  db19C1-vip     ## vip
10.10.20.55   db19C1-priv    ## private (interconnect)

######  2Node ##########
192.168.0.57  db19C2             ## public
192.168.0.58  db19C2-vip     ## vip
10.10.20.57   db19C2-priv    ## private (interconnect)

###### scan
192.168.0.59  db19C-scan     ## scan_ip
[grid@db19c2(+ASM2):/dg] 




## GRID 유저  1번 서버 

[grid@db19c1(+ASM1):/dg] mkdir ~/.ssh
[grid@db19c1(+ASM1):/dg] chmod 700 ~/.ssh
[grid@db19c1(+ASM1):/dg] ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/dg/.ssh/id_rsa): 
Enter passphrase (empty for no passphrase): 
Enter same passphrase again: 
Your identification has been saved in /dg/.ssh/id_rsa.
Your public key has been saved in /dg/.ssh/id_rsa.pub.
The key fingerprint is:
SHA256:uNKMzzXMl8FSN0nk0S8kUlIh1WcdY8gPD1TqQN1w+m0 grid@db19c1
The key's randomart image is:
+---[RSA 2048]----+
|          o*%*=*o|
|          o=.OO.=|
|          .o===+ |
|       . o .o.ooo|
|      . S o  . oE|
|     + + . o   . |
|    o + = o      |
|     + . o       |
|      o          |
+----[SHA256]-----+
[grid@db19c1(+ASM1):/dg] ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/dg/.ssh/id_dsa): 
Enter passphrase (empty for no passphrase): 
Enter same passphrase again: 
Your identification has been saved in /dg/.ssh/id_dsa.
Your public key has been saved in /dg/.ssh/id_dsa.pub.
The key fingerprint is:
SHA256:Mq0v28gnMse5wptuqqFSOewvDbLivjNAROs0P+FGUgk grid@db19c1
The key's randomart image is:
+---[DSA 1024]----+
|.E...            |
| .o.             |
|.= o             |
|o.* .  .         |
|.o *  o S        |
|o B .  +         |
|o= = ...         |
|=+o Bo*+.        |
|B==*=*=*o        |
+----[SHA256]-----+
[grid@db19c1(+ASM1):/dg] 
[grid@db19c1(+ASM1):/dg] cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
[grid@db19c1(+ASM1):/dg] cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys



## GRID 유저  2번 서버 
[grid@db19c2(+ASM2):/dg] hostname
db19c2
[grid@db19c2(+ASM2):/dg] id
uid=1001(grid) gid=1010(oinstall) groups=1010(oinstall),1011(dba),1012(asmadmin),1013(asmdba),1014(asmoper),1015(oper) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[grid@db19c2(+ASM2):/dg] mkdir ~/.ssh
[grid@db19c2(+ASM2):/dg] chmod 700 ~/.ssh
[grid@db19c2(+ASM2):/dg] ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/dg/.ssh/id_rsa): 
Enter passphrase (empty for no passphrase): 
Enter same passphrase again: 
Your identification has been saved in /dg/.ssh/id_rsa.
Your public key has been saved in /dg/.ssh/id_rsa.pub.
The key fingerprint is:
SHA256:F4NNUcxgrdUKk99LuFy1v66cTb3ctrw3mHOKJ9hF6SU grid@db19c2
The key's randomart image is:
+---[RSA 2048]----+
|          =O..   |
|         =+ = . .|
|        . +* +...|
|          .o+E+o |
|        S ..o+o..|
|         .  oo. o|
|          o . o.o|
|         . oo=*+=|
|           .o=*X*|
+----[SHA256]-----+
[grid@db19c2(+ASM2):/dg] ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/dg/.ssh/id_dsa): 
Enter passphrase (empty for no passphrase): 
Enter same passphrase again: 
Your identification has been saved in /dg/.ssh/id_dsa.
Your public key has been saved in /dg/.ssh/id_dsa.pub.
The key fingerprint is:
SHA256:oPl8LhNNFNnd2GXMoLKbgnKkdOwmfccvmw7zOkaRQxM grid@db19c2
The key's randomart image is:
+---[DSA 1024]----+
|        E= . +.=o|
|        = . o.o.o|
|      .o o. .    |
|     + .=  o     |
|    + +oSo.      |
|   . O..o. o     |
|    + Oo* =      |
|     =o+o*.o     |
|       +o+=o.    |
+----[SHA256]-----+
[grid@db19c2(+ASM2):/dg] 
[grid@db19c2(+ASM2):/dg] cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
[grid@db19c2(+ASM2):/dg] cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys



##  1번 GRID 에서 수행 
ssh db19c2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh db19c2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
scp ~/.ssh/authorized_keys db19c2:~/.ssh/authorized_keys


[grid@db19c1(+ASM1):/dg] ssh db19c2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
The authenticity of host 'db19c2 (192.168.0.57)' can't be established.
ECDSA key fingerprint is SHA256:PbP1p6bRuQnmSTXw1ebitjbaiHiRzp2GHLW2jRF6/uY.
ECDSA key fingerprint is MD5:54:e3:55:77:3c:9e:08:24:a5:28:b4:11:ce:d4:2a:bf.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'db19c2,192.168.0.57' (ECDSA) to the list of known hosts.
grid@db19c2's password: 
[grid@db19c1(+ASM1):/dg] 

##  2번 GRID 에서 수행 
[grid@db19c2(+ASM2):/dg] ssh db19c1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
The authenticity of host 'db19c1 (192.168.0.55)' can't be established.
ECDSA key fingerprint is SHA256:PbP1p6bRuQnmSTXw1ebitjbaiHiRzp2GHLW2jRF6/uY.
ECDSA key fingerprint is MD5:54:e3:55:77:3c:9e:08:24:a5:28:b4:11:ce:d4:2a:bf.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'db19c1,192.168.0.55' (ECDSA) to the list of known hosts.
grid@db19c1's password: 
[grid@db19c2(+ASM2):/dg] ssh db19c1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
[grid@db19c2(+ASM2):/dg] ssh db19c1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
[grid@db19c2(+ASM2):/dg] scp ~/.ssh/authorized_keys db19c1:~/.ssh/authorized_keys
authorized_keys                                                                     100% 3768     5.4MB/s   00:00    
[grid@db19c2(+ASM2):/dg] 



[grid@db19c1(+ASM1):/dg] ssh db19C2 date
Fri Apr 10 14:09:30 KST 2020
[grid@db19c1(+ASM1):/dg] ssh db19C2-vip  date
ssh: connect to host db19c2-vip port 22: No route to host
[grid@db19c1(+ASM1):/dg] ssh db19C2-priv date
The authenticity of host 'db19c2-priv (10.10.20.57)' can't be established.
ECDSA key fingerprint is SHA256:PbP1p6bRuQnmSTXw1ebitjbaiHiRzp2GHLW2jRF6/uY.
ECDSA key fingerprint is MD5:54:e3:55:77:3c:9e:08:24:a5:28:b4:11:ce:d4:2a:bf.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'db19c2-priv,10.10.20.57' (ECDSA) to the list of known hosts.
Fri Apr 10 14:09:46 KST 2020
[grid@db19c1(+ASM1):/dg] ssh db19C2-priv date
Fri Apr 10 14:09:49 KST 2020
[grid@db19c1(+ASM1):/dg] 




[grid@db19c2(+ASM2):/dg] ssh db19C1 date
Fri Apr 10 14:11:06 KST 2020
[grid@db19c2(+ASM2):/dg] ssh db19C1-priv date
The authenticity of host 'db19c1-priv (10.10.20.55)' can't be established.
ECDSA key fingerprint is SHA256:PbP1p6bRuQnmSTXw1ebitjbaiHiRzp2GHLW2jRF6/uY.
ECDSA key fingerprint is MD5:54:e3:55:77:3c:9e:08:24:a5:28:b4:11:ce:d4:2a:bf.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'db19c1-priv,10.10.20.55' (ECDSA) to the list of known hosts.
Fri Apr 10 14:11:15 KST 2020
[grid@db19c2(+ASM2):/dg] ssh db19C1-priv date
Fri Apr 10 14:11:17 KST 2020
[grid@db19c2(+ASM2):/dg] ssh db19C1-vip date
ssh: connect to host db19c1-vip port 22: No route to host
[grid@db19c2(+ASM2):/dg] 

--> GRID 유저 설정 완료 


## Oracle 유저 1번 서버
[oracle@db19c1(DB19C1):/db]mkdir ~/.ssh
[oracle@db19c1(DB19C1):/db]chmod 700 ~/.ssh
[oracle@db19c1(DB19C1):/db]ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/db/.ssh/id_rsa): 
Enter passphrase (empty for no passphrase): 
Enter same passphrase again: 
Your identification has been saved in /db/.ssh/id_rsa.
Your public key has been saved in /db/.ssh/id_rsa.pub.
The key fingerprint is:
SHA256:y9lgejQtUA7XFfol6VvrlV5D+1PZNMUH/MvrxXlzmBs oracle@db19c1
The key's randomart image is:
+---[RSA 2048]----+
|      . o. .oo.o |
|       =  .. .. +|
|      . . . o ..o|
|       . . o o .o|
|        S . o oo=|
|       = B   o.O*|
|      . = . . E*X|
|       .     ..*O|
|              +oo|
+----[SHA256]-----+
[oracle@db19c1(DB19C1):/db]ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/db/.ssh/id_dsa): 
Enter passphrase (empty for no passphrase): 
Enter same passphrase again: 
Your identification has been saved in /db/.ssh/id_dsa.
Your public key has been saved in /db/.ssh/id_dsa.pub.
The key fingerprint is:
SHA256:TqozsPaMJOrLXByrEZQhEtTbirNYKvZ1HWBKEiqOkCw oracle@db19c1
The key's randomart image is:
+---[DSA 1024]----+
|=+..             |
|+.+..            |
|E= .o. o         |
|B  .o.o .        |
|.o....  S.       |
| o=.o  +. .      |
|o++* .....       |
|B=*o+..          |
|=B+o+o           |
+----[SHA256]-----+
[oracle@db19c1(DB19C1):/db]cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
[oracle@db19c1(DB19C1):/db]cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
[oracle@db19c1(DB19C1):/db]ssh db19c2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
The authenticity of host 'db19c2 (192.168.0.57)' can't be established.
ECDSA key fingerprint is SHA256:PbP1p6bRuQnmSTXw1ebitjbaiHiRzp2GHLW2jRF6/uY.
ECDSA key fingerprint is MD5:54:e3:55:77:3c:9e:08:24:a5:28:b4:11:ce:d4:2a:bf.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'db19c2,192.168.0.57' (ECDSA) to the list of known hosts.
oracle@db19c2's password: 
[oracle@db19c1(DB19C1):/db]ssh db19c2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
oracle@db19c2's password: 
[oracle@db19c1(DB19C1):/db]ssh db19c2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
oracle@db19c2's password: 
[oracle@db19c1(DB19C1):/db]scp ~/.ssh/authorized_keys db19c2:~/.ssh/authorized_keys
oracle@db19c2's password: 
authorized_keys                                                                                                                                                               100% 2391    66.4KB/s   00:00    
[oracle@db19c1(DB19C1):/db]



## Oracle 유저 2번 서버
[oracle@db19c2(DBRAC2):/db]id
uid=1000(oracle) gid=1010(oinstall) groups=1010(oinstall),1011(dba),1012(asmadmin),1013(asmdba),1014(asmoper),1015(oper) context=unconfined_u:unconfined_r:unconfined_t:s0-s0:c0.c1023
[oracle@db19c2(DBRAC2):/db]mkdir ~/.ssh
[oracle@db19c2(DBRAC2):/db]chmod 700 ~/.ssh
[oracle@db19c2(DBRAC2):/db]ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/db/.ssh/id_rsa): 
Enter passphrase (empty for no passphrase): 
Enter same passphrase again: 
Your identification has been saved in /db/.ssh/id_rsa.
Your public key has been saved in /db/.ssh/id_rsa.pub.
The key fingerprint is:
SHA256:VLJM6r1yJiMHSX2vN1r3dGse6O4sHQT9nm8U3a0ckPo oracle@db19c2
The key's randomart image is:
+---[RSA 2048]----+
|        o . ..   |
|     . + + .o.   |
|    . o =  .... +|
|   . o + ..  ..o+|
|    o . S .....oo|
|     .   o  E.+o.|
|    . = = + o.ooo|
|     o * + +o+ o=|
|        .   +=++ |
+----[SHA256]-----+
[oracle@db19c2(DBRAC2):/db]ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/db/.ssh/id_dsa): 
Enter passphrase (empty for no passphrase): 
Enter same passphrase again: 
Your identification has been saved in /db/.ssh/id_dsa.
Your public key has been saved in /db/.ssh/id_dsa.pub.
The key fingerprint is:
SHA256:wyLg1auIirW2lhDTTMRp6ZvioFJ1PSKRoxuCNRUNLjM oracle@db19c2
The key's randomart image is:
+---[DSA 1024]----+
| o.++=           |
|  O.+..          |
|.BEooo..         |
|=.**o ooo        |
| +.*.oo.S.       |
|+.=. o . .       |
|=+o..            |
|=o+.             |
|+oo.             |
+----[SHA256]-----+
[oracle@db19c2(DBRAC2):/db]cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
[oracle@db19c2(DBRAC2):/db]cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
[oracle@db19c2(DBRAC2):/db]ssh db19c1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
The authenticity of host 'db19c1 (192.168.0.55)' can't be established.
ECDSA key fingerprint is SHA256:PbP1p6bRuQnmSTXw1ebitjbaiHiRzp2GHLW2jRF6/uY.
ECDSA key fingerprint is MD5:54:e3:55:77:3c:9e:08:24:a5:28:b4:11:ce:d4:2a:bf.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'db19c1,192.168.0.55' (ECDSA) to the list of known hosts.
[oracle@db19c2(DBRAC2):/db]ssh db19c1 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
[oracle@db19c2(DBRAC2):/db]ssh db19c1 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
[oracle@db19c2(DBRAC2):/db]scp ~/.ssh/authorized_keys db19c1:~/.ssh/authorized_keys
authorized_keys                                                                                                                                                               100% 3784    92.0KB/s   00:00    
[oracle@db19c2(DBRAC2):/db]



##############################################

1번 , 2번 공통적으로 수행 해 보자 

#############################################

[oracle@db19c1(DB19C1):/db]
[oracle@db19c1(DB19C1):/db]
[oracle@db19c1(DB19C1):/db]ssh db19C2 date
Mon Apr 13 14:46:13 KST 2020
[oracle@db19c1(DB19C1):/db]ssh db19C2-vip  date
The authenticity of host 'db19c2-vip (192.168.0.58)' can't be established.
ECDSA key fingerprint is SHA256:PbP1p6bRuQnmSTXw1ebitjbaiHiRzp2GHLW2jRF6/uY.
ECDSA key fingerprint is MD5:54:e3:55:77:3c:9e:08:24:a5:28:b4:11:ce:d4:2a:bf.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'db19c2-vip,192.168.0.58' (ECDSA) to the list of known hosts.
Mon Apr 13 14:46:26 KST 2020
[oracle@db19c1(DB19C1):/db]ssh db19C2-vip  date
Mon Apr 13 14:46:29 KST 2020
[oracle@db19c1(DB19C1):/db]ssh db19C2-priv date
The authenticity of host 'db19c2-priv (10.10.20.57)' can't be established.
ECDSA key fingerprint is SHA256:PbP1p6bRuQnmSTXw1ebitjbaiHiRzp2GHLW2jRF6/uY.
ECDSA key fingerprint is MD5:54:e3:55:77:3c:9e:08:24:a5:28:b4:11:ce:d4:2a:bf.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'db19c2-priv,10.10.20.57' (ECDSA) to the list of known hosts.
Mon Apr 13 14:46:41 KST 2020
[oracle@db19c1(DB19C1):/db]ssh db19C2-priv date
Mon Apr 13 14:46:49 KST 2020
[oracle@db19c1(DB19C1):/db]ssh db19C2-priv date
Mon Apr 13 14:47:45 KST 2020
[oracle@db19c1(DB19C1):/db]ssh db19C2-vip  date
Mon Apr 13 14:47:48 KST 2020
[oracle@db19c1(DB19C1):/db]ssh db19C2 date
Mon Apr 13 14:47:52 KST 2020
[oracle@db19c1(DB19C1):/db]


[oracle@db19c2(DBRAC2):/db]ssh db19C1 date
Mon Apr 13 14:48:16 KST 2020
[oracle@db19c2(DBRAC2):/db]
[oracle@db19c2(DBRAC2):/db]
[oracle@db19c2(DBRAC2):/db]
[oracle@db19c2(DBRAC2):/db]ssh db19C1 date
Mon Apr 13 14:48:26 KST 2020
[oracle@db19c2(DBRAC2):/db]ssh db19c1-vip date
The authenticity of host 'db19c1-vip (192.168.0.56)' can't be established.
ECDSA key fingerprint is SHA256:PbP1p6bRuQnmSTXw1ebitjbaiHiRzp2GHLW2jRF6/uY.
ECDSA key fingerprint is MD5:54:e3:55:77:3c:9e:08:24:a5:28:b4:11:ce:d4:2a:bf.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'db19c1-vip,192.168.0.56' (ECDSA) to the list of known hosts.
Mon Apr 13 14:48:35 KST 2020
[oracle@db19c2(DBRAC2):/db]ssh db19c1-vip date
Mon Apr 13 14:48:38 KST 2020
[oracle@db19c2(DBRAC2):/db]ssh db19c1-priv date
The authenticity of host 'db19c1-priv (10.10.20.55)' can't be established.
ECDSA key fingerprint is SHA256:PbP1p6bRuQnmSTXw1ebitjbaiHiRzp2GHLW2jRF6/uY.
ECDSA key fingerprint is MD5:54:e3:55:77:3c:9e:08:24:a5:28:b4:11:ce:d4:2a:bf.
Are you sure you want to continue connecting (yes/no)? yes
^[[AWarning: Permanently added 'db19c1-priv,10.10.20.55' (ECDSA) to the list of known hosts.
Mon Apr 13 14:48:50 KST 2020
[oracle@db19c2(DBRAC2):/db]ssh db19c1-priv date
Mon Apr 13 14:48:57 KST 2020
[oracle@db19c2(DBRAC2):/db]
[oracle@db19c2(DBRAC2):/db]
[oracle@db19c2(DBRAC2):/db]
 

 

5. runcluvfy  점검 및 조치 내용

[grid@db19c1(+ASM1):/dg/app/product/gihome] pwd
/dg/app/product/gihome
[grid@db19c1(+ASM1):/dg/app/product/gihome]./runcluvfy.sh stage -pre crsinst -n db19c1,db19c2 -verbose > /dg/runcluvfy.log 

조치 -1)
/etc/fstab  추가

tmpfs       /dev/shm       tmpfs    defaults        0 0


조치 -2)

/etc/sysconfig/network   추가 
# Created by anaconda
# Recommended value for NOZEROCONF
NOZEROCONF=yes


조치 -3)

Stop avahi-daemon damon if it not configured

systemctl status avahi-daemon
systemctl stop avahi-daemon
systemctl disable avahi-daemon


[root@db19c1 ~]# systemctl status avahi-daemon
● avahi-daemon.service - Avahi mDNS/DNS-SD Stack
   Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
[root@db19c1 ~]# 

[root@db19c2 ~]# systemctl status avahi-daemon
● avahi-daemon.service - Avahi mDNS/DNS-SD Stack
   Loaded: loaded (/usr/lib/systemd/system/avahi-daemon.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
[root@db19c2 ~]# 


[root@db19c1 ~]#  ps -ef | grep avahi-daemon
root     15139  8665  0 16:10 pts/0    00:00:00 grep --color=auto avahi-daemon
[root@db19c1 ~]# 


[root@db19c2 ~]# ps -ef | grep avahi-daemon
root      5689  5472  0 16:10 pts/0    00:00:00 grep --color=auto avahi-daemon
[root@db19c2 ~]#



조치 -4)
[root@db19c1 ~]# cd /dg/app/product/gihome/cv/rpm
[root@db19c1 rpm]# ls -lart
합계 12
-rw-r--r--. 1 grid oinstall 11412  3월 13  2019 cvuqdisk-1.0.10-1.rpm
drwxr-xr-x. 7 grid oinstall    71  4월 17  2019 ..
drwxr-xr-x. 2 grid oinstall    35  4월 17  2019 .
[root@db19c1 rpm]# rpm -Uvh cvuqdisk-1.0.10-1.rpm 
준비 중...                         ################################# [100%]
Using default group oinstall to install package
Updating / installing...
   1:cvuqdisk-1.0.10-1                ################################# [100%]

[root@db19c1 rpm]# scp cvuqdisk-1.0.10-1.rpm  db19c2:/dg
The authenticity of host 'db19c2 (192.168.0.57)' can't be established.
ECDSA key fingerprint is SHA256:PbP1p6bRuQnmSTXw1ebitjbaiHiRzp2GHLW2jRF6/uY.
ECDSA key fingerprint is MD5:54:e3:55:77:3c:9e:08:24:a5:28:b4:11:ce:d4:2a:bf.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'db19c2,192.168.0.57' (ECDSA) to the list of known hosts.
root@db19c2's password: 
cvuqdisk-1.0.10-1.rpm                                                                                                                     100%   11KB   5.5MB/s   00:00    
[root@db19c1 rpm]# 

조치 -5)

[root@db19c2 dg]#  systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
   Active: active (running) since 금 2020-04-10 16:07:00 KST; 56min ago
     Docs: man:firewalld(1)
 Main PID: 3778 (firewalld)
    Tasks: 2
   CGroup: /system.slice/firewalld.service
           └─3778 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid

 4월 10 16:06:57 db19c2 systemd[1]: Starting firewalld - dynamic firewall daemon...
 4월 10 16:07:00 db19c2 systemd[1]: Started firewalld - dynamic firewall daemon.
[root@db19c2 dg]# systemctl stop firewalld
[root@db19c2 dg]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; enabled; vendor preset: enabled)
   Active: inactive (dead) since 금 2020-04-10 17:03:39 KST; 30min ago
     Docs: man:firewalld(1)
  Process: 3778 ExecStart=/usr/sbin/firewalld --nofork --nopid $FIREWALLD_ARGS (code=exited, status=0/SUCCESS)
 Main PID: 3778 (code=exited, status=0/SUCCESS)

 4월 10 16:06:57 db19c2 systemd[1]: Starting firewalld - dynamic firewall daemon...
 4월 10 16:07:00 db19c2 systemd[1]: Started firewalld - dynamic firewall daemon.
 4월 10 17:03:38 db19c2 systemd[1]: Stopping firewalld - dynamic firewall daemon...
 4월 10 17:03:39 db19c2 systemd[1]: Stopped firewalld - dynamic firewall daemon.
[root@db19c2 dg]# 


firewalld 서비스 상태 확인.
systemctl status firewalld.service

firewalld 서비스 중지.
systemctl stop firewalld.service

firewalld 서비스 비활성화.
systemctl disable firewalld.service

firewalld 서비스 상태 확인.
systemctl status firewalld.service

조치5번의 경우 미해결시 grid 설치시 에러 발생 


[root@db19c1 dg]# systemctl stop firewalld
[root@db19c1 dg]# systemctl disable firewalld.service
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
[root@db19c1 dg]# systemctl status firewalld.service
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)

 4월 10 16:08:24 db19c1 systemd[1]: Starting firewalld - dynamic firewall daemon...
 4월 10 16:08:29 db19c1 systemd[1]: Started firewalld - dynamic firewall daemon.
 4월 10 17:03:33 db19c1 systemd[1]: Stopping firewalld - dynamic firewall daemon...
 4월 10 17:03:34 db19c1 systemd[1]: Stopped firewalld - dynamic firewall daemon.
[root@db19c1 dg]# systemctl disable firewalld
[root@db19c1 dg]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)

 4월 10 16:08:24 db19c1 systemd[1]: Starting firewalld - dynamic firewall daemon...
 4월 10 16:08:29 db19c1 systemd[1]: Started firewalld - dynamic firewall daemon.
 4월 10 17:03:33 db19c1 systemd[1]: Stopping firewalld - dynamic firewall daemon...
 4월 10 17:03:34 db19c1 systemd[1]: Stopped firewalld - dynamic firewall daemon.
[root@db19c1 dg]# 


[root@db19c2 dg]# systemctl stop firewalld
[root@db19c2 dg]# systemctl disable firewalld.service
Removed symlink /etc/systemd/system/multi-user.target.wants/firewalld.service.
Removed symlink /etc/systemd/system/dbus-org.fedoraproject.FirewallD1.service.
[root@db19c2 dg]# systemctl status firewalld.service
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)

 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete FORWARD --in-interface v... chain?).
 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete FORWARD --out-interface ...hat name.
 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete FORWARD --in-interface v...hat name.
 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete INPUT --in-interface vir... chain?).
 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete INPUT --in-interface vir... chain?).
 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete OUTPUT --out-interface v... chain?).
 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete INPUT --in-interface vir... chain?).
 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete INPUT --in-interface vir... chain?).
 4월 10 18:50:23 db19c2 systemd[1]: Stopping firewalld - dynamic firewall daemon...
 4월 10 18:50:24 db19c2 systemd[1]: Stopped firewalld - dynamic firewall daemon.
Hint: Some lines were ellipsized, use -l to show in full.
[root@db19c2 dg]# systemctl disable firewalld
[root@db19c2 dg]# systemctl status firewalld
● firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)

 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete FORWARD --in-interface v... chain?).
 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete FORWARD --out-interface ...hat name.
 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete FORWARD --in-interface v...hat name.
 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete INPUT --in-interface vir... chain?).
 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete INPUT --in-interface vir... chain?).
 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete OUTPUT --out-interface v... chain?).
 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete INPUT --in-interface vir... chain?).
 4월 10 18:49:27 db19c2 firewalld[29958]: WARNING: COMMAND_FAILED: '/usr/sbin/iptables -w2 -w --table filter --delete INPUT --in-interface vir... chain?).
 4월 10 18:50:23 db19c2 systemd[1]: Stopping firewalld - dynamic firewall daemon...
 4월 10 18:50:24 db19c2 systemd[1]: Stopped firewalld - dynamic firewall daemon.
Hint: Some lines were ellipsized, use -l to show in full.
[root@db19c2 dg]# 

 

6. GRID 설치

01.GIF

 

02.GIF

 

03.GIF

 

04.GIF

 

05.GIF

 

06.GIF

 

07.GIF

 

08.GIF

 

09.GIF

 

10-firewall_enable.GIF

 

조치 5번을 안하면 위와 같은 에러 발생

 

조치 완료 후 넘어 갑니다.

11.GIF

 

12.GIF

 

13.GIF

 

14.GIF

 

15.GIF

 

 

 

위로