Introduction / Issue During routine operations, SQL Server encountered a critical issue where TempDB’s transaction log became full due to an active transaction. This led to application timeouts, inability to…
Read MoreDescription: This guide provides a detailed, step-by-step process for installing and configuring the Oracle Enterprise Manager (OEM) 13.5 Management Agent on target servers. It starts with the initial OMS login…
Read MoreDescription: This document explains how we upgraded Oracle APEX, ORDS, and Java on the DBNAME database. It covers the checks and backups done before starting, the steps for installation and configuration, and how we fixed common issues during the process. The aim was to move from older versions to APEX 24.1, ORDS 24.1, and Java 11 smoothly, without affecting service availability. Componets Current versions Upgrade version Apex 22.2 24.1 Ords 21.2 24.1 Java Jdk-1.8 11.1 Pre checks and backups. Apex Workspace backups. Steps: Login to admin responsibility and take the workspace level backup. Using APEX port utility to take workspace and application backups in backend. Tomcat and Ords backup Taking current tomcat and ords backup using tar. Validate workspace schema backup should be taken in DBA team. Installation of apex in DB level.…
Read MoreDATAGAURD BROKER CONFIGURATION Introduction: Oracle Data Guard Broker is a management framework that automates and simplifies the configuration, monitoring, and administration of Oracle Data Guard environments. It provides a centralized…
Read MoreIntroduction:This document provides a step-by-step guide to installing Oracle APEX 21.2 on an Oracle 19c database running on Oracle Linux.It covers prerequisites, setup, and configuration for APEX, ORDS, Java, and…
Read MoreFailover issues in Always-on AG What is failover in always-on AG in SQL server.? In SQL Server Always On Availability Groups (AG), failover is the process of switching the…
Read MoreSA account is locked in SQL server What is SA account in SQL server.? The “SA” (system administrator) account in SQL Server is a highly privileged, built-in account with…
Read MoreIntroductionThis guide explains how to enable Transparent Data Encryption (TDE) in Oracle 19c.TDE protects sensitive data at rest by encrypting it automatically.We will set up the wallet, create the master…
Read MoreDetailed Description: The compile_invalid_objects.sh script is designed to automate the identification and compilation of invalid objects across pluggable databases (PDBs) within an Oracle multitenant database environment. Invalid objects—such as packages,…
Read MoreDetailed Description: This Bash script automates the enumeration and dynamic selection of Pluggable Databases (PDBs) in an Oracle Multitenant environment. It connects to the Oracle Container Database (CDB) as a…
Read More