Bright DBA

ORACLE DBA – Tips and Techniques

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
    • ASM
      • Move ASM Spfile to diff. DiskGroup
      • ASM Commands
      • Instantiating disk: failed
      • CSSD won’t start automatically
    • RAC
      • Create users, groups and Paths for Oracle RAC
      • Configure ASMLib for Oracle ASM
      • Configure UDEV Rules for Oracle ASM
      • 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
  • SQL Server
  • 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
  • MySQL
  • MariaDB
  • Redis
  • Mongo
  • GaussDB
  • DevOps
    • How to Install Jenkins on Linux

8

Published on July 11, 2020 in Add Targets Manually on EM Cloud Control 13cFull resolution (1831 × 745)
← Previous Next →
About me - Rajasekhar Amudala