After some time I am posting again Yeah!, there is a interesting topic always during any migration, what happend if the node of the cluster complete broke? and then we need to recreated from scratch. So let't try this out. Enviroment before the fail: Two nodes Cluster {host01,host02} one asm instance running on each node … Continue reading Removing and Adding back a fail Node Oracle RAC 12R2

I will start posting some of my old personal notes, that are still valid on day a day oracle database support, just clarifying that they are not new but it can help this note is just for get DDL metada from a specific user, it will extract most of the metadata related to it.

Introduction We will continue with GNS and Flex Cluster installations (Oracle Clusterware 12cR1 with Flex Cluster), this time we will add new HUB node to our environment so first we can clone the virtual machine template (Installing OL6) and make some changes to prepare it Points to carry out Configure VM template Run prerequisite tasks … Continue reading Adding a HUB node to Flex Cluster with GNS in RAC 12cR1 using addnode.sh

Introduction There are several tutorials on internet about this topic, I just show you the way that I used to install OL6. You have to download the ISO file; you can download from OTN or Software Delivery Cloud. This tutorial will have the following parts: Virtual Machine on Virtual Box creation OL6’s Basic Installation Configuring … Continue reading Installing Oracle Linux 6

Before start, I configured this based on other examples on web and I am configuring to being use for Single Client Access Name (SCAN) on Oracle RAC configuration. This DNS configuration is for a test environment, this is for make SCAN work. if you are using virtual machines I recommend you to install the DNS … Continue reading Configuring DNS with BIND on Oracle Linux 6

En ocasiones cuando se baja de memoria ram, del servidor de base de datos. Se tiene el problema de que el parametro MEMORY_TARGET no es soportado, esto se arregla editando el init.ora (pfile.ora), de la instancia de base de datos, y levantandola nuevamente.Si no existe el init.ora se debera crear en base al spfile.ora:SQL> create … Continue reading ORA-00845: MEMORY_TARGET not supported on this system

En Mayo del 2014 tuve el gusto de poder dar mi primera conferencia sobre tecnología Oracle con los estudiantes de Ingenieria en Sistemas de la Universidad del Valle Guatemala, durante la conferencia se presentaron los siguientes puntos: Configuración de la Instancia Conexión hacia la Instancia Componentes Instancia: Estructuras de memoria Instancia: Procesos en Background. Base … Continue reading Conferencia – Introducción a la arquitectura de base de datos Oracle