Oracle Technology Network
Artigos
Grid Computing
Artigos
Grid Computing
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.
Printer ViewEntre em Contato Conosco
- Vendas: 0800-891-4433
- Contatos Globais
- Diretório de Suporte