Oracle Adaptive Access Manager 10g R3 – Released, New Features

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 – […]

Read More

How to update Workflow Administrator Role in Oracle Applications 11i/R12

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 […]

Read More

AWR (Advance workload Repository)Report in Oracle 10G

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 […]

Read More

Recover an accidentally deleted file when the database is still open.

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 […]

Read More

RAC Storage

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 […]

Read More

Custom Look and Feel (CLAF) in Apps 11i (Framework Pages)

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 […]

Read More

Oracle Database Recovery Scenario and Solution

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 […]

Read More

Once again about MWA/MCSA

Well, this will be my start. Initally I planned a different topic for my first post. But with the recent talks about MWA/MCSA applications I can’t miss a chance to add my five cents to the subject. Autoconfig. In autoconfig-enbled environment configuration file mwa.cfg is written by autoconfig. So it would be good to modify […]

Read More

Mobile Web Application Tips

With reference to the article in our web site about Mobile Supply chain , I am trying to nail down some of the problem and configuration about MWA , which take care by DBA . This tips can be followed Mobile apllication Server version 11.5.5 to 11.5.10.X One of the important  configuration file for the […]

Read More

How can i see, Critical Patch Update is installed on the database,

Note that the methods in this note will allow you to check upon an Oracle installation, it is still recommended for a DBA to properly document all applied patches to the software installation. The output of ‘opatch lsinventory’ will give you a list of bug numbers, but it can be awkward to cross reference them […]

Read More
Not found