Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
Updating OS in Oracle RAC running on Azure using Flashgrid Software In this blog post we will talk about on how to update the OS for nodes running Oracle RAC …
Read More »Updating OS in Oracle RAC
April CPU JDK Upgrade on DB
April CPU JDK Upgrade on DB and Grid Homes in Oracle 19c Real Application Cluster Setup Current Version:- GRID HOME:- grid> cd $GRID_HOME/jdk/bin grid> ./java -version java version “1.8.0_311” …
Read More »Manually remove ODA DB HOME
Manually remove OLD DB HOMES if odacli-delete dbhome fails Please follow the instructions below: 1. Check if any running jobs currently: # odacli list-jobs. 2. If none, then stop the …
Read More »Removing Old Grid Home
Manually Remove an Old Grid Home After Upgrading/Patching to a Higher Grid Home on ODA 1. Check the components and their versions [root@testlinux ~]# odacli describe-componentSystem Version—————19.20.0.0.0 System node Name—————testlinux …
Read More »Materialized View refresh error
Materialized View refresh error generating huge Archive Logs after Database Upgrade to 19c. Issue:- A huge amount of archive log generation when materialized view refreshing after database upgrade from 11g …
Read More »ODA Space Utilization Issue
Oracle Database Appliance Space Utilization Issue One of the basic issue when having ODA (Oracle Database Appliance) system is space utilization in /opt mount point. Recently I was facing …
Read More »Switchover MySQL
Switchover MySQL Source 199Replica 198 SOURCE SET GLOBAL read_only=ON; set global super_read_only=ON; show variables like '%super%read%'; show variables like '%read_only%'; flush tables;flush logs; SHOW MASTER STATUS; REPLICA stop slave; …
Read More »Restarting MYSQL Instances and Servers
Restarting MYSQL Instances and Servers Environment:- MySQL Database Instances running in two separate Windows Servers namely PROD (172.21.50.162) and DR (10.218.86.8). They have been setup as Source (PROD) and …
Read More »Configuration of MYSQL Master Slave Replication
Configuration of MYSQL Master – Slave Replication Environment:- Two Server’s with MYSQL database and different hosts/nodes, Master (172.21.50.162) and Slave (10.218.86.8). Replication will be configured between these two servers …
Read More »Oracle Apex Upgrade to 22.2
Oracle Apex Upgrade to 22.2 ORACLE APEX Oracle APEX (also known as APEX or Oracle Application Express) is an enterprise low-code development platform from Oracle Corporation that is used …
Read More »