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 MoreMobile 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 MoreHow 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 MoreEmbedding 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 MoreOracle 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 MoreR12 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 MoreValidating 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 MoreError 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 MoreOracle Application Management Pack for Oracle E-Business Suite, Release 2.0
Oracle E-Business Suite Application Technology Group (ATG) is pleased to announce the availability of the Application Management Pack for Oracle E-Business Suite (EBS) version 2.0.2 Rollup update. Oracle strongly recommends that you apply the latest release, 2.0.2. Oracle application Management Pack 2.0.2 Application Management Pack 2.0.2 (Patch 6809246 ) is an OPatch rollup update […]
Read MoreUpgrade overview for Oracle Database to 11g Release 1 (11.1)
Steps mentioned in this post is overview of Oracle database upgrade from 8i, 9i or 10g to 11g Rel 1 i.e. 11.1.X.X.X (Step by step Oracle 10g upgrade to 11g including pointer to documentation coming soon…) Things good to know for 11g Database Upgrade 1. Oracle 11g Database software must be installed in new ORACLE_HOME 2. If you […]
Read More