Arquivo do mês: novembro 2013

Exadata InfiniBand Related Tools

Exadata InfiniBand Related Tools InfiniBand Related Tools # ibstat # ibstatus        — To get the status of the Infiniband services /usr/sbin/ibstatus # iblinkinfo       — To check the status of the Infiniband Link /usr/sbin/iblinkinfo.pl -Rl # ibswitches /usr/sbin/ibswitches … Continuar lendo

Publicado em EXADATA | Marcado com , , | Deixe um comentário

Ipmitool Oracle Exadata

Ipmitool Oracle Exadata IPMI — Intelligent Platform Management Interface, an interface standard that allows remote management, of a server from another, using standardized interface and to check status of components. # ipmitool # ipmitool -h         — Help # ipmitool … Continuar lendo

Publicado em EXADATA | Marcado com , | Deixe um comentário

Exadata Wait Events

Exadata Wait Events Here are the some of the wait events in Oracle Exadata. cell flash cache read hits cell single block physical read cell multiblock physical read cell list of blocks physical read cell smart file creation cell smart … Continuar lendo

Publicado em EXADATA | Marcado com , | Deixe um comentário

Exadata Statistics

Exadata Statistics Here is the list of Oracle Exadata Statistics. cell physical IO interconnect bytes cell physical IO interconnect bytes returned by smart scan cell physical IO bytes saved during optimized file creation cell physical IO bytes saved during optimized … Continuar lendo

Publicado em ORACLE 11gR2 | Marcado com , , , , , , , , , , | Deixe um comentário

dcli commands in Oracle Exadata

dcli commands in Oracle Exadata DCLI  — Distributed Command Line Interface/Interpreter (in Oracle Exadata) DCLI, a Python script, to execute commands across multiple cells (Oracle Exadata Storage Servers) from one cell. # dcli [Options] [Command] Command – Can be cellcli command or Linux command … Continuar lendo

Publicado em EXADATA | Marcado com | Deixe um comentário

cellcli commands in Oracle Exadata

cellcli commands in Oracle Exadata CellCLI  — Cell Command Line Interface/Interpreter (in Oracle Exadata) CellCLI manages Exadata Storage Servers (Cells). The scope of the CellCLI command is the cell where it is run, not in other cells. To invoke the CellCLI, login … Continuar lendo

Publicado em EXADATA | Marcado com , | Deixe um comentário

Goldengate com Exadata – manual de instalaçao

Oracle GoldenGate on Oracle Exadata Database Machine Configuration Oracle Maximum Availability Architecture White Paper May 2011 Maximum Availability Architecture Oracle Best Practices For High Availability Oracle White Paper—Oracle GoldenGate on Oracle Exadata Database Machine Configuration Executive Overview………………………………………………………………… 2 Configuration Overview … Continuar lendo

Publicado em EXADATA, GOLDENGATE | Marcado com , , , | Deixe um comentário

CARGA INCIAL POR EXEMPLOS

Fazendo uma carga direta com tabelas de colunas diferentes e filtrando dados. REPLICADOR —————————– Primeiramente crie o arquivo de parametros para um replicador de carga inicial =============================>>> REPORT <<<=============================== replicat repcarga SETENV (ORACLE_SID = “COMP”) userid ggcomp@comp, password oracle –handlecollisions … Continuar lendo

Publicado em GOLDENGATE | Marcado com , , , , | Deixe um comentário

MACRO PARA GERENCIAR ERROS ATRAVÉS DE EXCEPTION

— Replicator parameter file to apply changes — to tables — — — — This starts the macro — MACRO #exception_handler BEGIN , TARGET ggs_admin.exceptions , COLMAP ( rep_name = “RLOAD1” , table_name = @GETENV (“GGHEADER”, “TABLENAME”) , errno = … Continuar lendo

Publicado em GOLDENGATE | Marcado com , , , , | Deixe um comentário

Gerenciamento de conflitos com Goldengate

Oracle GoldenGate Best Practice – Oracle GoldenGate Conflict Management Version 1 Date: November 11, 2011 Ananth R. Tiru Senior Solutions Architect Center of Excellence Table of Contents Introduction: ………………………………………………………………………………………………………………………………. 3 Requirements: …………………………………………………………………………………………………………………………. 3 Methodology: ………………………………………………………………………………………………………………………….. 4 Approach: ……………………………………………………………………………………………………………………………….. 4 Implementation: … Continuar lendo

Publicado em GOLDENGATE | Marcado com , , , , , , , , | Deixe um comentário

Replicação Bidirecional com resolução de conflitos

Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active configuration Using Oracle GoldenGate (OGG) 11gR2 for Conflict Detection and Resolution (CDR) based on balance and timestamp in a bidirectional active-active … Continuar lendo

Publicado em GOLDENGATE | Marcado com , , , , , , | Deixe um comentário