Oracle R12.1.1 installation

Installation of Oracle Applications – R12.1.1 for Windows

Step – 1 Prerequisite

Operating System

• Windows 2003 Server

Software

• Oracle Apps R12.1.1 installation CD or files downloaded from Oracle edelivery
• Cygwin
• Microsoft Visual Studio 2008
• stopapps.bat and stopdb.bat files

Disk Partition

• Dir 1 : Win_2003         (C:\ )    15 GB or higher
• Dir 2 : R12_Stage       (D:\)     32 GB or higher
• Dir 3 : apps_R12         (E:\)     225 GB or higher

Step – 2 Antivirus Uninstallation

Ensure that you have uninstalled the antivirus from your system, as antivirus will not allow you to successfully complete the installation of Oracle Applications.

Step – 3 Setup Windows root

Install Windows Server 2003 in Dir 1 (C drive). For Win 2003 – install the Professional edition and set the number of users to 5 or as required.

Step – 4 Device Driver Check

On installation of Windows 2003 server,

Go to Control panel – System – hardware – Device Manager and ensure that there are no yellow question makes against any of the device drivers.

If found so, install all device drivers using the Mother board installation CD. (Atleast the Ethernet Controller driver (LAN Connectivity) and SM Bus Controller should be installed.

Step – 5 Setup the URL for the instance

In My Computers – right click – Properties,
go to Computer name – Change button. Enter “ibizapps”.
Click on “More” button and enter the following in “Primary DNS Suffix of this computer” as ibizsoftinc.com. In the Computer Name tabbed region it should show the “Full computer name” as ibizapps.ibizsoftinc.com. Reboot the system for the changes to take effect.  

Step – 6 Host File setups

Navigation Path : C:\ windows \system32 \drivers \etc and open the hosts file with Notepad.

You find an entry as 127.0.0.1            localhost.

Copy and paste it as the second line and append ibizsoftinc.comThe second line will now read as127.0.0.1       localhost.ibizsoftinc.com

Save and close the file

Step – 7 Network Set up

If you are connected to the Internet through a static IP from a Service provider or if you are in a LAN network, you need not have to install the Loop Back Adaptor.

You can verify your static IP connection by navigating to Start – Run – cmd > ipconfig.

This command will return an IP address. If it says Media state disconnected, you need to install a Loop Back Adaptor.

Step – 8 Loop Back Adaptor Setup

(Recommended over Step 7, even if your system is connected to network)

Loop Back Adaptor Installation

Disconnect the network cable from the system.

Navigate to Control Panel – Add hardware – Yes, I have connected hardware – Add a new hardware – Install a hardware I manually choose – Network Adaptors – Microsoft – Micro soft Loop Back Adaptor and continue to install. Then go to Start – Control panel – Network Connections and open the new connection that has been just installed.

Ensure that the Loop Back adaptor is mentioned in the “Connect Using” Box.

Then navigate to Internet Protocol (TCP/IP) – Properties – Use the following IP address

“IP address”       10.10.10.10,   
“Subnet mask”    255.255.255.0,

Use the following DNS sever –
“Preferred DNS server”  10.10.10.10.

Click on Advanced button and choose DNS tabbed region.
Choose “Append these DNS suffixes (in order)” and click on ADD button and add ibizsoftinc.com as enter the “DNS suffix for this connection” as ibizsoftinc.com.

Check on the button to “Register this connection’s address in DNS”

Recheck the ipconfig command in the DOS command prompt.It will now return 10.10.10.10. This completes the successful installation of LBA. 

Step – 9 Host name Verification

Verify your hostname – Start – Run – cmd  > hostname. It must return ibizapps.
Ping your host > ping ibizapps.ibizsoftinc.com.
It will now return 10.10.10.10 for the read write operation.

Step – 10 Networking Services Setup

This step is required only for Windows 2003 server (not for XP users).

Navigate to Start – Control panel – Add / Remove program.
Choose Add / Remove windows components and choose Networking services.

In detail choose all services. Continue and complete the installation of all the Network Services. The system will prompt for the windows 2003 server installation CD to complete the installation of Network Services.

Step – 11 Perform DNS server test

Navigate to Programs – Administrative tools – DNS.
Choose train – Action – Properties – Monitoring.
Check “A simple query against DNS server” and press Test now button.
It must Pass in the results window.

Step – 12 Oracle Apps Stage setups

Copy the DVD contents to a directory (Dir 2, D drive), to have a backup of the DVDs. Ensure that there are 26 zipped directories. Create a Directory ‘StageR12’. Unzip all the files to the directory StageR12 in the stage partition.

We can also unzip it directly from DVD to the directory StageR12, if there is a space constraint. Remember to unzip every file on to same StageR12 directory.It may ask “Do you want to overwrite”.  Enter “Yes to all”. Since all file contents are different, it has no common files to overwrite.

It will create the necessary directory structure below StageR12 and copy the related contents onto your hard disk.   

Step – 13 Create Directories in Windows root Directory
(In this case C drive)

Create the following directory in the Windows’s root directory.

• C:\Cygwin
• C:\VC2008
• C:\temp
• C:\tmp. temp
• C:\tmp.

Directory C:\tmp must be created even if C:\ is not the windows 2003 root.

Step – 14 Setup Printer

Install a Laser printer (even if it is not connected to the server.). Make that as the default printer. This step is required for the smooth running of your Concurrent Manager.

Step – 15 Cygwin Installation

Copy the content of Cygwin directory to a different directory other than the windows root directory.
(For e.g.  D:\Cygwin).

Run the Cygwin setup.exe file.
Choose the option “Install from Local Directory”.

In the Select Root Install Directory, choose the Root directory as C:\Cygwin.
Set Install For as ‘All Users’ and Default Text File Type as ‘Dos/text’.

Select the Local Package directory as D:\Cygwin (As we have the installation files copied to D drive) and continue installation.

Step – 15 Visual Studio 2008 Installations

Copy the content of Visual studios DVD into a local directory.

Navigate to VCExpress directory and run the setup file.
Choose “Install Visual Studios 2008”.

In the “Future Install Path” browse and choose C:\VC2008. Other features may be installed, depending on the disk space availability. It is preferable to have DotNet frame work.

Continue by clicking “Install”.
After installation, reboot the system for the Linker to work for the recognition of GNUMAKE.

On installation of Visual Studio 2008,
Copy C:\VC2008\VC\bin\link.exe to C:\windows\system32 directory.  

Step – 16 Cygwin file setups

Press Start and Run. Type cmd and click OK to go to DOS prompt.
Perform the following copy, in dos prompt.

C:\

cd C:\Cygwin\bin

Ensure you are in the bin directory

mv awk.exe awk.exe –ori
copy gawk.exe awk.exe
copy grep.exe egrep.exe
copy makeinfo.exe gnumake.exe

Step – 17 Environment Variables Setups

Navigate to Start – My Computer – Right click – Properties – Advanced –Environment Variables – Select Path – Edit

Add the following three paths in the beginning –C:\; C:\Cygwin\bin; C:\VC2008/VC;

Step – 18 Check GNUMAKE

Start – Run – cmd > which gnumake and ensure it returns /usr/bin/gnumake

Step – 19 DEP Setups for Internet Explorer

In My Computer – right click – System properties – Advanced – Performance – Settings Button – Data Execution Prevention tabbed region

Click Add button and browse Program Files – Internet Explorer and choose Iexplorer.exe.

Accept the caution and ensure Iexplorer.exe is added to the exception list of “Turn on DEP”.

In Tools – Internet options in your browser set the security to medium.

Ensure in Tools – Internet options – Security tabbed region – custom level, ensure that all the settings are set to enable or prompt.

This low level setting is required for the smooth functioning of apps.

Do not install any firewall, as it may prevent apps from running.

In Privacy tabbed region, enable cookies for first and third party and remove pop-up blocker.

In advanced tabbed region under security enable all “Allows’ and remove all “Check”  

Step – 20 Virtual Memory Setups

In My Computer – right click – System properties – Advanced – Performance settings – Advanced – Virtual memory

Change button set the paging file size to 4000 MB in the root directory (C drive).

Since our Oracle Applications is a 32 bit version, it can use a maximum of 4 GB only. Reboot the system to make effort of Virtual memory.

Step – 21 Oracle Applications Installation

Oracle Applications is now ready for installation.

Go to StageR12 \startCD \Disk1 \Rapidwiz and execute rapidwiz.cmd and follow the steps.
Provide your email id and password, click next.

Change the base directory to your apps directory (Dir 3, i.e. E drive in this case).
Domain name will be set automatically as ibizsoft.com.

Change Unix toolkit directory C:\mks to C:\Cygwin\bin

Change Visual studios directory C:msvc to C:\VC2008\VC and proceed to next

The process will perform the system check.
Ensure that you get all green tick during validation tests.

Otherwise correct the errors and go ahead for installation. It will now be totally automatic and takes three to four hours from now on to complete the installation.

On successful completion, you will get all green ticks in the post installation process

Installation process continues. Do not shut down the machine without completing the below process. 

Step 22 Login Details

URL to login : http://ibizsoft.ibizsoftinc.com:8000

Login as System Administrator with default Username and Password

Username : sysadmin
Password  : sysadmin

Step – 23 Application Proxy Port value Setup

Navigation Path :  System Administrator > Profile > System

Set the following profiles after installation Applications proxy Port with a value 8000. It will be NULL. Make a query App%proxy%. Add the value 8000 to site and commit (save). 

Step – 24 Application Server Proxy Setup

Navigation Path :  System Administrator > Profile > System

Applications Server side proxy Host and Domain name with a value
ibizapps.ibizsoftinc.com:8000. (It will be again NULL).

Make a query App%server%.
Add the value ibizapps.ibizsoftinc.com:8000 to site and commit.

Step – 25 IRC: Geocode Host setup

Navigation Path:  System Administrator > Profile > System

Query IRC%Geocode%. It will be pointing to a generic URL.
Change the URL to http://ibizapps.ibizsoftinc.com/elocation/lbs

Step – 26 Change workshift process

Navigation Path :  Sysadmin >  Concurrent  > Manager > Define
Then Query “Standard Manager”. Once the standard manager details are available, click on work shifts and change the process from 3 to 10.

Step – 27 Copy addbctl.cmd to Windows root Directory

Navigation Path: E :\ Oracle\ vis\ db\ tech_st\ 11.1.0\ appsutil\ scripts\ vis_ibizsoft then copy addbctl.cmd and paste it in the Windows root Directory (C:\)

Step – 28 Copy adstpall.cmd to Windows root Directory

Navigation Path: E :\ Oracle\ vis\ inst\ apps\ vis_ibizsoft\ admin\ scripts then copy adstpall.cmd and paste it in the Windows root Directory (C:\)

Step – 29 Setting up Stopapps.bat and Stopdb.bat

Copy stopapps.bat and stopdb.bat from the applications install directory to windows root directory. Right click and edit both the files to the windows root directory (C:\ adstpall.cmd apps/apps and C:\ addbctl.cmd stop immediate).

Copy and Paste both the edited files on your desktop. Ensure that you run stopapps.bat and stopdb.bat before every shutdown of your computer. To run the .bat file, just double click on the file.