RAJASEKHAR AMUDALA

Welcome to Bright DBA website.  

Please use the menu bar (or) Index below to navigate for Oracle/MS SQL Server/MySQL/MariaDB/DB2 LUW, PostgreSQL DBA articles !!!

Topics
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