Bright DBA

ORACLE DBA – Tips and Techniques

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

PSQL

PostgreSQL DBA

#PostgreSQL DBA Topics
1How to Install PostgreSQL ON Linux?
2How to Install PostgreSQL on Linux 7 using source code?
3How to START/STOP PostgreSQL ON Linux?
4How to Create Database in PostgreSQL?
5PostgreSQL User Management

 

Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/

Rajasekhar Amudala

Rajasekhar Amudala

Master of Business Administration (MBA)
Oracle 10g Certified Professional (OCP)
Oracle 11g Certified Professional (OCP)
Oracle 10g RAC Certified Expert (OCE)
Oracle 11g RAC Certified Expert (OCE)
Oracle Golden Gate Certified
Oracle Exadata Certified
OCI Architect Professional
About me - Rajasekhar Amudala