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 MoreEmbedding 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 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 MoreOverview 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 MoreYou 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 MoreMobile Supply Chain Applications allows you to perform common warehouse and shop floor transactions from any location in the manufacturing facility through the use of handheld devices. These include PDAs, handheld Radio Frequency (RF) units etc. This Application enables real-time interfaces to Oracle Applications through user interfaces. You can access the system from anywhere RF […]
Read MoreThis post is for our Online Apps DBA trainees trying to install Oracle Application on Virtual Linux machine. If you install Linux O.S. as (Guest Operating System) on top of your existing windows machine using VMware virtual Server check here, Next step is to copy R12/11i/oracle software from windows machine to VMware Linux O.S. Steps […]
Read MorePlatform Migration of Oracle Applications Migrate Platforms with Oracle Applications 11i to Linux platform While migrating to a new platform, we must make sure that the new platform is certified/supported by Oracle for both the database and the Apps tiers, if migrating both. If migrating just one of the tier to the new platform, then […]
Read MoreI am delighted to inform you all that my book “Oracle Applications DBA covering 11i and R12” publisher Mc Graw Hills now got released worldwide and now is available at amazon. The book “Oracle Applications DBA” covers all the pertinent aspects of administrating Oracle Applications—from installation to day-to-day maintenance. It covers upgrading, cloning, patching, maintenance and […]
Read MoreWe are pleased to announce our next online Oracle Apps DBA training batch starting on 11th October 2008. This course is available via web conference (weekends) with hands on exercise on installation/patching/cloning. Course content for Training: Day 1 & Day 2 -Oracle Applications Architecture -Oracle Application File systems-Operating System Configuration-Oracle Application Installation-Oracle Application Installation Troubleshooting-Log […]
Read More