프린트 하기

OS환경 : Oracle Linux 8.4 (64bit)

 

DB 환경 : Oracle Database 19.12.0.0 RAC ADG

 

OS 및 사전 설정은 아래 게시물 참조

Oracle Linux 8.4에 Oracle 19c RAC to RAC ADG 설치 가이드_Part 1(https://positivemh.tistory.com/824)

 

방법 : Oracle Linux 8.4에 Oracle 19c RAC to RAC ADG 설치 가이드_Part 2

기존 RAC
1번 노드 hostname : oel19db1, db_name : ORADB, db_unique_name : ORADB, ip : 192.168.137.10
1번 노드 hostname : oel19db2, db_name : ORADB, db_unique_name : ORADB, ip : 192.168.137.20

ADG 추가 구성
1번 노드(Standby) hostname : oel19adg1, db_name : ORADB, db_unique_name : ORAADG, ip : 192.168.137.50
1번 노드(Standby) hostname : oel19adg2, db_name : ORADB, db_unique_name : ORAADG, ip : 192.168.137.60

 

 

설치파일은 아래 4가지 파일을 이용함
GRID : LINUX.X64_193000_grid_home.zip
DB : LINUX.X64_193000_db_home.zip
OPatch : p6880880_190000_Linux-x86-64.zip(12.2.0.1.27)
RU : p32900083_190000_Linux-x86-64.zip
Patch 32900083 - Combo of OJVM Component Release Update 19.12.0.0.210720 + Grid Infrastructure Jul 2021 Release Update 19.12.0.0.210720
 ㄴ Patch 32895426 - Database Grid Infrastructure Jul 2021 Release Update 19.12.0.0.210720
 ㄴ Patch 32876380 - Oracle JavaVM Component Release Update 19.12.0.0.210720

 

 

GRID 설치

node1 에서 작업, GRID 설치파일 압축해제

1
2
$ cd $GRID_HOME
$ unzip /oracle/media/LINUX.X64_193000_grid_home.zip 

 

 

cvu rpm 설치(root 계정)

1
2
3
4
5
6
# rpm -ivh /oracle/app/grid/19c/cv/rpm/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%]

 

 

node2에도 rpm 설치(root 계정)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
1번 노드
# rsync --progress /oracle/app/grid/19c/cv/rpm/cvuqdisk-1.0.10-1.rpm oel19adg2:/root/
The authenticity of host 'oel19adg2 (192.168.137.60)' can't be established.
ECDSA key fingerprint is SHA256:sjdPi5sB0qgCnhO4Z8Ubftcl47tdoI9pOafXi0H5Na4.
Are you sure you want to continue connecting (yes/no/[fingerprint])? yes
Warning: Permanently added 'oel19adg2,192.168.137.60' (ECDSA) to the list of known hosts.
root@oel19adg2's password: 
cvuqdisk-1.0.10-1.rpm
         11,412 100%    0.00kB/s    0:00:00 (xfr#1, to-chk=0/1)
 
2번 노드
# rpm -ivh /root/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%]

 

 

OPatch 파일 최신파일로 교체

1
2
3
4
5
6
7
$ cd $GRID_HOME
$ mv OPatch/ OPatchold
$ unzip /oracle/media/p6880880_190000_Linux-x86-64.zip
$ $GRID_HOME/OPatch/opatch version -oh $GRID_HOME
OPatch Version: 12.2.0.1.27
 
OPatch succeeded.

 

 

ssh 수동 설정(yes, 패스워드 입력)

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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
$ cd $GRID_HOME/oui/prov/resources/scripts
$ ./sshUserSetup.sh -user oracle -hosts "oel19adg1 oel19adg2" -noPromptPassphrase -advanced
The output of this script is also logged into /tmp/sshUserSetup_2022-04-06-19-45-13.log
Hosts are oel19adg1 oel19adg2
user is oracle
Platform:- Linux 
Checking if the remote hosts are reachable
PING oel19adg1 (192.168.137.5056(84) bytes of data.
64 bytes from oel19adg1 (192.168.137.50): icmp_seq=1 ttl=64 time=0.027 ms
64 bytes from oel19adg1 (192.168.137.50): icmp_seq=2 ttl=64 time=0.041 ms
64 bytes from oel19adg1 (192.168.137.50): icmp_seq=3 ttl=64 time=0.037 ms
64 bytes from oel19adg1 (192.168.137.50): icmp_seq=4 ttl=64 time=0.036 ms
64 bytes from oel19adg1 (192.168.137.50): icmp_seq=5 ttl=64 time=0.038 ms
 
--- oel19adg1 ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4099ms
rtt min/avg/max/mdev = 0.027/0.035/0.041/0.008 ms
PING oel19adg2 (192.168.137.6056(84) bytes of data.
64 bytes from oel19adg2 (192.168.137.60): icmp_seq=1 ttl=64 time=0.183 ms
64 bytes from oel19adg2 (192.168.137.60): icmp_seq=2 ttl=64 time=0.232 ms
64 bytes from oel19adg2 (192.168.137.60): icmp_seq=3 ttl=64 time=0.237 ms
64 bytes from oel19adg2 (192.168.137.60): icmp_seq=4 ttl=64 time=0.219 ms
64 bytes from oel19adg2 (192.168.137.60): icmp_seq=5 ttl=64 time=0.184 ms
 
--- oel19adg2 ping statistics ---
5 packets transmitted, 5 received, 0% packet loss, time 4094ms
rtt min/avg/max/mdev = 0.183/0.211/0.237/0.023 ms
Remote host reachability check succeeded.
The following hosts are reachable: oel19adg1 oel19adg2.
The following hosts are not reachable: .
All hosts are reachable. Proceeding further...
firsthost oel19adg1
numhosts 2
The script will setup SSH connectivity from the host oel19adg1 to all
the remote hosts. After the script is executed, the user can use SSH to run
commands on the remote hosts or copy files between this host oel19adg1
and the remote hosts without being prompted for passwords or confirmations.
 
NOTE 1:
As part of the setup procedure, this script will use ssh and scp to copy
files between the local host and the remote hosts. Since the script does not
store passwords, you may be prompted for the passwords during the execution of
the script whenever ssh or scp is invoked.
 
NOTE 2:
AS PER SSH REQUIREMENTS, THIS SCRIPT WILL SECURE THE USER HOME DIRECTORY
AND THE .ssh DIRECTORY BY REVOKING GROUP AND WORLD WRITE PRIVILEGES TO THESE
directories.
 
Do you want to continue and let the script make the above mentioned changes (yes/no)?
yes   <-- yes 입력
 
The user chose yes
User chose to skip passphrase related questions.
Creating .ssh directory on local host, if not present already
Creating authorized_keys file on local host
Changing permissions on authorized_keys to 644 on local host
Creating known_hosts file on local host
Changing permissions on known_hosts to 644 on local host
Creating config file on local host
If a config file exists already at /home/oracle/.ssh/config, it would be backed up to /home/oracle/.ssh/config.backup.
Removing old private/public keys on local host
Running SSH keygen on local host with empty passphrase
Generating public/private rsa key pair.
Your identification has been saved in /home/oracle/.ssh/id_rsa.
Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.
The key fingerprint is:
SHA256:ykcd6Rue2boGQbP57mLqAV6E4YSOMA+KZIJXG/H+ef8 oracle@oel19adg1
The key's randomart image is:
+---[RSA 1024]----+
|.  o*.           |
|*ooo *  o  .     |
|BB  + o. +o      |
|+ o  o  +o .     |
|    . o So+      |
|   . + +.o.*     |
|    . + +o* .    |
|       oo.oo     |
|     .oo ++...E  |
+----[SHA256]-----+
Creating .ssh directory and setting permissions on remote host oel19adg1
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.
The script would create ~oracle/.ssh/config file on remote host oel19adg1. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host oel19adg1.
Warning: Permanently added 'oel19adg1,192.168.137.50' (ECDSA) to the list of known hosts.
oracle@oel19adg1's password: 
Done with creating .ssh directory and setting permissions on remote host oel19adg1.
Creating .ssh directory and setting permissions on remote host oel19adg2
THE SCRIPT WOULD ALSO BE REVOKING WRITE PERMISSIONS FOR group AND others ON THE HOME DIRECTORY FOR oracle. THIS IS AN SSH REQUIREMENT.
The script would create ~oracle/.ssh/config file on remote host oel19adg2. If a config file exists already at ~oracle/.ssh/config, it would be backed up to ~oracle/.ssh/config.backup.
The user may be prompted for a password here since the script would be running SSH on host oel19adg2.
Warning: Permanently added 'oel19adg2,192.168.137.60' (ECDSA) to the list of known hosts.
oracle@oel19adg2's password: 
Done with creating .ssh directory and setting permissions on remote host oel19adg2.
Copying local host public key to the remote host oel19adg1
The user may be prompted for a password or passphrase here since the script would be using SCP for host oel19adg1.
oracle@oel19adg1's password: 
Done copying local host public key to the remote host oel19adg1
Copying local host public key to the remote host oel19adg2
The user may be prompted for a password or passphrase here since the script would be using SCP for host oel19adg2.
oracle@oel19adg2's password: 
Done copying local host public key to the remote host oel19adg2
Creating keys on remote host oel19adg1 if they do not exist already. This is required to setup SSH on host oel19adg1.
 
Creating keys on remote host oel19adg2 if they do not exist already. This is required to setup SSH on host oel19adg2.
Generating public/private rsa key pair.
Your identification has been saved in .ssh/id_rsa.
Your public key has been saved in .ssh/id_rsa.pub.
The key fingerprint is:
SHA256:ocwDp7Lg/DzogOA8CAI3J0fOaawJjPdEVlmRE1FJorQ oracle@oel19adg2
The key's randomart image is:
+---[RSA 1024]----+
|    +.oo*Bo.     |
|o  B o.oo..      |
|+.= @ E ..       |
|.+ @ * . .       |
|= + o = S        |
|@. o   .         |
|+*o              |
|..+.             |
|.. o.            |
+----[SHA256]-----+
Updating authorized_keys file on remote host oel19adg1
Updating known_hosts file on remote host oel19adg1
Updating authorized_keys file on remote host oel19adg2
Updating known_hosts file on remote host oel19adg2
cat: /home/oracle/.ssh/known_hosts.tmp: No such file or directory
cat: /home/oracle/.ssh/authorized_keys.tmp: No such file or directory
SSH setup is complete.
 
------------------------------------------------------------------------
Verifying SSH setup
===================
The script will now run the date command on the remote nodes using ssh
to verify if ssh is setup correctly. IF THE SETUP IS CORRECTLY SETUP,
THERE SHOULD BE NO OUTPUT OTHER THAN THE DATE AND SSH SHOULD NOT ASK FOR
PASSWORDS. If you see any output other than date or are prompted for the
password, ssh is not setup correctly and you will need to resolve the
issue and set up ssh again.
The possible causes for failure could be:
1. The server settings in /etc/ssh/sshd_config file do not allow ssh
for user oracle.
2. The server may have disabled public key based authentication.
3. The client public key on the server may be outdated.
4. ~oracle or ~oracle/.ssh on the remote host may not be owned by oracle.
5. User may not have passed -shared option for shared remote users or
may be passing the -shared option for non-shared remote users.
6. If there is output in addition to the date, but no password is asked,
it may be a security alert shown as part of company policy. Append the
additional text to the <OMS HOME>/sysman/prov/resources/ignoreMessages.txt file.
------------------------------------------------------------------------
--oel19adg1:--
Running /usr/bin/ssh --l oracle oel19adg1 date to verify SSH connectivity has been setup from local host to oel19adg1.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
Wed Apr  6 19:45:42 KST 2022
------------------------------------------------------------------------
--oel19adg2:--
Running /usr/bin/ssh --l oracle oel19adg2 date to verify SSH connectivity has been setup from local host to oel19adg2.
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL. Please note that being prompted for a passphrase may be OK but being prompted for a password is ERROR.
Wed Apr  6 19:45:43 KST 2022
------------------------------------------------------------------------
------------------------------------------------------------------------
Verifying SSH connectivity has been setup from oel19adg1 to oel19adg1
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL.
Wed Apr  6 19:45:44 KST 2022
------------------------------------------------------------------------
------------------------------------------------------------------------
Verifying SSH connectivity has been setup from oel19adg1 to oel19adg2
IF YOU SEE ANY OTHER OUTPUT BESIDES THE OUTPUT OF THE DATE COMMAND OR IF YOU ARE PROMPTED FOR A PASSWORD HERE, IT MEANS SSH SETUP HAS NOT BEEN SUCCESSFUL.
Wed Apr  6 19:45:45 KST 2022
------------------------------------------------------------------------
-Verification from complete-
SSH verification complete.

 

 

패치파일 압축해제

1
2
$ cd /oracle/media
$ unzip p32900083_190000_Linux-x86-64.zip 

 

 

Xmanager - Passive 실행

 

 

grid 설치 및 패치

1
2
3
4
5
$ cd $GRID_HOME
$ ./gridSetup.sh -applyRU /oracle/media/32900083/32895426
Preparing the home to patch...
Applying the patch /oracle/media/32900083/32895426...
(자동으로 패치 적용 후 GUI 창이 나타남)

gui가 로딩되기까지 시간이 조금 걸림

 

 

Configure Oracle Grid Infrastructure for a New Cluster 선택

 

 

Configure an Oracle Standalone Cluster 선택

 

 

SCAN 정보 입력

 

 

ADD 선택

 

 

2번노드 정보 입력

 

 

수동 패스워드 설정을 했기 때문에 바로 Next

 

 

ens32에는 Public, ens35에는 ASM & Private로 선택

 

 

Use Oracle Flex ASM for storage 선택 

 

 

No 선택

 

 

OCR_VOTE 입력 후 Normal 선택
디스크가 안나올 경우 Change Discovery Path 선택

 

 

Change Discovery Path 선택 후 경로 입력 후 OK

 

 

disk 3개 선택 후 Next

 

 

패스워드 oracle 입력

 

 

Do not use IPMI 선택

 

 

EM 체크하지 않고 다음

 

 

그룹 dba로 선택

 

 

oracle base 지정

 

 

oraInventory 지정

 

 

설치 중 root 권한으로 스크립트 실행하는 부분에서 자동으로 스크립트 실행할지 여부 지정
root 패스워드 입력

 

 

사전 요구사항 체크중

 

 

물리메모리를 4gb로 잡아서 경고가 발생하고

SCAN 관련메세지는 SCAN IP가 DNS에 등록되어 있지 않아서 발생한 문제 모두 Ignore

 

 

response 파일이 필요하다면 따로 저장 후 Install

 

 

grid 설치중

 

 

root 계정으로 스크립트  실행할 지 물어보는 메세지 Yes

 

 

SCAN IP가 DNS에 등록되어 있지 않아서 발생한 문제 무시 해도됨 OK

 

 

Yes

 

 

Close 선택

 

 

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       oel19adg1                STABLE
               ONLINE  ONLINE       oel19adg2                STABLE
ora.chad
               ONLINE  ONLINE       oel19adg1                STABLE
               ONLINE  ONLINE       oel19adg2                STABLE
ora.net1.network
               ONLINE  ONLINE       oel19adg1                STABLE
               ONLINE  ONLINE       oel19adg2                STABLE
ora.ons
               ONLINE  ONLINE       oel19adg1                STABLE
               ONLINE  ONLINE       oel19adg2                STABLE
ora.proxy_advm
               OFFLINE OFFLINE      oel19adg1                STABLE
               OFFLINE OFFLINE      oel19adg2                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       oel19adg1                STABLE
      2        ONLINE  ONLINE       oel19adg2                STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       oel19adg1                STABLE
ora.OCR_VOTE.dg(ora.asmgroup)
      1        ONLINE  ONLINE       oel19adg1                STABLE
      2        ONLINE  ONLINE       oel19adg2                STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       oel19adg1                Started,STABLE
      2        ONLINE  ONLINE       oel19adg2                Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       oel19adg1                STABLE
      2        ONLINE  ONLINE       oel19adg2                STABLE
ora.cvu
      1        ONLINE  ONLINE       oel19adg1                STABLE
ora.oel19adg1.vip
      1        ONLINE  ONLINE       oel19adg1                STABLE
ora.oel19adg2.vip
      1        ONLINE  ONLINE       oel19adg2                STABLE
ora.qosmserver
      1        ONLINE  ONLINE       oel19adg1                STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       oel19adg1                STABLE
--------------------------------------------------------------------------------

 

 

OCR_VOTE DISK 확인

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
$ ocrcheck
Status of Oracle Cluster Registry is as follows :
     Version                  :          4
     Total space (kbytes)     :     901284
     Used space (kbytes)      :      84324
     Available space (kbytes) :     816960
     ID                       : 1379503481
     Device/File Name         :  +OCR_VOTE
                                    Device/File integrity check succeeded
 
                                    Device/File not configured
 
                                    Device/File not configured
 
                                    Device/File not configured
 
                                    Device/File not configured
 
     Cluster registry integrity check succeeded
 
     Logical corruption check bypassed due to non-privileged user

 

 

GRID 패치정보 확인

1
2
3
4
5
6
7
8
$ $GRID_HOME/OPatch/opatch lspatches -oh $GRID_HOME
32918050;TOMCAT RELEASE UPDATE 19.0.0.0.0 (32918050)
32916816;OCW RELEASE UPDATE 19.12.0.0.0 (32916816)
32915586;ACFS RELEASE UPDATE 19.12.0.0.0 (32915586)
32904851;Database Release Update : 19.12.0.0.210720 (32904851)
32585572;DBWLM RELEASE UPDATE 19.0.0.0.0 (32585572)
 
OPatch succeeded.

 

 

asmca 디스크 그룹 추가

asmca 진행

1
$ asmca

 

 

Disk Groups 선택

 

 

Create 선택

 

 

Disk Group Name 에 DATA 입력 후 External 선택 후 DATA 디스크 선택

 

 

OCR_VOTE와 DATA 디스크 그룹이 존재하는것을 확인 후 Exit

 

 

asmca 후 점검

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       oel19adg1                STABLE
               ONLINE  ONLINE       oel19adg2                STABLE
ora.chad
               ONLINE  ONLINE       oel19adg1                STABLE
               ONLINE  ONLINE       oel19adg2                STABLE
ora.net1.network
               ONLINE  ONLINE       oel19adg1                STABLE
               ONLINE  ONLINE       oel19adg2                STABLE
ora.ons
               ONLINE  ONLINE       oel19adg1                STABLE
               ONLINE  ONLINE       oel19adg2                STABLE
ora.proxy_advm
               OFFLINE OFFLINE      oel19adg1                STABLE
               OFFLINE OFFLINE      oel19adg2                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       oel19adg1                STABLE
      2        ONLINE  ONLINE       oel19adg2                STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       oel19adg1                STABLE
      2        ONLINE  ONLINE       oel19adg2                STABLE
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       oel19adg1                STABLE
ora.OCR_VOTE.dg(ora.asmgroup)
      1        ONLINE  ONLINE       oel19adg1                STABLE
      2        ONLINE  ONLINE       oel19adg2                STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       oel19adg1                Started,STABLE
      2        ONLINE  ONLINE       oel19adg2                Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       oel19adg1                STABLE
      2        ONLINE  ONLINE       oel19adg2                STABLE
ora.cvu
      1        ONLINE  ONLINE       oel19adg1                STABLE
ora.oel19adg1.vip
      1        ONLINE  ONLINE       oel19adg1                STABLE
ora.oel19adg2.vip
      1        ONLINE  ONLINE       oel19adg2                STABLE
ora.qosmserver
      1        ONLINE  ONLINE       oel19adg1                STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       oel19adg1                STABLE
--------------------------------------------------------------------------------

정상적으로 ora.DATA.dg가 생성됨

 

 

다음 게시글로 이동

다음 게시글에선 DB 엔진 설치와 ADG 구성을 진행함

Oracle Linux 8.4에 Oracle 19c RAC to RAC ADG 설치 가이드_Part 3(https://positivemh.tistory.com/826)

 

 

참조 : 

808783.1, 2329386.1, 1432367.1, 1130523.1, 1367311.1, 362656.1, 2804791.1, 1631552.1
https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/LOG_ARCHIVE_DEST_n-parameter-attributes.html#GUID-9ACDEC6C-C2E0-4EDA-B66D-B1F819D3368D
https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/troubleshooting-oracle-data-guard.html#GUID-97282862-4EA0-42D9-97EF-34E75A29F87F
https://docs.oracle.com/en/database/oracle/oracle-database/19/sbydb/index.html
https://docs.oracle.com/en/database/oracle/oracle-database/19/dgbkr/index.html
https://community.oracle.com/tech/apps-infra/discussion/2453742/error-12154-received-logging-on-to-the-standby
https://community.oracle.com/mosc/discussion/3986057/ur-a-parameter-in-tnsnames-ora
https://positivemh.tistory.com/674
https://positivemh.tistory.com/761
https://positivemh.tistory.com/765
https://positivemh.tistory.com/819
https://positivemh.tistory.com/820
https://positivemh.tistory.com/821
https://positivemh.tistory.com/822
https://positivemh.tistory.com/823
https://positivemh.tistory.com/825
https://positivemh.tistory.com/826
https://positivemh.tistory.com/827
https://positivemh.tistory.com/828
https://dataforum.io/display/ORCL/Oracle+Database+19c+Data+Guard
https://blog.goodusdata.com/95
https://blog.goodusdata.com/176
https://tawool.tistory.com/213
https://medium.com/@limaemerson/setting-active-data-guard-physical-standby-in-rac-one-nodes-architecture-part-1-3afcf5325eff
https://www.cndba.cn/zhoushao12/article/3674
https://floo.bar/2019/06/18/oracle-data-guard-broker-18-new-validate-network-configuration-command/
https://oracledbwr.com/step-by-step-configuration-of-data-guard-broker-for-rac-database/
https://dba.stackexchange.com/questions/285729/oracle-19c-with-sap-system-ora-12154-tnscould-not-resolve-the-connect-identi