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

Embedding SQL in Shell

Embedding a SQL inside Shell Script:- Here is a tip on how to run sqlplus scripts within a shell script. This is an example of how to pass database values into shell variables, and to make shell scripts more dynamic. This will help DBA to automate certain DBA tasks, also to setup some automation using […]

Read More

Oracle DB Vault Certified with E-Biz 11i

Oracle DBV with Apps 11i Oracle Database Vault restricts highly privileged users’ access and enforces separation of duty for Oracle EBusiness Suite environments. Regulations such as SarbanesOxley (SOX), Payment Card Industry (PCI), and the Healthcare Insurance Portability and Accountability Act (HIPAA) require strong internal controls to protect sensitive information such as financial, healthcare, and credit […]

Read More

R12 Changes from 11i

Overview of R12 Tech Stack Changes:- The mid tier technology had a boost up in R12, continual improvement with changing technology.  Here are the conversion of tech stack from 11i to R12. Application Server: 1.0    —->    10.1 Servlet Container: Jserv    —->    OC4J Apache: 1.3.19    —->    1.3.31 (or 2.0) Forms: 6    —->    10 What’s new in […]

Read More

Validating and rebuilding large and fragmented indexes in 11i

You can have various methods to identify the large or fragmented indexes in 11i or you can just configure the Oracle Alert to receive a mail. This alert is scheduled to check the situation periodically say daily at mid night. The alert ‘Indexes too large or fragmented‘ is pre-defined alert. There are three possible ways […]

Read More

Error while running SSO registration on 11i : txkrun.pl -script=SetSSOReg

While integrating Oracle E-Business Suite (Apps/11i) with Oracle Single Sign-On server (SSO) on one of test Instances, I received error like “Errors encountered running -txkSetSSOReg.pl“. Looking at error message carefully (check below), It was easy to figure out that value of Profile Option “Application framework Agent” was wrong. . Error Message on Screen applmgr@midtier>txkrun.pl -script=SetSSOReg […]

Read More
Not found