IN ORACLE MILIEU …

Beyond Knowledge

Monthly Archives: June 2008

Patching history of a file – adfhrept.sql

Leave a Comment Posted by on June 30, 2008

Oracle Apps 11i and E-Business Suite R12 provides a wonderful utility to get the history of any file applied through patches. When a patch it applied higher version file get implemented in application. This utility will give complete history about a file starting from the initial release till now and which patch has introduced which [...]

Oracle Application R12, Oracle Applications 11i , ,

AutoPatch modes, arguements and options

1 Comment Posted by on June 30, 2008

Here are the various options for applying the patch in Oracle apps 11i and R12. ADpatch comes with lots of option that can be used, especially when we are applying the patch in production. Modes of ADPATCH If we talk about the mode of applying patch, there are 3 modes 1) Pre-Install Mode Pre-install mode [...]

Oracle Application R12, Oracle Applications 11i , ,

Shared Memory and Semaphores – Oracle Database

Leave a Comment Posted by on June 27, 2008

Introduction: Some times if the database shut down is not graceful, shared memory wont be released. In that case if you try to login and start the database you will get following error. -bash-2.05b$ sqlplus /nolog SQL*Plus: Release 8.1.7.0.0 – Production on Thu Jun 26 12:57:25 2008 (c) Copyright 2000 Oracle Corporation.  All rights reserved. [...]

Oracle Database 10g, Oracle Database 9i , , ,

“Touch Count” for Buffer Cache

Leave a Comment Posted by on June 26, 2008

Introduction I was going through one of the interesting white paper on oraPub Inc. which talks about the mechanish or the algorithm Oracle engine uses to manage the buffers in database buffer cache. The paper is written by Craig A. Shallahamer (criag@orapub.com). Thanks to the author for sharing such an interestng information. Author has explained [...]

Oracle Database 10g , ,

Identifying Locks on Objects using V$LOCKS

4 Comments Posted by on June 21, 2008

Ever wondered when a user comes to you saying that he/she cannot run a DML statement, which one should be able to run with in a second. We suspect 2 reason for the same 1) Database is terribely slow (Which cannot be the case for processing a simple update) 2) Some one is holding an [...]

Database 10g Performance Tuning , , ,

Rolling Back Previous Autoconfig Run

Leave a Comment Posted by on June 19, 2008

In case your autoconfig run has created some issues in your environment and you want to rollback autoconfig run, you can do so by running restore.sh script. For every autoconfig run, autoconfig will create a directory “MMDDhhmm” under APPL_TOP/admin/TWO_TASK/out. Inside these directories, there will be several files which autoconfig has taken a backup off before [...]

Oracle Applications 11i , ,

Running Autoconfig in Test Mode

Leave a Comment Posted by on June 19, 2008

Before running the autoconfig in production to propogate your changes, its usually a good idea to run autoconfig in test mode. This will reduce the risk and you can understand the impact better. AD tool provides a script to run autoconfig in test mode. This script will create a report which will list all files [...]

Oracle Application R12, Oracle Applications 11i , , ,

Interested Transaction List (ITL)

12 Comments Posted by on June 16, 2008

Introduction This post gives a brief idea about how Oracle locks the rows on behalf of the transactions. Before going further on locking, it will be good for you to check the previous post on transaction management to understand the isolation levels of Oracle. Here we will discuss an important area present inside Oracle block [...]

Oracle Database 10g, Oracle Database 9i , ,

Recovering database after loss of current controlfile

Leave a Comment Posted by on June 13, 2008

In this scenario we will be recovering the database after loss of current control file. We assume that database is in archive log mode and all the datafile, online redo log files and archive log files are intact. Same steps holds good even if the database is in no archive log mode. 1) Database is [...]

Oracle Database 10g , ,

Recovering database after loosing active redo log file after archiving

9 Comments Posted by on June 13, 2008

We are considering the scenario where we have the database in archive log mode and we have lost one of the active redo log file. lets say that right now database is working fine and we are just starting it. All the files (Controlfiles, datafiles and online redo log files are intact). 1) Starting the [...]

Oracle Database 10g , ,

← Older posts

Follow

Get every new post delivered to your Inbox.

Join 156 other followers