Data Recovery Advisor feature helps in diagnosing and repairing data failures. It will automatically diagnose the issue and provides the recommendation for the repair that helps to resolve the [...]

What is a Redo log corruption?   In the Oracle RDBMS environment, redo logs comprise files in a proprietary format which log a history of all changes made to the database. Each redo log file [...]

1. Check current snap_interval and disable snapshot creation, see below. Check current AWR snapshot interval as follows: sqlplus /nolog connect / as sysdba select snap_interval from [...]

ERROR:- ********* Error occurred while running ./datapatch -verbose after applying latest patch on 19.0.0.0 Error at line 8325: script md/admin/sdoutlb.plb – 167/11 PLS-00201: identifier [...]

Introduction: The SYSTEM tablespace is a critical component of the Oracle database, containing essential metadata and data dictionary objects necessary for database operation. If the SYSTEM [...]

  What is XMLImporter The XMLImporter utility is used to import and deploy customizations or extensions in the form of XML metadata files (e.g., OA Framework pages or Personalizations) into [...]

Issue:   EBS procedures to follow when using code-signing certificates which utilizes an HSM (Hardware Security Module) or Token   Cause of the issue: Starting June 1st 2023, all trusted 3rd [...]

Introduction: This blog has the SQL query that can be used to pull the data for the oracle cloud users having what roles & for which BU it is assigned if it is not an employee.   Cause [...]

Introduction: This blog has the SQL query that can be used to pull the data for the oracle cloud critical users having what roles & for which BU it is assigned.   Cause of the issue: [...]

To Increase the Column Limit in 23c Oracle database The One of the New Features of oracle database 23C. Increase Column Limit The maximum number of columns allowed in a database table or view has [...]