Bright DBA
ORACLE DBA – Tips and Techniques
Menu
Skip to content
Home
DBA Monitor
DBA Sheet v7.0
OS-DB-Commands
Database-Scripts
Generate INSERT statements from the SELECT query
Generate INSERT statements to a flat file using a PL/SQL query
Oracle
DB-Install
Install Oracle AI Database 26ai
Install 19c GUI
Install 19c in silent mode
Install 18c
Install 12.2 Database Binaries in silent mode
Install Oracle Software in silent mode 11gR2
Install 10g
Deinstall Oracle 11gR2 Database binaries
Deinstall Oracle 18c Database Binaries
Oracle 19c Deinstall
Uninstall Oracle Client on Windows
DB-Upgrade
Upgrade DB using DBUA from 11.2.0.4 to 12.2.0.1
Upgrade DB Manually 11.2.0.4 to 12.2.0.1
Upgrade Oracle Database from 12.2.0.1 to 19c using DBUA
Upgrade Oracle Database Manually from 12.2.0.1 to 19c
Rolling Upgrade With an Existing Physical Standby Database
Upgrade TIMEZONE Version
Upgrade Database to 12.2 with Physical Standby
Patching
Patch Terminology
Apply Patch RU on Database 19c
18c DB Patching
18c DB Patching – Youtube
Apply RU on DATABASE 12.2
ROLLBACK RU from DATABASE 12.2
Apply DB PSU on Standby
DB-Admin
Oracle Container Database (CDB)
CREATE NEW PDB BY CLONING AN EXISTING PDB
CREATE PDB USING DBCA
CREATE PDB USING SEED
DROP PDB MANUALLY
STARTUP/SHUTDOWN CDB AND PDB
Convert Non-CDB to PDB with DBMS_PDB
SCHEMA REFRESH FROM 11G TO 12C PDB
Non-CDB
Store DB credentials in Oracle Wallet
Create database -DBCA silent mode
Drop Database
Delete database -DBCA silent mode
Create DB 19C – DBCA-GUI
Create DB 19C – DBCA-SILENT
CREATE NON-CDB ON ORACLE 12C IN SILENT MODE
Configure OEM Express 12c
Create Non-CDB on Oracle 12c using DBCA (GUI)
How to Change MAX_STRING_SIZE on Physical Standby Environment
How to change SQL prompt to show connected user and database name
Enable Archivelog
Change Archive Dest
How to Recover Loss of DATA – (Without a Backup!)
Configure OEM DBConsole manually
Proxy User
Database Link
DBMS_SCHEDULER
Enable/Disable JOBS during Maintenance
ORA-00054
Blocking Sessions
Create Service using DBMS_SERVICE
Error TNS-12543
Under Edit
BACKUP
How to Recover Loss of DATA – (Without a Backup!)
BACKUP ORACLE HOME AND INVENTORY
SCHEMA REFRESH FROM 11G TO 12C PDB
RMAN-CATALOG
RMAN Database Restore RAC – RAC
RMAN Database Restore ASM – ASM
RMAN Database Restore from ASM to File System
RMAN ACTIVE DUPLICATION ASM TO ASM
Backup Based RMAN Duplicate Database
ExaDB
Oracle Exadata – Models
Exadata DB Server (Compute Node) – CPU
Exadata DB Server (Compute Node) – Memory
Exadata Storage Server (Cell Node)
ExaData infi Network
Exadata Part Replacement Runbook
CellCLI Commands
PT
Tuning Stage 1
Statistics
Oracle Histograms
Export/Import schema statistics
CONTROL MANAGEMENT PACK ACCESS
Generate Explain Plan
SQL Query is really hanged or not
Tuning Stage 2
STATSPACK
ASH
AWR
Colored SQL_ID
SYSAUX Tablespace
Tuning Stage 3
Troubleshooting Long Running Queries
SQL Tuning Advisor
SQLT
How to Install SQLT
How to Run SQLT
How to Create Custom SQL Profile
Uninstall SQLT
Tracing
TRCA – Trace Analyzer
FF Analysis (Advanced Troubleshooting)
Fire-Fighting Analysis (Ongoing / Live Issues)
Explain Plan Analysis
Top SQL Analysis
10046 Trace Analysis
10053 Trace Analysis
Forensic Analysis (RCA – Completed Issues)
HA
CONFIGURATION
Active Dataguard on Non-ASM
Active Dataguard on ASM
Convert Physical Standby Database to Snapshot Standby Database
Convert Snapshot Standby database to Physical Standby database
Configure Cascading Standby Database
DG Broker Configuration
DG Broker Error – ORA-16714
Disable DG Broker
12.2 Active Dataguard in CDB on Non-ASM
Create Physical Standby using RMAN Backup Without Duplicate Command
Create Physical Standby using RMAN Backup with Duplicate Command
12c DG Broker Configuration
SWITCHOVER
Switchover Manual No-Broker
Switchover with Broker
FAILOVER
Failover with Broker(No Flashback)
Failover with No Broker (No Flashback)
Failover with Broker using Flashback
Failover with No Broker using Flashback
Enable Real-Time Apply
Refresh Standby Database using RMAN Incremental SCN Backup
Resetlogs on Primary where Standby in place
Drop SRL
RAC
Create users, groups and Paths for Oracle RAC
Configure ASMLib for Oracle ASM
Configure UDEV Rules for Oracle ASM
ASM
Move ASM Spfile to diff. DiskGroup
ASM Commands
Instantiating disk: failed
CSSD won’t start automatically
RAC Install
RAC Install 11.2.0.3
Upgrade GI to 11.2.0.4
Downgrade GI to 11.2.0.3
root.sh failed with ORA-29783 on RAC
Delete Node
Add Node
Delete Node without remove software
Add Node Back which was DELETED without remove software
RAC Admin
How to take OCR backup on 11.2.0.4
Cluster Name
Move/Relocate OCR
Restore loss of all VOTE disk
Cluster Startup issues
Add SCAN
RAC Tools
CLUVFY
OSWatcher
RAC Standby 12.2
Create ACFS File System on RAC
GG
GoldenGate Installation
Unidirectional DML Replication
Zero Downtime Migration
DDL Replication
GoldenGate 12C Installation
Integrated Capture
Oracle GoldenGate Heterogeneous Replication
Credential Store
ADD NEW TABLE TO AN EXISTING GOLDENGATE CONFIGURATION
Install Oracle GoldenGate 19C for Database 12C
Install Oracle GoldenGate 19C for Database 19C
OEM
Install OEM 13.2
Install OEM 13.3
Add Targets Manually on EM Cloud Control 13c
Upgrade OMSPatcher
Apply Patch on OMS 13.1
Apply Patch on Agent 13.1
MS-SQL
Installation & Basics
SQL Server Basics
Install Microsoft SQL Server Express 2014
Install Only SQL Server Management Studio
Create Database using GUI
Enable TCP/IP Connection
Allow Remote Connection
Security & User Management
Authentication Method
Create SQL Server Authenticated Login in SQL Server
Create Windows Group Authentication Login in SQL Server
Create Windows Authentication Login
Create SQL Server Authenticated Login in SQL Server
Create a new domain user account in Windows
Backup & Recovery
SQL Server – Recovery Models
Database Backup-FULL-DIFFERENTIAL-TLOG
Restore Database without Tail Backup
High Availability
Log Shipping (SQL Server 2022)
Windows Server 2022 Failover Cluster
Setup 4 Node Always On Availability Group
Who is NT AUTHORITY\SYSTEM?
Add Database to Existing AG using Backup and Restore
MySQL
Install MySQL 8 on Linux 7 Using RPM Packages
Create MySQL Database
Create New User Account in MySQL
Grant Privileges in MySQL
Create Roles in MySQL
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
How To Configure MySQL Master-Slave Replication?
PostgreSQL
Installation & Basics
Install PostgreSQL 15 using yum Repository on Linux
Install PostgreSQL Using Source Code
How to START/STOP PostgreSQL 13 on Linux
Create Database in PostgreSQL
Security & User Management
PostgreSQL User Management
pg_hba conf
Storage & Architecture
Change Data Directory
WAL Files
Change pg_wal path
PostgreSQL Tablespace
Backup & Recovery
Enable Archive Mode
Disable ARCHIVELOG
Logical – pg_dump and pg_restore (Backup & Restore)
Logical – pg_dumpall (Backup & Restore)
Physical – pg_basebackup (Backup and Restore)
Backup & Restore to Another Host (No Archive Mode)
Backup & Restore on Same Host
Restore PostgreSQL to New Host using pg_basebackup + WAL Archives
PostgreSQL PITR – Point in Time Recovery
High Availability
Streaming Replication
Manual Failover – Streaming Replication
Synchronous Replication
PostgreSQL HA Setup with REPMGR + Automatic Failover
DB2
Install DB2 V10.5 using GUI
DB2 STOP and START
DB2 Troubleshooting Guide
DevOps
How to Install Jenkins on Linux
Search for:
Upgrade Issues
Page under construction