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
Apply RU on DATABASE 12.2
ROLLBACK RU from DATABASE 12.2
Apply DB PSU on Standby
DB-Admin
Create database -DBCA silent mode
Drop Database
Delete database -DBCA silent mode
Create DB 19C – DBCA-GUI
Create DB 19C – DBCA-SILENT
CREATE NEW PDB BY CLONING AN EXISTING PDB
CREATE PDB USING DBCA
DROP PDB MANUALLY
SCHEMA REFRESH FROM 11G TO 12C PDB
CREATE PDB USING SEED
CREATE NON-CDB ON ORACLE 12C IN SILENT MODE
Configure OEM Express 12c
Convert Non-CDB to PDB with DBMS_PDB
Create Non-CDB on Oracle 12c using DBCA (GUI)
STARTUP/SHUTDOWN CDB AND PDB
How to Change MAX_STRING_SIZE on Physical Standby Environment
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
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
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
Dataguard
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
ExaDB
CellCLI Commands
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
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?
PostgreSQL
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
PostgreSQL User Management
DB2
Install DB2 V10.5 using GUI
DB2 STOP and START
DB2 Troubleshooting Guide
DevOps
How to Install Jenkins on Linux
AWS
Search for:
MEDICAL_CERTIFICATE 2
Post navigation
←
Create Service using DBMS_SERVICE
