Redo log corruption
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 consists…
Read MoreRecreate the Automatic Workload Repository
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 wrm$_wr_control; Disable AWR snapshot…
Read Moredatapatch failes after applying latest RU patch on 19.25.0.0
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 ‘SYS.DBMS_PRIV_CAPTURE’ must be declared -> Error…
Read MoreSYSTEM TABLESPACE RECOVERY USING RMAN
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 tablespace becomes corrupted or…
Read MoreUsage of XMLImporter and adcgnjar in Oracle E-Business Suite
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…
Read MoreProcedures for Using Code-Signing Certificates with an HSM (Hardware Security Module) in EBS
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 party…
Read MoreUser is not as employee roles in Oracle Cloud
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…
Read MoreCloud Critical Users Roles with respective BU Wise
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…
Read MoreColumn Limit in 23c Oracle database
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…
Read MoreEssential PostgreSQL Shortcut Commands for Efficient Database Management
Essential PostgreSQL Shortcut Commands for Efficient Database Management 📌 Master psql with these quick and powerful shortcut commands! Category: Database, PostgreSQL Tags: PostgreSQL, psql, database management, SQL commands Slug: postgresql-shortcut-commands…
Read More