메뉴 건너뛰기

Korea Oracle User Group

Install/Configuration

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

우뽕 2020.04.21 16:31 조회 수 : 1146

 

 

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 설치 종료 합니다.

 

 

 

위로