Database Blog

DBA Tip : RMAN restore when backup file are spread across 2 different mount points

Introduction Restore rman backup when backup file are spread among two different mount points Posted by Hemanth Sathavalli  Customers whose databases are of huge size and if the RMAN backup size…

Read More

Issue in Preclone process after upgrading 11i with 10g R2

Introduction Solution to fix the Issue in Preclone process after upgrading 11i with 10g R2 Posted by Narasimha Rao Dear all, This post is relating to following issue we face after…

Read More

Upgradation of Discoverer from 4i to 10g for Applications 11i CU2 (11.5.10.2)

Introduction Steps to upgrade Discoverer from 41 to 10g Applicatioins Posted by Narasimha Rao Upgradation of Discoverer from 4i to 10g for Applications 11i CU2 (11.5.10.2) Environment Details : Operating system…

Read More

Apex Installation for 11g Instance

Introduction Steps to install Apex in 11g instance Posted by Narasimha Rao Pre Installation Tasks: 1. Create Tablespace for Apex Data and Files. SQL> create tablespace apex datafile ‘//apexd01.dbf’ size 500m;…

Read More

Apex Listener Configuration for Apex

Introduction Steps to configure apex listener for apex. Posted by Narasimha Rao 1) Check java version after completion of glassfish installation . /java -version 2) Go to location /oracle/glassfishv3/jdk/bin and Run…

Read More

How to Cancel a Concurrent Request Stuck in the Queue

Introduction Steps to cancel Concurrent Request Stuck in the Queue Posted by Syed Hussaini Some times we get a Request from customers that they are not able to cancel their request…

Read More

Enable Trace and take tkprof

Introduction Steps to see how to enable trace and tkprof Posted by Sakthi Sethu Perumal Step 1 : Check Request ID from Find Concurrent request screen (In my case Request…

Read More

Add,drop and rebalance ASM diskgroups

Introduction Steps to see how we can add, drop and rebalance diskgroups Posted by Karthick Adding Disks to a Disk Group ALTER DISKGROUP DATA_DG ADD DISK ‘/devices/DiskA1’,’/device/DiskB1’; Dropping Disks and Disk…

Read More

How to add the disk to existing diskgroups

Introduction Steps to add new disk to existing groups. Posted by Karthick Steps: Connect as sqlplus / as sysasm; TO CHECK DISKGROUP NAME: select group_number,name from v$asm_diskgroup; GROUP_NUMBER NAME ———— ——————————   …

Read More

Oracle – Data Guard Broker Setup

Introduction Steps to configure Oracle – Data Guard Broker Posted by Sundaravel Ramasubbu In this document, Primary Server: Chennai Secondary Server: Trichy Primary DB Unique Name : PROD_DGP Standby DB Unique…

Read More