"CRSCTL 명령어"의 두 판 사이의 차이
DB CAFE
(→crs autorestart Enable/Disable) |
(→crsctl 명령어) |
||
(같은 사용자의 중간 판 12개는 보이지 않습니다) | |||
1번째 줄: | 1번째 줄: | ||
== crsctl 명령어 == | == crsctl 명령어 == | ||
− | === crs autorestart Enable/Disable === | + | * oracle docs |
+ | *:https://docs.oracle.com/database/121/CWADD/GUID-6A4E73C4-E1A0-4D90-B69A-7B2B4DAB66BA.htm#CWADD91595 | ||
+ | |||
+ | === crs autorestart Enable/Disable === | ||
* Run as root user | * Run as root user | ||
<source lang=sql> | <source lang=sql> | ||
10번째 줄: | 13번째 줄: | ||
</source> | </source> | ||
+ | === crs Stop/Start === | ||
+ | <source lang=sql> | ||
+ | -- stop crs ( run from root) | ||
+ | $GRID_HOME/bin/crsctl stop crs | ||
+ | |||
+ | -- start crs( run from root) | ||
+ | $GRID_HOME/bin/crsctl start crs | ||
+ | </source> | ||
=== RAC에서 클러스터 명 찾기 === | === RAC에서 클러스터 명 찾기 === | ||
<source lang=sql> | <source lang=sql> | ||
$GRID_HOME/bin/cemutlo -n | $GRID_HOME/bin/cemutlo -n | ||
+ | -- or | ||
+ | $GRID_HOME/bin/olsnodes -c | ||
+ | </source> | ||
+ | |||
+ | === voting disk 위치 조회 === | ||
+ | <source lang=sql> | ||
+ | $GRID_HOME/bin/crsctl query css votedisk | ||
+ | </source> | ||
+ | |||
+ | === OCR 위치 조회 === | ||
+ | <source lang=sql> | ||
+ | $GRID_HOME/bin/ocrcheck | ||
+ | </source> | ||
+ | |||
+ | === 그리드 버전 조회 === | ||
+ | <source lang=sql> | ||
+ | $GRID_HOME/bin/crsctl query crs softwareversion | ||
+ | </source> | ||
+ | |||
+ | === 클러스터 컴포넌트 상태 체크 === | ||
+ | <source lang=sql> | ||
+ | $GRID_HOME/bin/crsctl stat res -t | ||
+ | |||
+ | $GRID_HOME/bin/crsctl check crs | ||
+ | |||
+ | $GRID_HOME/bin/crsctl check cssd | ||
+ | |||
+ | $GRID_HOME/bin/crsctl check crsd | ||
+ | |||
+ | $GRID_HOME/bin/crsctl check evmd | ||
+ | </source> | ||
+ | |||
+ | === cluster_interconnect 상세조회 === | ||
+ | <source lang=sql> | ||
+ | $GRID_HOME/bin/oifcfg getif | ||
+ | |||
+ | app-ipmp0 172.21.39.128 global public | ||
+ | loypredbib0 172.16.3.192 global cluster_interconnect | ||
+ | loypredbib1 172.16.4.0 global cluster_interconnect | ||
+ | |||
+ | select NAME,IP_ADDRESS from v$cluster_interconnects; | ||
+ | |||
+ | NAME IP_ADDRESS | ||
+ | --------------- ---------------- | ||
+ | loypredbib0 172.16.3.193 | ||
+ | loypredbib1 172.16.4.1 | ||
+ | </source> | ||
+ | |||
+ | ===ocr /list 수동 백업 === | ||
+ | <source lang=sql> | ||
+ | List down the backups of OCR | ||
+ | |||
+ | $GRID_HOME/bin/ocrconfig -showbackup | ||
+ | |||
+ | |||
+ | |||
+ | Take manual OCR backup | ||
+ | |||
+ | $GRID_HOME/bin/ocrconfig -manualbackup | ||
+ | </source> | ||
+ | |||
+ | === Voting Disk를 새로운 DistGroup으로 이동하기 === | ||
+ | <source lang=sql> | ||
+ | $GRID_HOME/bin/crsctl replace votedisk +NEW_DG | ||
+ | |||
+ | -- Check the status using below command | ||
+ | $GRID_HOME/bin/crsctl query css votedisk | ||
+ | </source> | ||
+ | |||
+ | === 디스크 타임아웃 조회 === | ||
+ | * Disk timeout from node to voting disk(disktimeout) | ||
+ | <source lang=sql> | ||
+ | crsctl get css disktimeout | ||
+ | |||
+ | CRS-4678: Successful get disktimeout 200 for Cluster Synchronization Services. | ||
+ | </source> | ||
+ | |||
+ | * Network latency in the node interconnect (Misscount) | ||
+ | <source lang=sql> | ||
+ | crsctl get css misscount | ||
+ | |||
+ | CRS-4678: Successful get misscount 30 for Cluster Synchronization Services. | ||
+ | </source> | ||
+ | |||
+ | === olsnode를 이용한 node 정보 조회 === | ||
+ | <source lang=sql> | ||
+ | -- List of nodes in the cluster | ||
+ | olsnodes | ||
+ | |||
+ | -- Nodes with node number | ||
+ | olsnodes -n | ||
+ | |||
+ | -- Node with vip | ||
+ | olsnodes -i | ||
+ | olsnodes -s -t | ||
+ | |||
+ | -- Leaf or Hub | ||
+ | olsnodes -a | ||
+ | |||
+ | -- Getting private ip details of the local node | ||
+ | olsnodes -l -p | ||
+ | |||
+ | -- Get cluster name | ||
+ | olsnodes -c | ||
+ | </source> | ||
+ | |||
+ | === 클러스터 환경설정 정보 조회 === | ||
+ | <source lang=sql> | ||
+ | $ crsctl get cluster configuration | ||
+ | |||
+ | Name : dbaclass-cluster | ||
+ | Configuration : Cluster | ||
+ | Class : Standalone Cluster | ||
+ | Type : flex | ||
+ | The cluster is not extended. | ||
+ | -------------------------------------------------------------------------------- | ||
+ | MEMBER CLUSTER INFORMATION | ||
+ | |||
+ | Name Version GUID Deployed Deconfigured | ||
+ | ================================================================================ | ||
+ | ================================================================================ | ||
+ | </source> | ||
+ | |||
+ | <source lang=sql> | ||
+ | $ crsctl get node role status -all | ||
+ | |||
+ | Node 'hostnode1' active role is 'hub' | ||
+ | Node 'hostnode2' active role is 'hub' | ||
+ | </source> | ||
− | + | === RAC 인터페이스 정보조회 === | |
+ | <source lang=sql> | ||
+ | oifcfg iflist -p -n | ||
− | $GRID_HOME/bin/ | + | backup0 172.21.56.0 PRIVATE 255.255.254.0 |
+ | cdnet0 162.168.1.0 PRIVATE 255.255.255.0 | ||
+ | cdnet0 169.254.0.0 PUBLIC 255.255.128.0 | ||
+ | cdnet1 162.168.2.0 PRIVATE 255.255.255.0 | ||
+ | cdnet1 169.254.128.0 PUBLIC 255.255.128.0 | ||
+ | pap-ipmp0 172.20.179.128 PUBLIC 255.255.255.128 | ||
+ | tan-ipmp0 172.20.128.0 PRIVATE 255.255.252.0 | ||
+ | dppp0 162.168.224.0 PRIVATE 255.255.255.0 | ||
+ | </source> | ||
+ | |||
+ | === RAC - OLR(Oracle Local Registry) === | ||
+ | * OLR(ORACLE LOCAL REGISTRY) | ||
+ | <source lang=sql> | ||
+ | -- Get current OLR location:(run from root only) | ||
+ | $GRID_HOME/bin/ocrcheck -local | ||
+ | |||
+ | -- List the OLR backups: | ||
+ | $GRID_HOME/bin/ocrconfig -local -showbackup | ||
+ | |||
+ | -- Take manual OLR backup: | ||
+ | $GRID_HOME/bin/ocrconfig -local -manualbackup | ||
</source> | </source> | ||
+ | |||
+ | [[category:oracle]] |
2024년 8월 20일 (화) 18:47 기준 최신판
thumb_up 추천메뉴 바로가기
- DBA { Oracle DBA 명령어 > DBA 초급 과정 > DBA 고급 과정 }
- 튜닝 { 오라클 튜닝 목록 }
- 모델링 { 데이터 모델링 가이드 }
목차
- 1 crsctl 명령어
- 1.1 crs autorestart Enable/Disable
- 1.2 crs Stop/Start
- 1.3 RAC에서 클러스터 명 찾기
- 1.4 voting disk 위치 조회
- 1.5 OCR 위치 조회
- 1.6 그리드 버전 조회
- 1.7 클러스터 컴포넌트 상태 체크
- 1.8 cluster_interconnect 상세조회
- 1.9 ocr /list 수동 백업
- 1.10 Voting Disk를 새로운 DistGroup으로 이동하기
- 1.11 디스크 타임아웃 조회
- 1.12 olsnode를 이용한 node 정보 조회
- 1.13 클러스터 환경설정 정보 조회
- 1.14 RAC 인터페이스 정보조회
- 1.15 RAC - OLR(Oracle Local Registry)
1 crsctl 명령어[편집]
- oracle docs
1.1 crs autorestart Enable/Disable[편집]
- Run as root user
$GRID_HOME/bin/crsctl enable crs
CRS-4622: Oracle High Availability Services autostart is enabled.
$GRID_HOME/bin/crsctl disable crs
CRS-4621: Oracle High Availability Services autostart is disabled.
1.2 crs Stop/Start[편집]
-- stop crs ( run from root)
$GRID_HOME/bin/crsctl stop crs
-- start crs( run from root)
$GRID_HOME/bin/crsctl start crs
1.3 RAC에서 클러스터 명 찾기[편집]
$GRID_HOME/bin/cemutlo -n
-- or
$GRID_HOME/bin/olsnodes -c
1.4 voting disk 위치 조회[편집]
$GRID_HOME/bin/crsctl query css votedisk
1.5 OCR 위치 조회[편집]
$GRID_HOME/bin/ocrcheck
1.6 그리드 버전 조회[편집]
$GRID_HOME/bin/crsctl query crs softwareversion
1.7 클러스터 컴포넌트 상태 체크[편집]
$GRID_HOME/bin/crsctl stat res -t
$GRID_HOME/bin/crsctl check crs
$GRID_HOME/bin/crsctl check cssd
$GRID_HOME/bin/crsctl check crsd
$GRID_HOME/bin/crsctl check evmd
1.8 cluster_interconnect 상세조회[편집]
$GRID_HOME/bin/oifcfg getif
app-ipmp0 172.21.39.128 global public
loypredbib0 172.16.3.192 global cluster_interconnect
loypredbib1 172.16.4.0 global cluster_interconnect
select NAME,IP_ADDRESS from v$cluster_interconnects;
NAME IP_ADDRESS
--------------- ----------------
loypredbib0 172.16.3.193
loypredbib1 172.16.4.1
1.9 ocr /list 수동 백업[편집]
List down the backups of OCR
$GRID_HOME/bin/ocrconfig -showbackup
Take manual OCR backup
$GRID_HOME/bin/ocrconfig -manualbackup
1.10 Voting Disk를 새로운 DistGroup으로 이동하기[편집]
$GRID_HOME/bin/crsctl replace votedisk +NEW_DG
-- Check the status using below command
$GRID_HOME/bin/crsctl query css votedisk
1.11 디스크 타임아웃 조회[편집]
- Disk timeout from node to voting disk(disktimeout)
crsctl get css disktimeout
CRS-4678: Successful get disktimeout 200 for Cluster Synchronization Services.
- Network latency in the node interconnect (Misscount)
crsctl get css misscount
CRS-4678: Successful get misscount 30 for Cluster Synchronization Services.
1.12 olsnode를 이용한 node 정보 조회[편집]
-- List of nodes in the cluster
olsnodes
-- Nodes with node number
olsnodes -n
-- Node with vip
olsnodes -i
olsnodes -s -t
-- Leaf or Hub
olsnodes -a
-- Getting private ip details of the local node
olsnodes -l -p
-- Get cluster name
olsnodes -c
1.13 클러스터 환경설정 정보 조회[편집]
$ crsctl get cluster configuration
Name : dbaclass-cluster
Configuration : Cluster
Class : Standalone Cluster
Type : flex
The cluster is not extended.
--------------------------------------------------------------------------------
MEMBER CLUSTER INFORMATION
Name Version GUID Deployed Deconfigured
================================================================================
================================================================================
$ crsctl get node role status -all
Node 'hostnode1' active role is 'hub'
Node 'hostnode2' active role is 'hub'
1.14 RAC 인터페이스 정보조회[편집]
oifcfg iflist -p -n
backup0 172.21.56.0 PRIVATE 255.255.254.0
cdnet0 162.168.1.0 PRIVATE 255.255.255.0
cdnet0 169.254.0.0 PUBLIC 255.255.128.0
cdnet1 162.168.2.0 PRIVATE 255.255.255.0
cdnet1 169.254.128.0 PUBLIC 255.255.128.0
pap-ipmp0 172.20.179.128 PUBLIC 255.255.255.128
tan-ipmp0 172.20.128.0 PRIVATE 255.255.252.0
dppp0 162.168.224.0 PRIVATE 255.255.255.0
1.15 RAC - OLR(Oracle Local Registry)[편집]
- OLR(ORACLE LOCAL REGISTRY)
-- Get current OLR location:(run from root only)
$GRID_HOME/bin/ocrcheck -local
-- List the OLR backups:
$GRID_HOME/bin/ocrconfig -local -showbackup
-- Take manual OLR backup:
$GRID_HOME/bin/ocrconfig -local -manualbackup