RAJASEKHAR AMUDALA

Welcome to Bright DBA website.  Please use the menu bar (or) Index below to navigate for Oracle/MS SQL/MySQL/PostgreSQL DBA articles !!!

S.NoTopicsRemarks
DBA Monitor
1 OS
2 Database
3NetworkComing soon !!!
4StorageComing 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
139Database link
DBMS SCHEDULER
140How to Create and Monitor DBMS_SCHEDULER Jobs
141Enable/Disable JOBS during Maintenance
Microsoft SQL Server DBA
142Steps to Install Microsoft SQL Server Express 2014
143How to Install Only SQL Server Management Studio
144Create Database using the SQL Server Management Studio
145Enable TCP/IP Connection
146Allow Remote Connection
147Authentication Method
148How to Create SQL Server Authenticated Login in SQL Server
149How to create Windows Authentication Login in SQL Server
150How to Create Windows Group Authentication Login in SQL Server
151Create a new domain user account in Windows Server 2016
Microsoft SQL Server – Backup and Recovery
152Recovery Models
153Database Backup: FULL,DIFFERENTIAL and T-LOG
154Restore & Recover Database
MySQL DBA
155Install MySQL 8 on Linux 7 Using RPM Packages
156Create MySQL Database
157Create New User Account in MySQL
158Grant/Revoke Privileges in MySQL
159Create Roles in MySQL
MySQL – Backup/Restore
160How To Backup MySQL Database Using mysqldump?
161How to Restore Database from Single MySQL Database Backup?
162How to Restore A Single Database From A Backup File Which Contains Multiple Databases?
163How To Restore Single Table From Full Database Backup in MySQL?
MySQL – Replication
164How To Configure MySQL Master-Slave Replication? (One-Way Replication)
PostgreSQL DBA
165How to Install PostgreSQL 13 ON RHEL 7?
166How to START/STOP PostgreSQL 13 ON RHEL 7?
167How to Create Database in PostgreSQL?
Linux
168Download Oracle files on Linux via wget
169How to Install SQL Developer on Linux
170How to Disable the Firewall on Linux 6
DBA Scripts
171Oracle DBA Sheet v5.8
172Oracle DBA Sheet v6.1
173DBA Daily ReportComing soon !!!