Oracle CREATE Commands Cheat Sheet for Database administrators as Best Practices. CREATE USER: is used to define and manage user access within the Oracle database system. CREATE USER mir IDENTIFIED BY mirdb; or CREATE USER mir IDENTIFIED… Read more..

How to Configure TNSNAMES.ORA in Oracle on Linux, Windows, and using SQL Developer The TNSNAMES.ORA file is a key Oracle configuration file that maps service names to connection details, allowing clients to connect to database servers. Proper configuration is essential for DBAs, developers, and administrators. Here are some alternative… Read more..

Configuring Disks for Oracle ASM Storage Setup in Oracle database 19C Overview:  The disk configuration is a major step when setting up Oracle ASM (Automatic Storage Management) in Oracle Database 19c. ASM provides an efficient way to manage database storage by organizing disks into disk groups, improving… Read more..

Oracle 19c Standalone Database Patching high level steps: Upgrade from 19.3 to 19.20. Steps to Perform Before Patch Implementation Here demonstrates the complete patching process across three phases: Pre-Patch Patching  Post-Patch Let… Read more..

Database Switchover was successful but the temporary tablespace got failures, why this issue happen Before proceeding to this process, create the database outage for both the primary and standby databases. Disable all the database jobs in both primary and standby database., check if the database jobs are running or schedules by crontab jobs or any Read More