Saturday, September 16, 2017

Published Oracle Technology Articles (Oracle Technology Network (OTN), OraWorld Magazine and All things ORACLE from Redgate


Published 100+ Oracle Technology Articles Globally - Oracle Technology Network (OTN), OraWorld Magazine and 
All things ORACLE from Redgate 

Co-Author – OraWorld Magazine (4 Articles)


Article-1: OraWorld Magazine has published - Topic on CBO Artificial Intelligence (Part-2)
http://www.oraworld.org/fileadmin/documents/13-2019_ORAWORLD.pdf

Article-2: OraWorld Magazine has published - Topic on CBO Artificial Intelligence (Part-1)
http://www.oraworld.org/fileadmin/documents/12-ORAWORLD-k.pdf

Article-3: OraWorld Magazine has published - Topic on "Oracle Analytical Functions:Tips and Tricks"
http://www.oraworld.org/fileadmin/documents/11-2018_ORAWORLD.pdf

Article-4: Oracle Exadata Database Machine: Decade of Innovation
http://www.oraworld.org/fileadmin/documents/18-ORAWORLD.pdf

Oracle Technology Network (OTN) – English  (6 Articles)


Article-1: Multiple Pluggable Database (PDBs) Replication in Multitenant Database Using Oracle GoldenGate 12c
https://community.oracle.com/docs/DOC-995763

Article-2: Data Replication with Multiple Extracts and Multiple Replicats with Integrated Capture Mode Using 
Oracle GoldenGate 12c
https://community.oracle.com/docs/DOC-995764

Article-3: Upgrade Options In Oracle 12c Multitenant Database
https://community.oracle.com/docs/DOC-995765

Article-4: Bi-Directional Replication with Pluggable Database (PDB) in Multitenant Database Using Oracle GoldenGate 12c
https://community.oracle.com/docs/DOC-995762

Article-5: How To Query Hive and Impala from Oracle using ODBC Heterogeneous Gateway
https://community.oracle.com/docs/DOC-1002634

Article-6: Database Patching: Patch like a King with a Single Click – Database As A Service (DbaaS)
https://community.oracle.com/docs/DOC-1005964

Oracle Technology Network (OTN) – SPANISH  (47 Articles)


Article-1: Oracle RAC 12c: "Flex ASM" y "Flex Cluster"
http://www.oracle.com/technetwork/es/articles/database-performance/caracteristicas-flex-asm-y-cluster-2088714-esa.html

Article-2: Oracle Exadata Database Machine: "Smart Flash Logging"
http://www.oracle.com/technetwork/es/articles/database-performance/exadata-smart-flash-logging-2088700-esa.html

Article-3: Oracle Exadata Database Machine: “Exachk”
http://www.oracle.com/technetwork/es/articles/database-performance/exadata-database-machine-exachk-2095610-esa.html

Article-4: Oracle Exadata Database Machine: “Exadata Hybrid Columnar Compression (EHCC)”
http://www.oracle.com/technetwork/es/articles/database-performance/exadata-hybrid-columnar-compression-2098797-esa.html

Article-5: Oracle Exadata Database Machine: “Write-Back Flash Cache”
http://www.oracle.com/technetwork/es/articles/database-performance/exadata-write-back-flash-cache-2101480-esa.html

Article-6: Oracle Exadata Database Machine: IO Resource Manager (IORM)
http://www.oracle.com/technetwork/es/articles/database-performance/io-resource-manager-2100979-esa.html

Article-7: Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 1) 
http://www.oracle.com/technetwork/es/articles/database-performance/seguridad-asm-base-de-datos-parte1-2166616-esa.html

Article-8: Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 2)
http://www.oracle.com/technetwork/es/articles/database-performance/seguridad-asm-base-datos-parte2-2167445-esa.html

Article-9: Oracle Exadata Database Machine: Seguridad a nivel de ASM y de Base de Datos (Parte 3)
http://www.oracle.com/technetwork/es/articles/database-performance/seguridad-asm-base-datos-parte3-2167449-esa.html

Article-10: Todo lo que tienes que saber sobre COMMON y LOCAL en Oracle Database 12c
http://www.oracle.com/technetwork/es/articles/idm/common-local-12c-2190666-esa.html

Article-11: Oracle Database 12c: Una introducción a los conceptos de Respaldo, Recuperación y Recuperación a 
un punto en el tiempo (PITR) de PDBs
http://www.oracle.com/technetwork/es/articles/database-performance/pdbs-backup-recovery-dbpitr-2192211-esa.html

Article-12: Migración a la versión 12c de la base de datos Oracle sin interrupción de servicio usando 
Oracle Golden Gate 12c
http://www.oracle.com/technetwork/es/articles/datawarehouse/oracle-golden-gate-2192209-esa.html

Article-13: RMAN: Como hacer para Restaurar y/o Recuperar solo los "Tablespaces" esenciales
http://www.oracle.com/technetwork/es/articles/database-performance/restaurar-recuperar-tablespaces-2228109-esa.html

Article-14: Oracle Standby Database, un "amigo" para 1000 casos
http://www.oracle.com/technetwork/es/articles/database-performance/oracle-standby-database-2232804-esa.html

Article-15: Oracle Database 12c: Data Redaction
http://www.oracle.com/technetwork/es/articles/idm/oracle-data-redaction-12c-esp-2226725-esa.html

Article-16: Oracle Database 12c: Cómo usar archivos “XML Manifest” para conectar y desconectar PDBs
http://www.oracle.com/technetwork/es/articles/sql/xml-manifest-pdbs-2244550-esa.html

Article-17: Creación de un reporte simple usando Information Publisher Report.
http://www.oracle.com/technetwork/es/articles/oem/reportes-con-information-publisher-2492705-esa.html

Article-18: Oracle Database as a Service (DBaaS): Aplicando Parches con un clic
http://www.oracle.com/technetwork/es/articles/database-performance/aplicar-parche-oracle-dbaas-3338001-esa.html

Article-19: Oracle Database 12c Multitenant: Métodos de Upgrade
http://www.oracle.com/technetwork/es/articles/database-performance/multitenant-metodos-de-upgrade-3351666-esa.html

Article-20: Replicación consolidada y en cascada (DDL and DML) usando Oracle GoldenGate (11g y 12c) entre 
Bases de Datos Oracle (11g y 12c)
http://www.oracle.com/technetwork/es/articles/database-performance/consolidada-cascada-ddl-dml-3418927-esa.html

Article-21: Arquitectura y Setup de FileSystems ACFS en Oracle 12c RAC de 3 Nodos con Flex ASM
http://www.oracle.com/technetwork/es/articles/database-performance/setup-filesystems-acfs-flex-asm-3427843-esa.html

Article-22: Replicación de datos con múltiples procesos "Extract" y "Replicat" con el modo de captura integrada 
utilizando Oracle GoldenGate 12c
http://www.oracle.com/technetwork/es/articles/database-performance/replicacion-datos-multiples-proceso-3661869-esa.html

Article-23: Oracle Exadata Database Machine - Funcionalidad :Disk Scrubbing
http://www.oracle.com/technetwork/es/articles/database-performance/exadata-db-machine-disk-scrubbing-3679915-esa.html

Article-24: Replicación entre IBM DB2 LUW y Oracle Database utilizando Oracle GoldenGate Parte I
http://www.oracle.com/technetwork/es/articles/database-performance/repliacion-ibm-3713613-esa.html

Article-25: Clonación en Caliente de una Pluggable Database (PDB) en Ambiente Multi-Tenant con Oracle Database 12c R2.
http://www.oracle.com/technetwork/es/articles/database-performance/clonacion-pdb-3713590-esa.html

Article-26: Uso de OAKCLI en Oracle Database Appliance (ODA) X5-2 con Alta Disponibilidad.
http://www.oracle.com/technetwork/es/articles/database-performance/uso-de-oakcli-3709129-esa.html

Article-27: Replicación de múltiples bases de datos “Pluggable” (PDBs) en una arquitectura 
“Multitenant” utilizando Oracle GoldenGate 12c
http://www.oracle.com/technetwork/es/articles/database-performance/bases-de-datos-pluggable-3708769-  esa.html

Article-28: Replicacion bidireccional con base de datos Pluggable (PDB) en una arquitectura Multitenant utilizando 
Oracle GoldenGate 12c
http://www.oracle.com/technetwork/es/articles/database-performance/replicacion-bidireccional-3737802-esa.html

Article-29: Reubicando Pluggable Database (PDB) en Modo READ WRITE en Ambiente MultiTenant con Real Application Cluster (RAC)
http://www.oracle.com/technetwork/es/articles/database-performance/default-3754342-esa.html

Article-30: Performance Profiles para PDBs en Oracle Database 12c Release 2
http://www.oracle.com/technetwork/es/articles/database-performance/perform-profile-3803116-esa.html

Article-31: Consultando Impala y Hive desde Oracle usando un gateway heterogeneo ODBC
http://www.oracle.com/technetwork/es/articles/database-performance/default-3679880-esa.html

Article-32: Creando puntos de restauración de base de datos utilizando snapshots ZFS de Oracle Solaris
http://www.oracle.com/technetwork/es/articles/database-performance/restaura-db-snapshots-zfs-oracle-3679894-esa.html

Article-33: Configuración y administración de Oracle Database Vault 12c en un ambiente “Multitenant” utilizando 
Oracle Enterprise Manager 12c.
http://www.oracle.com/technetwork/es/articles/database-performance/databasevault-12c-multitenant-3703502-esa.html

Article-34: Flashback Pluggable Database (PDB) en Ambiente Multi-Tenant con Oracle Database 12c R2.
http://www.oracle.com/technetwork/es/articles/database-performance/flashback-pdb-3715323-esa.html

Article-35: Instalación de Parches de Servidor, Discos y Base de Datos en un Oracle Database Appliance (ODA) 
X5-2 High Availability (HA)
http://www.oracle.com/technetwork/es/articles/database-performance/parches-discos-3803644-esa.html

Article-36: Juego de Caracteres de PDBs, Como limitar IO por PDB y Como Configurar Memoria por PDB en Ambientes 
Multi-Tenant Usando Oracle 12c R2 (12.2.0.1.0)
http://www.oracle.com/technetwork/es/articles/database-performance/juegodecaracteres-3873458-esa.html

Article-37: Upgrade de Oracle Database Appliance (ODA) utilizando Re-imaging de Sistema Operativo
https://www.oracle.com/technetwork/es/articles/database-performance/upgrade-oda-re-imaging-5278093-esa.html

Article-38: Descubriendo Oracle Database Appliance (ODA) en Oracle Enterprise Manager Cloud Control (OEM).
https://www.oracle.com/technetwork/es/articles/oem/odb-appliance-en-oem-5231544-esa.html

Article-39: Oracle Database 12cR2 (12.2.0) ACFS Security y ACFS Encryption
https://www.oracle.com/technetwork/es/articles/idm/acfs-sec-encryption-5143934-esa.html

Article-40: Instalación y Configuración de la Infrastructura Grid e Instalación del Software de Base de Datos 
Oracle 12c R2 (12.2.0.1.0) en Alta Disponibilidad
https://www.oracle.com/technetwork/es/articles/grid/instalacion-conf-grid-5095571-esa.html

Article-41: Utilitario DBMCLI en Oracle Exadata Database Machine
https://www.oracle.com/technetwork/es/articles/database-performance/dbmcli-oracle-exadatadb-4406856-esa.html

Article-42: Crear una Snapshot Database en Oracle Database Appliance (ODA) X5-2
https://www.oracle.com/technetwork/es/articles/database-performance/snapshot-database-oda-4125409-esa.html

Article-43: Recopilando información de diagnostico mediante Oracle Trace File Analyzer (TFA)
https://www.oracle.com/technetwork/es/articles/database-performance/trace-file-analyzer-tfa-5806507-esa.html

Article-44: Mejorando el rendimiento en un Real Application Cluster (RAC) usando Tablespaces Temporales Locales
https://www.oracle.com/technetwork/es/articles/database-performance/local-temp-tablespace-5813489-  esa.html

Article-45: Oracle Database Appliance (ODA): ODABR un utilitario para Backup / Restore de sistema
https://www.oracle.com/technetwork/es/articles/database-performance/odabr-backup-restore-5888353-esa.html

Article-46: Beneficios e implementación de Oracle Virtual Private Database (VPD)
https://www.oracle.com/technetwork/es/articles/idm/virtual-private-db-5928071-esa.html

Article-47: Beneficios e implementación de Oracle Virtual Private Database (VPD)
https://www.oracle.com/technetwork/es/articles/idm/virtual-private-db-5928071-esa.html


Oracle Technology Network (OTN) – Portuguese  (43 Articles)


Article-1: Oracle Database 12cR2 (12.2.0) ACFS Segurança e Encriptação
https://www.oracle.com/technetwork/pt/articles/idm/acfs-seg-e-encripta%C3%A7ao-5178123-ptb.html

Article-2: Configurando Oracle Database File System (DBFS) em Real Application Clusters (RAC) no Oracle 12c
https://www.oracle.com/technetwork/pt/articles/database-performance/odb-file-system-em-rac-5025666-ptb.html

Article-3: Gerenciando Ambientes de Teste e Desenvolvimento se beneficiando dos snapshots do ACFS Usando o 
'gDBclone' em Clusters de Aplicativo Real (RAC) em Ambientes Multitenant
https://www.oracle.com/technetwork/pt/articles/database-performance/gdbclone-em-rac-5023304-ptb.html

Article-4: Configurando Oracle GoldenGate com Oracle Grid Infrastructure Bundled Agents (XAG) no 
Real Application Clusters (RAC) On Oracle 12c
https://www.oracle.com/technetwork/pt/articles/grid/configurar-ogg-com-xag-5011606-ptb.html

Article-5: DBMCLI utilitário de linha de comando - Oracle Exadata Database Machine
https://www.oracle.com/technetwork/pt/articles/database-performance/dbmcli-oracle-exadatadb-5011499-ptb.html

Article-6: Instalação e configuração do Clusterware e RDBMS em Oracle Database 12c R2 (12.2.0.1.0) com Alta Disponibilidade (HA)
https://www.oracle.com/technetwork/pt/articles/database-performance/clusterware-rdbms-or12cr2-4443115-ptb.html

Article-7: Criando snapshot database (clone) no Oracle Database Appliance (ODA) X5-2
https://www.oracle.com/technetwork/pt/articles/database-performance/snapshot-db-oda-x5-2-4416187-ptb.html

Article-8: Utilizando o Hive e o Impala através do banco de dados Oracle
https://www.oracle.com/technetwork/pt/articles/sql/hive-e-impala-bd-oracle-4241853-ptb.html

Article-9: Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 1)
http://www.oracle.com/technetwork/pt/articles/database-performance/seguranca-nivel-asm-banco-de-dados-2129933-ptb.html

Article-10: Oracle Exadata Database Machine X3: “Smart Flash Logging”
http://www.oracle.com/technetwork/pt/articles/database-performance/exadata-smart-flash-logging-2132507-ptb.html

Article-11: Oracle Exadata Database Machine: “Write-Back Flash Cache”
http://www.oracle.com/technetwork/pt/articles/database-performance/exadata-write-back-flash-cache-2164875-ptb.html

Article-12: Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 2)
http://www.oracle.com/technetwork/pt/articles/database-performance/seguranca-asm-banco-dados-parte2-2166649-ptb.html

Article-13: Oracle Exadata Database Machine: Segurança a nível de ASM e de Banco de Dados (Parte 3)
http://www.oracle.com/technetwork/pt/articles/database-performance/seguranca-asm-banco-de-dados-parte3-2166659-ptb.html

Article-14: Oracle RAC 12c:Flex ASM e Flex Cluster
http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-rac-12c-flex-asm-cluster-2172079-ptb.html

Article-15: Oracle Exadata Database Machine: Exachk
http://www.oracle.com/technetwork/pt/articles/servers-storage-admin/oracle-exadata-exachk-2209072-ptb.html

Article-16: Tudo o que você precisa saber sobre o Common e o Local no Oracle Database 12c
http://www.oracle.com/technetwork/pt/articles/idm/common-local-oracle-database-12c-2235405-ptb.html

Article-17: Funcionalidade Data Redaction - Oracle Database 12c
http://www.oracle.com/technetwork/pt/articles/idm/funcionalidade-data-redaction-12c-2209076-ptb.html

Article-18: Oracle Exadata Database Machine: “Exadata Hybrid Columnar Compression (EHCC)
http://www.oracle.com/technetwork/pt/articles/oem/oracle-hybrid-columnar-compression-2436203-ptb.html

Article-19: Oracle Database 12c: An introduction to concepts backup, recovery and recovery to a point in time (PITR) of PDBs
http://www.oracle.com/technetwork/pt/articles/database-performance/oracle-databse-pitr-pdbs-2438403-ptb.html

Article-20: Migração para a versão 12c do Banco de Dados sem Downtime, utilizando Oracle Golden Gate
http://www.oracle.com/technetwork/pt/articles/datawarehouse/migracao-12-oracle-golden-gate-2479499-ptb.html

Article-21: Criação de um relatório simples utilizando o Information Publisher Report
http://www.oracle.com/technetwork/pt/articles/oem/information-publisher-report-oem-2488821-ptb.html

Article-22: Oracle Exadata Database Machine: I/O Resource Manager (IORM).
http://www.oracle.com/technetwork/pt/articles/database-performance/exadata-resource-manager-iorm-2507896-ptb.html

Article-23: Replicação bi-direcional com Pluggable Database (PDB) utilizando Oracle GoldenGate 12c
http://www.oracle.com/technetwork/pt/articles/database-performance/replicacao-bi-direcional-com-pdbs-2931915-ptb.html

Article-24: Replicação de múltiplos Pluggable Databases em um Banco de Dados Multitenant utilizando Oracle GoldenGate 12c
http://www.oracle.com/technetwork/pt/articles/database-performance/replicacao-pdbs-oracle-goldengate-2941832-ptb.html

Article-25: Replicação de Dados com Múltiplos processos de Extração e Replicação em Modo de Captura Integrada no Oracle GoldenGate 12c
http://www.oracle.com/technetwork/pt/articles/database-performance/replicacao-dados-oracle-goldengate-2995049-ptb.html

Article-26: Opções de Atualização no Oracle 12c Multitenant Database
http://www.oracle.com/technetwork/pt/articles/database-performance/atualizacao-oracle-12c-multitenant-2996705-ptb.html

Article-27: Criando pontos de restauração para o banco de dados Oracle utilizando snapshots do Oracle Solaris ZFS
http://www.oracle.com/technetwork/pt/articles/database-performance/criando-point-in-time-snapshots-zfs-3215254-ptb.html

Article-28: Database as a Service (DBAAS): Aplicação de patches de forma simplificada
http://www.oracle.com/technetwork/pt/articles/database-performance/aplicando-patches-dbaas-3321593-ptb.html

Article-29:: Replicação consolidada e em cascata combinadas (DDL e DML) usando Oracle GoldenGate (11g e 12c) entre 
Oracle databases (11g e 12c)
http://www.oracle.com/technetwork/pt/articles/database-performance/replica-ddl-dml-oracle-goldengate-3410097-ptb.html

Article-30: Replicação entre o IBM DB2 LUW e o Oracle Database 12c utilizando o Oracle GoldenGate - Parte 1
http://www.oracle.com/technetwork/pt/articles/database-performance/replicar-db2-database-goldengate-3496397-ptb.html

Article-31: Flashback Pluggable Database (PDB) emambiente Multi-Tenant usando Oracle Database 12c R2
http://www.oracle.com/technetwork/pt/articles/database-performance/flashback-3703752-ptb.html

Article-32: Clonando a quente umPluggable Database (PDB) emum ambiente Multi-Tenantusando Oracle Database 12c R2
http://www.oracle.com/technetwork/pt/articles/database-performance/pdb-multi-tenant-3746608-ptb.html

Article-33: Realocando Pluggable Database (PDB) em modo READ WRITE em ambiente Multi-Tenant com Real Application Cluster (RAC)
http://www.oracle.com/technetwork/pt/articles/database-performance/read-write-3755576-ptb.html

Article-34: Disk Scrubbing Feature Oracle Exadata Database Machine
http://www.oracle.com/technetwork/pt/articles/database-performance/disk-scrubbing-3758877-ptb.html

Article-35: Pluggable Database (PDB) Character sets, IORM e Configurações de memória em um ambiente Multi-Tenant 
usando Oracle 12c R2 (12.2.0.1.0)
http://www.oracle.com/technetwork/pt/articles/database-performance/iorm-pdb-3760315-ptb.html

Article-36: Uso do OAKCLI em Oracle Database Appliance (ODA) X5-2 High Availability (HA)
http://www.oracle.com/technetwork/pt/articles/database-performance/oakcli-x5-3760326-ptb.html

Article-37: Pluggable Database Performance Profiles no Oracle Database 12c Release 2
http://www.oracle.com/technetwork/pt/articles/database-performance/profiles-3835567-ptb.html

Article-38: Configuração e Administração do Oracle Database Vault 12c em Multitenant utilizando o Oracle 
Enterprise Manager Total Cloud Control 12c
http://www.oracle.com/technetwork/pt/articles/database-performance/vault-3939546-ptb.html

Article-39: Multi-Instances Redo Apply em Physical Standby Database Instances em um ambiente 3-Node RAC
https://www.oracle.com/technetwork/pt/articles/database-performance/multiinstance-redoapply-5813499-ptb.html

Article-40: Aumente a Performance usando Local Temporary Tablespaces em Real Application Cluster (RAC)
https://www.oracle.com/technetwork/pt/articles/database-performance/local-temp-tablespace-5871028-ptb.html

Article-41: Coletando informações de diagnóstico usando Oracle Trace File Analyzer (TFA)
https://www.oracle.com/technetwork/pt/articles/database-performance/trace-file-analyzer-5958317-ptb.html

Article-42: Benefícios e Implementação do Oracle Virtual Private Database (VPD)
https://www.oracle.com/technetwork/pt/articles/idm/virtual-private-databas-6282211-ptb.html

Article-43: Usando o recurso Recover Standby Database do serviço Dataguard no 19c
https://www.oracle.com/technetwork/pt/articles/database-performance/recover-standby-db-19c-6335374-ptb.html


All things ORACLE from redgate – English          (2 Articles)


Article-1: Upgrading A Database Using Recovery Manager (RMAN) Duplicate Command In Oracle 12c.
http://allthingsoracle.com/upgrading-a-database-using-recovery-manager-rman-duplicate-command-in-oracle-12c/

Article-2: Integrated DDL and DML with Encrypt using Oracle GoldenGate 12c.
http://allthingsoracle.com/integrated-ddl-and-dml-with-encrypt-using-oracle-goldengate-12c/

Author- IT Central Station – English     (1 Article)


Article-1: With Multi-Tenancy, You Can Set Up Background Processes And Memory At The Container Level
https://www.itcentralstation.com/product_reviews/oracle-database-review-
39827-by-architec8a80?gitb_token=IWlcGsIWsWpa-0eTVVv2KQ&tid=um-npro-post

Author- Spain Oracle User Group (SPOUG) – Spanish    (3 Articles)


Article-1: Oracle RAC 12c: "Flex ASM" y "Flex Cluster"
http://blog-spoug.blogspot.com/2018/07/oracle-rac-12c-flex-asm-y-flex-cluster.html

Article-2: Oracle Exadata Database Machine: "Smart Flash Logging"
http://blog-spoug.blogspot.com/2018/07/oracle-exadata-database-machine-smart.html

Article-3: Oracle Exadata Database Machine: herramienta “Exachk”
http://blog-spoug.blogspot.com/2018/07/oracle-exadata-database-machine.html

2 comments: