| DBA Monitor |
| 1 | OS | |
| 2 | Database | |
| 3 | Network | Coming soon !!! |
| 4 | Storage | Coming soon !!! |
| Install Oracle |
| 5 | Install Oracle 10gR2 | |
| 6 | Install Oracle Software in silent mode 11gR2 | |
| 7 | Install Oracle Software in silent mode 12cR2 | |
| 8 | Install Oracle 18c using OUI - GUI | |
| 9 | Install Oracle 19c using OUI - GUI | |
| 10 | Install Oracle Software in silent mode 19c | |
| 11 | YouTube - Install Oracle Database 19c on Linux 7 | |
| Deinstall Oracle |
| 12 | Deinstall Oracle 11gR2 | |
| 13 | Deinstall Oracle 11gR2 Client on Windows | |
| 14 | Deinstall Oracle 18c | |
| 15 | Deinstall Oracle 19c | |
| Create Database Oracle |
| 16 | Create Database in silent mode 11gR2 | |
| 17 | Create Non-CDB Oracle Database 12c on Linux using DBCA (GUI) | |
| 18 | CREATE NON-CONTAINER DATABASE ON ORACLE 12C IN SILENT MODE USING DBCA | |
| 19 | CREATE PLUGGABLE DATABASE MANUALLY USING SEED(PDB$SEED) | |
| 20 | CREATE NEW PLUGGABLE DATABASE (PDB2) BY CLONING AN EXISTING PLUGGABLE DATABASE (PDB1) | |
| 21 | CREATE PLUGGABLE DATABASE USING DBCA (from PDB$SEED) | |
| 22 | Convert 12.2 Non-CDB (NONCDB12C) as PDB (NONCDB12C) into CDB (CDB1) | |
| 23 | Create Non-CDB Oracle Database 19c on Linux using DBCA (GUI) | |
| 24 | CREATE NON-CONTAINER DATABASE ON ORACLE 19C IN SILENT MODE USING DBCA | |
| 25 | YouTube - How to create Oracle Database using DBCA? | |
| Drop Database |
| 26 | Delete database using DBCA silent mode 11gR2 | |
| 27 | How to Drop the Database Manually | |
| 28 | How to Drop Pluggable Database Manually 12cR2 | |
| 29 | YouTube - How to Drop Database | |
| Database Startup/Shutdown |
| 30 | HOW TO STARTUP/SHUTDOWN CDB AND PDB 12cR2 | |
| 31 | YouTube - How to Start Database | |
| 32 | Youtube - How to Shutdown Database | |
| How to connect to Database |
| 33 | YouTube - How to connect to Database as SYSDBA | |
| 34 | YouTube - How to connect to Database Remotely using SQL Developer? | |
| 35 | Proxy User and Connect Through | |
| Database Patching / Rollback |
| 36 | Patch Terminology | |
| 37 | Apply Database Patch on 12.2 - Release Update | |
| 38 | Oracle 18c Database Patching | |
| 39 | Apply Database Patch on 19c - Release Update | |
| 40 | How To Apply Database PSU Patch where Standby in Place 11gR2 | |
| 41 | ROLLBACK DATABASE RELEASE UPDATE from Oracle Database 12.2.0.1 | |
| Datapump |
| 42 | SCHEMA REFRESH FROM 11G TO 12C PDB | |
| Backup and Restore - Database Refresh |
| 43 | How to Backup ORACLE_HOME binaries and Oracle INVENTORY | |
| 44 | RMAN Catalog | |
| 45 | RMAN Database Restore RAC – RAC | |
| 46 | RMAN Database Restore from ASM (NON-RAC) TO ASM (NON-RAC) | |
| 47 | RMAN Database Restore from ASM (NON-RAC) TO File System (NON-RAC) | |
| 48 | RMAN ACTIVE DUPLICATION ASM TO ASM without downtime | |
| 49 | Backup Based RMAN Duplicate Database | |
| Database Upgrade |
| 50 | Upgrade Oracle Database Manually from 11.2.0.4 to 12.2.0.1 | |
| 51 | Upgrade Oracle Database from 11.2.0.4 to 12.2.0.1 using DBUA | |
| 52 | Upgrade Oracle Database from 12.2.0.1 to 19c using DBUA | |
| 53 | Upgrade Oracle Database Manually from 12.2.0.1 to 19c (NON-CDB) | |
| 54 | Upgrading Oracle Database from 11.2.0.4 to 12.2.0.1 where Physical Standby in Place | |
| 55 | Rolling Database Upgrade from 12.2.0.1 to 19c using Transient Logical standby | |
| Dataguard - Configuration |
| 56 | Creating Active Data Guard Physical Standby Environment | |
| 57 | Creating Active Data Guard Physical Standby Environment on ASM | |
| 58 | Covert Physical Standby database to Snapshot Standby database R/W mode | |
| 59 | Convert Snapshot database to Physical Standby database | |
| 60 | Configure Cascading Standby Database on 11G | |
| 61 | How to setup Data Guard Broker Configuration | |
| 62 | DG Broker Error – ORA-16714 | |
| 63 | Disable Data Guard Broker Before Patch or Upgrade | |
| 64 | Creating Physical Standby Active DataGuard Configuration in 12.2.0.1 Container Database | |
| 65 | How to Create Physical Standby Database using RMAN Backup Without Using Duplicate Command | |
| 66 | How to Create Physical Standby Database using RMAN Backup With Duplicate Command | |
| 67 | 12c DG Broker Configuration | |
| 68 | Upgrading Oracle Database from 11.2.0.4 to 12.2.0.1 where Physical Standby in Place | Duplicate |
| 69 | Rolling Database Upgrade from 12.2.0.1 to 19c using Transient Logical standby | Duplicate |
| 70 | Create RAC Physical Standby Database using RMAN Active Duplicate Command | Duplicate |
| Dataguard - Switchover |
| 71 | Performing Switchover with No Broker (Manual) | |
| 72 | Performing Switchover with DG Broker | |
| Dataguard - Failover |
| 73 | Failover with DG Broker (No-Flashback) | |
| 74 | Failover with No DG Broker (No Flashback) / Failover using Manual Method | |
| 75 | Reinstate a failed over Data Guard using Flashback Database | |
| 76 | Failover with No DG Broker using Flashback Database | |
| Dataguard - Patching |
| 77 | How To Apply Database PSU Patch where Standby in Place | Duplicate |
| Dataguard - Other |
| 78 | How to Enable Real Time Apply | |
| 79 | Refresh Standby Database using RMAN Incremental SCN Backup - Huge GAP | |
| 80 | Resetlogs on Primary Database where Standby in place | |
| 81 | How to drop the standby redo logs | |
| ASM |
| 82 | How to move ASM SPFILE from +DATA to +VOTE diskgroup | |
| 83 | ASM Commands - Non-RAC | |
| 84 | Instantiating disk: failed while creating ASM disk | |
| 85 | After server reboot, CSSD and ASM are not came up automatically | |
| RAC |
| 86 | RAC Install 11.2.0.3 | |
| 87 | Upgrade RAC GI to 11.2.0.4 from 11.2.0.3 | |
| 88 | Downgrade RAC GI to 11.2.0.3 from 11.2.0.4 | |
| 89 | root.sh failed with ORA-29783 on RAC | |
| 90 | Delete Node from Cluster in 11gR2 (11.2.0.3) | |
| 91 | Add Node to 11gR2 Oracle RAC Cluster (11.2.0.3) | |
| 92 | Delete Node without remove GI and RDBMS binaries | |
| 93 | Add Node Back to Cluster which was deleted without removing GI and RDBMS binaries | |
| 94 | How to take OCR backup on 11.2.0.4 | |
| 95 | How to display Oracle Cluster name | |
| 96 | How to Move/Relocate OCR from +DATA to +VOTE diskgroup | |
| 97 | Restore loss of all VOTE disks | |
| 98 | Cluster Startup Issues | Internal |
| 99 | Cluster Verification Utility Command Reference | |
| 100 | How to Configure OSWatcher | |
| 101 | Create RAC Physical Standby Database using RMAN Active Duplicate Command | |
| 102 | Create ACFS File System on RAC | |
| Performance Tuning |
| 103 | About Oracle Statistics | |
| 104 | Oracle Histograms | |
| 105 | Export and Import schema statistics from one database to another | |
| 106 | How to Disable CONTROL_MANAGEMENT_PACK_ACCESS | |
| 107 | Generate/Customize Explain Plan | |
| 108 | Monitoring Progress of a SQL Execution Plan / sql query is really hanged or not | |
| 109 | STATSPACK Utility | |
| 110 | ASH Report – ASH (Active Session History) Reports | |
| 111 | AWR Report – AWR (Automatic Workload Repository) reports | |
| 112 | How to mark SQL_ID as Colored | |
| 113 | Troubleshooting Flow For Long Running Queries | |
| 114 | How to run SQL Tuning Advisor Manually | |
| 115 | How to Install SQLT | |
| 116 | How to Run SQLT | |
| 117 | How to Create Custom SQL Profile | |
| 118 | How to Uninstall SQLT | |
| 119 | How to Enable Trace | |
| 120 | Trace Analyzer TRCANLZR (TRCA) | |
| DB Generic |
| 121 | How to change SQL prompt to show connected user and database name | |
| 122 | How to change Archive destination | |
| 123 | Enable the database in Archivelog mode | |
| 124 | How to Recover Loss of DATA (Without a Backup!) using Oracle Flash Back Query | |
| 125 | Proxy User and Connect Through | Duplicate |
| 126 | ORA-00054 resource busy and acquire with NOWAIT specified | |
| 127 | How to find Blocking Sessions | |
| 128 | Create Service using DBMS_SERVICE | |
| 129 | Error TNS-12543 while connect to a remote database on a Linux | |
| 130 | How to Change MAX_STRING_SIZE on Physical Standby Environment | |
| OEM |
| 131 | Steps to configure Oracle 11g OEM DBConsole manually for database | |
| 132 | Enable Oracle Enterprise Manager Express 12c | |
| 133 | Oracle Enterprise Manager Cloud Control 13c Release 2 (13.2.0.0) Installation on Oracle Linux 64 bit | |
| 134 | Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0) Installation on Oracle Linux 64 bit | |
| 135 | Add Database Target on EM Cloud Control 13c | |
| 136 | How to upgrade the Enterprise Manager 13.1 Cloud Control OMSPatcher to the Latest Version | |
| 137 | Apply Oracle Enterprise Manager 13c Release 1 Patch Set Update 13.1.0.0.170718 for Oracle Management Service | |
| 138 | Apply Patch on Oracle Management Agent 13c Release 1 (13.1.0.0.0) | |
| Database Link |
| 139 | Database link | |
| DBMS SCHEDULER |
| 140 | How to Create and Monitor DBMS_SCHEDULER Jobs | |
| 141 | Enable/Disable JOBS during Maintenance | |
| Microsoft SQL Server DBA |
| 142 | Steps to Install Microsoft SQL Server Express 2014 | |
| 143 | How to Install Only SQL Server Management Studio | |
| 144 | Create Database using the SQL Server Management Studio | |
| 145 | Enable TCP/IP Connection | |
| 146 | Allow Remote Connection | |
| 147 | Authentication Method | |
| 148 | How to Create SQL Server Authenticated Login in SQL Server | |
| 149 | How to create Windows Authentication Login in SQL Server | |
| 150 | How to Create Windows Group Authentication Login in SQL Server | |
| 151 | Create a new domain user account in Windows Server 2016 | |
| Microsoft SQL Server – Backup and Recovery |
| 152 | Recovery Models | |
| 153 | Database Backup: FULL,DIFFERENTIAL and T-LOG | |
| 154 | Restore & Recover Database | |
| MySQL DBA |
| 155 | Install MySQL 8 on Linux 7 Using RPM Packages | |
| 156 | Create MySQL Database | |
| 157 | Create New User Account in MySQL | |
| 158 | Grant/Revoke Privileges in MySQL | |
| 159 | Create Roles in MySQL | |
| MySQL – Backup/Restore |
| 160 | How To Backup MySQL Database Using mysqldump? | |
| 161 | How to Restore Database from Single MySQL Database Backup? | |
| 162 | How to Restore A Single Database From A Backup File Which Contains Multiple Databases? | |
| 163 | How To Restore Single Table From Full Database Backup in MySQL? | |
| MySQL – Replication |
| 164 | How To Configure MySQL Master-Slave Replication? (One-Way Replication) | |
| PostgreSQL DBA |
| 165 | How to Install PostgreSQL 13 ON RHEL 7? | |
| 166 | How to START/STOP PostgreSQL 13 ON RHEL 7? | |
| 167 | How to Create Database in PostgreSQL? | |
| Linux |
| 168 | Download Oracle files on Linux via wget | |
| 169 | How to Install SQL Developer on Linux | |
| 170 | How to Disable the Firewall on Linux 6 | |
| DBA Scripts |
| 171 | Oracle DBA Sheet v5.8 | |
| 172 | Oracle DBA Sheet v6.1 | |
| 173 | DBA Daily Report | Coming soon !!! |