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 MoreIf 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 MoreAWR 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 MoreOn 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 MoreStorage 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 MoreThis 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 MoreThe 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 MoreWell, 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 MoreWith 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 MoreNote 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