Tag: Oracle E-Business Suite

EBS DBA: Integrating EBS with Oracle 11G Cluster Infrastructure

This is a short one. Yesterday I was asked to marry an EBS autoconfig feature to an Oracle 11G Cluster infrastructure. In particular the client’s intention was to use srvctl to manage Instances and at the same time keeping DB side Network related configuration managed by autoconfig. There are several possible solutions. However, I used the following…

Read More >

DBD::Oracle 1.28 Release Candidate 1

Here is the latest and greatest DBD::Oracle for your programming pleasure. This is a long overdue maintenance release that fixes a large number of bug and issues which are detailed below in the Changes. Don’t worry there are some new goodies in this release namely I have added in 4 new
server side tracing/debugging attributes

Read More >

EBS DBA: WF Mailer Override Address and Cloning: How to

I just recently faced an issue on how to automate the Workflow Mailer override address for development and testing environments during the EBS cloning process. The problem is that the only official way to set the override address in the latest ATG releases is to go through the OAM portal and change the override email via the GUI interface. I came to this solution.

Read More >

EBS DBA: R12.1.2 Another Step for Automated Vanilla EBS Cloning

If you have tried to automate EBS cloning then you definitely know that you can’t get through without hacking and customizing the Oracle-provided Rapid Clone utility. One of the areas we should “hack” the code to make it running in batch scripts is the services startup bit. The problem is that by default straight after Rapid Clone is completed Oracle starts all the services on the Apps node and until now there wasn’t a way to change it.

Read More >

EBS DBAs Be Warned! NOLOGGING Can Hit You Badly …

I’ve just come across an old known issue again today. Was working in the greatest and latest 12.1.2 Oracle e-Business Suite environment. Surprisingly, I face the old issue when WF_LOCAL_ROLES and WF_LOCAL_USER_ROLES objects (among other objects) are set to NOLOGGING mode. The easiest solution is to switch the whole database to FORCE_LOGGING mode:

Read More >

Oracle: What is an Unrecoverable Data File?

Unrecoverable data files are those that involve nologging operations since the last successful backup took place. There are several ways to identify them. I’ll take you through them.

Read More >

Setting up Virtual Hosts for Database and Applications Tiers in 11i

In this post I would like to share with you the virtual hosts set-up (two nodes each on the application tier, and two on the DB tier) for a customer using 11.5.9.

Read More >

Oracle E-Business Suite: Querying Patches, Part 2

In the first part of this blog I tried to shed some light on EBS patch terminology and naming conventions. In this post, I’ll show you how to check your patchset levels and query applied patches.

Read More >

Alex Gorbachev — Interview on High Availability @ InSync09

Following my presentation at InSycn09 about Oracle E-Business Suite high availability, I gave an interview to a fellow Oracle tweeter here in Sydney and member of the team behind The Red Room blog — Gareth Llewellyn. I should say that my dedication to the interview was very strong and you will believe me if I tell you that during that time the party in the InSync09 exhibition hall was already in the full swing. Thanks to Gareth, the interview is now on Youtube and if you go there directly, you can watch in HD.

Read More >

Reporting from InSync09 in Sydney

It’s the second day of the InSync09 conference in Sydney — the first large-scale conference in Australia that combined user of all Oracle applications such as E-Business Suite, Hyperion, Siebel and all others that Oracle has bought in the last years. There is quite a bit of sessions on SOA and Fusion technology.

Read More >
Page 2 of 41234