DB/Oracle
[RAC][INSTALL] 5_RAC 설치 후 추가 내용
밍구멍구
2023. 3. 2. 16:44
root가 cluster 제어할 수 있도록 bash 적용
su -
vi ~/.bash_profile
아래내용 기입
# User specific environment and startup programs
export ORACLE_HOME=/ora_engine/12c/dbhome_1
export GRID_HOME=/grid_engine/12c/grid
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$GRID_HOME/bin
export PATH
RAC 기동 절차
- 기동 시작 절차 (중지는 반대로 4>3>2>1)
| 순서 | 작업 | 비고 |
| 1 | CRS 시작 | 양쪽 노드에서 |
| 2 | CRS 어플리케이션 시작 | 한 노드에서 |
| 3 | Listerner 시작 | 한 노드에서 |
| 4 | DB 인스턴스 시작 | 한 노드에서 |
(1) CRS 기동 시작
> 항상 시작 후 상태 확인
[root@ol79rac1 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.
[root@ol79rac2 ~]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started.[root@ol79rac2 ~]# crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr
ONLINE ONLINE ol79rac1 STABLE
ONLINE ONLINE ol79rac2 STABLE
ora.DATA.dg
ONLINE ONLINE ol79rac1 STABLE
ONLINE ONLINE ol79rac2 STABLE
ora.LISTENER.lsnr
OFFLINE OFFLINE ol79rac1 STABLE
ONLINE ONLINE ol79rac2 STABLE
ora.MGMT.dg
ONLINE ONLINE ol79rac1 STABLE
ONLINE ONLINE ol79rac2 STABLE
ora.OCR_VOTE.dg
ONLINE ONLINE ol79rac1 STABLE
ONLINE ONLINE ol79rac2 STABLE
ora.RECO.dg
ONLINE ONLINE ol79rac1 STABLE
ONLINE ONLINE ol79rac2 STABLE
ora.net1.network
ONLINE ONLINE ol79rac1 STABLE
ONLINE ONLINE ol79rac2 STABLE
ora.ons
OFFLINE OFFLINE ol79rac1 STABLE
OFFLINE OFFLINE ol79rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE ol79rac1 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE ol79rac1 169.254.234.5 10.0.2
.3,STABLE
ora.asm
1 ONLINE ONLINE ol79rac1 Started,STABLE
2 ONLINE ONLINE ol79rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE ol79rac1 STABLE
ora.ol79rac1.vip
1 ONLINE ONLINE ol79rac1 STABLE
ora.ol79rac2.vip
1 ONLINE ONLINE ol79rac2 STABLE
ora.qosmserver
1 ONLINE ONLINE ol79rac1 STABLE
ora.racdb.db
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
2 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
ora.scan1.vip
1 ONLINE ONLINE ol79rac1 STABLE
--------------------------------------------------------------------------------
(2) CRS 어플리케이션 시작
[root@ol79rac1 ~]# srvctl start nodeapps
PRKO-2421 : Network resource is already started on node(s): ol79rac1,ol79rac2
PRKO-2420 : VIP ol79rac1-vip is already started on nodes: ol79rac1
PRKO-2420 : VIP ol79rac2-vip is already started on nodes: ol79rac2
PRKO-2422 : ONS is already started on node(s): ol79rac1,ol79rac2
(3) listener 시작
[root@ol79rac1 ~]# srvctl start LISTENER[root@ol79rac1 ~]# srvctl status LISTENER
Listener LISTENER is enabled
Listener LISTENER is running on node(s): ol79rac1,ol79rac2or
[root@ol79rac1 ~]# ps -ef | grep tnslsnr
grid 354 1 0 09:51 ? 00:00:00 /grid_engine/12c/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit
root 1307 3765 0 09:52 pts/0 00:00:00 grep --color=auto tnslsnr
grid 23098 1 0 09:45 ? 00:00:00 /grid_engine/12c/grid/bin/tnslsnr ASMNET1LSNR_ASM -no_crs_notify -inherit
grid 23279 1 0 09:45 ? 00:00:00 /grid_engine/12c/grid/bin/tnslsnr LISTENER_SCAN1 -no_crs_notify -inherit
grid 23280 1 0 09:45 ? 00:00:00 /grid_engine/12c/grid/bin/tnslsnr MGMTLSNR -no_crs_notify -inherit
(4) Database 시작
[root@ol79rac1 ~]# srvctl start database -d RACDB[root@ol79rac1 ~]# srvctl status database -d RACDB
Instance RACDB1 is running on node ol79rac1
Instance RACDB2 is running on node ol79rac2or
[root@ol79rac2 ~]# crsctl stat res ora.racdb.db -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.racdb.db
1 ONLINE ONLINE ol79rac1 Open,HOME=/ora_engin
e/12c/dbhome_1,STABL
E
2 ONLINE ONLINE ol79rac2 Open,HOME=/ora_engin
e/12c/dbhome_1,STABL
E
--------------------------------------------------------------------------------crsctl
※ CRSCTL
- oracle clusterware 관리 및 cluster daemon resource(crs,css,evm) 관리하는 유틸리티
클러스터 리소스 시작/정지
클러스터 데몬 사용여부설정 ( enable , disable )
클러스터 상태 체크
클러스터 컴포넌트 Debugging Oracle Clusterware components
srvctl
※ SRVCTL
- DB와 인스턴스, 설정 정보 관리, 인스턴스와 서비스를 이동하거나 제거하는데 쓰이는 유틸리티
(참고 자료 : https://blog.goodusdata.com/100)