Posts
Backup & Recovery
- Configure and Manage RMAN Recovery Catalog
- Create a Trace file for Control file
- Database Backup Script using RMAN
- Improve Backup Performance – Change Tracking
- Move or Rename Oracle Files
- Oracle Data Pump (expdp, impdp) in Oracle Database
- Performing Block Media Recovery in Oracle
- Recover a Table From a Drop/Truncate/Delete By RMAN
- Restoring Corrupted Datafile Using RMAN in Oracle
- RMAN Command
Data Guard
Database Maintenance
- After Revoked Tablespace Quota From User in Oracle
- Change Archive Log Mode in Oracle Database
- Control System Privileges (Truncate or Drop) in Oracle Database
- Create Duplicate Or Refresh the Database Using RMAN Backup on RAC
- Move Objects From One Tablespace to Another Tablespace in Oracle
- Move or Rename Oracle Files
- ORACLE HANG ANALYZE
- Permission changed for all directories including files in Oracle Home (RAC)
- Steps for PSU (Patch Set Update) Patching on RAC with Data Guard
- Tips to Avoid Mistake and Be a Safer DBA
- Unused or Drop Column? Which option should use?
Exadata
- Configure Distributed Command Line Interface (DCLI)
- Exadata Key Features
- Exadata Simulation (X3) on VM Part – I
- Exadata Simulation (X3) on VM Part – II
- Exadata Simulation on VM (Cell 12.1.1.1.0)
- Exadata Smart Scan
- Hybrid Columnar Compression
- Oracle Database Software Installation and Create Database on RAC
- Oracle Exadata Smart Flash Cache
- Storage Indexes in Exadata System
GoldenGate
- A Guide to OGG Microservices Architecture (OGG MA) Log File Paths
- Configure GolgeGate Replication with19c
- Create a User ALIAS for GoldenGate Credential using CREDENTIALSTORE
- Enable DDL Replication in GoldenGate
- GoldenGate Commands
- GoldenGate Error and Solution
- Initial Load for GoldenGate Replication Setup
- Install Oracle GoldenGate 19c on Linux
- Migrate Oracle GoldenGate Classic to MicroServices
- Oracle GolgeGate
- Step-by-Step Installation of Oracle GolgenGate (OGG) 21c Microservices
- Using AdminClient for Command Line Utility for OGG MA
OCM Preparation
- Administration Database Users including Roles and Privileges on Multitenant
- Configure and Manage RMAN Recovery Catalog
- Configure Heat Map & Automatic Data Optimization (ADO) in Oracle 12c
- Configure Resource Manager on Container Database
- Configure the network environment for Multitenant Database
- Create and Manage Partition Table in Oracle
- Creating a Pluggable Database
- Creating Container and Pluggable Database Using CREATE DATABASE SQL Command
- In-Database Archiving
- Install Agent on OEM 12c or 13c in Silent Mode
- Install Agent on OEM using GUI
- Install Oracle 12.1 Software and Create database in Silent Mode
- Managing a Pluggable Database
- OCM 12c Preparation
- OCM 12c Preparation: Prepare Exam Environments
- OEM Cloud Control 12c Release 4 Installation on Oracle Linux 6.5
- Oracle Data Pump (expdp, impdp) in Oracle Database
- Oracle Database 12c RAC on Oracle Linux 6.5
- Performing Block Media Recovery in Oracle
- Restoring Corrupted Datafile Using RMAN in Oracle
- Temporal Validity in 12c
OEM
Oracle Application
Oracle Cloud
Oracle Core
Oracle Database
- Administration Database Users including Roles and Privileges on Multitenant
- Configure Heat Map & Automatic Data Optimization (ADO) in Oracle 12c
- Configure Resource Manager on Container Database
- Configure the network environment for Multitenant Database
- Create Oracle RAC Database Using DBCA
- Creating a Pluggable Database
- Creating Container and Pluggable Database Using CREATE DATABASE SQL Command
- Deinstall Oracle Software in Silent Mode
- Important Link About Oracle
- Install Agent on OEM 12c or 13c in Silent Mode
- Install Oracle 12.1 Software and Create database in Silent Mode
- Install Oracle Software in Silent Mode
- Installing Oracle Client In Silent Mode on Linux
- Managing a Pluggable Database
- Manually Upgrade Oracle Database from 11gR2 to 12cR2
- Move or Rename Oracle Files
- Oracle Data Pump (expdp, impdp) in Oracle Database
- Oracle Database 11g R2 (11.2) Installation On Oracle Enterprise Linux 7 (OEL7)
- Oracle Database 11g Release 2 RAC On Oracle Linux 7.1
- Oracle Database 12c R1 (12.1) RAC installation
- Oracle Database 12c R2 (12.2) RAC On Oracle Linux 7
- Oracle Database 12c RAC on Oracle Linux 6.5
- Oracle Database 12c, 18c & 19c Product Versions and Upgradation Path
- Oracle Database 19c Installation On Oracle Linux 7.1
- Oracle Database Upgrade Manually from 12.1 to 19.3
- Recover a Table From a Drop/Truncate/Delete By RMAN
- Temporal Validity in 12c
- Upgrade Oracle Database from 11gR2 to 12cR2 Using DBUA
- V$ View & Data Dictionary View on Oracle
Oracle Database 11g
- Create Oracle RAC Database Using DBCA
- Deinstall Oracle Software in Silent Mode
- Install Oracle Software in Silent Mode
- Manually Upgrade Oracle Database from 11gR2 to 12cR2
- Move or Rename Oracle Files
- Oracle Data Pump (expdp, impdp) in Oracle Database
- Oracle Database 11g R2 (11.2) Installation On Oracle Enterprise Linux 7 (OEL7)
- Oracle Database 11g Release 2 RAC On Oracle Linux 7.1
- Upgrade Oracle Database from 11gR2 to 12cR2 Using DBUA
Oracle Database 12c
- Administration Database Users including Roles and Privileges on Multitenant
- Configure Heat Map & Automatic Data Optimization (ADO) in Oracle 12c
- Configure Resource Manager on Container Database
- Configure the network environment for Multitenant Database
- Creating a Pluggable Database
- Creating Container and Pluggable Database Using CREATE DATABASE SQL Command
- Deinstall Oracle Software in Silent Mode
- Install Agent on OEM 12c or 13c in Silent Mode
- Install Oracle 12.1 Software and Create database in Silent Mode
- Install Oracle Software in Silent Mode
- Managing a Pluggable Database
- Manually Upgrade Oracle Database from 11gR2 to 12cR2
- Move or Rename Oracle Files
- Oracle Data Pump (expdp, impdp) in Oracle Database
- Oracle Database 12c R1 (12.1) RAC installation
- Oracle Database 12c R2 (12.2) RAC On Oracle Linux 7
- Oracle Database 12c RAC on Oracle Linux 6.5
- Oracle Database Upgrade Manually from 12.1 to 19.3
- Temporal Validity in 12c
- Upgrade Oracle Database from 11gR2 to 12cR2 Using DBUA
Oracle Database 18c
Oracle Database 19c
Performance Tuning
RAC & ASM
- Adding a Node to Oracle RAC 12c
- Automatic Storage Management (ASM)
- Configure Oracle 12c RAC to RAC Data Guard (DR) on Linux
- Copy Password File From Primary ASM to Standby ASM on Oracle 12c
- Create ASM Disk Group
- Create Oracle RAC Database Using DBCA
- Deleting a Node to Oracle RAC 12c
- Grid Infrastructure (11.2.0.4) Installation
- Migrating OCR, Voting Disk and MGMTDB to another ASM DiskGroup in 12c RAC
- Oracle Database 11g Release 2 RAC On Oracle Linux 7.1
- Oracle Database 12c R1 (12.1) RAC installation
- Oracle Database 12c R2 (12.2) RAC On Oracle Linux 7
- Oracle Database 12c RAC on Oracle Linux 6.5
- Oracle Database Software Installation and Create Database on RAC
- Oracle RAC Cache Fusion
- Oracle Real Application Cluster (RAC) Important Components
- Unable To Load Module Oracleasm in Oracle 12c
- USABLE_FILE_MB is showing negative values in V$ASM_DISK View
Scripting
Unix
- Add a New Disk to an Existing Linux Server
- Create a filesystem on Linux
- How to Rename Ethernet Interface to eth0 in Linux on VM
- Install Oracle Linux 5.9 on VM
- Install Oracle Linux 6.8 on VM
- Install Oracle Linux 7 on VM
- Setup Password less connection using SSH for User Equivalence on Linux
- Upgrade Oracle Enterprise Linux (OEL) 6 to OEL 7
Upgrade and Migration
- Manual Upgrades to Non-CDB Oracle Database
- Manually Upgrade Oracle Database from 11gR2 to 12cR2
- Oracle Database 12c, 18c & 19c Product Versions and Upgradation Path
- Oracle Database Migrate Using Mixed Oracle Version
- Oracle Database Upgrade Manually from 12.1 to 19.3
- Upgrade Oracle Database from 11gR2 to 12cR2 Using DBUA
VitualBox Manager
- Clone Virtual Machine
- Configure Network between two Physical Machines for VM Setup
- Configure Virtual Machine for RAC
- Connect VM using Putty from Local Computer
- Create Virtual Machine (VM) for Exadata Storage Server
- Creating a new file system for an existing Linux virtual machine
- How to Rename Ethernet Interface to eth0 in Linux on VM
- Install Oracle Linux 5.8
- Install Oracle Linux 5.9 on VM
- Install Oracle Linux 6.8 on VM
- Install Oracle Linux 7 on VM
- Setup Password less connection using SSH for User Equivalence on Linux
