Oct 16 2020
Oracle RAC (Real Application Cluster) is used for complex application to increase database performance, high availability and scalability. In this article, I will show how to install Oracle RAC (12.2.0.1) on Oracle Enterprise Linux 7.1. Below high level steps will perform to install/configure Oracle RAC: Configure 2 Virtual Machine (VM) for 2 Nodes RAC. Install …
Sep 19 2020
In this topic, I will demonstrate Oracle RAC components. SCAN IP VIP IP SCAN Listener Cache Fusion Cluster Interconnect RAC 2-way Global Cache Transfer RAC 3-way Global Cache Transfer Cache Coherency Global Cache Services (GCS) Global Resource Directory (GRD) Global Enqueue Services (GES)
Sep 01 2020
Until Oracle 8i released, Oracle Introduced Parallel Server on Oracle 6i version. Oracle Introduced Real Application Cluster concept on Oracle 8i version. Oracle Cache Fusion is one of the important component in Oracle RAC environment. What is Cache Fusion: Oracle RAC has two or more instances, and it uses Cache Fusion to smoothly move data …
Aug 18 2020
If create a database using DBCA, usually password file create on ASM Diskgroup. For RAC, this is also recommended to use ASM Diskgroup for spfile and password file. In this topic, I will show how to copy password file from ASM of Primary database to Standby on ASM. Password File location on Primary Database:
Aug 13 2020
CRS (Cluster Ready Service) is not starting and getting ‘FATAL: Module oracleasm not found’ error on log files. [root@ocmnode1 ~]# cat /var/log/messages Aug 12 01:32:08 ocmnode1 modprobe: FATAL: Module oracleasm not found.Aug 12 01:32:33 ocmnode1 modprobe: FATAL: Module oracleasm not found.Aug 12 01:34:32 ocmnode1 modprobe: FATAL: Module oracleasm not found. After checked in details found …
Aug 09 2020
Sometime DBA need to move or migrate below mentioned files or DB to different ASM DiskGroup for difference reason. I will show how to move or migrate below mentioned files or DB from one ASM DiskGroup to Another: How to move or migrate OCR and Voting Disk from one ASM Diskgroup to another. How to …
Aug 08 2020
Complete below list of tasks: DBA may need to add a new node or existing node (which got deleted from cluster) into Clusterware. List of tasks for New Node: Install same version of OS Setup environment variable Install all required package including Oracleasm Configure Networking (IP and others) Check Time Synchronization Change Recommended Kernel Parameters …
Aug 01 2020
A node in the cluster may crash due to hardware or OS problems and is not recoverable. So DBA needs to delete a problematic node from clusterware. In this topic I will show discuss how to delete a node from two nodes RAC. Two Nodes: ocmnode1 will be deleted ocmnode1 ocmnode2 Deinstall Oracle Home:
Jul 03 2020
Jul 02 2020
In this topic I will show how to create ASM DISK Group using ASMCA tools or command line. From grid owner (either grid or oracle user) need to set environment variable for ASM Instance and run asmca command from GUI mode. [grid@exadb01 ~]$ . oraenvORACLE_SID = [grid] ? +ASM1The Oracle base has been set to …
