Oracle Grid Infrastructure 12cR1 - Parte 10 - Validações Finais

Por Victor Armbrust
Postado em Janeiro 2014

Indice

1. Oracle Grid Infrastructure 12cR1 - Parte 1 - Visão Geral e Novos Recursos
2. Oracle Grid Infrastructure 12cR1 - Parte 2 - Configurando o Sistema Operacional
3. Oracle Grid Infrastructure 12cR1 - Parte 3 - Pré-Requisitos do Sistema Operacional
4. Oracle Grid Infrastructure 12cR1 - Parte 4 - Configurando DNS
5. Oracle Grid Infrastructure 12cR1 - Parte 5 - Pré-Requisitos do Grid Infrastructure
6. Oracle Grid Infrastructure 12cR1 - Parte 6 - Instalando o Grid Infrastructure
7. Oracle Grid Infrastructure 12cR1 - Parte 7 - Instalando o Database Software
8. Oracle Grid Infrastructure 12cR1 - Parte 8 - Criando Diskgroups no ASM
9. Oracle Grid Infrastructure 12cR1 - Parte 9 - Criando o Database
10.Oracle Grid Infrastructure 12cR1 - Parte 10 - Validações Finais

Ao término da criação do novo database, fazer uma verificação final no Ambiente.

Validação do Cluster

Verificar todos os serviços

# su – grid
# $ORACLE_HOME/bin/crsctl stat res -t

------------------------------------------------------------------------
Name           Target  State        Server               State details       
------------------------------------------------------------------------
Local Resources
------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       racnode1              STABLE
               ONLINE  ONLINE       racnode2              STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       racnode1              STABLE
               ONLINE  ONLINE       racnode2              STABLE
ora.OCR.dg
               ONLINE  ONLINE       racnode1              STABLE
               ONLINE  ONLINE       racnode2              STABLE
ora.asm
               ONLINE  ONLINE       racnode1              Started,STABLE
               ONLINE  ONLINE       racnode2              Started,STABLE
ora.net1.network
               ONLINE  ONLINE       racnode1              STABLE
               ONLINE  ONLINE       racnode2              STABLE
ora.ons
               ONLINE  ONLINE       racnode1              STABLE
               ONLINE  ONLINE       racnode2              STABLE
-----------------------------------------------------------------------
Cluster Resources
-----------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       racnode1                 STABLE
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       racnode2                 STABLE
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       racnode2                 STABLE
ora.MGMTLSNR
      1        ONLINE  ONLINE       racnode2                 169.254.50.16 10.11.
                                                             0.2 10.1.0.2,STABLE
ora.cvu
      1        ONLINE  ONLINE       racnode2                 STABLE
ora.mgmtdb
      1        ONLINE  ONLINE       racnode2                 Open,STABLE
ora.oc4j
      1        ONLINE  ONLINE       racnode2                 STABLE
ora.oradb.db
      1        ONLINE  ONLINE       racnode1                 Open,STABLE
      2        ONLINE  ONLINE       racnode2                 Open,STABLE
ora.racnode1.vip
      1        ONLINE  ONLINE       racnode1                 STABLE
ora.racnode2.vip
      1        ONLINE  ONLINE       racnode2                 STABLE
ora.scan1.vip
      1        ONLINE  ONLINE       racnode1                 STABLE
ora.scan2.vip
      1        ONLINE  ONLINE       racnode2                 STABLE
ora.scan3.vip
      1        ONLINE  ONLINE       racnode2                 STABLE
--------------------------------------------------------------------------------

Validação do OCR

Verificar o local dos discos do OCR/Voting

# su – grid

# $GRID_HOME/bin/ocrcheck

Status of Oracle Cluster Registry is as follows :
         Version                  :          4
         Total space (kbytes)     :     409568
         Used space (kbytes)      :       1552
         Available space (kbytes) :     408016
         ID                       : 1530974981
         Device/File Name         :       +OCR
                                   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 bypassed due to non-privileged user

CVU

Executar o CVU para validação

# su – grid
# cd /u01/install/RAC_DB_12c/grid
# ./runcluvfy.sh stage -post crsinst -n racnode1,racnode2

# ./runcluvfy.sh stage -post crsinst -n racnode1,racnode2

Performing pre-checks for cluster services setup 

Checking node reachability...
Node reachability check passed from node "racnode1"


Checking user equivalence...
User equivalence check passed for user "grid"

Checking node connectivity...

Checking hosts config file...

Verification of the hosts config file successful

Node connectivity passed for subnet "10.11.0.0" with node(s) 
racnode1,racnode2
TCP connectivity check passed for subnet "10.11.0.0"

Node connectivity passed for subnet "10.1.0.0" with node(s)
racnode1,racnode2
TCP connectivity check passed for subnet "10.1.0.0"

Node connectivity passed for subnet "192.168.1.0" with node(s) 
racnode1,racnode2
TCP connectivity check passed for subnet "192.168.1.0"


Interfaces found on subnet "192.168.1.0" that are likely 
candidates for VIP are:
racnode1 bond0:192.168.1.11
racnode2 bond0:192.168.1.12

Interfaces found on subnet "10.11.0.0" that are likely candidates 
for a private interconnect are:
racnode1 eth2:10.11.0.1
racnode2 eth2:10.11.0.2

Interfaces found on subnet "10.1.0.0" that are likely candidates 
for a private interconnect are:
racnode1 eth3:10.1.0.1
racnode2 eth3:10.1.0.2
Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "10.11.0.0".
Subnet mask consistency check passed for subnet "10.1.0.0".
Subnet mask consistency check passed for subnet "192.168.1.0".
Subnet mask consistency check passed.

Node connectivity check passed

Checking multicast communication...

Checking subnet "10.11.0.0" for multicast communication with 
multicast group "224.0.0.251"...
Check of subnet "10.11.0.0" for multicast communication with 
multicast group "224.0.0.251" passed.

Check of multicast communication passed.

Checking ASMLib configuration.
Check for ASMLib configuration passed.
Total memory check passed
Available memory check passed
Swap space check passed
Free disk space check passed for "racnode2:/usr,racnode2:/var,racnode2:/
etc,racnode2:/sbin,racnode2:/tmp"

Free disk space check passed for "racnode1:/usr,racnode1:/var,racnode1:/
etc,racnode1:/sbin,racnode1:/tmp"
Check for multiple users with UID value 501 passed 
User existence check passed for "grid"
Group existence check passed for "oinstall"
Group existence check passed for "dba"
Membership check for user "grid" in group "oinstall" [as Primary] passed
Membership check for user "grid" in group "dba" passed
Run level check passed
Hard limits check passed for "maximum open file descriptors"
Soft limits check passed for "maximum open file descriptors"
Hard limits check passed for "maximum user processes"
Soft limits check passed for "maximum user processes"
System architecture check passed
Kernel version check passed
Kernel parameter check passed for "semmsl"
Kernel parameter check passed for "semmns"
Kernel parameter check passed for "semopm"
Kernel parameter check passed for "semmni"
Kernel parameter check passed for "shmmax"
Kernel parameter check passed for "shmmni"
Kernel parameter check passed for "shmall"
Kernel parameter check passed for "file-max"
Kernel parameter check passed for "ip_local_port_range"
Kernel parameter check passed for "rmem_default"
Kernel parameter check passed for "rmem_max"
Kernel parameter check passed for "wmem_default"
Kernel parameter check passed for "wmem_max"
Kernel parameter check passed for "aio-max-nr"
Package existence check passed for "make"
Package existence check passed for "binutils"
Package existence check passed for "gcc(x86_64)"
Package existence check passed for "libaio(x86_64)"
Package existence check passed for "glibc(x86_64)"
Package existence check passed for "compat-libstdc++-33(x86_64)"
Package existence check passed for "glibc-devel(x86_64)"
Package existence check passed for "gcc-c++(x86_64)"
Package existence check passed for "libaio-devel(x86_64)"
Package existence check passed for "libgcc(x86_64)"
Package existence check passed for "libstdc++(x86_64)"
Package existence check passed for "libstdc++-devel(x86_64)"
Package existence check passed for "sysstat"
Package existence check passed for "ksh"
Package existence check passed for "nfs-utils"

Checking availability of ports "6200,6100" required for 
component "Oracle Notification Service (ONS)"
Port availability check passed for ports "6200,6100"
Check for multiple users with UID value 0 passed 
Current group ID check passed

Starting check for consistency of primary group of root user

Check for consistency of root user's primary group passed

Starting Clock synchronization checks using Network Time Protocol(NTP)...

NTP Configuration file check started...
NTP Configuration file check passed

Checking daemon liveness...
Liveness check passed for "ntpd"
Check for NTP daemon or service alive passed on all nodes

NTP common Time Server Check started...
Check of common NTP Time Server passed

Clock time offset check from NTP Time Server started...
Clock time offset check passed

Clock synchronization check using Network Time Protocol(NTP) passed

Core file name pattern consistency check passed.

User "grid" is not part of "root" group. Check passed
Default user file creation mask check passed
Checking integrity of file "/etc/resolv.conf" across nodes

"domain" and "search" entries do not coexist in any  "/etc/resolv.conf" file
All nodes have same "search" order defined in file "/etc/resolv.conf"
The DNS response time for an unreachable node is within acceptable limit on all nodes

Check for integrity of file "/etc/resolv.conf" passed

Time zone consistency check passed

Checking integrity of name service switch configuration file "/etc/nsswitch.conf" ...
All nodes have same "hosts" entry defined in file "/etc/nsswitch.conf"

Check for integrity of name service switch configuration file "/etc/nsswitch.conf" passed


Checking daemon "avahi-daemon" is not configured and running
Daemon not configured check passed for process "avahi-daemon"
Daemon not running check passed for process "avahi-daemon"

Starting check for /dev/shm mounted as temporary file system ...

Check for /dev/shm mounted as temporary file system passed

Starting check for /boot mount ...

Check for /boot mount passed

Starting check for zeroconf check ...

Check for zeroconf check passed

Pre-check for cluster services setup was successful on all the nodes. 

Versão do Banco de Dados

Verificar a versão do Banco de Dados

# su – oracle
# sqlplus / as sysdba

SQL> select name,open_mode from v$database;
NAME      OPEN_MODE
--------- --------------------
ORCL      READ WRITE

SQL> select banner from v$version;
BANNER
-----------------------------------------------------------------------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
PL/SQL Release 12.1.0.1.0 - Production
CORE     12.1.0.1.0             Production
TNS for Linux: Version 12.1.0.1.0 - Production
NLSRTL Version 12.1.0.1.0 - Production

SQL>

É importante lembrar que este Database foi criado como Container Database (CDB) para permitir a migração e criação de novos PDBs. Sendo assim, este database está pronto para uso.

 


Victor Armbrust é DBA há 10 anos, especialista em Banco de Dados Oracle e Bacharel em Ciências da Computação. Com sólidos conhecimentos em Banco de Dados e Sistemas operacionais, possui certificações OCP 10g/11g. Eleito Oracle ACE Member em 2013.
 Consultor de Banco de Dados na Oracle ACS Brasil.