Monday, February 9, 2009

Oracle Apps ERP 11i (11.5.10.2) setup on Win2003

Single Node Oracle Applications 11i (11.5.10.2) Setup on 32bit Windows 2003 Enterprise Edition Server.
1. Ask your system administrator to prepare a Windows 2003 Server with Service pack 2. Create a domain user (applmgr) and add it to the administrator group of this server. From the SAN storage map and mount 300 to 400 GB space as ntfs on to this server.
c:\>diskpart
DISKPART> automount enable
Automatic mounting of new volumes enabled.

2. Install the following softwares in c:\ driver and see to it that the directory path should not have any space.

MKS 9.1 Toolkit --> c:\mks
VC++-->c:\vc
GNUMAKE-->c:\Gnumake
XMLSDK

Note that JDK and PERL should not exist in the server. This will be installed automatically while we do the setup of oracle applications 11i (11.5.10.2)

-->Copy link.exe from c:\vc\vc98\bin, copy cc.exe, which.exe, gnumake.exe to c:\windows\system32
-->Set path=%PATH%;C:\Gnumake\make-3.81;C:\Gnumake\make-3.81\WinRel
-->Add node name, ipaddress in c:\windows\system32\drivers\etc\hosts file

3. On Windows platforms, Rapid Install requires Microsoft XML Parser 3.0 Service Pack 4 (or later) in order to set up and start services. Before you begin your installation, follow these steps to determine if the correct version of the XML Parser is installed on your system, and take action as necessary.
--> Open the Windows Explorer
--> Navigate to the system root directory (default is C:\winnt\system32).
--> Right-click msxm13.dll. Select Properties. them click Version.
--> If XML Parser is not already installed, or if the version on your system is not 3.0 SP4 (or later) , go to the following URL and download the Microsoft XML Parser 3.0 SP4 Software Development Kit:

http://www.microsoft.com/downloads/ThankYou.aspx?familyId=b43
2cd45-b7ed-4c32-a443-ec56f10ee175&displayLang=en

--> After installing MSXML 3.0 SP4 SDK, copy msxm12.lib from \lib to \lib, where is the installed location of the MSXML 3.0 SP4 SDK, and is the installed location of Visual C++/C 6.0.

i.e from C:\Program Files\Microsoft XML Parser SDK\lib to C:\VC\VC98\Lib directory.

-->Restart server after all the above setups and before installing oracle applications 11i.

4. Now we will start rapidwiz to do the oracle applications setup. If you were doing the setup for multinode system then rapidwiz should be started from the database node. It makes DB setup first then if you want to select Apps setup seperately then from Apps Node start rapidwiz and select config.txt file to do the apps-tier setup.

Single node oracle applications setup has Oracle Database 9i (9.2.0.6) and oracle applications 11i (11.5.10.2) by default. Later you can also upgrade the database from 9i to 10g (10.2.0.4).

Start rapidwiz to do the setup,
c:\> cd Stage11i\startCD\Disk1\rapidwiz
c:\Stage11i\startCD\Disk1\rapidwiz> rapidwiz.cmd


NOTE: During the setup on Dell servers I faced the following error and resolved the problem through metalink note 433203.1 Oracle Applications 11i Install Fails on Windows when Number of Processors is Greater than 12

Problem:
There was an error while running the command -
I:\oracle\proderpdb\9.2.0\temp\proderp_oragridctl\adrun9i.cmd APPS APPS

The process tried to write to a nonexistent pipe.
The process tried to write to a nonexistent pipe.
The process tried to write to a nonexistent pipe.
The process tried to write to a nonexistent pipe.

RW-50004: Error code received when running external process. Check log file for details.
Running Database Install Driver for PRODERP instance Database Availability Check

Cause:
The issue is caused by the following unpublished bug :
Bug.5661195 RAPIDWIZ FAILS ON WINDOWS PLATFORM WHEN NUMBER OF CPU CORE EXCEEDS 12
This is a Release 12 bug which has been fixed in the file InstantiateFile.java for R12 . This fix will be later included in R12 TXK patch. But it is not yet fixed for 11i. The following bug is the backport logged for 11i version. This bug is also unpublished.
Bug.5694544 BACKPORT OF Bug 5661195

Solution
In the server it was showing 16 processors (4 x dual core x 2 logical processors=16 processors) so even after changing the value of the environment variable NUMBER_OF_PROCESSORS to 12 and after rebooting the value was again set back to 16. So the system administrator went to the BIOS of the server and disabled logical processors i.e disabled HYPER THREADING of processors, after this it showed only 8 processors(4 x dual core=8 processors). Then restarted the server and started the installation without any issues.

To overcome this problem encountered on Windows, please execute the following steps:
1. Right click on "My Computer" > "Advanced" tab > Click on button "Environment variables".
2. Edit the value of NUMBER_OF_PROCESSORS from the value which is greater than 12(e.g. in this case 16) to 12. Apply the changes.
3. Reboot the machine to ensure that the environment variable NUMBER_OF_PROCESSORS is set to the corrected value i.e.12.
4. Clean the current install. Refer the following metalink document :Note 143976.1 How to Clean Up a Failed Install of Oracle Applications 11.5.2 on an NT Platform
5. Check the value of NUMBER_OF_PROCESSORS on the command prompt before the rapidwiz is started
echo %NUMBER_OF_PROCESSORS%
6. Run rapidwiz and finish database(of the Oracle Applications) installation.
7. Once the Oracle Applications is installed, the value of environment variable NUMBER_OF_PROCESSORS could be reset to its original value.

Screen 1: Install Oracle Applications - Welcome

Screen 2: Select wizar operation

Select 'Install Oracle Applications E-business 11i' radio button.
Don't select 'Use Express Configuration'
Don't select 'Upgrade

Screen 3: Load Configuration
Select 'NO'.

Screen 4: Install Type
Select 'Single-node (All services on a single node)' radio button.
Don't select 'Multi-node (Services distributed on two or more nodes)'

Screen 5: Database Type
Select Database Type as 'Vision Demo Database' from list box and give database name as 'proderp'

Screen 6: Database Install Information
Base Install Directory = i:\oracle
Oracle Home= i:\oracle\proderpdb\9.2.0
Data Top (SYS)=i:\oracle\proderpdata
Data Top (LOG)=i:\oracle\proderpdata
Data Top (TXN)=i:\oracle\proderpdata
Data Top (Archive)=i:\oracle\proderpdata

Screen 7: Admin Server / Concurrent Mgr / Forms Server / Web Server
MKS directory=c:\mks
MSDEV directory=c:\vc
Base install directory=i:\oracle
APPL_TOP Mount point=i:\oracle\proderpappl
APPL_TOP aux. 1=i:\oracle\proderpappl
APPL_TOP aux.2=i:\oracle\proderpappl
APPL_TOP aux.3=i:\oracle\proderpappl
COMMON_TOP=i:\oracle\proderpcomn
8.0.6 ORACLE_HOME=i:\oracle\proderpora\8.0.6
iAS ORACLE_HOME=i:\oracle\proderpora\iAS
Temp Directory=i:\oracle\proderpcomn\temp

Screen 8: Global System Settings
Domain Name=oracle.com
Port Pool=2
Database Port=1523
RPC Port=1628
Reports Port=7002
Web Listener Port=8002
OProcMgr Port=8202
Servlet Port=8802
Forms Listener Port=9002
Metric Server Data Port=9102
Metric Server Req. Port=9202
JTF Fulfillment Server Port=9302
Map Viewer Servlet Port=9802
OEM Web Utility Port=10002
VisiBroker OrbServer Agent Port=10102
MSCA Server Port=10202
MSCA Dispatcher Port=10302
Java Object Cache Port=12347
OACORE Servlet Port Range=16020-16029
Discoverer Servlet Port Range=17020-17029
Forms Servlet Port Range=18020-18029
XMLSVCS Servlet Port Range=19020-19029

Screen 9: Save Instance Specific Configuration
Enter the full path of the configuration file=c:\config.txt
Here when you press next the following is performed.
-Port Availability
-O/S User and Group Check
-File System Check
-Host/Domain Check
-System Utilities Check
-Operating System Check
-Port Uniqueness
-File Space Check
-OS Patch Checks

If any of the above failed then first resolve it and then proceed with the following steps else the setup will not be completed successfully.

Screen 10: Component Installation Review
The setup portion of the installation is complete. Clicking Next will install the Oracle Application components.
Screen 11: Post Install Checks
This screen shows that this instance has passed all of the post install tests like Database Availability check, Environment File Check, DBC File check, HTTP Check, JSP Check and PHP Check.

Screen 10: Finish
Finish Screen completes the setup. Now to start the applications page run the following URL in the browzer,

http://servername.domainname:8002/OA_HTML/AppsLocalLogin.jsp


Login as SYSADMIN/SYSADMIN to connect to the applications as a super user.


Your Comments/Queries: email me at masamimalik@yahoo.com

No comments: