메뉴 건너뛰기

Korea Oracle User Group

Install/Configuration

19c RAC 2Node 설치 -4 [ GRID ]

우뽕 2020.04.21 16:31 조회 수 : 959

 

 

31.GIF

 

32.GIF

33.GIF

 

[root@db19c1(+ASM1):/dg/app/oraInventory] orainstRoot.sh

bash: orainstRoot.sh: command not found...

[root@db19c1(+ASM1):/dg/app/oraInventory] ./orainstRoot.sh

Changing permissions of /dg/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

 

Changing groupname of /dg/app/oraInventory to oinstall.

The execution of the script is complete.

[root@db19c1(+ASM1):/dg/app/oraInventory] cd $ORACLE_HOME

[root@db19c1(+ASM1):/dg/app/product/gihome] ls -lart root.sh

-rwx------. 1 grid oinstall 415 Apr 10 20:42 root.sh

[root@db19c1(+ASM1):/dg/app/product/gihome] 

[root@db19c1(+ASM1):/dg/app/product/gihome] ./root.sh

Performing root user operation.

 

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /dg/app/product/gihome

 

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.

 

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: /dg/app/product/gihome/crs/install/crsconfig_params

The log of current session can be found at:

  /dg/app/grid_base/crsdata/db19c1/crsconfig/rootcrs_db19c1_2020-04-10_09-28-10PM.log

2020/04/10 21:28:48 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.

2020/04/10 21:28:48 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.

2020/04/10 21:28:48 CLSRSC-363: User ignored prerequisites during installation

2020/04/10 21:28:49 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.

2020/04/10 21:28:50 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2020/04/10 21:28:58 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.

2020/04/10 21:29:01 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.

2020/04/10 21:29:02 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.

2020/04/10 21:29:04 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.

2020/04/10 21:29:08 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.

2020/04/10 21:29:32 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.

2020/04/10 21:29:34 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.

2020/04/10 21:29:35 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.

2020/04/10 21:29:38 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.

2020/04/10 21:29:52 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.

2020/04/10 21:29:58 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.

2020/04/10 21:30:09 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.

2020/04/10 21:30:30 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.

 

ASM has been created and started successfully.

 

[DBT-30022] Disk group OCRVOT_DG mounted successfully.

 

2020/04/10 21:34:27 CLSRSC-482: Running command: '/dg/app/product/gihome/bin/ocrconfig -upgrade grid oinstall'

CRS-4256: Updating the profile

Successful addition of voting disk d603d5eea27f4fabbf0635c2cfdb8d4e.

Successfully replaced voting disk group with +OCRVOT_DG.

CRS-4256: Updating the profile

CRS-4266: Voting file(s) successfully replaced

##  STATE    File Universal Id                File Name Disk group

--  -----    -----------------                --------- ---------

 1. ONLINE   d603d5eea27f4fabbf0635c2cfdb8d4e (/dev/raw/raw6) [OCRVOT_DG]

Located 1 voting disk(s).

 

2020/04/10 21:38:21 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

2020/04/10 21:40:15 CLSRSC-343: Successfully started Oracle Clusterware stack

2020/04/10 21:40:15 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.

2020/04/10 21:45:38 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'

 

[INFO] [DBT-30001] Disk groups created successfully. Check /dg/app/grid_base/cfgtoollogs/asmca/asmca-200410PM094600.log for details.

 

2020/04/10 21:50:29 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

[root@db19c1(+ASM1):/dg/app/product/gihome] 

 

[root@db19c1(+ASM1):/dg/app/product/gihome] ocrcheck

Status of Oracle Cluster Registry is as follows :

         Version                  :          4

         Total space (kbytes)     :     491684

         Used space (kbytes)      :      84452

         Available space (kbytes) :     407232

         ID                       :  703113999

         Device/File Name         : +OCRVOT_DG

                                    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 succeeded

 

[root@db19c1(+ASM1):/dg/app/product/gihome] 

 
### permission , owner   
ACTION=="add", KERNEL=="raw*", OWNER="oracle", GROUP="dba", MODE="0660"
--> 아래처럼 에러 
2020/04/10 21:25:33 CLSRSC-482: Running command: '/dg/app/product/gihome/bin/ocrconfig -upgrade grid oinstall'
Errors in file :
ORA-27091: unable to queue I/O
ORA-06512: at line 4
ORA-15081: failed to submit an I/O operation to a disk
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 424
ORA-06512: at line 2
PROT-1: Failed to initialize ocrconfig
PROC-26: Error while accessing the physical storage Storage layer error [Insufficient quorum to open OCR devices] [0]
2020/04/10 21:25:43 CLSRSC-157: Failed to create Oracle Cluster Registry configuration
2020/04/10 21:25:44 CLSRSC-259: Oracle Clusterware Repository configuration failed
Died at /dg/app/product/gihome/crs/install/oraocr.pm line 1759.
[root@db19c1(+ASM1):/dg/app/product/gihome]

## GRID 유저로 변경 해야 함
ACTION=="add", KERNEL=="raw*", OWNER="grid", GROUP="dba", MODE="0660"
 

 

 

 

 

[root@db19c2(+ASM2):/dg/app/oraInventory] ./orainstRoot.sh

Changing permissions of /dg/app/oraInventory.

Adding read,write permissions for group.

Removing read,write,execute permissions for world.

 

Changing groupname of /dg/app/oraInventory to oinstall.

The execution of the script is complete.

[root@db19c2(+ASM2):/dg/app/oraInventory] 

[root@db19c2(+ASM2):/dg/app/oraInventory] 

[root@db19c2(+ASM2):/dg/app/oraInventory] 

[root@db19c2(+ASM2):/dg/app/oraInventory] crsctl status re -t

bash: crsctl: command not found...

[root@db19c2(+ASM2):/dg/app/oraInventory]

 

[root@db19c2(+ASM2):/dg/app/product/gihome] ./root.sh

Performing root user operation.

 

The following environment variables are set as:

    ORACLE_OWNER= grid

    ORACLE_HOME=  /dg/app/product/gihome

 

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.

 

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: /dg/app/product/gihome/crs/install/crsconfig_params

The log of current session can be found at:

  /dg/app/grid_base/crsdata/db19c2/crsconfig/rootcrs_db19c2_2020-04-10_09-50-59PM.log

2020/04/10 21:51:16 CLSRSC-594: Executing installation step 1 of 19: 'SetupTFA'.

2020/04/10 21:51:16 CLSRSC-594: Executing installation step 2 of 19: 'ValidateEnv'.

2020/04/10 21:51:17 CLSRSC-363: User ignored prerequisites during installation

2020/04/10 21:51:17 CLSRSC-594: Executing installation step 3 of 19: 'CheckFirstNode'.

2020/04/10 21:51:17 CLSRSC-4002: Successfully installed Oracle Trace File Analyzer (TFA) Collector.

2020/04/10 21:51:20 CLSRSC-594: Executing installation step 4 of 19: 'GenSiteGUIDs'.

2020/04/10 21:51:21 CLSRSC-594: Executing installation step 5 of 19: 'SetupOSD'.

2020/04/10 21:51:21 CLSRSC-594: Executing installation step 6 of 19: 'CheckCRSConfig'.

2020/04/10 21:51:22 CLSRSC-594: Executing installation step 7 of 19: 'SetupLocalGPNP'.

2020/04/10 21:51:25 CLSRSC-594: Executing installation step 8 of 19: 'CreateRootCert'.

2020/04/10 21:51:26 CLSRSC-594: Executing installation step 9 of 19: 'ConfigOLR'.

2020/04/10 21:51:39 CLSRSC-594: Executing installation step 10 of 19: 'ConfigCHMOS'.

2020/04/10 21:52:17 CLSRSC-594: Executing installation step 11 of 19: 'CreateOHASD'.

2020/04/10 21:52:21 CLSRSC-594: Executing installation step 12 of 19: 'ConfigOHASD'.

2020/04/10 21:52:21 CLSRSC-330: Adding Clusterware entries to file 'oracle-ohasd.service'

2020/04/10 21:53:31 CLSRSC-594: Executing installation step 13 of 19: 'InstallAFD'.

2020/04/10 21:53:35 CLSRSC-594: Executing installation step 14 of 19: 'InstallACFS'.

2020/04/10 21:55:13 CLSRSC-594: Executing installation step 15 of 19: 'InstallKA'.

2020/04/10 21:55:16 CLSRSC-594: Executing installation step 16 of 19: 'InitConfig'.

2020/04/10 21:55:35 CLSRSC-594: Executing installation step 17 of 19: 'StartCluster'.

2020/04/10 21:56:43 CLSRSC-343: Successfully started Oracle Clusterware stack

2020/04/10 21:56:43 CLSRSC-594: Executing installation step 18 of 19: 'ConfigNode'.

2020/04/10 21:58:37 CLSRSC-594: Executing installation step 19 of 19: 'PostConfig'.

2020/04/10 21:59:06 CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

[root@db19c2(+ASM2):/dg/app/product/gihome] 

 

 

Error 4 opening dom ASM/Self in 0x855fa90

Domain name to open is ASM/Self 

Error 4 opening dom ASM/Self in 0x855fa90

 

 19C: While Executing Root.sh on Remote Nodes HIT UNEXPECTED "ERROR 4 OPENING DOM ASM/SELF IN 0x57f7d60" (Doc ID 2571719.1)

   =-=> 이상 없음 ( 날수 있고 안 날 수 있음 )

 

 

 [root@db19c1(+ASM1):/dg/app/product/gihome] crsctl status res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details       

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.LISTENER.lsnr

               ONLINE  ONLINE       db19c1                   STABLE

               ONLINE  ONLINE       db19c2                   STABLE

ora.MGMT_DG.GHCHKPT.advm

               OFFLINE OFFLINE      db19c1                   STABLE

               OFFLINE OFFLINE      db19c2                   STABLE

ora.chad

               ONLINE  ONLINE       db19c1                   STABLE

               ONLINE  ONLINE       db19c2                   STABLE

ora.helper

               OFFLINE OFFLINE      db19c1                   STABLE

               OFFLINE OFFLINE      db19c2                   IDLE,STABLE

ora.mgmt_dg.ghchkpt.acfs

               OFFLINE OFFLINE      db19c1                   volume /opt/oracle/r

                                                             hp_images/chkbase is

                                                             unmounted,STABLE

               OFFLINE OFFLINE      db19c2                   STABLE

ora.net1.network

               ONLINE  ONLINE       db19c1                   STABLE

               ONLINE  ONLINE       db19c2                   STABLE

ora.ons

               ONLINE  ONLINE       db19c1                   STABLE

               ONLINE  ONLINE       db19c2                   STABLE

ora.proxy_advm

               ONLINE  ONLINE       db19c1                   STABLE

               ONLINE  ONLINE       db19c2                   STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)

      1        ONLINE  ONLINE       db19c1                   STABLE

      2        ONLINE  ONLINE       db19c2                   STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       db19c1                   STABLE

ora.MGMTLSNR

      1        ONLINE  ONLINE       db19c1                   169.254.13.179 10.10

                                                             .20.55,STABLE

ora.MGMT_DG.dg(ora.asmgroup)

      1        ONLINE  ONLINE       db19c1                   STABLE

      2        ONLINE  ONLINE       db19c2                   STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.OCRVOT_DG.dg(ora.asmgroup)

      1        ONLINE  ONLINE       db19c1                   STABLE

      2        ONLINE  ONLINE       db19c2                   STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.asm(ora.asmgroup)

      1        ONLINE  ONLINE       db19c1                   Started,STABLE

      2        ONLINE  ONLINE       db19c2                   Started,STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.asmnet1.asmnetwork(ora.asmgroup)

      1        ONLINE  ONLINE       db19c1                   STABLE

      2        ONLINE  ONLINE       db19c2                   STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.cvu

      1        ONLINE  ONLINE       db19c1                   STABLE

ora.db19c1.vip

      1        ONLINE  ONLINE       db19c1                   STABLE

ora.db19c2.vip

      1        ONLINE  ONLINE       db19c2                   STABLE

ora.mgmtdb

      1        ONLINE  ONLINE       db19c1                   Open,STABLE

ora.qosmserver

      1        ONLINE  ONLINE       db19c1                   STABLE

ora.rhpserver

      1        OFFLINE OFFLINE                               STABLE

ora.scan1.vip

      1        ONLINE  ONLINE       db19c1                   STABLE

--------------------------------------------------------------------------------

[root@db19c1(+ASM1):/dg/app/product/gihome] 

 

 

 

 [root@db19c2(+ASM2):/dg/app/product/gihome] crsctl status res -t

--------------------------------------------------------------------------------

Name           Target  State        Server                   State details       

--------------------------------------------------------------------------------

Local Resources

--------------------------------------------------------------------------------

ora.LISTENER.lsnr

               ONLINE  ONLINE       db19c1                   STABLE

               ONLINE  ONLINE       db19c2                   STABLE

ora.MGMT_DG.GHCHKPT.advm

               OFFLINE OFFLINE      db19c1                   STABLE

               OFFLINE OFFLINE      db19c2                   STABLE

ora.chad

               ONLINE  ONLINE       db19c1                   STABLE

               ONLINE  ONLINE       db19c2                   STABLE

ora.helper

               OFFLINE OFFLINE      db19c1                   STABLE

               OFFLINE OFFLINE      db19c2                   IDLE,STABLE

ora.mgmt_dg.ghchkpt.acfs

               OFFLINE OFFLINE      db19c1                   volume /opt/oracle/r

                                                             hp_images/chkbase is

                                                             unmounted,STABLE

               OFFLINE OFFLINE      db19c2                   STABLE

ora.net1.network

               ONLINE  ONLINE       db19c1                   STABLE

               ONLINE  ONLINE       db19c2                   STABLE

ora.ons

               ONLINE  ONLINE       db19c1                   STABLE

               ONLINE  ONLINE       db19c2                   STABLE

ora.proxy_advm

               ONLINE  ONLINE       db19c1                   STABLE

               ONLINE  ONLINE       db19c2                   STABLE

--------------------------------------------------------------------------------

Cluster Resources

--------------------------------------------------------------------------------

ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)

      1        ONLINE  ONLINE       db19c1                   STABLE

      2        ONLINE  ONLINE       db19c2                   STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.LISTENER_SCAN1.lsnr

      1        ONLINE  ONLINE       db19c1                   STABLE

ora.MGMTLSNR

      1        ONLINE  ONLINE       db19c1                   169.254.13.179 10.10

                                                             .20.55,STABLE

ora.MGMT_DG.dg(ora.asmgroup)

      1        ONLINE  ONLINE       db19c1                   STABLE

      2        ONLINE  ONLINE       db19c2                   STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.OCRVOT_DG.dg(ora.asmgroup)

      1        ONLINE  ONLINE       db19c1                   STABLE

      2        ONLINE  ONLINE       db19c2                   STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.asm(ora.asmgroup)

      1        ONLINE  ONLINE       db19c1                   Started,STABLE

      2        ONLINE  ONLINE       db19c2                   Started,STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.asmnet1.asmnetwork(ora.asmgroup)

      1        ONLINE  ONLINE       db19c1                   STABLE

      2        ONLINE  ONLINE       db19c2                   STABLE

      3        OFFLINE OFFLINE                               STABLE

ora.cvu

      1        ONLINE  ONLINE       db19c1                   STABLE

ora.db19c1.vip

      1        ONLINE  ONLINE       db19c1                   STABLE

ora.db19c2.vip

      1        ONLINE  ONLINE       db19c2                   STABLE

ora.mgmtdb

      1        ONLINE  ONLINE       db19c1                   Open,STABLE

ora.qosmserver

      1        ONLINE  ONLINE       db19c1                   STABLE

ora.rhpserver

      1        OFFLINE OFFLINE                               STABLE

ora.scan1.vip

      1        ONLINE  ONLINE       db19c1                   STABLE

--------------------------------------------------------------------------------

[root@db19c2(+ASM2):/dg/app/product/gihome] 

 

 

 

34.GIF

 

35.GIF

 

36.GIF

 

37.GIF

 

퍼미션_변경.GIF

 

퍼미션_변경-1.GIF

 

GRID 설치 종료 합니다.

 

 

 

번호 제목 글쓴이 날짜 조회 수
40 Oracle Database 19c Patch Update(단일 인스턴스 오라클 DB 19.3 에서 19.9로 RU Update) 명품관 2020.11.24 35230
39 New version of our Hands-On Lab available for download "Upgrade/Migrate/Consolidate to Oracle 12c" HOL 명품관 2015.12.22 8994
38 How to Enable/Disable Oracle Binary Option [1] Talros 2016.03.09 8626
37 19c RAC OJVM 패치작업 우뽕 2020.04.22 5322
36 Oracle RAC RU rolling patching from 19.3 to 19.9.0.0.201020(Patch 31750108) [1] file 명품관 2020.12.08 5279
35 Oracle 19c RAC 설치 with Oracle Linux 8.2 - 2 (Grid Infrastructure) file 명품관 2020.11.19 5109
34 Oracle 19c RAC 설치 with Oracle Linux 8.2 - 1 (OS 및 스토리지 설정) 명품관 2020.11.14 4889
33 ASM 에 spfile 등록 및 삭제 하기 우뽕 2020.07.27 4485
32 오라클 21c RAC 설치 with Oracle Linux 8.2 - 1 (OS 및 스토리지 설정) 명품관 2021.12.01 3073
31 Oracle 19c RAC 설치 with Oracle Linux 8.2 - 5 (DBCA로 Database 생성) file 명품관 2020.11.19 2834
30 19c RAC 2Node 설치 -1 [ 환경 ,OS 세팅 ] file 우뽕 2020.04.14 2696
29 19c RAC - Manual Patch 적용방법 우뽕 2020.05.05 2347
28 Oracle EM(Enterprise Manager) 13.4 설치 및 구성 - 2(EM 설치) file 명품관 2020.11.27 2342
27 Oracle 19c RAC 설치 with Oracle Linux 8.2 - 3 (사용할 Disk Group 생성) file 명품관 2020.11.19 1495
26 DBCA/DBUA 사용시 마지막 단계 Finish 버튼 클릭 후 행 현상 발생 시 체크 사항 명품관 2015.12.17 1465
25 19c RAC 2Node 설치-8 [ Patch ] 우뽕 2020.04.22 1407
24 19c RAC 2Node 삭제 하기 file 우뽕 2020.04.22 1352
23 메뉴얼하게 DB 추가 작업 - GRID 리소스에 DB 추가 작업 우뽕 2020.07.27 1304
22 Oracle EM(Enterprise Manager) 13.4 설치 및 구성 - 1(Repository DB 설치) file 명품관 2020.11.23 1204
21 Automatic Storage Management (ASM) 사용시 고려해야 할 사항 [2] 우뽕 2020.02.06 1063
위로