Bright DBA
ORACLE DBA – Tips and Techniques
Menu
Skip to content
Home
DBA Monitor
Scripts
DBA Sheet v6.1
DBA Sheet v7.0
DBA Daily Report
Generate INSERT statements from the SELECT query
Generate INSERT statements to a flat file using a PL/SQL query
OS
DATABASE
NETWORK
STORAGE
Oracle
DB-Install
Install 10g
Install Oracle Software in silent mode 11gR2
Deinstall Oracle 11gR2 Database binaries
Uninstall Oracle Client on Windows
Create database -DBCA silent mode
Delete database -DBCA silent mode
Drop Database
Patch Terminology
DB-Admin
How to change SQL prompt to show connected user and database name
Change Archive Dest
Enable Archivelog
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
Store DB credentials in Oracle Wallet
Under Edit
BACKUP
BACKUP ORACLE HOME AND INVENTORY
Datapump
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
12c/18c/19c
Install 12.2 Database Binaries in silent mode
Upgrade DB Manually 11.2.0.4 to 12.2.0.1
Upgrade DB using DBUA from 11.2.0.4 to 12.2.0.1
CREATE PDB USING SEED
CREATE NEW PDB BY CLONING AN EXISTING PDB
CREATE PDB USING DBCA
DROP PDB MANUALLY
Configure OEM Express 12c
CREATE NON-CDB ON ORACLE 12C IN SILENT MODE
Create Non-CDB on Oracle 12c using DBCA (GUI)
Convert Non-CDB to PDB with DBMS_PDB
SCHEMA REFRESH FROM 11G TO 12C PDB
STARTUP/SHUTDOWN CDB AND PDB
Apply RU on DATABASE 12.2
ROLLBACK RU from DATABASE 12.2
How to Change MAX_STRING_SIZE on Physical Standby Environment
18C
Install 18c
Deinstall Oracle 18c Database Binaries
18c DB Patching
Install 19c GUI
Install 19c in silent mode
Oracle 19c Deinstall
Create DB 19C – DBCA-GUI
Create DB 19C – DBCA-SILENT
Apply Patch RU on Database 19c
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
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
HA
DG 11g
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
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
Apply DB PSU on Standby
Refresh Standby Database using RMAN Incremental SCN Backup
Resetlogs on Primary where Standby in place
Drop SRL
DG 12c
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
Upgrade Database to 12.2 with Physical Standby
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
Exadata
CellCLI Commands
GG
GG 11g
GoldenGate Installation
Unidirectional DML Replication
Zero Downtime Migration
DDL Replication
GG 12C
GoldenGate 12C Installation
Integrated Capture
Oracle GoldenGate Heterogeneous Replication
Credential Store
ADD NEW TABLE TO AN EXISTING GOLDENGATE CONFIGURATION
GG 19C
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
PostgreSQL
Install PostgreSQL 13 using yum Repository on Linux
Install PostgreSQL Using Source Code
How to START/STOP PostgreSQL 13 on Linux
Create Database in PostgreSQL
PostgreSQL User Management
PostgreSQL pg_hba.conf
Change Data Directory
WAL Files (Redo log files)
Change WAL Directory Location (pg_wal)
Enable Archive Mode (WAL Archiving)
Disable ARCHIVELOG Mode
PostgreSQL Tablespace
pg_dump & pg_restore
Backup and Restore Using pg_dumpall
pg_basebackup
Clone PostgreSQL Cluster (No Archive Mode)
Backup and Restore on Same Host Using pg_basebackup
PostgreSQL Backup & Restore+Recover to New Host with WAL Archive files
PostgreSQL Point-in-Time Recovery (PITR)
Incremental backups in PostgreSQL 17
Streaming Replication (Active Dataguard)
Failover Streaming Replication
Synchronous Replication in PostgreSQL
How to setup repmgr for PostgreSQL Automatic Failover
DB2
Install DB2 V10.5 using GUI
DB2 STOP and START
DB2 Troubleshooting Guide
DevOps
How to Install Jenkins on Linux
MSSQL
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
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
SQL Server – Recovery Models
Database Backup-FULL-DIFFERENTIAL-TLOG
Restore Database without Tail Backup
Log Shipping (SQL Server 2022)
Windows Server 2022 Failover Cluster
Always On Availability Group
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?
MariaDB
Search for:
11g to 12c
Page under construction