All posts by Atul Kumar
Hot Backup Scripts for database backup and apps backup
Yesterday I discussed about backup Overview & cold backup if you have not gone though it you can read it from http://becomeappsdba.blogspot.com/2006/09/backup-recovery-in-oracle-apps.html Yesterday I mentioned that I am going to post about hot backup scripts , here it comes Enable Archive Log First check if your database is in Archive mode SQL> archive log list […]
Read MoreBackup & Recovery in Oracle Apps Database
Based on lots of request from readers of this blog I am posting on Backup & Recovery of Oracle Apps 11i database & application tier. I’ll discuss on How to troubleshoot load balancer in oracle Apps after Backup & Recover. You might have read in Oracle Documentation lot of time to backup your system before […]
Read MoreHardware Load balancing at HTTP Layer in Apps Contd..
If you are accessing this page directly without reading previous post about load balancer & broad level steps of configuring load balancer in Apps then first check previous posts mentioned at bottom After configuring Load Balancer in Oracle Applications 11i you as Apps DBA need to apply three prereq. patches Patch 3175852 – This patch […]
Read MoreConfigure Hardware Load Balancer at HTTP Server Layer
Yesterday I discussed about Overview of Load balancer and various types of load balancer as you can configure load balancer at various levels like – DNS Layer Load balancing – HTTP Server level Hardware Load balancing(Discussed today) – Jserv level load balancing (I’ll discuss after HTTP level load balancing) Today in this post I am […]
Read MoreConfigure Load Balancer in Oracle Apps 11i , E-Business Suite
What is Load Balancer in Oracle Applications 11i ? As name suggest its used to balance load on oracle applications, so lets say you initially sized (How to size server configuration in your apps 11i Instance during Implementation coming soon..) your server for 100 concurrent users & now additional 90 users started using your system […]
Read MoreOracle Critical Patch Updates and security Alerts
You might have noticed recently that Oracle has started new patching CPU (Critical Patch Update) and Oracle is Quite serious about it . These patches are not only for Oracle Applications 11i but they are for entire Oracle Products (11i, database, 10g application server, collaboration suite, Peoplesoft, JDEdward..) . Today and in my subsequent posts […]
Read MoreInstalling 10g Application Server
If you remember I discussed on 29th August that I am planning to post How to integrate E-Business Suite with 10g Application Server ? In order to do same you need to first Install 10g Application Server on same or separate machine as you can’t upgrade E-Business Suite Application Server i.e. iAS 1.0.2.2.2 . If […]
Read MoreChange Idle Session timeout ICX Session Timeout session.timeout
First of all I want to thank my reader (Budding Apps DBA) from Vennela Technologies, Hyderabad India for posting question to me that If someone ask Apps DBA to change Session Idle Time out value How & where will you change ? In order to answer first you have to understand what kind of seesions […]
Read MoreOracle Apps DBA 11i Interview Questions
Lot of you have requested for Oracle Applications 11i questions frequently asked during Apps DBA Interview. I have listed apps technical questions on my site under http://teachmeoracle.com/interview.html There are around 13 pages currently with more than 50+ questions. You can view questions by clicking on Next Page and Previous Page at bottom of page. There […]
Read More10g Application Server Basics
Currently with 11.5.8-9-10 or may be previous versions you might be using 9i Application Server Version 1.0.2.2.2 . As you are aware 10g Application Server 10.1.x.x as well is now certified with Oracle Applications 11i , I think its quite important for you to learn 10g Application Server basics as well. P.S. For Oracle Applications […]
Read More