Oracle R12.1.1 installation
Installation of Oracle Applications – R12.1.1 for Windows
Step – 1 Prerequisite
- Windows 2003 Server
- Oracle Apps R12.1.1 installation CD or files downloaded from Oracle edelivery
- Microsoft Visual Studio 2008
- stopapps.bat and stopdb.bat files
- 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:\tmp. temp
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.
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.