Abdul Khalique Siddique

Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner

Home / Abdul Khalique Siddique

Abdul Khalique Siddique

In addition to my proficiency in Oracle Database, I have also specialized in Oracle E-Business Suite. I have hands-on experience in implementing, configuring, and maintaining EBS applications, enabling organizations to streamline their business processes and achieve operational efficiency. Also I have hands-on experience in Oracle Cloud Infrastructure (OCI). I have worked with OCI services such as compute, storage, networking, and database offerings, leveraging the power of the cloud to deliver scalable and cost-effective solutions. My knowledge of OCI architecture and deployment models allows me to design and implement robust and secure cloud environments for various business requirements. Furthermore, I have specialized in disaster recovery solutions for Oracle technologies. I have designed and implemented comprehensive disaster recovery strategies, including backup and recovery procedures, standby databases, and high availability configurations. My expertise in data replication, failover mechanisms, and business continuity planning ensures that organizations can quickly recover from disruptions and maintain uninterrupted operations.

Updating OS in Oracle RAC

Abdul Khalique Siddique April 20, 2024 Oracle APPS DBA 0 78

OracleDBconfig

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 …

April CPU JDK Upgrade on DB

Abdul Khalique Siddique April 12, 2024 Oracle APPS DBA Comments Off on April CPU JDK Upgrade on DB 183

OracleDBconfig

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” …

Manually remove ODA DB HOME

Abdul Khalique Siddique March 27, 2024 Oracle Database Material 0 112

OracleDBconfig

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 …

Removing Old Grid Home

Abdul Khalique Siddique March 16, 2024 Oracle Database Material 0 90

OracleDBconfig

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 …

Materialized View refresh error

Abdul Khalique Siddique March 14, 2024 Oracle APPS DBA 0 137

OracleDBerror

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 …

ODA Space Utilization Issue

Abdul Khalique Siddique January 15, 2024 ODA 0 45

ODApost-07ebc366

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 …

Switchover MySQL

Abdul Khalique Siddique November 10, 2023 MySql Comments Off on Switchover MySQL 55

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; …

Restarting MYSQL Instances and Servers

Abdul Khalique Siddique October 14, 2023 MySql Comments Off on Restarting MYSQL Instances and Servers 64

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 …

Configuration of MYSQL Master Slave Replication

Abdul Khalique Siddique September 27, 2023 MySql 0 111

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 …

Oracle Apex Upgrade to 22.2

Abdul Khalique Siddique March 14, 2023 Installation/Configurations12c 0 438

OracleDBconfig

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 …

Page 1 of 212 »