Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
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 »Manually remove ODA DB HOME
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 »CVE-2023-21839 – Critical vulnerability in Oracle WebLogic
CVE-2023-21839 – Critical vulnerability in Oracle WebLogic CVE-2023-21839 refers to a critical vulnerability found in Oracle WebLogic, which is an enterprise-level application server used to deploy and manage Java-based applications. …
Read More »How to Restrict Application Users in Oracle EBS
How to Restrict Application Users to a Single Session in Oracle E-Business Suite Introduction: Maintaining security in an Oracle E-Business Suite (EBS) environment is crucial to protect sensitive data and …
Read More »