Este artigo tem como objetivo demonstrar a Criação dos Discos de Grupo e Instalar o Produto Oracle Database 11g.

Para criar os Discos de Grupo vamos acessar o Sqlplus via com o privilégio SYSASM. Caso queira criar com o ASMCA acesse o artigo Clicando Aqui.

Vamos acessar o Sqlplus no Node 1 e criar os Discos de Grupos (+DGDATA, +DGREDO).

[root@imrac11g1 ~]# su - oracle
oracle=orcl1-> . .var_oracle_grid.sh
oracle=+ASM1-> sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 6 00:19:43 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> create diskgroup DGDATA external redundancy disk 'ORCL:ASM1' attribute 'compatible.asm'='11.2','compatible.rdbms'='10.1';

Diskgroup created.

SQL> create diskgroup DGREDO external redundancy disk 'ORCL:ASM3' attribute 'compatible.asm'='11.2','compatible.rdbms'='10.1';

Diskgroup created.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
oracle=+ASM1->

Maiores informações sobre criação de Discos de Grupo no ASM acesse Administering Oracle ASM Disk Groups.
OBS: Durante a criação dos Discos de Grupo, verificar se os mesmos estão montados nos Dois Nodes. Caso não esteja, acessar o Node2 conforme abaixo e montar os mesmos após já criados.

oracle=orcl2-> pwd
/home/oracle
oracle=orcl2-> . .var_oracle_grid.sh
oracle=+ASM2-> sqlplus / as sysasm

SQL*Plus: Release 11.2.0.3.0 Production on Thu Feb 6 00:29:09 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options

SQL> alter diskgroup DGDATA mount;

Diskgroup altered.

SQL> alter diskgroup DGREDO mount;

Diskgroup altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
oracle=+ASM2->

Vamos neste momento instalar o produto Oracle Database 11g (11.2.0.3).
Segue abaixo o passo a passo.

Executar o Script conforme abaixo em ambos os Nodes. (Este é um exemplo da Imagem acima de Instalação do produto Oracle Database).

[root@imrac11g1 ~]# /u01/app/oracle/product/11.2.0/db_01/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/db_01

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.
Finished product-specific root actions.
[root@imrac11g1 ~]#

#### Node2 ####

[root@imrac11g2 ~]# /u01/app/oracle/product/11.2.0/db_01/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/product/11.2.0/db_01

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.
Finished product-specific root actions.
[root@imrac11g2 ~]#

Conforme citado nas imagens acima IPMI (Intelligent Platform Management Interface) no Oracle RAC 11gR2 fornece um conjunto de interfaces comuns para o hardware e firmware que os administradores de sistema podem usar para monitorar e gerenciar a saúde do sistema. Com o Oracle Database 11g Release 2, o Oracle Clusterware pode integrar IPMI para fornecer suporte de isolamento de falhas e para garantir a integridade do cluster.

Maiores informações acesse sobre IPMI acesse Enabling Intelligent Platform Management Interface (IPMI).

Continua no artigo Implementando Oracle Database 11gR2 RAC on Virtualbox em Linux com ISCSI – P4.

Autor: Maycon Tomiasi

Formado em Tecnologia da Informação na FIPP (Faculdade de Informática de Presidente Prudente), Analista DBA Oracle pela Teiko Soluções em Tecnologia da Informação, residente em Blumenau/ SC, Certificado OCP 10g/11g/12c, OCS 11g Implementation, OCE 11g Performance Tuning, OCE 11g RAC & GRID e OPN Specialist. Conhecimentos em PHP.

• 
•