Posts by Sakthi Sethuperumal S

Using adrci Tool in 11g

Introduction Steps to use adrci tool in 11g Posted by Sakthi Sethu Perumal Oracle 11g introduces adrci tool. This tool is used to examine contents of ADR repository and also to package…

Read More

Commands to rebuild Index, Partitioned Index, LOB Index, IOT (Index Organized Table)

Introduction Here are the Commands to rebuild Index, Partitioned Index, LOB Index, IOT (Index Organized Table) Posted by Sakthi Sethu Perumal To rebuild the index: set pagesize 1000 SELECT ‘ALTER…

Read More

Complete Guide for upgrading oracle applications 11i with 10g R2

Introduction This is the guide for upgrading oracle applications 11i with  10g R2 Posted by Narasimha Rao Dear All, Sub: Upgrading oracle applications 11i with 10g R2. ( This ll be…

Read More

Sending Mails through Os( Unix ) with Mailx

Introduction Steps to send mail through unix with mailx Posted by Narasimha Rao Dear All, This Post is relating to Useful Operating system techniques to send mails using command : Mailx…

Read More

Oracle EBS Apps in MS-Vista

Introduction Information about Oracle EBS Apps in MS-vista Posted by Narasimha Rao Dear All,   This post is relating to using Vista in EBS.   Info: Vista is certified in Ebs…

Read More

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