Oracle on 20th Oct. released new version (10g R3 /10.1.4.5) of Oracle Adaptive Access Manager  (Why OAAM version 10.1.4.5 is called as OAAM 10g R3 ?)
A. Oracle Adaptive Access Manager (OAAM) is product for web access real-time fraud detection and multifactor online authentication.
Main Functionality of OAAM is to protect against
- Phishing
- Pharming
- Trojans
- key logging
- […]

Popularity: 11% [?]

continue reading.....

If you want to see workflow details (owned by other users) or status diagram in Oracle Applications 11i/R12 then you should belong to one of responsibilities/user listed under WF_ADMIN_ROLE.
By default (in 11i & R12) this role is set to user sysadmin (In old versions 11.5.8 or prior, it used to set to *)
If you wish […]

Popularity: 14% [?]

continue reading.....

AWR is an enhancement/upgradation of statspack, which help us to tune the database.
Oracle Database 10g uses a scheduled job, GATHER_STATS_JOB, to collect AWR statistics. This job is created, and enabled automatically when you create a new Oracle database under Oracle Database 10g.
GATHER_STATS_JOB, to collect AWR statistics every 1 hour
.
We can disable and enable the schedule […]

Popularity: 17% [?]

continue reading.....

On Unix/Linux, when a file is deleted, but a process still has the file open, the file is still there in the filesystem, and only the inode is removed.
But the process can continue to use its file handle, and the file can also be accessible under /proc/<pid>/fd .
In the following example, we use that behavior […]

Popularity: 15% [?]

continue reading.....

Storage Options for RAC

CFS (Cluster File System) – Easy to manage but only available on some platforms.  Does not address striping and mirroring.
RAW – Available on all platforms but difficult to manage. Does not address striping and mirroring.
NFS – Easy to manage but only available on some platforms.  Does not address striping and mirroring.
ASM (Automatic […]

Popularity: 12% [?]

continue reading.....

This post covers overview of Custom Look and Feel (CLAF) in Self Service Pages (Oracle Apps 11i) and steps to troubleshoot look & feel related issues.
.
Custom Look and Feel functionality in 11i  Framework Pages

1.User type in username/password to login to Apps 11i
2. System checks value of profile option Oracle Applications Look and Feel at User Level […]

Popularity: 13% [?]

continue reading.....

The purpose of this article  is to get acquianted with some of the recovery scenarios , this topic is useful for the folks who is having less experience and looking for good DBA exposure and preparing for interview .
   I am trying to  jotting down both RMAN and normal database technique :-
 1.Complete Closed database Recovery. […]

Popularity: 13% [?]

continue reading.....