내맘대로긍정이 알려주는
Oracle 23ai 신기능
무료 세미나 발표자료
OS환경 : Oracle Linux 8.5 (64bit)
DB 환경 : Oracle Database 19.12.0.0 RAC
방법 : 오라클 19c RAC Grid 문제 시 재설치 가이드
[오라클 19c RAC /etc /opt 등 파일이 제거된 경우 조치방안 https://positivemh.tistory.com/800 ]
작업중 문제로 인해 1번 노드는 grid가 기동되었지만 2번 노드는 root.sh 가 계속 실패하는 현상 발생하여
grid 를 완전히 재설치한뒤 다시 db에 연결하는 방법을 설명함
복구(재설치) 작업절차
1. 2번 노드 grid home 수동 제거
2. ocr, vote disk 초기화
3. ocr, vote disk oracleasm 에 재등록
4. gridSetup
5. DATA disk mount
6. db 등록
[오라클 19c RAC /etc /opt 등 파일이 제거된 경우 조치방안 https://positivemh.tistory.com/800 ] 중
1번 노드 deconfig 후 root.sh 로 정상화
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
# crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE oel19db1 STABLE
ora.chad
OFFLINE OFFLINE oel19db1 STABLE
ora.net1.network
ONLINE ONLINE oel19db1 STABLE
ora.ons
ONLINE ONLINE oel19db1 STABLE
ora.proxy_advm
OFFLINE OFFLINE oel19db1 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE oel19db1 STABLE
ora.OCR_VOTE.dg(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE oel19db1 Started,STABLE
2 ONLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 ONLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE oel19db1 STABLE
ora.oel19db1.vip
1 ONLINE ONLINE oel19db1 STABLE
ora.oel19db2.vip
1 ONLINE INTERMEDIATE oel19db1 FAILED OVER,STABLE
ora.oradb.db
1 ONLINE ONLINE oel19db1 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
2 ONLINE OFFLINE STABLE
ora.qosmserver
1 ONLINE ONLINE oel19db1 STABLE
ora.scan1.vip
1 ONLINE ONLINE oel19db1 STABLE
--------------------------------------------------------------------------------
|
2번 노드 deconfig, root.sh 실패
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
case 1
# cd $GRID_HOME/
# sh root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/app/grid/19c
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /oracle/app/grid/19c/crs/install/crsconfig_params
The log of current session can be found at:
/oracle/app/oracle/crsdata/oel19db2/crsconfig/rootcrs_oel19db2_2022-01-05_11-23-58AM.log
2022/01/05 11:24:00 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.
2022/01/05 11:24:00 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
2022/01/05 11:24:00 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
oracle.ops.mgmt.cluster.ClusterException: scp: /oracle/app/oracle/crsdata/@global/crsconfig/ckptGridHA_global.xml: No such file or directory
2022/01/05 11:24:01 CLSRSC-180: An error occurred while executing the command '/oracle/app/grid/19c/bin/cluutil -copy -sourcefile /oracle/app/oracle/crsdata/@global/crsconfig/ckptGridHA_global.xml -sourcenode oel19db1 -destfile /oracle/app/oracle/crsdata/@global/crsconfig/ckptGridHA_global.xml -nodelist oel19db2'
2022/01/05 11:24:01 CLSRSC-571: failed to copy file '/oracle/app/oracle/crsdata/@global/crsconfig/ckptGridHA_global.xml' from node 'oel19db1' to file '/oracle/app/oracle/crsdata/@global/crsconfig/ckptGridHA_global.xml' on local node
Died at /oracle/app/grid/19c/crs/install/crsutils.pm line 14238.
case 2
# cd $GRID_HOME/
# sh root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/app/grid/19c
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /oracle/app/grid/19c/crs/install/crsconfig_params
The log of current session can be found at:
/oracle/app/oracle/crsdata/oel19db2/crsconfig/rootcrs_oel19db2_2021-12-31_11-58-31PM.log
2021/12/31 23:58:34 CLSRSC-456: The Oracle Grid Infrastructure has already been configured.
|
여러번 테스트로 인해 root.sh 실패 시 내용이 2개임
장애조치
1번 노드 deconfig
1
2
3
4
5
6
7
8
9
10
11
12
13
14
|
# $GRID_HOME/perl/bin/perl $GRID_HOME/crs/install/rootcrs.pl -deconfig -force -verbose -keepdg
Using configuration parameter file: /oracle/app/grid/19c/crs/install/crsconfig_params
The log of current session can be found at:
/oracle/app/oracle/crsdata/oel19db1/crsconfig/crsdeconfig_oel19db1_2022-01-06_03-25-11PM.log
PRCR-1070 : Failed to check if resource ora.net1.network is registered
CRS-0184 : Cannot communicate with the CRS daemon.
PRCR-1070 : Failed to check if resource ora.helper is registered
CRS-0184 : Cannot communicate with the CRS daemon.
PRCR-1070 : Failed to check if resource ora.ons is registered
CRS-0184 : Cannot communicate with the CRS daemon.
2022/01/06 15:25:17 CLSRSC-180: An error occurred while executing the command '/oracle/app/grid/19c/bin/srvctl config nodeapps'
Redirecting to /bin/systemctl restart rsyslog.service
2022/01/06 15:25:39 CLSRSC-336: Successfully deconfigured Oracle Clusterware stack on this node
|
2번 노드 deconfig
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
# $GRID_HOME/perl/bin/perl $GRID_HOME/crs/install/rootcrs.pl -deconfig -force -verbose -keepdg -lastnode
Using configuration parameter file: /oracle/app/grid/19c/crs/install/crsconfig_params
The log of current session can be found at:
/oracle/app/oracle/crsdata/oel19db2/crsconfig/crsdeconfig_oel19db2_2022-01-06_03-27-32PM.log
****Unable to retrieve Oracle Clusterware home.
Start Oracle Clusterware stack and try again.
2022/01/06 15:27:39 CLSRSC-180: An error occurred while executing the command '/oracle/app/grid/19c/bin/srvctl stop cvu -f'
****Unable to retrieve Oracle Clusterware home.
Start Oracle Clusterware stack and try again.
2022/01/06 15:27:32 CLSRSC-180: An error occurred while executing the command '/oracle/app/grid/19c/bin/srvctl remove cvu -f'
2022/01/06 15:27:32 CLSRSC-46: Error: '/oracle/app/oracle/crsdata/oel19db2/crsconfig/srvmcfg4.log' does not exist
2022/01/06 15:27:32 CLSRSC-46: Error: '/oracle/app/oracle/crsdata/oel19db2/crsconfig/srvmcfg4.log' does not exist
****Unable to retrieve Oracle Clusterware home.
Start Oracle Clusterware stack and try again.
2022/01/06 15:27:32 CLSRSC-180: An error occurred while executing the command '/oracle/app/grid/19c/bin/srvctl stop scan_listener -f'
****Unable to retrieve Oracle Clusterware home.
Start Oracle Clusterware stack and try again.
2022/01/06 15:27:32 CLSRSC-180: An error occurred while executing the command '/oracle/app/grid/19c/bin/srvctl remove scan_listener -y -f'
****Unable to retrieve Oracle Clusterware home.
Start Oracle Clusterware stack and try again.
2022/01/06 15:27:32 CLSRSC-180: An error occurred while executing the command '/oracle/app/grid/19c/bin/srvctl stop scan -f'
2022/01/06 15:27:32 CLSRSC-46: Error: '/oracle/app/oracle/crsdata/oel19db2/crsconfig/srvmcfg7.log' does not exist
2022/01/06 15:27:32 CLSRSC-46: Error: '/oracle/app/oracle/crsdata/oel19db2/crsconfig/srvmcfg7.log' does not exist
****Unable to retrieve Oracle Clusterware home.
Start Oracle Clusterware stack and try again.
2022/01/06 15:27:33 CLSRSC-180: An error occurred while executing the command '/oracle/app/grid/19c/bin/srvctl remove scan -y -f'
2022/01/06 15:27:33 CLSRSC-46: Error: '/oracle/app/oracle/crsdata/oel19db2/crsconfig/srvmcfg8.log' does not exist
2022/01/06 15:27:33 CLSRSC-46: Error: '/oracle/app/oracle/crsdata/oel19db2/crsconfig/srvmcfg8.log' does not exist
****Unable to retrieve Oracle Clusterware home.
Start Oracle Clusterware stack and try again.
2022/01/06 15:27:33 CLSRSC-180: An error occurred while executing the command '/oracle/app/grid/19c/bin/srvctl config nodeapps'
CRS-4047: No Oracle Clusterware components configured.
CRS-4000: Command Stop failed, or completed with errors.
CRS-4047: No Oracle Clusterware components configured.
CRS-4000: Command Check failed, or completed with errors.
2022/01/06 15:27:33 CLSRSC-191: Failed to stop Oracle Clusterware stack
Died at /oracle/app/grid/19c/crs/install/crsdeconfig.pm line 479.
|
실패함
/etc/ora~ 남아있는 파일 제거(1번 노드)
1
|
# rm -rf /etc/ora*
|
$GRID_HOME, /etc/ora~ 남아있는 파일 제거(2번 노드)
1
2
|
# rm -rf $GRID_HOME
# rm -rf /etc/ora*
|
oraInventory 백업(양쪽 노드)
1
2
|
# cd /oracle/app/
# mv oraInventory oraInventorybak
|
dd 명령으로 OCR_VOTE용 oracleasm으로 생성한 로우디바이스 헤더 초기화(양쪽 노드)
1
2
3
4
5
6
7
|
# dd if=/dev/oracleasm/disks/OCR_VOTE1 of=/tmp/ocr1.txt bs=1048576 count=100
# dd if=/dev/oracleasm/disks/OCR_VOTE2 of=/tmp/ocr2.txt bs=1048576 count=100
# dd if=/dev/oracleasm/disks/OCR_VOTE3 of=/tmp/ocr3.txt bs=1048576 count=100
# dd if=/dev/zero of=/dev/oracleasm/disks/OCR_VOTE1 bs=1048576 count=50
# dd if=/dev/zero of=/dev/oracleasm/disks/OCR_VOTE2 bs=1048576 count=50
# dd if=/dev/zero of=/dev/oracleasm/disks/OCR_VOTE3 bs=1048576 count=50
|
dd 명령으로 OCR_VOTE용 로우디바이스 헤더 초기화(양쪽 노드)
1
2
3
|
# dd if=/dev/zero of=/dev/19c/OCR_VOTE1 bs=1048576 count=50
# dd if=/dev/zero of=/dev/19c/OCR_VOTE2 bs=1048576 count=50
# dd if=/dev/zero of=/dev/19c/OCR_VOTE3 bs=1048576 count=50
|
제대로 초기화 되었는지 확인(양쪽 노드)
1
2
3
4
5
6
|
# oracleasm querydisk /dev/19c/OCR_VOTE1
Device "/dev/19c/OCR_VOTE1" is not marked as an ASM disk
# oracleasm querydisk /dev/19c/OCR_VOTE2
Device "/dev/19c/OCR_VOTE2" is not marked as an ASM disk
# oracleasm querydisk /dev/19c/OCR_VOTE3
Device "/dev/19c/OCR_VOTE3" is not marked as an ASM disk
|
not marked 로 나오면 초기화가 된것
oracleasm scandisk(양쪽 노드)
1
2
3
4
5
6
7
|
# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Cleaning disk "OCR_VOTE1"
Cleaning disk "OCR_VOTE2"
Cleaning disk "OCR_VOTE3"
Scanning system for ASM disks...
|
oracleasm listdisk(양쪽 노드)
1
2
|
# oracleasm listdisks
DATA01
|
oracleasm createdisk(1번 노드)
1
2
3
4
5
6
7
8
9
10
|
oracleasm createdisk(1번 노드)
# oracleasm createdisk OCR_VOTE1 /dev/19c/OCR_VOTE1
Writing disk header: done
Instantiating disk: done
# oracleasm createdisk OCR_VOTE2 /dev/19c/OCR_VOTE2
Writing disk header: done
Instantiating disk: done
# oracleasm createdisk OCR_VOTE3 /dev/19c/OCR_VOTE3
Writing disk header: done
Instantiating disk: done
|
oracleasm scan 및 listdisk(양쪽 노드)
1
2
3
4
5
6
7
8
9
|
# oracleasm scandisks
Reloading disk partitions: done
Cleaning any stale ASM disks...
Scanning system for ASM disks...
# oracleasm listdisks
DATA01
OCR_VOTE1
OCR_VOTE2
OCR_VOTE3
|
cvuqdisk rpm 재설치 후 2번 노드에 복사(1번 노드)(왜인지 모르겠지만 지워져있어서 재설치)
1
2
3
4
5
6
7
8
9
10
|
# cd $GRID_HOME/cv/rpm
# rpm -Uvh cvuqdisk-1.0.10-1.rpm
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Using default group oinstall to install package
Updating / installing...
1:cvuqdisk-1.0.10-1 ################################# [100%]
# scp cvuqdisk-1.0.10-1.rpm 192.168.137.20:/root
root@192.168.137.20's password:
cvuqdisk-1.0.10-1.rpm 100% 11KB 7.1MB/s 00:00
|
cvuqdisk rpm 재설치(2번 노드)
1
2
3
4
5
6
7
|
cvuqdisk rpm 재설치(2번 노드)
# rpm -Uvh cvuqdisk-1.0.10-1.rpm
Verifying... ################################# [100%]
Preparing... ################################# [100%]
Using default group oinstall to install package
Updating / installing...
1:cvuqdisk-1.0.10-1 ################################# [100%]
|
grid 재설치를 위한 권한 재부여(양쪽노드)
1
2
|
# chown -R oracle:dba /oracle/
# chmod -R 755 /oracle/
|
gridSetup 진행(1번 노드)
1
2
3
|
# su - oracle
$ cd $GRID_HOME/
$ ./gridSetup.sh
|
Configure Oracle Grid Infrastructure for a New Cluster 선택
Configure an Oracle Standalone Cluster 선택
SCAN 정보 입력
ADD 선택
2번 노드 정보 입력
패스워드 없는 ssh 연결설정은 이미 되어있으므로 Next
ASM & Private로 선택
Use Oracle Flex ASM for storage 선택
No 선택
OCR_VOTE 입력 후 Normal 선택
디스크가 안나올 경우 Change Discovery Path 선택
Change Discovery Path 선택 후 경로 입력 후 OK(/dev/oracleasm/disks)
disk 3개 선택 후 Next
패스워드 oracle 입력
Yes 선택
Do not use IPMI 선택
EM 체크하지 않고 다음
그룹 dba로 선택
Yes 선택
oracle base 지정
Yes 선택
Next
사전 요구사항 체크중
패키지도 이미 설치되어있고 NTP는 사용하지않고
SCAN 관련메세지는 SCAN IP가 DNS에 등록되어 있지 않아서 발생한 문제 모두 Ignore
response 파일이 필요하다면 따로 저장 후 Install
첫번째 스크립트부터 복사 후 root 유저로 실행
orainstRoot.sh 실행(1번 노드 실행 후 2번 노드 실행)
1
2
3
4
5
6
7
|
# /oracle/app/oraInventory/orainstRoot.sh
Changing permissions of /oracle/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /oracle/app/oraInventory to dba.
The execution of the script is complete.
|
root.sh 실행(1번 노드)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
# /oracle/app/grid/19c/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/app/grid/19c
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /oracle/app/grid/19c/crs/install/crsconfig_params
The log of current session can be found at:
/oracle/app/oracle/crsdata/oel19db1/crsconfig/rootcrs_oel19db1_2022-01-06_03-52-01PM.log
2022/01/06 15:52:06 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.
2022/01/06 15:52:06 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
2022/01/06 15:52:06 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
2022/01/06 15:52:08 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.
2022/01/06 15:52:08 CLSRSC-4004: Failed to install Oracle Trace File Analyzer (TFA) Collector. Grid Infrastructure operations will continue.
2022/01/06 15:52:08 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.
Redirecting to /bin/systemctl restart rsyslog.service
2022/01/06 15:52:09 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.
2022/01/06 15:52:09 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.
2022/01/06 15:52:16 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.
2022/01/06 15:52:18 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.
2022/01/06 15:52:26 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.
2022/01/06 15:52:26 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.
2022/01/06 15:52:29 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.
2022/01/06 15:52:29 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2022/01/06 15:52:47 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2022/01/06 15:52:47 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2022/01/06 15:53:05 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2022/01/06 15:53:09 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
ASM has been created and started successfully.
[DBT-30001] Disk groups created successfully. Check /oracle/app/oracle/cfgtoollogs/asmca/asmca-220106PM035338.log for details.
2022/01/06 15:54:32 CLSRSC-482: Running command: '/oracle/app/grid/19c/bin/ocrconfig -upgrade oracle dba'
CRS-4256: Updating the profile
Successful addition of voting disk 3d353ab18a7d4f42bfddda8ca95ab3d7.
Successful addition of voting disk b79437dae8024f54bf8fc6785507f8ce.
Successful addition of voting disk 72214d7f509a4f46bf5e3c2e6d0c4f82.
Successfully replaced voting disk group with +OCR_VOTE.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 3d353ab18a7d4f42bfddda8ca95ab3d7 (/dev/oracleasm/disks/OCR_VOTE1) [OCR_VOTE]
2. ONLINE b79437dae8024f54bf8fc6785507f8ce (/dev/oracleasm/disks/OCR_VOTE2) [OCR_VOTE]
3. ONLINE 72214d7f509a4f46bf5e3c2e6d0c4f82 (/dev/oracleasm/disks/OCR_VOTE3) [OCR_VOTE]
Located 3 voting disk(s).
2022/01/06 15:55:36 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2022/01/06 15:56:30 CLSRSC-343: Successfully started Oracle Clusterware stack
2022/01/06 15:56:30 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2022/01/06 15:57:21 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2022/01/06 15:57:34 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
|
root.sh 실행(2번 노드)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
|
# /oracle/app/grid/19c/root.sh
Performing root user operation.
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /oracle/app/grid/19c
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Relinking oracle with rac_on option
Using configuration parameter file: /oracle/app/grid/19c/crs/install/crsconfig_params
The log of current session can be found at:
/oracle/app/oracle/crsdata/oel19db2/crsconfig/rootcrs_oel19db2_2022-01-06_03-58-42PM.log
2022/01/06 15:58:45 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.
2022/01/06 15:58:45 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.
2022/01/06 15:58:45 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.
2022/01/06 15:58:46 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.
2022/01/06 15:58:46 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.
Redirecting to /bin/systemctl restart rsyslog.service
2022/01/06 15:58:46 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.
2022/01/06 15:58:47 CLSRSC-4004: Failed to install Oracle Trace File Analyzer (TFA) Collector. Grid Infrastructure operations will continue.
2022/01/06 15:58:47 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.
2022/01/06 15:58:47 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.
2022/01/06 15:58:47 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.
2022/01/06 15:58:50 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.
2022/01/06 15:58:51 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.
2022/01/06 15:58:51 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.
2022/01/06 15:58:52 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2022/01/06 15:59:07 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2022/01/06 15:59:07 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2022/01/06 15:59:23 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2022/01/06 15:59:24 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
2022/01/06 15:59:32 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2022/01/06 16:00:12 CLSRSC-343: Successfully started Oracle Clusterware stack
2022/01/06 16:00:12 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2022/01/06 16:00:21 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2022/01/06 16:00:28 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
|
스크립트 모두 실행후 OK
SCAN IP가 DNS에 등록되어 있지 않아서 발생한 문제 무시 해도됨 OK
Yes
grid 설치 완료
완료 후 grid 상태 확인
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
|
# crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE oel19db1 STABLE
ONLINE ONLINE oel19db2 STABLE
ora.chad
ONLINE ONLINE oel19db1 STABLE
ONLINE ONLINE oel19db2 STABLE
ora.net1.network
ONLINE ONLINE oel19db1 STABLE
ONLINE ONLINE oel19db2 STABLE
ora.ons
ONLINE ONLINE oel19db1 STABLE
ONLINE ONLINE oel19db2 STABLE
ora.proxy_advm
OFFLINE OFFLINE oel19db1 STABLE
OFFLINE OFFLINE oel19db2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 ONLINE ONLINE oel19db2 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE oel19db1 STABLE
ora.OCR_VOTE.dg(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 ONLINE ONLINE oel19db2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE oel19db1 Started,STABLE
2 ONLINE ONLINE oel19db2 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 ONLINE ONLINE oel19db2 STABLE
ora.cvu
1 ONLINE ONLINE oel19db1 STABLE
ora.oel19db1.vip
1 ONLINE ONLINE oel19db1 STABLE
ora.oel19db2.vip
1 ONLINE ONLINE oel19db2 STABLE
ora.qosmserver
1 ONLINE ONLINE oel19db1 STABLE
ora.scan1.vip
1 ONLINE ONLINE oel19db1 STABLE
--------------------------------------------------------------------------------
|
OCR_VOTE는 있지만 DATA 리소스와 db 리소스는 없음
asmca로 DATA diskgroup mount
1
|
$ asmca
|
Disk Groups 선택
DATA가 DISMOUNTED 상태임
Mount All 선택
Yes 선택
DATA도 mount 됨
mount 후 재확인
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
|
$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE oel19db1 STABLE
ONLINE ONLINE oel19db2 STABLE
ora.chad
ONLINE ONLINE oel19db1 STABLE
ONLINE ONLINE oel19db2 STABLE
ora.net1.network
ONLINE ONLINE oel19db1 STABLE
ONLINE ONLINE oel19db2 STABLE
ora.ons
ONLINE ONLINE oel19db1 STABLE
ONLINE ONLINE oel19db2 STABLE
ora.proxy_advm
OFFLINE OFFLINE oel19db1 STABLE
OFFLINE OFFLINE oel19db2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 ONLINE ONLINE oel19db2 STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 ONLINE ONLINE oel19db2 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE oel19db1 STABLE
ora.OCR_VOTE.dg(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 ONLINE ONLINE oel19db2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE oel19db1 Started,STABLE
2 ONLINE ONLINE oel19db2 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 ONLINE ONLINE oel19db2 STABLE
ora.cvu
1 ONLINE ONLINE oel19db1 STABLE
ora.oel19db1.vip
1 ONLINE ONLINE oel19db1 STABLE
ora.oel19db2.vip
1 ONLINE ONLINE oel19db2 STABLE
ora.qosmserver
1 ONLINE ONLINE oel19db1 STABLE
ora.scan1.vip
1 ONLINE ONLINE oel19db1 STABLE
--------------------------------------------------------------------------------
|
db 리소스 등록
1
2
3
|
$ srvctl add database -d ORADB -o $ORACLE_HOME
$ srvctl add instance -d ORADB -i ORADB1 -n oel19db1
$ srvctl add instance -d ORADB -i ORADB2 -n oel19db2
|
db 기동
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
|
$ srvctl start database -d ORADB
PRCR-1079 : Failed to start resource ora.oradb.db
CRS-5017: The resource action "ora.oradb.db start" encountered the following error:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/app/oracle/product/19c/dbs/initORADB2.ora'
. For details refer to "(:CLSN00107:)" in "/oracle/app/oracle/diag/crs/oel19db2/crs/trace/crsd_oraagent_oracle.trc".
CRS-5017: The resource action "ora.oradb.db start" encountered the following error:
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/app/oracle/product/19c/dbs/initORADB1.ora'
. For details refer to "(:CLSN00107:)" in "/oracle/app/oracle/diag/crs/oel19db1/crs/trace/crsd_oraagent_oracle.trc".
CRS-2674: Start of 'ora.oradb.db' on 'oel19db2' failed
CRS-2632: There are no more servers to try to place resource 'ora.oradb.db' on that would satisfy its placement policy
CRS-2674: Start of 'ora.oradb.db' on 'oel19db1' failed
|
실패함 파라미터파일을 찾지못함
파라미터 파일 확인
1
2
3
|
$ cd $ORACLE_HOME/dbs
$ ls
hc_ORADB1.dat id_ORADB1.dat init.ora
|
없음
asm에서 파라미터파일 확인
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
$ asmcmd
ASMCMD> ls
DATA/
OCR_VOTE/
ASMCMD> cd DATA
ASMCMD> ls
ORADB/
ASMCMD> cd ORADB
ASMCMD> ls
CONTROLFILE/
DATAFILE/
ONLINELOG/
PARAMETERFILE/
PASSWORD/
TEMPFILE/
ASMCMD> cd PARAMETERFILE
ASMCMD> ls
spfile.268.1086046877
ASMCMD> pwd
+DATA/ORADB/PARAMETERFILE
ASMCMD> exit
|
파라미터파일 생성 후 asm경로를 바라보게끔 설정(1번 노드)
1
2
3
|
$ cd $ORACLE_HOME/dbs
$ vi initORADB1.ora
spfile='+DATA/ORADB/PARAMETERFILE/spfile.268.1086046877'
|
파라미터파일 생성 후 asm경로를 바라보게끔 설정(2번 노드)
1
2
3
|
$ cd $ORACLE_HOME/dbs
$ vi initORADB2.ora
spfile='+DATA/ORADB/PARAMETERFILE/spfile.268.1086046877'
|
다시 db 기동
1
|
$ srvctl start database -d ORADB
|
grid 상태 확인
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
|
$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE oel19db1 STABLE
ONLINE ONLINE oel19db2 STABLE
ora.chad
ONLINE ONLINE oel19db1 STABLE
ONLINE ONLINE oel19db2 STABLE
ora.net1.network
ONLINE ONLINE oel19db1 STABLE
ONLINE ONLINE oel19db2 STABLE
ora.ons
ONLINE ONLINE oel19db1 STABLE
ONLINE ONLINE oel19db2 STABLE
ora.proxy_advm
OFFLINE OFFLINE oel19db1 STABLE
OFFLINE OFFLINE oel19db2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 ONLINE ONLINE oel19db2 STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 ONLINE ONLINE oel19db2 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE oel19db1 STABLE
ora.OCR_VOTE.dg(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 ONLINE ONLINE oel19db2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE oel19db1 Started,STABLE
2 ONLINE ONLINE oel19db2 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE oel19db1 STABLE
2 ONLINE ONLINE oel19db2 STABLE
ora.cvu
1 ONLINE ONLINE oel19db1 STABLE
ora.oel19db1.vip
1 ONLINE ONLINE oel19db1 STABLE
ora.oel19db2.vip
1 ONLINE ONLINE oel19db2 STABLE
ora.oradb.db
1 ONLINE ONLINE oel19db1 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
2 ONLINE ONLINE oel19db2 Open,HOME=/oracle/ap
p/oracle/product/19c
,STABLE
ora.qosmserver
1 ONLINE ONLINE oel19db1 STABLE
ora.scan1.vip
1 ONLINE ONLINE oel19db1 STABLE
--------------------------------------------------------------------------------
|
db도 정상적으로 open 됨
db 상태 확인
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Thu Jan 6 16:09:26 2022
Version 19.12.0.0.0
Copyright (c) 1982, 2021, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.12.0.0.0
SQL> select instance_name, version, status from gv$instance;
INSTANCE_NAME VERSION STATUS
---------------- ----------------- ------------
ORADB1 19.0.0.0.0 OPEN
ORADB2 19.0.0.0.0 OPEN
|
정상
패치 정보 확인
1
2
3
4
5
6
7
8
9
|
$ cd $ORACLE_HOME/OPatch
$ ./opatch lspatches
List of Homes on this system:
Home name= OraGI19Home1, Location= "/oracle/app/grid/19c"
Inventory load failed... LsPatchesSession::loadAndPrintInstalledPatch()
LsPatchesSession failed: RawInventory gets null OracleHomeInfo
OPatch failed with error code 2
|
oraInvnetory가 새로 생성되서 패치 정보 확인이 되지않음
현재 oraInvnetory의 ContentsXML/inventory.xml 확인
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
$ cat /oracle/app/oraInventory/ContentsXML/inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2021, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>12.2.0.7.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraGI19Home1" LOC="/oracle/app/grid/19c" TYPE="O" IDX="1" CRS="true"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
|
db home 정보가 없음
기존에 백업해두었던 oraInvnetory 중 ContentsXML/inventory.xml 확인
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
$ cat /oracle/app/oraInventorybak/ContentsXML/inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2021, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>12.2.0.7.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraGI19Home1" LOC="/oracle/app/grid/19c" TYPE="O" IDX="1" CRS="true"/>
<HOME NAME="OraDB19Home1" LOC="/oracle/app/oracle/product/19c" TYPE="O" IDX="2"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
|
ORACLE HOME 에 대해 oraInventory 재등록(양쪽 노드)
1
2
3
4
5
6
7
8
9
|
$ cd $ORACLE_HOME/oui/bin
$ ./runInstaller -silent -ignoreSysPrereqs -attachHome ORACLE_HOME=$ORACLE_HOME ORACLE_HOME_NAME="OraDB19Home1"
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 7712 MB Passed
The inventory pointer is located at /etc/oraInst.loc
You can find the log of this install session at:
/oracle/app/oraInventory/logs/AttachHome2022-01-06_04-10-23PM.log
'AttachHome' was successful.
|
재등록후 oraInvnetory의 ContentsXML/inventory.xml 확인
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
$ cat /oracle/app/oraInventory/ContentsXML/inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2022, Oracle and/or its affiliates.
All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>12.2.0.7.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="OraGI19Home1" LOC="/oracle/app/grid/19c" TYPE="O" IDX="1" CRS="true"/>
<HOME NAME="OraDB19Home1" LOC="/oracle/app/oracle/product/19c" TYPE="O" IDX="2"/>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
|
정상적으로 db 정보가 등록됨
다시 패치정보 확인(양쪽 노드)
1
2
3
4
5
|
$ cd $ORACLE_HOME/OPatch
$ ./opatch lspatches
32876380;OJVM RELEASE UPDATE: 19.12.0.0.210720 (32876380)
32916816;OCW RELEASE UPDATE 19.12.0.0.0 (32916816)
32904851;Database Release Update : 19.12.0.0.210720 (32904851)
|
정상적으로 확인됨
참조 : 1377349.1, 1354258.1, 2571719.1, 563048.1, 556834.1
https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/unconfiguring-oracle-clusterware-without-removing-binaries.html#GUID-41C5E8EE-68F9-4849-B4B8-BD82D4A17A57
https://pat98.tistory.com/1068
https://positivemh.tistory.com/762
https://positivemh.tistory.com/800
'ORACLE > Rac' 카테고리의 다른 글
오라클 12c R2 RAC to RAC ADG redo log 삭제 및 추가 및 리사이즈 하기 (0) | 2022.06.27 |
---|---|
오라클 11g R2 RAC OS 커널 패치시 작업 가이드 (0) | 2022.01.15 |
오라클 19c RAC /etc /opt 등 파일이 제거된 경우 조치방안 (2) | 2022.01.01 |
오라클 19c RAC ora.chad 리소스 offline 인 경우 조치방안 (0) | 2021.12.31 |
오라클 19c RAC sqlnet.ora SQLNET.AUTHENTICATION_SERVICES = (NONE) 설정 시 발생하는 문제 (0) | 2021.12.26 |