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
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
ORA-15410: Disks in disk group do not have equal size
I was trying the last night add a disk to an AMS diskgroup (Normal Redundancy) but when I added the disk I received the “ORA-15410: Disks in disk group DATA_TEST do not have equal size”. In older asm version I could add disk of different size without any issue, researching a little bit I found … Continue reading ORA-15410: Disks in disk group do not have equal size
How to find and execution plan and SQL ID for a SQL statement?
This time I will show you how to get the explain plan and SQL_ID from a query statement. If we have the SQL statement we just need to run it and then execute the following query: select plan_table_output from table(dbms_xplan.display_cursor(null,null,'all')); The display_cursor function return the execution plan that is allocated on the SQL area. … Continue reading How to find and execution plan and SQL ID for a SQL statement?