Posts by Madan Mohan Reddy

Concurrent Program Failure with Error “FDPSTP failed due to ORA-20100”

  User Submitted concurrent Program “XXFM TBI DEBIT CONTROL” in DEV environment after Clone. Program failure happening with Below Error. Oracle Database 19c (Multitenant) and EBS Application is 12.2.10 running…

Read More

Oracle datafiles mount filled and PDB goes to mount state

Introduction: In Oracle databases, datafiles are crucial components that store the actual data. Datafiles are physical files on disk that store the data for all database objects, such as tables…

Read More

Edition-Based Redefinition[EBR] –Granualar access in EBS R12

Introduction: Edition-Based Redefinition is an essential feature in Oracle, designed for oracle database administrators, developers who manage application upgrades. EBR allows for seamless updates with minimal or no downtime, enabling…

Read More

Oracle TDE Encryption at Tablespace and Table Column Level

The security of data in Oracle Database is ensured through robust authentication, authorization, and auditing mechanisms. A critical aspect of data storage involves datafiles, which are essential components residing in…

Read More

Dynamic Data Masking at table column level in Oracle Database

Database tables often contain sensitive information such as credit card details, contact information, and personal bank details, which require safeguarding against unauthorized access. To address this concern, Oracle 12c and…

Read More

Secure PDBs using LOCKDOWN PROFILEs

Purpose: LOCKDOWN Profiles concept will be applicable for Oracle Multitenant databases. We can apply this LOCKDOWN Profiles concept to specific CDB, specific PDB or ALL PDBs. This Concept will help…

Read More

Find unused or unnecessary Privileges of Oracle Database user

Purpose: Usually a  Privilege can be treated as unused privilege if this is not being used by user or pre-running programs at database level. During new application development phase or…

Read More