All posts by Atul Kumar

1Z0-233 Dump or Interview Questions for Oracle Apps DBA

Here are few more Interview questions for Oracle Application DBA’s and same can be used as 1Z0-233 Install Patch and Maintain Applications dump for certification. These question are submitted by our reader Jaya Kumar, Working as a “Oracle Apps DBA” in Chennai for “Savant Technologies” (www.savantit.com) . If you wish to share question, script or […]

Read More

Install Oracle Applications R12 (12i) on Unix/Linux

On request from lot of my readers I am covering Oracle Apps R12 (some guys call it 12i) installation once again. You can check Oracle Apps R12 Installation Guide at  Oracle Applications R12 Installation Guide I am going to cover only important points from this guide which should be enough for you to help in […]

Read More

SSL in Oracle Apps 11i / R12

In order to Understand SSL in Oracle Applications 11i & R12 lets first understand  Components in Apps which can listen for SSL Requests ——————————————— 1. Load balancer (if you have one between clients and oracle apps) 2. Web Server (11i web server built on Oracle Apache) 3. Form Server(If forms are configured for Forms Listener default […]

Read More

Session Timeout for Oracle Single Sign-On Server

Idle Session Timeout is value (in minutes for Oracle Single Sign-On Server) after which user has to re-login, if they are inacte (No Activity / Idle) during that time. It is recommended to set Idle Session time out (Global Inactivity timeout) for security reasons. By default there is No Value set for Idle Session Timeout for […]

Read More

Oracle Apps DBA Interview Questions – Install

Here is list of first 10 questions for Oracle Applications DBA Interview . These questions are also useful if you are preparing for Oracle Apps DBA Certification 1Z0-233 11i Install Patch and Maintain Applications Q. Explain Single Node or Multi Node installation Single Node – All components of Apps 11i i.e. Database, CM, Forms, Web Server on […]

Read More

Oracle Internet Directory – Basics II

Few years ago, When I started learning Oracle Internet Directory I jumped directly on administration of OID (including start/stop and debugging) without understanding basics of OID. My suggestion is to go through basics first which I am going to cover in this post. For my first post on OID visit OID from Apps DBA’s eye […]

Read More

25 Things Apps DBA should know for Apps 11i/R12 Integration with OID/SSO

Check below 25 points which Apps DBA should know for Apps(11i/R12) integration with SSO/OID (Single Sign-On/Oracle Internet Directory) 1. If you change APPS password using FNDCPASS utility, update provisioning profile with new password using OIDPROVTOOL. (More on OID Scripts & Tools coming soon). This is required as APPS password is stored in provisioning profile in […]

Read More

Preserving Customizations in Oracle Apps 11i or R12

Most of the time when Apps DBA’s handover instance to developers, functional consultants after cloning/patching; users complain that their customizations are missing. I meet lot of Apps DBA’s spending time putting back customizations after running Autoconfig or cloning. As some of my readers requested on how to avoid customizations being overwritten by Autoconfig or cloning […]

Read More

Questions for Oracle Apps 11i & R12 Integration with 10g AS/SSO

Here are few questions which you should think/ask/discuss for Oracle Applications 11i & R12 Integration with 10g Application Server (Portal, Discoverer, SSO, OID) Do you need 10g Portal component of 10g AS with Oracle Applications 11i & R12 ? (*Integration of 10g AS can be without portal and dicoverer as well i.e. OID & SSO […]

Read More

Oracle Apps DBA Training Institues in India

Looking at mails in my inbox from DBA’s and freshers looking for Oracle Apps DBA training Institutes/courses, I decided to dedicate this post for Training Institutes providing Oracle Apps DBA Training. Few things you should check before joining Training –Formal Training is always good to quickly get an overview of product but not enough; to […]

Read More