설치4에서 grid Home 퍼미션이 변경 되었습니다.
따라서 현재 vncserver 를 이용하여 x-window를 다시 띠우려면 퍼미션 변경을 해주어야 사용이 가능 합니다.
현재 vnc 프로세스를 죽인 상태가 아니므로 바로 asmca를 이용하여 신규 디스크 그룹을 추가 합니다.
[grid@db19c1(+ASM1):/dg] cd $GRID_HOME
[grid@db19c1(+ASM1):/dg/app/product/gihome] cd bin
[grid@db19c1(+ASM1):/dg/app/product/gihome/bin] ls -lart asmca
-rwxr-x---. 1 root oinstall 7912 Apr 20 11:42 asmca
[grid@db19c1(+ASM1):/dg/app/product/gihome/bin] ./asmca
[root@db19c1(+ASM1):/dg] crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE db19c1 STABLE
ONLINE ONLINE db19c2 STABLE
ora.MGMT_DG.GHCHKPT.advm
OFFLINE OFFLINE db19c1 STABLE
OFFLINE OFFLINE db19c2 STABLE
ora.chad
ONLINE ONLINE db19c1 STABLE
ONLINE ONLINE db19c2 STABLE
ora.helper
OFFLINE OFFLINE db19c1 IDLE,STABLE
OFFLINE OFFLINE db19c2 IDLE,STABLE
ora.mgmt_dg.ghchkpt.acfs
OFFLINE OFFLINE db19c1 STABLE
OFFLINE OFFLINE db19c2 STABLE
ora.net1.network
ONLINE ONLINE db19c1 STABLE
ONLINE ONLINE db19c2 STABLE
ora.ons
ONLINE ONLINE db19c1 STABLE
ONLINE ONLINE db19c2 STABLE
ora.proxy_advm
OFFLINE OFFLINE db19c1 STABLE
OFFLINE OFFLINE db19c2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE db19c1 STABLE
2 ONLINE ONLINE db19c2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA_DG.dg(ora.asmgroup)
1 ONLINE ONLINE db19c1 STABLE
2 ONLINE ONLINE db19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.FRA_DG.dg(ora.asmgroup)
1 ONLINE ONLINE db19c1 STABLE
2 ONLINE ONLINE db19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE db19c1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE db19c1 169.254.3.182 10.10.
20.55,STABLE
ora.MGMT_DG.dg(ora.asmgroup)
1 ONLINE ONLINE db19c1 STABLE
2 ONLINE ONLINE db19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.OCRVOT_DG.dg(ora.asmgroup)
1 ONLINE ONLINE db19c1 STABLE
2 ONLINE ONLINE db19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE db19c1 Started,STABLE
2 ONLINE ONLINE db19c2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE db19c1 STABLE
2 ONLINE ONLINE db19c2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE db19c1 STABLE
ora.db19c1.vip
1 ONLINE ONLINE db19c1 STABLE
ora.db19c2.vip
1 ONLINE ONLINE db19c2 STABLE
ora.mgmtdb
1 ONLINE ONLINE db19c1 Open,STABLE
ora.qosmserver
1 ONLINE ONLINE db19c1 STABLE
ora.rhpserver
1 OFFLINE OFFLINE STABLE
ora.scan1.vip
1 ONLINE ONLINE db19c1 STABLE
--------------------------------------------------------------------------------
[root@db19c1(+ASM1):/dg]
여기서 중요한 부분을 하나 더 체크를 드리면
리스너포트 추가 관련 이야기 입니다.
기본포트는 무조건 1521 포트 입니다. 물론 asm 포트는 다릅니다.
[root@db19c1(+ASM1):/dg] netstat -an | grep LISTEN | grep tcp
tcp 0 0 169.254.23.156:54120 0.0.0.0:* LISTEN
tcp 0 0 169.254.23.156:29322 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:5901 0.0.0.0:* LISTEN
tcp 0 0 169.254.23.156:14285 0.0.0.0:* LISTEN
tcp 0 0 169.254.23.156:19983 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:6000 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:6001 0.0.0.0:* LISTEN
tcp 0 0 192.168.0.59:1521 0.0.0.0:* LISTEN
tcp 0 0 192.168.0.56:1521 0.0.0.0:* LISTEN
tcp 0 0 192.168.0.55:1521 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:6100 0.0.0.0:* LISTEN
tcp 0 0 192.168.0.56:1525 0.0.0.0:* LISTEN
tcp 0 0 169.254.23.156:1525 0.0.0.0:* LISTEN
tcp 0 0 10.10.20.55:1525 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:30517 0.0.0.0:* LISTEN
tcp 0 0 192.168.122.1:53 0.0.0.0:* LISTEN
tcp 0 0 192.168.20.55:1526 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN
tcp 0 0 169.254.23.156:12831 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:2016 0.0.0.0:* LISTEN
tcp6 0 0 192.168.0.55:5000 :::* LISTEN
tcp6 0 0 :::35114 :::* LISTEN
tcp6 0 0 :::10380 :::* LISTEN
tcp6 0 0 :::5901 :::* LISTEN
tcp6 0 0 :::111 :::* LISTEN
tcp6 0 0 :::6000 :::* LISTEN
tcp6 0 0 :::6001 :::* LISTEN
tcp6 0 0 ::1:6100 :::* LISTEN
tcp6 0 0 :::22 :::* LISTEN
tcp6 0 0 ::1:631 :::* LISTEN
tcp6 0 0 :::6200 :::* LISTEN
tcp6 0 0 :::8888 :::* LISTEN
tcp6 0 0 :::8895 :::* LISTEN
tcp6 0 0 127.0.0.1:20640 :::* LISTEN
[root@db19c1(+ASM1):/dg]
[root@db19c2 trace]# netstat -an | grep LISTEN | grep tcp
tcp 0 0 0.0.0.0:26344 0.0.0.0:* LISTEN
tcp 0 0 169.254.14.116:23209 0.0.0.0:* LISTEN
tcp 0 0 169.254.14.116:44495 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:6000 0.0.0.0:* LISTEN
tcp 0 0 192.168.0.58:1521 0.0.0.0:* LISTEN
tcp 0 0 192.168.0.57:1521 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:6100 0.0.0.0:* LISTEN
tcp 0 0 192.168.122.1:53 0.0.0.0:* LISTEN
tcp 0 0 192.168.20.57:1526 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:22 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:2016 0.0.0.0:* LISTEN
tcp6 0 0 192.168.0.57:5000 :::* LISTEN
tcp6 0 0 :::111 :::* LISTEN
tcp6 0 0 :::6000 :::* LISTEN
tcp6 0 0 127.0.0.1:17361 :::* LISTEN
tcp6 0 0 ::1:6100 :::* LISTEN
tcp6 0 0 :::22 :::* LISTEN
tcp6 0 0 ::1:631 :::* LISTEN
tcp6 0 0 :::6200 :::* LISTEN
tcp6 0 0 :::27869 :::* LISTEN
[root@db19c2 trace]#
이런분 있을 겁니다.
포트를 1521를 사용을 하기 싫어서 netca 를 띠워서 포트 추가 하시는 경우 입니다.
추가 되는 경우 아래 처럼 정상적으로 추가는 됩니다.
[root@db19c1(+ASM1):/dg] ps -ef | grep tns
root 14 2 0 20:17 ? 00:00:00 [netns]
grid 18874 1 0 20:23 ? 00:00:00 /dg/app/product/gihome/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
grid 18964 1 0 20:23 ? 00:00:00 /dg/app/product/gihome/bin/tnslsnr LISTENER -no_crs_notify -inherit
grid 18966 1 0 20:23 ? 00:00:00 /dg/app/product/gihome/bin/tnslsnr LISTENER_DB19C -no_crs_notify -inherit
grid 18968 1 0 20:23 ? 00:00:00 /dg/app/product/gihome/bin/tnslsnr MGMTLSNR -no_crs_notify -inherit
grid 18998 1 0 20:23 ? 00:00:00 /dg/app/product/gihome/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit
root 23205 8221 0 20:27 pts/0 00:00:00 grep --color=auto tns
[root@db19c1(+ASM1):/dg]
[root@db19c2(+ASM2):/dg] crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE db19c1 STABLE
ONLINE ONLINE db19c2 STABLE
ora.LISTENER_DB19C.lsnr
ONLINE ONLINE db19c1 STABLE
ONLINE ONLINE db19c2 STABLE
~~ 생략
제가 가이드 드리는것은 db까지 모든 설치 완료 후 포트 변경 및 추가 작업을 해 주시길 바랍니다.
db 설치시 에러 발생 할 수 있는데 그 이유를 보니 포트 충돌이 생길수 있습니다. 따라서 반드시 포트 추가 작업 시 어떤 포트가 열려있고 어떤 포트를 사용하면 가능 하겠다는것을 점검 및 체크 후 사용 하시길 바랍니다.
