My Articles

> Creating new CDB using DBCA in 12cR1

> Re-Creating Appsutil directory for DB Tier in EBS R12

> Overview of Oracle Local Registry (OLR) in RAC 11gR2

> Oracle RAC 11gR2 Installation on Virtual Box

> Default "LISTENER" is not configured when running DBCA

> Find Roles and Privelages for USER

> Find out CPU usage for each session

> Overview of ADOP Phase=Prepare

> Automated Syncup Script For Manual Standby Database

> Setup Manual Standby Database

> Useful EXPDP Commands

> Enable Maintenance Mode in Oracle Apps

> Run Autoconfig On DB Tier and Apps Tier

> Oracle EBS R12.2 installation on Linux Virtual Box

> ORA-1166 file number 101 is larger than MAXDATAFILES (100)

> Find your ORACLE session ID number

> Sending mail with HTML content in PERL

> Sendmail Utility: Sending mail in PERL

> Admrgpch Utility: Merge Patches using admrgpch

> RACGuide: 12c RAC Installation on Linux [Video]

> ORA-02030 How to grant on v$ views

> Query to check characterset in Oracle

> Query to check locally managed tablespaces

> OPatch failed with error code 41

> OUI-67076: opatch lsinventory Error

> Oracle Database 12cR1 installation (12.1.0.2) on linux

> Script: Display SGA Statistics in Oracle Database

> Script: Check RMAN Backup job Status

> impdp - ORA-31640 ORA-31693 ORA-19505 ORA-27037

> Script: Oracle Database Growth per Month

> Adding disk to ASM disk group in oracle 11g

> CRS-4639 CRS-4124 Oracle High Availability Services startup failed in 11gR2 RAC

> ORA-04031 unable to allocate 3896 bytes of shared memory in ASM Instance

> Data Guard Physical Standby Database - Part1

> Enable and Disable Archive Log Mode in Oracle 10g/11g

> XML Clob data type 'Value Error' while creating Materialized views

> Parameters used in the LOG_ARCHIVE_DEST_n

> ORA-31685 Error while import using IMPDP

> Find CPU and Memory info in AIX Machine

> To find applied PSU patchsets in Oracle

> Cloning a New Virtual Machine from Existing VM Box

> Script: Some Useful Oracle Database Monitoring Commands for DBA's - PART1

> Applying Incremental backup on Physical standby database

> ORA-14452: attempt to create, alter or drop an index on temporary table already in use

> Listener INTERMEDIATE status with "Not All Endpoints Registered" in 11gR2 RAC

> Installation of Oracle Database 11gR2 on Oracle Enterprise Linux 5.7

> Oracle Enterprise Linux 5.7 installation on Oracle VirtualBox

> Usage of SQLFILE parameter in Data Pump Import

> Renaming an Oracle database

> Script: Shell Script to export Full DB or Single or Multiple Schemas

> Managing Temp Tablespace

> Useful Oracle 11gR2 SRVCTL commands

> Oracle 11gR2 Clusterware Commands

> Space release problem in OS level while Dropping Temporary Tablespace

> Export Logical Database Backup Dumps to ASM Disk

> Startup And Shutdown Modes In Oracle

> Oracle File Structure

> Logfile Architecture and Logwriter Process

> Tablespace Management in Oracle

> Setup SSH Configuration in LINUX