Recent posts

How to enable Partitioning in Oracle Database Enterprise Edition 11.2 and higher

How to enable Partitioning in Oracle Database Enterprise Edition 11.2 and higher When you…

Read more

Getting Warnings While Applying Patch in EBS - Entry in the Archive Does Not Have Expected Size

Getting Warnings While Applying Patch in EBS - Entry in the Archive Does Not Have Expecte…

Read more

Resolving the ‘UNNAMED File Issue/Error’ in Oracle Data Guard: A Comprehensive Guide

Resolving the ‘UNNAMED File Issue/Error’ in Oracle Data Guard: A Comprehensive Guide Orac…

Read more

Monitoring Invalid objects in Oracle EBS R12.2

Monitoring Invalid objects in Oracle EBS R12.2 ADZDUTLRECMP.sql : Compiling Invalid Objec…

Read more

Useful srvctl Commands for Oracle RAC and Non-RAC Databases

Useful srvctl Commands for Oracle RAC and Non-RAC Databases This post provides a comprehe…

Read more

Steps on creating a new PDB service

Steps on creating a new PDB service Setting up a new service in a Pluggable Database (PDB…

Read more

SQL Script to Mirror a user in Oracle Database

SQL Script to Mirror a user in Oracle Database Save the following as mirror_user.sql. SET…

Read more

How to reset an Oracle database user password using an encrypted password

How to reset an Oracle database user password using an encrypted password When a user'…

Read more

Unexpected error while executing the action at state: supportedOSCheck 19c on Oracle Linux 8

Unexpected error while executing the action at state: supportedOSCheck 19c on Oracle Linu…

Read more

How To Failover and Flashback a Physical Standby for testing without recreating Database

How To Failover and Flashback a Physical Standby for testing without recreating Database …

Read more