| DBA Monitor |
| OS |
| Database |
| Network |
| Storage |
| Install Oracle |
| Install Oracle 10gR2 |
| Install Oracle Software in silent mode 11gR2 |
| Install Oracle Software in silent mode 12cR2 |
| Install Oracle 18c using OUI - GUI |
| Install Oracle 19c using OUI - GUI |
| Install Oracle Software in silent mode 19c |
| YouTube - Install Oracle Database 19c on Linux 7 |
| Deinstall Oracle |
| Deinstall Oracle 11gR2 |
| Deinstall Oracle 11gR2 Client on Windows |
| Deinstall Oracle 18c |
| Deinstall Oracle 19c |
| Create Database Oracle |
| Create Database in silent mode 11gR2 |
| Create Non-CDB Oracle Database 12c on Linux using DBCA (GUI) |
| CREATE NON-CONTAINER DATABASE ON ORACLE 12C IN SILENT MODE USING DBCA |
| CREATE PLUGGABLE DATABASE MANUALLY USING SEED(PDB$SEED) |
| CREATE NEW PLUGGABLE DATABASE (PDB2) BY CLONING AN EXISTING PLUGGABLE DATABASE (PDB1) |
| CREATE PLUGGABLE DATABASE USING DBCA (from PDB$SEED) |
| Convert 12.2 Non-CDB (NONCDB12C) as PDB (NONCDB12C) into CDB (CDB1) |
| Create Non-CDB Oracle Database 19c on Linux using DBCA (GUI) |
| CREATE NON-CONTAINER DATABASE ON ORACLE 19C IN SILENT MODE USING DBCA |
| YouTube - How to create Oracle Database using DBCA? |
| Drop Database |
| Delete database using DBCA silent mode 11gR2 |
| How to Drop the Database Manually |
| How to Drop Pluggable Database Manually 12cR2 |
| YouTube - How to Drop Database |
| Database Startup/Shutdown |
| HOW TO STARTUP/SHUTDOWN CDB AND PDB 12cR2 |
| YouTube - How to Start Database |
| Youtube - How to Shutdown Database |
| How to connect to Database |
| YouTube - How to connect to Database as SYSDBA |
| YouTube - How to connect to Database Remotely using SQL Developer? |
| Proxy User and Connect Through |
| Database Patching / Rollback |
| Patch Terminology |
| Apply Database Patch on 12.2 - Release Update |
| Oracle 18c Database Patching |
| Apply Database Patch on 19c - Release Update |
| How To Apply Database PSU Patch where Standby in Place 11gR2 |
| ROLLBACK DATABASE RELEASE UPDATE from Oracle Database 12.2.0.1 |
| Datapump |
| SCHEMA REFRESH FROM 11G TO 12C PDB |
| Backup and Restore - Database Refresh |
| How to Backup ORACLE_HOME binaries and Oracle INVENTORY |
| RMAN Catalog |
| RMAN Database Restore RAC – RAC |
| RMAN Database Restore from ASM (NON-RAC) TO ASM (NON-RAC) |
| RMAN Database Restore from ASM (NON-RAC) TO File System (NON-RAC) |
| RMAN ACTIVE DUPLICATION ASM TO ASM without downtime |
| Backup Based RMAN Duplicate Database |
| Database Upgrade |
| Upgrade Oracle Database Manually from 11.2.0.4 to 12.2.0.1 |
| Upgrade Oracle Database from 11.2.0.4 to 12.2.0.1 using DBUA |
| Upgrade Oracle Database from 12.2.0.1 to 19c using DBUA |
| Upgrade Oracle Database Manually from 12.2.0.1 to 19c (NON-CDB) |
| Upgrading Oracle Database from 11.2.0.4 to 12.2.0.1 where Physical Standby in Place |
| Rolling Database Upgrade from 12.2.0.1 to 19c using Transient Logical standby |
| Dataguard - Configuration |
| Creating Active Data Guard Physical Standby Environment |
| Creating Active Data Guard Physical Standby Environment on ASM |
| Covert Physical Standby database to Snapshot Standby database R/W mode |
| Convert Snapshot database to Physical Standby database |
| Configure Cascading Standby Database on 11G |
| How to setup Data Guard Broker Configuration |
| DG Broker Error – ORA-16714 |
| Disable Data Guard Broker Before Patch or Upgrade |
| Creating Physical Standby Active DataGuard Configuration in 12.2.0.1 Container Database |
| How to Create Physical Standby Database using RMAN Backup Without Using Duplicate Command |
| How to Create Physical Standby Database using RMAN Backup With Duplicate Command |
| 12c DG Broker Configuration |
| Upgrading Oracle Database from 11.2.0.4 to 12.2.0.1 where Physical Standby in Place |
| Rolling Database Upgrade from 12.2.0.1 to 19c using Transient Logical standby |
| Create RAC Physical Standby Database using RMAN Active Duplicate Command |
| Dataguard - Switchover |
| Performing Switchover with No Broker (Manual) |
| Performing Switchover with DG Broker |
| Dataguard - Failover |
| Failover with DG Broker (No-Flashback) |
| Failover with No DG Broker (No Flashback) / Failover using Manual Method |
| Reinstate a failed over Data Guard using Flashback Database |
| Failover with No DG Broker using Flashback Database |
| Dataguard - Patching |
| How To Apply Database PSU Patch where Standby in Place |
| Dataguard - Other |
| How to Enable Real Time Apply |
| Refresh Standby Database using RMAN Incremental SCN Backup - Huge GAP |
| Resetlogs on Primary Database where Standby in place |
| How to drop the standby redo logs |
| ASM |
| How to move ASM SPFILE from +DATA to +VOTE diskgroup |
| ASM Commands - Non-RAC |
| Instantiating disk: failed while creating ASM disk |
| After server reboot, CSSD and ASM are not came up automatically |
| RAC |
| RAC Install 11.2.0.3 |
| Upgrade RAC GI to 11.2.0.4 from 11.2.0.3 |
| Downgrade RAC GI to 11.2.0.3 from 11.2.0.4 |
| root.sh failed with ORA-29783 on RAC |
| Delete Node from Cluster in 11gR2 (11.2.0.3) |
| Add Node to 11gR2 Oracle RAC Cluster (11.2.0.3) |
| Delete Node without remove GI and RDBMS binaries |
| Add Node Back to Cluster which was deleted without removing GI and RDBMS binaries |
| How to take OCR backup on 11.2.0.4 |
| How to display Oracle Cluster name |
| How to Move/Relocate OCR from +DATA to +VOTE diskgroup |
| Restore loss of all VOTE disks |
| Cluster Startup Issues |
| Cluster Verification Utility Command Reference |
| How to Configure OSWatcher |
| Create RAC Physical Standby Database using RMAN Active Duplicate Command |
| Create ACFS File System on RAC |
| Performance Tuning |
| About Oracle Statistics |
| Oracle Histograms |
| Export and Import schema statistics from one database to another |
| How to Disable CONTROL_MANAGEMENT_PACK_ACCESS |
| Generate/Customize Explain Plan |
| Monitoring Progress of a SQL Execution Plan / sql query is really hanged or not |
| STATSPACK Utility |
| ASH Report – ASH (Active Session History) Reports |
| AWR Report – AWR (Automatic Workload Repository) reports |
| How to mark SQL_ID as Colored |
| Troubleshooting Flow For Long Running Queries |
| How to run SQL Tuning Advisor Manually |
| How to Install SQLT |
| How to Run SQLT |
| How to Create Custom SQL Profile |
| How to Uninstall SQLT |
| How to Enable Trace |
| Trace Analyzer TRCANLZR (TRCA) |
| DB Generic |
| How to change SQL prompt to show connected user and database name |
| How to change Archive destination |
| Enable the database in Archivelog mode |
| How to Recover Loss of DATA (Without a Backup!) using Oracle Flash Back Query |
| Proxy User and Connect Through |
| ORA-00054 resource busy and acquire with NOWAIT specified |
| How to find Blocking Sessions |
| Create Service using DBMS_SERVICE |
| Error TNS-12543 while connect to a remote database on a Linux |
| How to Change MAX_STRING_SIZE on Physical Standby Environment |
| OEM |
| Steps to configure Oracle 11g OEM DBConsole manually for database |
| Enable Oracle Enterprise Manager Express 12c |
| Oracle Enterprise Manager Cloud Control 13c Release 2 (13.2.0.0) Installation on Oracle Linux 64 bit |
| Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0) Installation on Oracle Linux 64 bit |
| Add Database Target on EM Cloud Control 13c |
| How to upgrade the Enterprise Manager 13.1 Cloud Control OMSPatcher to the Latest Version |
| Apply Oracle Enterprise Manager 13c Release 1 Patch Set Update 13.1.0.0.170718 for Oracle Management Service |
| Apply Patch on Oracle Management Agent 13c Release 1 (13.1.0.0.0) |
| Database Link |
| Database link |
| DBMS SCHEDULER |
| How to Create and Monitor DBMS_SCHEDULER Jobs |
| Enable/Disable JOBS during Maintenance |
| Microsoft SQL Server DBA |
| Steps to Install Microsoft SQL Server Express 2014 |
| How to Install Only SQL Server Management Studio |
| Create Database using the SQL Server Management Studio |
| Enable TCP/IP Connection |
| Allow Remote Connection |
| Authentication Method |
| How to Create SQL Server Authenticated Login in SQL Server |
| How to create Windows Authentication Login in SQL Server |
| How to Create Windows Group Authentication Login in SQL Server |
| Create a new domain user account in Windows Server 2016 |
| Microsoft SQL Server – Backup and Recovery |
| Recovery Models |
| Database Backup: FULL,DIFFERENTIAL and T-LOG |
| Restore & Recover Database |
| MySQL DBA |
| Install MySQL 8 on Linux 7 Using RPM Packages |
| Create MySQL Database |
| Create New User Account in MySQL |
| Grant/Revoke Privileges in MySQL |
| Create Roles in MySQL |
| MySQL – Backup/Restore |
| How To Backup MySQL Database Using mysqldump? |
| How to Restore Database from Single MySQL Database Backup? |
| How to Restore A Single Database From A Backup File Which Contains Multiple Databases? |
| How To Restore Single Table From Full Database Backup in MySQL? |
| MySQL – Replication |
| How To Configure MySQL Master-Slave Replication? (One-Way Replication) |
| MariaDB DBA |
| Install MariaDB with yum on Linux7 -- Coming soon !!! |
| Create MariaDB Database --- Coming soon !!! |
| Create New User Account in MairaDB --- Coming soon !!! |
| Grant/Revoke Privileges in MariaDB --- coming soon !!!! |
| Create Roles in MariaDB -- Coming soon !!! |
| MariaDB – Backup/Restore |
| Coming Soon !!! |
| Coming Soon !!! |
| MariaDB – Replication |
| How To Configure Maria Master-Slave Replication? (One-Way Replication) -- Coming soon !!! |
| MariaDB MaxScale Set up |
| Setup MaxScale -- Coming soon !!! |
| Load Balancing -- Coming soon !!! |
| Switchover -- Coming soon !!! |
| Failover -- Coming soon !!! |
| PostgreSQL DBA |
| How to Install PostgreSQL 13 ON RHEL 7? |
| How to START/STOP PostgreSQL 13 ON RHEL 7? |
| How to Create Database in PostgreSQL? |
| Linux |
| Download Oracle files on Linux via wget |
| How to Install SQL Developer on Linux |
| How to Disable the Firewall on Linux 6 |
| DBA Scripts |
| Oracle DBA Sheet v5.8 |
| Oracle DBA Sheet v6.1 |
| DBA Daily Report |
| GoldenGate |
| Installing Oracle GoldenGate V11.2.x for Oracle 10gR2 on Linux x86-64 |
| Unidirectional DML Replication |
| Zero Downtime Migration |
| DDL Replication |
| GoldenGate 12C Installation |
| Integrated Capture |
| Oracle GoldenGate Replication between MySQL 5.5 to Oracle 12c |
| Oracle GoldenGate Security – Credential Store for Database Logins |
| ADD NEW TABLE TO AN EXISTING GOLDENGATE CONFIGURATION |
| Installing Oracle GoldenGate 19.1.0.0 for Oracle DB 12c on Linux 7 |
| Install Oracle GoldenGate 19.1.0.0.4 for Oracle Database 19c on Linux 7 |