Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
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 »ODA Space Utilization Issue
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 »Applying Patch on EBS Environment using ADOP
Applying Patch on EBS Environment using ADOP and Creating a Restore Point for Database if patch fails in Cutover Phase Introduction: As an Apps DBA, applying patches to an E-Business …
Read More »Implementing Class of Secure Transport (COST) in Oracle RAC 11.2
Implementing Class of Secure Transport (COST) in Oracle RAC 11.2 Introduction: Class of Secure Transport (COST) is a security feature introduced in Oracle Database 11g Release 2 (11.2) that enhances …
Read More »Oracle Data Guard Synchronization
As an Oracle Database Administrator, one of the common challenges faced by DBAs is ensuring that the Disaster Recovery (DR) system is in sync with the Primary server. …
Read More »