Yearly Archives: 2023

Resource Database Corruption

Resource Database Corruption: What is resource database: Resource database is a binary and a system database, and its corruption would not allow instance to start. If resource database is corrupt…

Read More

Making Use of APEX BLOBS with Oracle Storage Cloud Service

1. Overview This document talks about how to push the blob uploaded by the end-user to Oracle Cloud Storage. 2. Technologies and Tools Used The following technologies has been used to achieve…

Read More

SQL Server installation Slipstream

                        Slipstream in SQL Server What is the slipstream how to use slipstream to install SQL server? Slipstream is a technique used by System Admins to easily update the setup packages…

Read More

Time and Month Selection in Oracle APEX

1. Overview This document talks about how to bring the Time and Month Selection in Oracle APEX. 2. Technologies and Tools Used The following technologies has been used to achieve pushing blob…

Read More

How to uninstall patch

How to uninstall patch file when need to downgrade and remove it What is the patch file. RTM is the original build version of the product when you download the…

Read More

Different ways to get the Explain Plan for a SQL ID 

1.To Display the execution plan of the last SQL statement executed by the current session  SET LINESIZE 150  SET PAGESIZE 2000  SELECT * FROM table (DBMS_XPLAN.DISPLAY_CURSOR);  2.To display the execution…

Read More

Integrated SOA Gateway – A Guide

Integrated SOA Gateway  – A Guide   Introduction to Integrated SOA Gateway Oracle E-Business Suite Integrated SOA Gateway (ISG) is a complete set of service infrastructure to provide, consume, and…

Read More

APPS_DDL package issues in fs_clone

APPS_DDL package  issues in  fs_clone This blog is intended for DBA’s who have issues in completing fs_clone. We applied a critical patch for one of the client and afterwards executed…

Read More

Configure tomcat web server to prevent information leakage

Configure tomcat web server to prevent information leakage: Problem Description:  This information can help an attacker gain a greater understanding of the systems in use and potentially develop further attacks…

Read More

ORA-38824 for trigger FLOWS_FILES.wwv_biu_flow_file_objects

ORA-38824 for trigger FLOWS_FILES.wwv_biu_flow_file_objects.  Issue Faced: After installing apex 20.2 some of the APEX functions were not working as expected. For example, we are not able to import applications using…

Read More