A Blog for Oracle

Installing R12 on XP

noreply@blogger.com (Karthi) — Sun, 26 Jul 2009 04:18:00 +0000

Dear All,

I have installed Oracle E-Business Suite Release 12 on Windows XP Professional successfully. Installation steps is quite similar to the installation steps on Windows 2003 [1]. The only difference I did is installing production environment instead of vision demo database.

I have done a single node installation as follows:

Hardware & Software Specifications:

- Intel Pentium 4, CPU 3.2 GHz
- 2 GB of RAM
- 180 GB Hard Drive
- Windows XP Professional with Sevice Pack 2

Installation Steps:

1) Install Windows XP Professional with SP2

2) Set 'Computer Name' as well as 'Domain Name'.

- Right click on 'My Computer' > Properties > 'Computer Name' > Change
- Set 'Computer Name' to
- Click on More
- Set a 'Primary DNS Suffix of this Computer' to

3) Install Microsoft Loopback adapter and define an IP address (10.10.10.10)

For more information on how to do this, please refer to "How to install the Microsoft Loopback adapter in Windows XP":

http://support.microsoft.com/kb/839013

4) Add a new entry in C:\windows\system32\drivers\etc\hosts as follows:

10.10.10.10 hostname.domainname.com

5) From the command prompt, make sure you can do the following:

C:\> ping 10.10.10.10
C:\> ping hostname
C:\> ping hostname.domainname.com

6) Create a new user 'hsawwan' and make this user a member of:
- Administrators (local user)

7) Install Visual C++ 8.0 (Which is included in Microsoft Visual Studio 2005) in 'C:\VCPlus' -- Make sure not to install VC++ in a directory that contains spaces.

8) Download 'Cygwin' and install the required packages:

- Create a Cygwin directory (C:\cygwin) -- Make sure not to install 'Cygwin' in a directory that contains spaces.
- Download the Cygwin Software (http://www.cygwin.com)
- Run 'Setup.exe' and choose 'Download without Installing'
- Select the following packages:

Archive - Default, plus manually select the zip package
Base - Default, plus manually select: ash, coreutils, diffutils, findutils, gawk, grep, sed, tar and which
Devel - Default, plus manually select binutils, gcc, gcc-core, gcc-g++, make and mktemp
Doc - Default, plus manually select cygwin-doc and man
Editors - Default, plus manually select vim
Interpreters - Default, plus manually select gawk
Shells - Default, plus manually select ash and tcsh
Utils - Default, plus manually select cygutils and file

- Once the download is complete, run 'Setup.exe' again and choose 'Install from Local Directory'
- Specify the directory where you want to install Cygwin (C:\cygwin) and DOS as the Default Text File Type

9) GNUMake is not required when using 'Cygwin' since it comes as a part of the 'Cygwin'.

C:\cygwin\bin>copy gawk.exe awk.exe
C:\cygwin\bin>copy grep.exe egrep.exe
C:\cygwin\bin>copy make.exe gnumake.exe
C:\cygwin\bin>copy gcc.exe cc.exe

10) Add 'C:\cygwin\bin' to the system path.

11) No JDK installation is required, JDK 5.0 (java version "1.5.0_08") is bundled with Oracle Applications R12 installation.

12) Set Up the Stage Area:

Stage Area (C:\Stage12) requires a 26 GB hard disk space.

Extract the zip files (25 files) which have been downloaded from (http://edelivery.oracle.com). Nothing special to do since the extracted files will create the stage area directory structure by itself. You should see the following structure under 'C:\Stage12' once you are done with the files extraction:

- startCD > Disk1
- oraAppDB > (Disk 1 to Disk 35)
- oraApps > (Disk 1 to Disk 7)
- oraAS > (Disk 1 to Disk 2)
- oraDB > (Disk 1 to Disk 3)

13) Start the installation:

C:\> cd Stage12\startCD\Disk1\rapidwiz
C:\Stage12\startCD\Disk1\rapidwiz> RapidWiz.cmd

The installation wizard is similar to 11.5.10 RapidWiz. For 'VC++' and 'Cygwin' I have provided the following paths:

s_MSDEVdir=C:\VCPlus\VC
s_MKSdir=C:\cygwin\bin

- It took almost 2 hours to install the production environment (3 hours when installing the Vision instance)
- Total space required to install the production environment is 60 GB (153 GB is required to install the Vision instance)

References:

[1] Oracle E-Business Suite R12 Installation on Windows 2003 (http://forums.oracle.com/forums/thread.jspa?threadID=484238)
[2] Note: 405293.1 (Oracle Applications Release Notes Release 12)
[3] Note: 402311.1 (Oracle Applications Installation and Upgrade Notes Release 12 (12.0) for Microsoft Windows)
[4] Note: 414992.1 (Using Cygwin to Maintain Oracle E-Business Suite Release 12 on Windows)
[5] Oracle® Applications Installation Guide: Using Rapid Install Release 12 (Part No. B31295-02)

Responsibility Not Visible to user in the list of responsibilites assigned t...

noreply@blogger.com (Karthi) — Sun, 26 Jul 2009 04:15:00 +0000

Recently came to know that though the system adminstrator is given the responsibility access to users, users are not able to view the responsibilities in the list of responsibilities assigned.

1. Check if the responsibility is not end dated.
2. Run the request " Syn responsibility role data into the WF table".
3. Run the request " Synchronize WF LOCAL tables" enter the paramters
- Orig System: ALL
- Parallel Process:0
- Logging Mode: LOGGING (Logging Activated)
- Temporary Tablespace : Blank
- Riase Errors: Yes
4. Run the request "Workflow Directory Services User/Role Validation" enter the paramters
- p_BatchSize:10000
- Fix dangling user/roles : Yes
- Add missing user/role assignments : Yes
- Update WHO columns in WF tables: Yes
5. Log off and login back and verify that the responsibility appears.

That should resolve the issue.

If the problem is not resolved still ask the sysadmin to start the following servives
Navigation: System Administrator > Workflow > Oracle application manager > Workflow Manager
- Workflow Deffered Notification Agent Listner
- Workflow Error Agent Listner
- Workflow Java Deffered Agent Listner
- Workflow Java Error Agent Listner.

In case still there is a issue please raise a Service request with Oracle.

11i Installation on XP

noreply@blogger.com (Karthi) — Thu, 19 Feb 2009 03:59:00 +0000

Hi viewers,

the following is the procedure for implementing oracle 11i in an personal computer:

Software Requirements:

1. VC++ - freeware (can be downloaded from microsoft website) http://www.microsoft.com/express/download/#webInstall

2. Pearl - not a freeware. findout from ur collogues whether any free edition is available. paid edition can be downloaded from www.activestate.com

3. cygwin - freeware can be downloaded from cygwin website.

Hardware requirements:

1. RAM - mininum 1GB ram for effective usage

2. Hard disk - Minimum 120GB harddisk, 150GB is recommended.

in 120GB harddisk u can only install windows, software requirements and oracle 11i. other than that u cannot install install even MS Office. so better allocate 150GB for installation.

Installation procedure overview:

1. Install all the software requirements, that is, VC++, Active pearl, cygwin.

2. Staging the oracle applications.

3. Domain name configuration.

3. Starting the rapidwiz.

Discriptive installation procedure:

1. Instllation of Software requirements:

a. VC++ is a software which will be available only with the Visual Basic software which can be downloaded from the microsoft download center.

b. Active pearl can be downloaded from the website www.activestate.com.

c. cygwin can be downloaded from the website www.cygwin.com.

there is no specific procedure for installing these softwares except cygwin. The necessory packages u need to select to download while installing is:

a. All Default
b. Archive Default, plus manually select the zip package
c. Base Default, plus manually select the following extra packages: ash, coreutils,
diffutils, findutils, gawk, grep, sed, tar and which
d. Devel Default, plus manually select binutils, gcc, gcc-core, gcc-g++, make and
mktemp
e. Doc Default, plus manually select cygwin-doc and man
f. Editors Default, plus manually select vim
g. Interpreters Default, plus manually select gawk
h. Shells Default, plus manually select ash and tcsh
i. Utils Default, plus manually select cygutils and file

it is important to remember the location of the installed softwares.