Parte 2- Instalando GRID

No Lab anterior, vimos como configurar os Discos utilizando ASMLIB. Agora, o próximo passo é instalação do Grid.

Configurando Pré-requisitos

• Download Software (Grid Infrastructure)

# mkdir -p /u01/stage
# chown oracle:oinstall /u01/stage

OTN: Oracle Database 12c Release 2 (12.2.0.1) Software (64-bit).
edelivery: Oracle Database 12c Release 2 (12.2.0.1) Software (64-bit)

• Configurar /etc/hosts

# vim /etc/hosts
127.0.0.1 srvoracle-asm localhost localhost.localdomain localhost4 localhost4.localdomain4

• Configurar Diretórios

# mkdir -p /u01/app/oracle/12.2.0/grid
# chown oracle:oinstall /u01 -R

• Unzip Oracle Grid Software

$ cd /u01/app/oracle/12.2.0/grid
$ unzip /u01/stage/linuxx64_12201_grid_home.zip

• Configurar SHM no Oracle Linux 7

# vim /etc/fstab
tmpfs /dev/shm tmpfs defaults,size=2G 0 0

• Criar .profileGRID

 $ vim /home/oracle/.profileGRID

Executar Instalador GRID

$ cd /u01/app/oracle/12.2.0/grid
$ sh gridSetup.sh

• Alterar as opções:

Configure Oracle Grid Infrastructure for a Standalone Server (Oracle Restart)

Grupo ADM do Oracle Asm: oinstall
Grupo DBA do Oracle Asm: oinstall

Change Discovery Path
/dev/oracleasm/disks/

Verificando os Discos e Serviços

$ crsctl status res -t
$ sqlplus / as sysasm

COL NAME FORMAT A10;
COL PATH FORMAT A30;
SELECT MOUNT_STATUS,HEADER_STATUS,MODE_STATUS,STATE,TOTAL_MB,FREE_MB,NAME,PATH,LABEL
FROM V$ASM_DISK;

COL COMPATIBILITY FORMAT A10;
SELECT NAME,STATE,TYPE,TOTAL_MB,FREE_MB,COMPATIBILITY,OFFLINE_DISKS FROM V$ASM_DISKGROUP;