메뉴 건너뛰기

Korea Oracle User Group

Install/Configuration

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

우뽕 2020.04.21 16:31 조회 수 : 960

 

 

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 19c RAC 2Node 설치-6 [ db sw ] file 우뽕 2020.04.22 120
39 19c RAC 2Node 설치-9 [ dbca ] file 우뽕 2020.04.22 129
38 19c RAC 2Node 설치-10 [ dbca ] file 우뽕 2020.04.22 141
37 19c RAC 2Node 설치-7 [ db sw ] file 우뽕 2020.04.22 216
36 ORA-32000 : Spfile 수정이 불가능. [1] file 우뽕 2020.01.23 234
35 19c RAC 2Node 설치 -3 [ GRID ] file 우뽕 2020.04.21 244
34 19c RAC 2Node 설치-11[ dbca ] file 우뽕 2020.04.22 250
33 ORA-27300, ORA-27301, ORA-27302 Error 와 함께 DB Shutdown - 작성중. Talros 2020.08.28 321
32 오라클 21c RAC 설치 with Oracle Linux 8.2 - 3 (사용할 Disk Group 생성) file 명품관 2021.12.02 342
31 패치 conflict(충돌) 검사 방법 [1] 우뽕 2023.04.04 384
30 19c RAC 2Node 설치 -2 [ 환경, GRID ] file 우뽕 2020.04.21 395
29 12c R1 Install on Cent OS - Part 2 (Grid install) [1] file Talros 2016.02.15 396
28 오라클 21c RAC 설치 with Oracle Linux 8.2 - 5 (DBCA로 Database 생성) file 명품관 2021.12.02 497
27 19c RAC 2Node 설치-5 [ asmca ] file 우뽕 2020.04.21 519
26 12c R1 Install on Cent OS - Part 1 ( Preinstall ) file Talros 2016.02.02 527
25 오라클 21c RAC 설치 with Oracle Linux 8.2 - 4 (Database Software 설치) file 명품관 2021.12.02 801
24 오라클 21c RAC 설치 with Oracle Linux 8.2 - 2 (Grid Infrastructure) [1] file 명품관 2021.12.01 809
23 DBCA에서 ORA-12546: TNS:permission denied.. file 우뽕 2020.02.14 870
22 Oracle 19c RAC 설치 with Oracle Linux 8.2 - 4 (Database Software 설치) file 명품관 2020.11.19 953
» 19c RAC 2Node 설치 -4 [ GRID ] file 우뽕 2020.04.21 960
위로