프린트 하기

내맘대로긍정이 알려주는

Oracle 23ai 신기능
무료 세미나 발표자료

다운로드 trending_flat

OS환경 : Oracle Linux 7.6 (64bit)


DB 환경 : Oracle Database 19.3.0.0


OS 및 GRID 설치는 아래 게시물 참조

Oracle Linux 7.6에 Oracle 19c RAC 설치가이드_Part 1(https://positivemh.tistory.com/522)


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

1번 노드 hostname : oel19db1

2번 노드 hostname : oel19db2


*본문에 2번노드 표시가 없으면 모두 1번노드에서 작업



asmca 디스크 그룹 추가

asmca 진행

1
$ asmca



gui 로딩중



Disk Groups 선택



Create 선택



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



생성중



OK



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



Yes



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
53
54
$ 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
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       oel19db1                 STABLE
      2        ONLINE  ONLINE       oel19db2                 STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       oel19db1                 STABLE
      2        ONLINE  ONLINE       oel19db2                 STABLE
      3        ONLINE  OFFLINE                               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
      3        OFFLINE OFFLINE                               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       oel19db1                 Started,STABLE
      2        ONLINE  ONLINE       oel19db2                 Started,STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       oel19db1                 STABLE
      2        ONLINE  ONLINE       oel19db2                 STABLE
      3        OFFLINE OFFLINE                               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
--------------------------------------------------------------------------------

ora.DATA.dg(ora.asmgroup) 가 2개 ONLINE 되어 있어야함



db 소프트웨어(엔진) 설치

db 설치 미디어 압축 해제

1
2
3
$ cd /ORA19/media/cp -av LINUX.X64_193000_db_home.zip $ORACLE_HOME/
$ cd $ORACLE_HOME
$ unzip LINUX.X64_193000_db_home.zip



runinstaller 실행

1
2
$ db (alias)
$ ./runInstaller



Set Up Software Only 선택



Oracle Real Application Cluster database installation 선택



1,2 선택(SSH connectivity는 grid 설치시 진행했으므로 하지않음)



Enterprise Edition 선택



oracle base 지정



group 는 모두 dba 로 지정



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

root 패스워드 입력



사전 요구사항 체크중



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

모두 Ignore



Yes



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



db 엔진 설치중



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



Close



db 엔진 설치 완료



19.6 버전으로 패치를 하고 싶다면 아래 게시글 참조

Oracle 19c RAC OPatch Release Update 적용 방법(https://positivemh.tistory.com/529)



db생성

dbca 진행

1
2
$ su - oracle
$ dbca



gui 로딩중



Create a database 선택



Advanced configuration 선택



Database Type : RAC, configuration type : Admin Managed, General Purpose 선택



db 1, 2 선택



SID 입력



데이터 저장영역 선택 +DATA



FRA, 아카이브 사용하지 않음



Next



메모리 변경없이 기본으로 잡혀있는데로 사용



Character sets - Choose from the list of chracter sets - KO16MSWIN949 선택



Connection mode - Ddedicated server mode 선택



Next



패스워드 입력



Yes



Create database 선택, Generate database creation scripts 지정



사전 요구사항 체크중



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

모두 Ignore



Yes



Finish



db 생성중



Close



DB 생성 확인

1
2
3
4
5
6
7
$ sqlplus / as sysdba
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



crs 상태 확인

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
$ 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
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
      1        ONLINE  ONLINE       oel19db1                 STABLE
      2        ONLINE  ONLINE       oel19db2                 STABLE
      3        ONLINE  OFFLINE                               STABLE
ora.DATA.dg(ora.asmgroup)
      1        ONLINE  ONLINE       oel19db1                 STABLE
      2        ONLINE  ONLINE       oel19db2                 STABLE
      3        ONLINE  OFFLINE                               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
      3        OFFLINE OFFLINE                               STABLE
ora.asm(ora.asmgroup)
      1        ONLINE  ONLINE       oel19db1                 Started,STABLE
      2        ONLINE  ONLINE       oel19db2                 STABLE
      3        OFFLINE OFFLINE                               STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
      1        ONLINE  ONLINE       oel19db1                 STABLE
      2        ONLINE  ONLINE       oel19db2                 STABLE
      3        OFFLINE OFFLINE                               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=/ORA19/app
                                                             /oracle/product/19.3
                                                             .0/db_1,STABLE
      2        ONLINE  ONLINE       oel19db2                 Open,HOME=/ORA19/app
                                                             /oracle/product/19.3
                                                             .0/db_1,STABLE
ora.qosmserver
      1        ONLINE  ONLINE       oel19db1                 STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       oel19db1                 STABLE
--------------------------------------------------------------------------------





저작자표시

'ORACLE > Install' 카테고리의 다른 글

Oracle Linux 6.8에 Oracle 11g R2 환경 OS Watcher 설치 가이드  (0) 2020.03.11
Oracle 19c RAC OPatch Release Update 적용 가이드  (6) 2020.03.08
Oracle Linux 7.6에 Oracle 19c RAC 설치 가이드_Part 1  (42) 2020.03.01
Oracle 19c 컴포넌트 추가 설치 방법  (0) 2020.02.09
Oracle Linux 8.1에 Oracle 19c 설치 가이드  (15) 2020.01.05

티스토리툴바