Category Archives for r12
Test your Apps DBA skills – Interview Questions for Oracle Apps DBAs
Q. How would you know that your applications setup is a using shared APPL_TOP configuration ? – If you apply a patch, it should be visible on all nodes (APPL_TOP) which are part of shared APPL_TOP configuration. – Since APPL_TOP is on a shared disk, create file in APPL_TOP from one node, it should be […]
Read MoreSQL to monitor (check status) of Workflow Notification Mailer (Java)
SQL> SELECT COMPONENT_STATUS from APPS.FND_SVC_COMPONENTS where COMPONENT_ID=10006;
Read MorePatch Application Assistant (admsi.pl) in Oracle Apps R12
PAA (Patch Application Assistant) is tool/Perl script to generate customized installation instructions for a patch in Oracle Applications R12 which helps user to track and perform manual steps during patching. 1. admsi.pl is under $AD_TOP/bin 2. You can run admsi.pl (Patch Application Assistant) in two mode i) GUI (Graphical User Interface) ii) CLI (Command Line […]
Read MoreOracle 12.0.6 R12 RUP6 is Out now
Oracle released 12.0.6 on Nov 7, 2008. Here is quick snapshot of 12.0.6 for DBA’s & System Administrators. . 1. Patch Number for 12.0.6 is 6728000 2. Prereq. patch for 12.0.6 (6728000) is R12.AD.A.delta.6 (7305220) & optional online help patch (7109200) 3. As with other ad patches, You CAN’T merge 12.0.6 (6728000) with R12.AD.A.delta.6 (7305220) […]
Read MoreOnce 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 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 MoreOracle Apps Release 12.1 , Guess official release date ?
Any guess for Oracle Apps Release 12.1 date ? Release date for 12.1 version is not official yet but if you are looking for new features in Oracle Applications Release 12.1 for Apps DBA’s here is my list . Technical Components in 12.1 Database Version with Oracle Apps 12.1 is going to be 10.2.0.4 Forms […]
Read MoreMy Book “Oracle Applications DBA” released worldwide
I 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 MoreInstall Oracle Apps R12 (12.0.4) on Windows >> Install VC++ & R12
This is third and last post w.r.t. R12/12i (12.0.4) on Windows. For previous post to download R12, cygwin, VC++ Click Here . To create User and cygwin installation click here This post covers VC++ & R12/12i installation . VC++ Installation Download VC++ redistributable package from here or full version ( I used 90 days […]
Read MoreInstall R12 (12.0.4) on Windows : Create User >> Install Cygwin
This is next post w.r.t. installing Apps R12 on windowsand covers prereq. step (Create O.S. User, Download & Install cygwin and set environment variable). For previous post with link to download software Click Here Installation of VC++ and Oracle E-Business Suite R12/12i (12.0.4) will follow shortly in third and concluding part. A. Create Operating System […]
Read More