Tag: Oracle E-Business Suite

Alex Gorbachev Presenting at InSync09

InSync09 is the first conference in Australia focused on Oracle applications which in the past few years multiplied immensely in numbers — e-Business Suite, JD Edwards, JD Edwards, Hyperion, Siebel, BEA, PeopleSoft. There is also significant focus on SOA. The presentation that I’m doing is titled “Making Oracle E-Business Suite R12 Highly Available”. It’s more an architectural paper to show what are the paths and how to plan the environment for high availability and what technologies can be used. Obviously, I will touch some of the DBA friendly topics like RAC and DataGuard but it definitely won’t be focused on the database tier only. It’s actually going to be quite an experience as I’m not really an Apps DBA myself so learning curve has been quite steep. I do, however, have good advisers in this are so it should be fine.

Read More >

Oracle E-Business Suite Patch Taxonomy, Part 1

E-Business Suite patching is very broad topic. I’m going to cover just a fraction of this vast theme, one that I believe is often overlooked. I decided to split it into two logical parts; Part 1) Oracle E-Business Suite patch terminology, and Part 2) Querying patches, patchsets, family packs. This blog could also be called “Oracle EBS patch evolution theory.” Like any other theory, it can be challenged and proven wrong. I tried to make it unbiased based purely on my experience and to present it in the way that makes sense in context of general patching activities.

Read More >

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?

Read More >

UKOUG 2008 Highlights

Tonight I returned from my first UKOUG conference. I’ve been to smaller conferences like Microsoft Technet and big ones like European Oracle Open World before, but this was without a doubt best one so far (measured by the value of content and amount of fun). I couldn’t attend all the sessions that aroused my interest, there were simply too many of them. From those I attended, there are few I’d like to mention as highlights of the conference. Here they are…

Read More >

Installing Oracle R12 EBS in my Living Room

I built a Dual Core box with 8G of RAM for an install of E-Business Suite R12. For OS I chose Oracle EL5U2, mainly because I’m used to the RH/OEL clones, and also because I expected it to be less painful than other distributions. I started slowly, as time allowed, spending some time chasing various libraries and packages on the Net. Eventually it took me a week to realize how tedious it is to go the manual way. I got so frustrated by the dependencies that I gave up and purchased access to the ULN network.

Read More >

How to Tie OS-level PIDs to Oracle Database Sessions

About once a week, our team gets a request from the server admins to provide some information on why a database server is running slowly. This typically begins a painstaking process of finding the main processes on the OS side and tracing them back to database sessions. Attached to this post (see bottom for link) is a general diagram that the team came up with for relating our tables together, taking RAC into consideration.

Read More >

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 adcfgclone.pl fail to properly recognize the appltops for merging. But in R12, life is made easy. Let me show you.

Read More >

Join us! Pythian Europe Launch Event in Prague on Wednesday

I’m pleased to announce that there will be the formal launch of Pythian Europe at the premises of the Canadian Embassy in Prague on Wednesday the 6th of August from 17:00 to 18:30. This historic event will be announced by Mrs. Sameena Qureshi, Trade Counsellor, Embassy of Canada; and Paul Vallee, President and Founder, The Pythian Group. Present will be various members from the press (IT and Business), as well as representatives from Oracle and Sun Microsystems, the Canadian Chamber of Commerce in Prague, and many more. We will prepare some unusual and very tasty snacks and refreshments.

Read More >

DNS Setup for Effective 11i DR Failover

One of the main goals in architecting a Disaster Recovery (DR) solution is to make a DR failover transparent to the end users. Too often, users must reboot their desktops, clear their browser cache and the jinitiator jar cache, and so on, even when we have made sure that the post-failover URL of the 11i instance is the same. After a failover of an 11i instance from a primary site to a DR site, if the user can operate without changing anything in his desktop, only then can we say that the goal is achieved.

Read More >

Oracle R12 Certified for Linux 64-bit on the x86_64 Platform

If you are a early adopter of R12 with a version earlier than 12.0.3, its time to patch up to 12.0.3 or 12.0.4. and migrate to the Linux 64-bit platform. This migration to Linux 64-bit should not be a big hassle, as it is binary-compatible with Linux 32-bit. I expect it be as simple as 1) copy, 2) relink, and 3) startup. I will, however, find out the exact method, and post here in the blog.

Read More >
Page 3 of 41234