Recent posts

Query to Check for Errors in the Alert Log

Query to Check for Errors in the Alert Log SELECT      TO_CHAR(originating_timestamp, …

Read more

Compile all Invalids Manually in Oracle Database

Compile all Invalids Manually in Oracle Database Script: DECLARE    CURSOR invalid_object…

Read more

TDE Key Store Management in Oracle Database

TDE Key Store Management in Oracle Database Once a keystore is created, it cannot be dele…

Read more

Unplug PDB command fails ORA-46680 Master Keys Of The Container Database Must Be Exported

Unplug PDB command fails ORA-46680 Master Keys Of The Container Database Must Be Exported…

Read more

Step-by-Step Process to Apply a Patch in Oracle Apps EBS R12.1

Step-by-Step Process to Apply a Patch in Oracle Apps EBS R12.1 Applying an application pa…

Read more

Batch Script in Windows to take export EXPDP of Oracle Database

Batch Script in Windows to take export EXPDP of Oracle Database To automate the process o…

Read more

Windows batch script to take RMAN backup of Oracle Database

Windows batch script to take RMAN backup of Oracle Database Steps to Create the Script: O…

Read more

Step by Step Guide to Install Oracle Database 19c on Windows

Step by Step Guide to Install Oracle Database 19c on Windows In this post I am going to s…

Read more

Setup Linux 8 Repository in for Oracle Linux

Setup Linux 8 Repository in for Oracle Linux We can setup a OL8 repository manually as be…

Read more

Users Receiving Larger Number of Emails For Already Closed Notifications

Users Receiving Larger Number of Emails For Already Closed Notifications An EBS user rece…

Read more

Query To Check DB_RECOVERY_FILE_DEST_SIZE Utilization in Oracle

Query To Check DB_RECOVERY_FILE_DEST_SIZE Utilization in Oracle Script: set linesize 999 …

Read more