Database Blog

Monitoring and Managing Streaming Replication in PostgreSQL

Streaming replication in PostgreSQL is a vital feature for ensuring data availability and redundancy. Once your primary and standby servers are set up, it’s essential to monitor the replication status…

Read More

PostgreSQL Master and Slave Configuration Guide: Implementing Streaming Replication

PostgreSQL’s streaming replication is a powerful feature that allows real-time data replication from a primary database server (master) to one or more standby servers (slaves). This guide will take you…

Read More

Integrating Active Directory (AD) with a Linux Instance

Introduction         Integrating our Linux instances with Microsoft Active Directory (AD) can streamline user management, here will walk you through the steps needed to integrate a Linux…

Read More

Simplify Cloud Automation: How to Use Terraform with OCI Stacks

Introduction In Oracle Cloud Infrastructure (OCI), the OCI Stack provides a powerful and streamlined way to manage infrastructure with Terraform directly from the OCI Console. In this document, we will…

Read More

RAC Node Addition Steps

RAC Node Addition Steps At Present we are having 2 node Rac Environment , we are going to add Node3 .. RAC – Node Addition 1)Assigning IP address in all…

Read More

Configuring Oracle E-Business Suite REST Services in EBS R12.2.1

Configuring Oracle E-Business Suite REST Services in EBS R12.2.1   Configuring Oracle E-Business Suite Integrated SOA Gateway for REST Services Note: Ensure that your Oracle E-Business Suite instance is on…

Read More

Getting error APP-FND-01564 When Form Is Called Or Responsibility Selected after enabling Unified Auditing in EBS

Issue:   After enabling unified auditing feature in EBS R12.2.5 with 19c database version , getting “APP-FND-01564: ORACLE error in afpodbinit” when opening a ebs form or when a responsibility is…

Read More

R12_2 application patching adop cutover failed

Issue:   EBS R12.2 application patching “adop cutover” got failed with following error. Node Primary: Failed Cutover status: FS_CUTOVER_COMPLETED Node DMZ: Failed Cutover status: FLIP_SNAPSHOTS_COMPLETED adop exiting with status = 2…

Read More

Oracle Data Guard Physical Standby switchover using DGMGRL:-

Oracle Data Guard Physical Standby switchover using DGMGRL:-   Performing a Oracle Data Guard Switchover Using DGMGRL    Step1:-Check the Primary Database   Check both side:-   Select name,open_mode,database_role,protection_level from…

Read More

Reinstate Failed Primary Database using Flashback:-

Reinstate Failed Primary Database using Flashback:-   Methods to Reinstate database using Flashback:-   1) Using DGMGRL 2) Using SQL*PLUS   1) Using DGMGRL:-   Startup the Failed Primary Database…

Read More