Author's posts
Aug 24 2020
How to Rename Ethernet Interface to eth0 in Linux on VM
Sometime you may need to change the Network Interface Name on your system. I faced issue while I was cloning a node to prepare a new node for RAC Environments on Oracle Linux 6.5. When you clone a VM, you need to reassign the Network device means it will assign new UUID for the device …
Aug 18 2020
Copy Password File From Primary ASM to Standby ASM on Oracle 12c
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
Unable To Load Module Oracleasm in Oracle 12c
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
Migrating OCR, Voting Disk and MGMTDB to another ASM DiskGroup in 12c RAC
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
Adding a Node to Oracle RAC 12c
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
Deleting a Node to Oracle RAC 12c
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 26 2020
Oracle Exadata Smart Flash Cache
Smart Flash Cache: Oracle Exadata Smart Flash Cache stores frequently access data in Flash Storage which is very fast than other storage. This happens automatically and user don’t need to take any action to use this feature. Flash Cache is Smart – it avoids caching data which will not be reused or which is too …
Jul 20 2020
Hybrid Columnar Compression
About Exadata Hybrid Columnar Compression Oracle introduced basic compress feature from Oracle 9i version. Exadata Hybrid Columnar Compression can be specified at Table or Table Partition and Tablespace Level. Not Suitable for data which is frequently changing. Locking at CU level instead of row level so potentially many rows could be locked instead of single …
Jul 19 2020
Configure Distributed Command Line Interface (DCLI)
To manger and monitor Exadata Storage we can use two utility. CELLCLI DCLI CELLCLI: Each Exadata Storage Cell is administered individually by using cellcli. But this utility can connect a local cell server. cellcli works with MS process to perform the administration task like creation of cell or grid disk. DCLI: DCLI utility enables execution …
Jul 19 2020
Storage Indexes in Exadata System
What is Storage Index in Exadata System? Storage Index in Exadata is another important feature which helps to reduce useless I/Os for query execution. A storage index is a memory-based structure that reduces the amount of physical I/O performed in an Exadata cell. The storage index keeps track of minimum and maximum column values of …