Posts by Vasu Balla

Improve Gather Stats in Oracle E-Business Suite

One important aspect of a healthy Oracle database is database statistics. It’s the main data on which CBO feeds to generate good execution plans for SQLs. Implementing a periodic and consistent gather statistics procedure in Oracle E-Business Suite is every Applications DBA’s duty. But often I see that they are not set up properly to…

Exchange Server 2010 with Oracle Workflow Mailer

Almost all Oracle E-Business Suite DBAs will run into this problem if they are using exchange server as their Workflow IMAP server. Workflow is a important component of Oracle E-Business Suite, and its mailer component adds a biggest oracle EBS feature of inbound mail processing of workflow approval and rejection email replies from end users….

Amazon Elastic Load Balancer with Oracle E-Business Suite

This blog post outlines a couple of issues we faced in our Oracle E-Business consulting group when configuring Amazon Elastic Load Balancer with Oracle E-Business Suite 11i. The current IT industry trend is to virtualize all servers, and Oracle E-Business Suite servers are no exception. Among current cloud operators, Amazon Cloud infrastructure is a favorite…

How to Fix the Oracle EBS 12.1.3 JDBC Connection Lock Issue

As with any product, there is always an increased risk of bugs when a new feature is introduced. Oracle E-Business Suite is no different. In release Release 12, Oracle introduced a usability feature called Configurable Homepage. This is a new homepage layout that is drastically different from 11i. This feature brings in a new gamut…

Oracle E-Business Suite News from OpenWorld 2012

I always followed all Oracle OpenWorld happenings through blogs, but this is the first OpenWorld that I physically attended. The blog post from Michael Abbey on tips for OOW first timers was a godsend for me. This helped me to navigate OOW like a pro. This is what I checked out..

Oracle Ebusiness Suite 12.2 Online Patching Feature

Oracle hosted a webcast of Sysadmin-oriented Preview of EBS 12.2. It was an enlighting webcast, which gave a very good idea about things coming up in Release 12.2. Today I want to discuss about a prominent feature of the upcoming Oracle E-Business suite Release 12.2, Online patching feature. The screengrab in thiis post of a slide from presentation gives a nice overview of the feature.

Jserv JVM Issues with Many SSWA Users

If your configuration matches the following setup, then this blog could be helpful to you. Set up: OS: Redhat Enterprise Linux 3 or 4, JDK: Sun Java 1.3 or 1.4, Apps: 11.5.9 or 11.5.10, Users: many Oracle Self Service Web Applications Users e.g., iProc, iRec, Timecard, and HR self-service With this setup, you might have already faced issues like the Apps login page not responding, or browsers timing out in loading SSWA pages. You might have raised numerous long-running TARs with Oracle support on this and ended up uploading lot of Apache and Jserv debug logs, and you always end up recycling or bouncing the Apache service to fix the issue. Don’t worry—you are not alone here.

JSP Cache Issues in 11i and R12

As an Apps DBA, you might have been asked to clear the JSP cache many times, either by Developers or Oracle Support. The usual directory that holds the JSP cache is $COMMON_TOP/_pages in 11i and R12 releases. In older versions of 11i it used to be $OA_HTML/_pages. What is this JSP Cache? It’s the compiled version of JSP files. When JSP gets compiled by Apache Jserv, it gets internally gets converted into a .java file (servlet) and then that .java file gets compiled into a .class file Why do we need to clear the JSP cache?

SunFire T2000 servers are best suited for Oracle MiddleTier

Recently, an Oracle-L discussion on Sun T2000 servers got me thinking. The T2000 servers have Sun’s new line of processors, UltraSPARC-T1. These processors come with 8 physical cores, and each core has 4 threads (similar to hyperthreading in Intel Xeon Processors). So each UltraSPARC-T1 processor shows up as 32 Processors (8 cores * 4 threads) at the operating system (OS) level. Sun termed this technology “Cool Threads”. It is supposed to give high-volume throughput along with saving millions on power and cooling costs. But many discussion forums have more complaints against these T2000 servers than praises.

Multi-Node to Single-Node Cloning in R12 and 11i

Anybody who has tried this multi-node to single-node cloning in 11i knows that it’s difficult and very error-prone. If we outline the Apps Tier cloning process, it looks like this (supposing we have a two-node instance with the DB and CM on one node, and Web and Forms on the other): This process is called merging appltops. It’s not as easy as it looks. Many times, the production environment might not have proper values in the fnd_nodes table, which makes fail to properly recognize the appltops for merging. But in R12, life is made easy. Let me show you.

Page 2 of 3123