Business suite

Installing Oracle E-Business Suite R12 on Windows 2003

This article and those to follow are written from
point of view of someone fairly new to Oracle’s E-Business suite, described in another
item like EBS, Oracle Applications and Oracle Apps. You may be an oracle
DBA responsible for setting up a test or evaluation environment, or you can
already work with EBS, but have inherited the configuration architecture and need to
study what it takes to upgrade.

There are several blogs on the Internet where
information about installing EBS is listed, but it is mostly sketchy. The
blogs tend to ignore the essential parts outright, let’s assume you already know what has
to be done through previous experience installing or maintaining EBS, or they
are written in broken English/chat room conversation. My guarantee in this series of articles
is that you can start from scratch and come away with a high and
running an EBS instance using the Vision Enterprises database. Vision
The Enterprise (or VIS) database that can be created during an EBS installation is
The EBS equivalent of the sample schematics found in the RDBMS product line (HR, OE,
SH, etc).

Coming from a traditional Oracle DBA training, the
the installation process is similar to what you have seen before, and is not similar
what you have seen before. Allow me a cinematic analogy to describe the
difference. The film “Witness”, with Harrison Ford, in the scene where
his character turns off the lights of a city bully, and a local man says:
“I haven’t seen anything like it in all my years”, followed by Eli (the father)
saying, “He’s from…Ohio…my cousin.” The local man then said, “Well, they
Ohio Amish must be different. This precisely describes the relationship
between the traditional Oracle DBA world and what you’re about to see in EBS.

The host platform/operating system, and which one is
relatively easy to reproduce for most people, is based on Windows 2003 32-bit
Server (R2). If you want to create a test server at home, you can get a
Inexpensive PC with hundreds of GB of disk space and several GB of RAM
many places online or from your local computer store. I bought a Lenovo
ThinkCentre A61 (AMD64 dual core) and beefed it up with another 500GB internal
hard drive and 4 GB of RAM. Windows 2003 in this configuration does not
recognize the first 4GB of RAM, so don’t go overboard with this purchase. Be certain
to backup OEM software before installing 2003 (which you can download for
Microsoft evaluation).

Two ways to get software for EBS are to order media
pack from Oracle (about $60) or download from Oracle Technology Network. The
interface in the EBS area of ​​OTN (Online delivery)
is very different from anything at OTN (your first introduction to the
Ohio Amish).

Choose a language and click Continue. Complete the export
validation page and you will then be ready to select the software suite for
To download.

Select the E-Business Suite product pack for 32-bit Windows
and part number B37233-03 for version 12.0.4.

There are (at the time of writing) 48 separate downloads for
perform. First the good news: you don’t need all 48. Second, some more good news: if
using Firefox, get the Down with them all
add-in to manage downloads. You will select the items to download, then
let the add-in do its job.

Here is what you will NOT need:

Oracle Database Lite 10g version 2
(10.2.0.1.1) for Microsoft Windows (32-bit) CD

B30674-01

456M

Oracle Governance, Risk, and Compliance
Manager 7.8

V13399-01

78M

Stellent UCM Content Server 7.5.2 for Linux

B42463-01

705M

Stellent UCM Content Server 7.5.2 for UNIX
based systems

B42464-01

1.4G

Stellent UCM Content Server 7.5.2 for
Microsoft Windows (32 bit)

B42465-01

812M

Oracle Governance, Risk, and Compliance
Controls Suite – Disc 1

V12253-01

962M

Oracle Governance, Risk, and Compliance
Controls Suite for Microsoft Windows – Disc 2 (Part 1 of 2)

V12227-01
Part 1 of 2

1.8G

Oracle Governance, Risk, and Compliance
Controls Suite for Microsoft Windows – Disc 2 (Part 2 of 2)

V12227-01
Part 2 of 2

1.2G

Oracle Transaction Management

V12266-01

5.3M

Oracle Business Intelligence Suite Enterprise Edition 10.1.3.2.0
Linux Programs (DVD) (Part 1 of 4)

B42085-01
Part 1 of 4

660M

Oracle Business Intelligence Suite Enterprise Edition 10.1.3.2.0
Linux Programs (DVD) (Part 2 of 4)

B42085-01
Part 2 of 4

372M

Oracle Business Intelligence Suite Enterprise Edition 10.1.3.2.0
Linux Programs (DVD) (Part 3 of 4)

B42085-01
Part 3 of 4

620M

Oracle Business Intelligence Suite Enterprise Edition 10.1.3.2.0
Linux Programs (DVD) (Part 4 of 4)

B42085-01
Part 4 of 4

330M

The easiest thing to do is to download everything and extract
each download individually in its own folder. Once done, you must
create a stage or installation hierarchy. A representative structure is shown
below.

Under E:StageR12 (for example), create five folders named
As shown above. Once the downloads have been extracted, note that most of the
checkout folders will show oraDB (for example) when the cursor hovers over the
folder (like view properties). The startCD folder will have a “disk”
directory placed there. Navigate to where the “start here” download was
extract and drag the Disk1 folder just below the startCD folder. In a
similarly there will be folders named Disk1 to Disk9 under oraApps,
Disk1 to Disk4 under oraDB, Disk1 and Disk2 under oraAS (use oraAS, not oraiAS
as shown in some places), and finally, Disk1 through Disk35 under oraAppDB.
When you’re done, the folders and product IDs should be organized as shown below.
Folders B or V-whatever will be mostly empty, as their respective disknot
the content has been moved up a few levels. I left the files in place in the
table below so you can see where each should be extracted to or in with
relative to the five top-level folders. Also you don’t need the component.label
or dvd.label files.

Boot CD

oraApps

oraDB

oraAS

oraAppDB

The installation guide mentions the use of a Perl script
(adautostg.pl) to create the staging area. It will not work on this installation
option because we are not using a CD/DVD location, so the entry to specify
drive location (during script execution) fails. You have to
manually place the files/folders as instructed.

Two to three additional pre-installation steps require
facility Cygwin (UNIX Toolkit), a runtime environment
version of VisualStudio
(mainly for Visual C/C++) and Perl. Cygwin installation/configuration steps are
described in MetaLink note 414992.1, “Using Cygwin to maintain Oracle E-Business Suite version 12
on Windows.

add :cygwinbin to path environment
variable and perform the following copy operations:


Copy gawk.exe to awk.exe
Copy grep.exe to egrep.exe
Copy make.exe to gnumake.exe
Copy gcc.exe to cc.exe

The Microsoft component can be downloaded from here. Concretely, you want
the Visual C++ Express edition. During installation, the folder tree should look like
like that:

Add C:V98VCbin to the path environment variable.

To get Perl, go here
then click Get ActivePerl in the upper right corner. Getting Perl is not
essential at this point, but you’ll need it later. You can test Perl
installation as described in the installation guide (use the options to list
the version). If you get errors about incompatible libraries, see if you
have PERL5LIB set (from other Oracle product installations such as the 10g
companion). If defined, remove this variable.

In the next part of this series, we will begin the
installation process and review the installation architecture.

»


See all articles by columnist
Steve Callan