[Oracle] Oracle Grid Infrastructure 19c

prana·2025년 2월 19일
1

ORACLE

목록 보기
80/96

gui

# xhost +
# su - grid
$ export DISPLAY=:0.0
엔진 설치 --> $ORACLE_HOME 
[grid@cowjin1 20250211-19:01:13]:+ASM1:[/oramedia]
$ unzip p35319490_190000_Linux-x86-64.zip ---> RU 압축풀기
Opatch 패치 
gridsetup.sh -applyRU RU압축푼장소 지정

# xhost +
# su - grid
$ export DISPLAY=:0.0
-- $ORACLE_HOME에서 ./gridSetup.sh -applyRU /oramedia/35319490

  • ✅ Configure Oracle Grid Infrastructure for a New Cluster
    • 다중 노드(2개 이상의 서버)로 구성된 클러스터 환경
    • CRS, ASM, GNS, SCAN 등을 포함
  • Configure Oracle Grid Infrastructure for a Standalone Server (Oracle Restart)
    • 단일 인스턴스 환경, RAC가 아닌 Standalone 서버(싱글 노드)에서 ASM 제공하기 위해 Grid Infrastructure 설정하는 과정
  • Upgrade Oracle Grid Infrastructure

  • ✅ Configure an Oracle Standalone Cluster
  • Configure an Oracle Domain Services Cluster
  • Configure an Oracle Member Cluster for Oracle Databases
  • Configure an Oracle Member Cluster for Applications

  • Cluster명, Scan명, SCAN Port를 입력. SCAN명에는 사전에 DNS에 등록했던 이름을 입력한다.

  • GNS사용한 동적 IP 주소 할당

    • 이 옵션을 선택한 경우, 네트워크 관리자는 GNS(표준 혹은 멀티 클러스터)에 따라 정해지도록 sub domain을 위임한다.

  • 정적 IP주소 할당

    • 이 옵션을 선택하면, 네트워크 관리자는 고정IP 주소를 클러스터 각 물리 호스트명과 Oracle Clusterware관리 VIP에 할당한다. 또한 DNS에 기반한 정적 name resolution이 각 노드에 할당된다.
  • catjin2
  • catjin2-vip
1,2 호기
[root@cowjin1 ~]# passwd grid
Changing password for user grid.
New password:
Retype new password:
passwd: all authentication tokens updated successfully.


-- 테스트용으로 4개 만들었는데 보통은 하나만 사용한다
10.10.0.1   cowjin-priv1
10.10.0.2   catjin-priv1
20.20.0.1   cowjin-priv2
20.20.0.2   catjin-priv2
30.30.0.1   cowjin-priv3
30.30.0.2   catjin-priv3
40.40.40.1  cowjin-priv4
40.40.40.2  catjin-priv4

  • RAC 성능정보 분석하는 DB를 만들 것인지 선택항목으로, no

이렇게 구성하려고 함..!

  • External : 복제x
  • normal: 이중화
    • normal일 때 Failure Group: 스토리지 내 같은 LUN에 이중화가 되어 있는데, 이를 다른 LUN에 이중화 구성할 수 있도록 명시적으로 경로를 지정해준다.
  • High: 삼중화

IPMI

DB는 데이터 정합성

  • Self Check / Disk Misscount / Inter connect --> 장애 요인 3가지
  • zombie처럼 process가 증가하는 경우 / memory나 os가 응답이ㅣ 없어서 서버를 재부팅 해야 하는 경우
    => ocssd, ohasd가 os를 재기동하는데 process다보니까 os재기동 명령어가 정상적으로 수행되지 않을 때도 있음
    IPMI를 사용하면 h/w 자체의 기능을 이용해서 서버를 제어 가능함

[root@catjin2 ~]# sh /tmp/GridSetupActions2025-02-13_06-42-21PM/CVU_19_grid_2025-02-13_18-44-20_337240/runfixup.sh
All Fix-up operations were completed successfully.

[root@cowjin1 ~]# sh /tmp/GridSetupActions2025-02-13_06-42-21PM/CVU_19_grid_2025-02-13_18-44-20_337240/runfixup.sh
All Fix-up operations were completed successfully.
[root@cowjin1 ~]#






1. root로 접속
2. script 수행
3. 스크립트 하나당 노드 하나씩, 그 다음 노드 수행 -> 다음 스크립트 실행
4. OK 버튼 클릭

1. orainstRoot.sh

1. orainstRoot.sh
#node 1
[root@cowjin1 oraInventory]# sh orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to dba.
The execution of the script is complete.

#node 2
[root@catjin2 oraInventory]# ls
ContentsXML  logs  oraInst.loc  orainstRoot.sh
[root@catjin2 oraInventory]# sh orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to dba.
The execution of the script is complete.

2. root.sh

#node 1
Using configuration parameter file: /u01/app/oracle/product/19c/gridhome_1/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/base/crsdata/cowjin1/crsconfig/rootcrs_cowjin1_2025-02-17_11-32-25PM.log
2025/02/17 23:32:31 CLSRSC-594: Executing installation step 1 of 19: 'ValidateEnv'.
2025/02/17 23:32:31 CLSRSC-594: Executing installation step 2 of 19: 'CheckFirstNode'.
2025/02/17 23:32:33 CLSRSC-594: Executing installation step 3 of 19: 'GenSiteGUIDs'.
2025/02/17 23:32:33 CLSRSC-594: Executing installation step 4 of 19: 'SetupOSD'.
Redirecting to /bin/systemctl restart rsyslog.service
2025/02/17 23:32:34 CLSRSC-594: Executing installation step 5 of 19: 'CheckCRSConfig'.
2025/02/17 23:32:34 CLSRSC-594: Executing installation step 6 of 19: 'SetupLocalGPNP'.
2025/02/17 23:32:41 CLSRSC-594: Executing installation step 7 of 19: 'CreateRootCert'.
2025/02/17 23:32:44 CLSRSC-594: Executing installation step 8 of 19: 'ConfigOLR'.
2025/02/17 23:32:58 CLSRSC-594: Executing installation step 9 of 19: 'ConfigCHMOS'.
2025/02/17 23:32:58 CLSRSC-594: Executing installation step 10 of 19: 'CreateOHASD'.
2025/02/17 23:33:02 CLSRSC-594: Executing installation step 11 of 19: 'ConfigOHASD'.
2025/02/17 23:33:02 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2025/02/17 23:33:21 CLSRSC-594: Executing installation step 12 of 19: 'SetupTFA'.
2025/02/17 23:33:21 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2025/02/17 23:33:22 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2025/02/17 23:33:47 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2025/02/17 23:33:51 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
2025/02/17 23:33:22 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2025/02/17 23:33:47 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2025/02/17 23:33:51 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.

ASM has been created and started successfully.

[DBT-30001] Disk groups created successfully. Check /u01/app/base/cfgtoollogs/asmca/asmca-250217PM113420.log for details.

2025/02/17 23:34:58 CLSRSC-482: Running command: '/u01/app/oracle/product/19c/gridhome_1/bin/ocrconfig -upgrade grid dba'
CRS-4256: Updating the profile
Successful addition of voting disk e470e08d1a634fb6bf789a16d97a05cf.
Successfully replaced voting disk group with +OCRVOTE.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   e470e08d1a634fb6bf789a16d97a05cf (ORCL:OCRVOTING02) [OCRVOTE]
Located 1 voting disk(s).
2025/02/17 23:35:44 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2025/02/17 23:36:09 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.
2025/02/17 23:36:42 CLSRSC-343: Successfully started Oracle Clusterware stack
2025/02/17 23:36:42 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2025/02/17 23:37:29 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2025/02/17 23:37:44 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded



# node 2
[root@catjin2 gridhome_1]# sh root.sh
Performing root user operation.

The following environment variables are set as:
    ORACLE_OWNER= grid
    ORACLE_HOME=  /u01/app/oracle/product/19c/gridhome_1

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: /u01/app/oracle/product/19c/gridhome_1/crs/install/crsconfig_params
The log of current session can be found at:
  /u01/app/base/crsdata/catjin2/crsconfig/rootcrs_catjin2_2025-02-17_11-40-28PM.log
2025/02/17 23:40:32 CLSRSC-594: Executing installation step 1 of 19: 'ValidateEnv'.
2025/02/17 23:40:32 CLSRSC-594: Executing installation step 2 of 19: 'CheckFirstNode'.
2025/02/17 23:40:33 CLSRSC-594: Executing installation step 3 of 19: 'GenSiteGUIDs'.
2025/02/17 23:40:33 CLSRSC-594: Executing installation step 4 of 19: 'SetupOSD'.
Redirecting to /bin/systemctl restart rsyslog.service
2025/02/17 23:40:34 CLSRSC-594: Executing installation step 5 of 19: 'CheckCRSConfig'.
2025/02/17 23:40:35 CLSRSC-594: Executing installation step 6 of 19: 'SetupLocalGPNP'.
2025/02/17 23:40:36 CLSRSC-594: Executing installation step 7 of 19: 'CreateRootCert'.
2025/02/17 23:40:36 CLSRSC-594: Executing installation step 8 of 19: 'ConfigOLR'.
2025/02/17 23:40:46 CLSRSC-594: Executing installation step 9 of 19: 'ConfigCHMOS'.
2025/02/17 23:40:46 CLSRSC-594: Executing installation step 10 of 19: 'CreateOHASD'.
2025/02/17 23:40:47 CLSRSC-594: Executing installation step 11 of 19: 'ConfigOHASD'.
2025/02/17 23:40:47 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'
2025/02/17 23:41:16 CLSRSC-594: Executing installation step 12 of 19: 'SetupTFA'.
2025/02/17 23:41:16 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.
2025/02/17 23:41:16 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.
2025/02/17 23:42:42 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.
2025/02/17 23:42:43 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.
2025/02/17 23:42:51 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.
2025/02/17 23:43:51 CLSRSC-343: Successfully started Oracle Clusterware stack
2025/02/17 23:43:51 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.
2025/02/17 23:44:04 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.
2025/02/17 23:44:08 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded
profile
prana
이전 포스트

[Oracle] ASM, ADVM

다음 포스트

[Oracle] ASMCA

0개의 댓글