Recent posts

Step-by-Step Guide to Create and Attach an NFS Mount Point to a New Server

Step-by-Step Guide to Create and Attach an NFS Mount Point to a New Server Prerequisites:…

Read more

Understanding Temporary Tablespace Files in Oracle CDB and PDB Databases

Understanding Temporary Tablespace Files in Oracle CDB and PDB Databases In an Oracle Mul…

Read more

How to Check CDB Size & PDB Size in Oracle Database

How to Check CDB Size & PDB Size in Oracle Database 1. Check CDB (Container Database)…

Read more

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