Database Blog

APEX & ORDS UPGRADE

Description: 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 More

DATAGAURD BROKER CONFIGURATION 

DATAGAURD 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 More

APEX 21.2 Installation in Oracle Linux 19C Database

Introduction: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 More

SA account is locked in sql server

SA 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 More

Configuring Transparent Data Encryption (TDE) in Oracle 19c with WALLET_ROOT and FILE Keystore

IntroductionThis 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 More

Automated Compilation of Invalid Database Objects in Oracle Multitenant Architecture

Detailed 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 More

Automated PDB Enumeration and Dynamic Login Selector for Oracle Multitenant Databases

Detailed 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

How to recover suspect/Recovery pending databases in SQL Server?

How to recover suspect/Recovery pending databases in SQL Server?  Introduction:  In SQL Server, a database may enter SUSPECT or RECOVERY PENDING state due to corruption, missing files, or insufficient resources.…

Read More

High-Level Steps to Add SQL Server to a Cluster

High-Level Steps to Add SQL Server to a Cluster  Introduction:  Adding a SQL Server instance to a Windows Server Failover Cluster (WSFC) is a process that enables high availability for…

Read More

How to fix orphan user in SQL server? 

Introduction In SQL Server, an orphaned user occurs when a database user exists without a corresponding login in the server’s master database. This usually happens after restoring a database from…

Read More