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
Get DDL user metadata using dbms_metadata.get_ddl
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.
Adding a HUB node to Flex Cluster with GNS in RAC 12cR1 using addnode.sh
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
Oracle Clusterware 12cR1 with Flex Cluster and GNS on Oracle Linux 6 (Virtual Box)
Introduction When I started this installation I configured DNS before, there are some interesting points that we have to have in mind because it could take some time to resolve them. I will focus on the Network Prerequisites (DNS and DHCP) if you configure both of these the next process’s going to be very easy … Continue reading Oracle Clusterware 12cR1 with Flex Cluster and GNS on Oracle Linux 6 (Virtual Box)
Configuring DNS and DHCP to use on Oracle Grid Naming Service
Configuring DNS and DHCP to use it on Oracle Grid Named Service This configuration will be on the same server Oracle Linux 6, I installed just to ensure that Oracle clusterware will be working fine with GNS option, so if there is any subjection about this configuration let me know. As of now it is … Continue reading Configuring DNS and DHCP to use on Oracle Grid Naming Service
Installing Oracle Linux 6
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
Creación de una PDB desde SEED con ASM y OMF
Como se sabe ahora en la arquitectura de Oracle Database 12c se tiene el concepto de base de datos como contenedores (container database), a continuación, mostrare como crear una pluggable database desde la base de datos SEED Suposiciones: Se tiene un base de datos contenedor (container) de nombre cdb2 cdb2 es una base de datos … Continue reading Creación de una PDB desde SEED con ASM y OMF
Configuring DNS with BIND on 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
Adding/Updating SCAN Listener on RAC 11gR2
When I installed Oracle RAC, I have configured the SCAN Listener with Dnsmasq. it uses the hosts file located on /etc folder. My surprise was when I started working with the RAC I just have one SCAN_LISTENER. The issue with DNSmasq is that is use the /etc/hosts entry so I prefer to go ahead and … Continue reading Adding/Updating SCAN Listener on RAC 11gR2
Shutdown/Startup all services in Oracle RAC
I have this old entry on my notes, when I started learning RAC this was one on my first question, how to make a clean shutdown of all the clusterware services... so I'm sharing below this short note: Steps To Shutdown(stop)/Startup(start) CRS, OHAS, ASM, RDBMS & ACFS Services on a RAC Cluster 11.2 & 12.1 … Continue reading Shutdown/Startup all services in Oracle RAC
An Oracle DBA Journey 