Receivables Auto Invoice Import Failed with DUPLICATE INVOICE Error Message Introduction:- Oracle Fusion Cloud Applications 23B (11.13.23.04.0) Information in this document applies to any oracle fusion platform. Cause of…
Read MoreProblem: After patching an Oracle 19.8 GRID_HOME on Oracle Restart setup with 19.20 RU patch [35319490], I was not able to start up Oracle Restart HAS due to mentioned error.…
Read MoreAdding data file to Mirroring database What is Mirroring? Database mirroring involves redoing every insert, update, and delete operation that occurs on the principal database onto the mirror database as…
Read MoreIn this case how to open your standby database in read/write mode when you don’t have any access (Lost) on Primary database. NOTE: Currently both Primary and Standby database are…
Read MoreIntroduction: In today’s dynamic IT landscape, ensuring seamless access to critical applications is paramount. This guide outlines the strategic steps to deploy a robust high-availability architecture using a two-node TOMCAT…
Read MoreAll Redo log group Members are in active state, ORA-20 max number of processes exceeded, Database went hung state After restart A) All Redo log group Members all are in…
Read MoreWhat is log shipping? SQL Server Log shipping allows you to automatically send transaction log backups from a primary database on a primary server instance to one or more secondary databases…
Read MoreINSTANCE API Oracle REST Data Services (ORDS) offers a powerful solution for managing connection pools, enabling efficient communication between applications and databases. The Instance API, introduced in ORDS 20.4, revolutionizes…
Read MoreWhat is oracle OS watcher? Oracle OS watcher is collects and stores as archives operating system and network metrics that you can use to diagnose performance issues. OSWbb operates as…
Read MorePrecheck in table and index level: Step 1: Check the Table size and Index size select segment_name,TABLESPACE_NAME ,segment_type, bytes/1024/1024/1024 size_gb from dba_segments where segment_name = ‘&segment_name’ or segment_name in (select index_name…
Read More