Disclaimer: Apply to a TEST environment first. Use on production systems is at DBAs own risk.
E-Business 12 on Windows 7
This is a HP laptop running Windows 7 professional 64 bit.
With an Intel i3 processor and 8GB of memory.
At the time this document was written Windows 7 is not
certified by Oracle to run E business R12.
This install of E-Business R12 is for testing purposes.
Today 01-Apr-2010
Reference:
Installation Steps for XP:
http://forums.oracle.com/forums/thread.jspa?threadID=494790&tstart=0
Oracle download: style='mso-tab-count:1'> http://edelivery.oracle.com
[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)
http://download.oracle.com/docs/cd/B40089_07/current/acrobat/120oaig.pdf
414992.1 – Using Cygwin to Maintain Oracle E-Business Suite
Release 12 on Windows
You will need to install Visual C++ 2005 (8.0) Standard or
Professional editions — See (Note: 761567.1 – Oracle Applications
Installation and Upgrade Notes Release 12 (12.1.1) for
Microsoft Windows Server (32-bit)) for details.
The following blog also outlines very similar steps with
some visuals:
http://r12-install.blogspot.com/
I will install under default Windows user who is of
administrator type.
Installing on XP Mode Virtual PC
option of Windows 7 professional:
After 3 weeks of trying to install on a virtual PC XP Mode,
and getting into many issues such as limited virtual disk space, I decided just
to take a chance and try installing E-Business R12 directly on Windows 7 64
bit, which worked fine as outlined in this document.
Security and spay removal software
might interfere with the installation:
First turn off your Norton Security Center, if you have one.
In my case, to be safe I first disabled Internet connection
on my HP Laptop by disabling my N card from Hardware manager, then disabled
Norton and my Windows Defender.
1) Create stage area:
Do not attempt to just run Rapidwiz straight out the DVD
media or unzipped downloaded install files. The rapidwiz will just run for a
while copying itself and the content of the start here DVD into temp on your C:
drive and then it would die with error like
the script failed and returned status 1.
You must have a staging area created by adautostg.pl , then
from the staging are you execute rapidwiz.
First download and install latest perl from
http://www.perl.com which will install in C:\Perl64\bin
Bounce/restart your computer.
I have the following drives:
F: is my DVD drive.
Put start here Disk of R12 Media into F:
From Dos I do as seen here:
f:
cd \Disk1\rapidwiz
C:\Perl64\bin\perl adautostg.pl
àThis will start staging into C:StageR12
àIt took close to 3 hours to stage all it needs. All
success.
2) Set ‘Computer Name’ as well as
‘Domain Name’.
Similar to XP as outlined in http://forums.oracle.com/forums/thread.jspa?threadID=494790&tstart=0
Right click on My Computerà Properties
style='font-family:Wingdings;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";mso-char-type:symbol;mso-symbol-font-family:
Wingdings'>à
Computer Name à
Change
Set ‘Computer Name’ to <hostname> style='mso-tab-count:1'>
àIn my environment
hostname is set to hplaptop.
Click on More
Set a Primary DNS Suffix of this Computer to
<domainname.com>
àIn my environment
hostname is set to idbasolutions.com
Note:
Similar to XP as outlined in
http://forums.oracle.com/forums/thread.jspa?threadID=494790&tstart=0
You do not have to join a domain, just set a ‘Primary DNS
Suffix of this Computer’ to any domain you choose (i.e. home.com).
Remember that you need to add an entry in the hosts file of
your hostname and domainname (i.e. if hostname is abc, and domain name is
xyz.com, then the entry should be –> <IP Address> abc.xyz.com).
3) Install Microsoft Loopback
adapter and define an IP address
Similar to XP as outlined in
http://forums.oracle.com/forums/thread.jspa?threadID=494790&tstart=0
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
Manual installation
To manually install the Microsoft Loopback adapter in
Windows XP, follow these steps:
Click Start, and then click Control Panel.
If you are in Classic view, click Switch to Category View
under Control Panel in the left pane.
Double-click Printers and Other Hardware, and then click
Next.
Under See Also in the left pane, click Add Hardware, and
then click Next.
Click Yes, I have already connected the hardware, and then click
Next.
At the bottom of the list, click Add a new hardware device,
and then click Next.
Click Install the hardware that I manually select from a
list, and then click Next.
Click Network adapters, and then click Next.
In the Manufacturer box, click Microsoft.
In the Network Adapter box, click Microsoft Loopback
Adapter, and then click Next.
Click Finish.
4) Add a new entry in
C:\windows\system32\drivers\etc\hosts as follows:
<IP Address> <hostname.domainname.com>
127.0.0.1 hostname.domainname.com
I set hosts file to this:
127.0.0.1
localhost
127.0.0.1
HPLPAPTOP.idbasolutions.com
style='mso-tab-count:1'> loopback
127.0.0.1
HPLPAPTOP loopback
5) From the command prompt, make
sure you can do the following:
C:\> ping 127.0.0.1
C:\> ping hostname
C:\> ping hostname.domainname.com
Then do this:
Disabled Accelerators
Toolsà Manage Add on Disable Unnecessary Accelerators.
I disabled all.
6) I used the local user which is
of admin type, to do the install.
Also change user account control setting so it stops
prompting every time rapidwiz is trying to make changes to the system by
navigating as follow:
Control panelàUser accountà Change user account
control setting
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.
http://www.microsoft.com/express/downloads/
àJust download Visual C++ 2008 Express Edition (all
express editions are free).
Express edition is free as opposed to standard version which
costs close to $250 on Amazon.
Install mks ToolKit:
This is not free as opposed to Cygwin which in my case did
not work as seen in section of this document titled Error
7)
‘Cygwin’ did not work for my install, Rapidwiz kept on
asking for tempmake or other shells that was not in this ‘Cygwin’.
Mks ToolKit and ‘Cygwin’ are cshell and Unix command
emulators that E-Business needs to run.
9) Add C:\mks\mksnt to the system path.
Right click on "My Computer" > Properties >
Advanced > Environment Variables > PATH. 11) No JDK installation is
required, JDK 5.0 (java version "1.5.0_08") is bundled with Oracle
Applications R12 installation.
10) Start the installation:
C:\> cd C:\StageR12\startCD\Disk1\rapidwiz
C:\Stage12\startCD\Disk1\rapidwiz> RapidWiz.cmd
The installation wizard is similar to 11.5.10 RapidWiz. For
‘VC++’ and ‘mks’ I have provided the following paths:
C:\VCPlus\VC
C:\mks\mksnt
When prompted by rapidwize for C++ and mks provide the
following path C:\VCPlus\VC for C++ (it will error if you just give C:\VCPlus)
Once installer started the step 2 of 5 unziping Oracle
applications stuff, I did a search in the staging area for file refhost but
there was none.
Then I searched c:\oracle\VIS for refhost and if found a
few, I modified prov_refhost.xml and refhost.xml including the following right
after the Windows Vista entery:
<!–Microsoft
Windows 7–>
<OPERATING_SYSTEM>
<VERSION
VALUE="6.1"/>
</OPERATING_SYSTEM>
See sample at the end of this doc.
Log files:
Rapidwize temp install log files are located in:
C:\Users\bobbya\AppData\Local\Temp\04181559
Oracle Universal installer logs:
C:\Program Files (x86)\Oracle\Inventory\logs
bobbya being the local user of admin type which was used to
do the install.
Seen errors and fixes:
Error: 1)
RW-20019 error right at the begening of rapidwize.
Fix: include the host name in hosts file.
Sample:
127.0.0.1
localhost
127.0.0.1
HPLPAPTOP.idbasolutions.com
style='mso-tab-count:1'> loopback
127.0.0.1
HPLPAPTOP loopback
Error: 2)
It passes all prerequisites and stars install after 10 or 15
minutes it give the following error:
windows cannot find \jre\NT\1.5.0\bin\java
When I look at the install DVD and browse to
D:\Disk1\rapidwiz\jre\NT I can only see folder 1.6.0 there is no 1.5.0 and
Rapidwise seems to be looking for 1.5.0
I Google this and saw other users with the same problem and
they had just copied the content of 1.6.0 into a 1.5.0 in
\Disk1\rapidwiz\jre\NT
Here is what I did:
I dumped the content of the install DVD start here to
C:\stage on windows 7 and created a 1.5.0 folder in
D:\Disk1\rapidwiz\jre\NT
with what was in 1.5.0 and created a new DVD from this dump
on C: and used the new DVD to install.
Error: 3)
In step 1 of 5: Installing database stack:
After copying all the zip files rapidwize fails and I could
see that it during database stack it tries to acquire 500 MB swap and it said 0
available
Also the log files says that adsvdlsn.cmd fails. Location of
adsvdlsn.com: VIS ORACLE_HOME appsutil\install\host_name fails.
I run adsvdlsn.cmd just by it self and it fails because of
tns being down. But at this stage there is not yet a database running.
Fix:
I created swap file called paging file in windows in C: and
D: and set to initial extent 4605 MB Max 9210 MB by navigating to
Right click my computer–>Advance tab–>Virtual
Memory. It was previously set to be system managed.
I abort Current install of rapidwize cleaned temp in
C:\Users\bobbya\AppData\Local\Temp and cleaned all in C:\oracle\VIS
Bounced and restart install rapidwiz
The rapidwiz install once restarted did pass the point of
failure earlier about the swap space. And continued to step 2 of 5: Installing
Oracle Applications.
Error 5)
If you interrupt install, then you must clean temp and start
OUI from the start menu and navigate to Oracle just installed and start OUI and
un-install, then make sure there is nothing in C:\oracle\VIS then clean
registery as seen here:
And clean temp:
C:\Users\bobbya\AppData\Local\Temp\04181559
C:\Program Files (x86)\Oracle\
style='font-family:Wingdings;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";mso-char-type:symbol;mso-symbol-font-family:
Wingdings'>àRemove
inventory.
For registery clean up these tow locations of any VIS
related services or home:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE
CAUTION: Note that if you have other Oracle product on that
machine then only remove stuff relating to VIS
Error 6)
If rapidwiz at the end of database technology stack
installation seems to hung for ever on adrun11g.cmd then you might have not
cleaned up properly the previous rapidwiz install run, especially the clean up
of the inventory. Repeat the previous step described in Error 5).
Error 7)
The rapidwiz install runs for about two hours, finishes
adrundb.cmd and goes into step 3 of 5 registering application technology and
while running adrunias.cmd gives this error:
RW-50004: Error code received when running external process.
Check log file details.
Running APPL_TOP install Driver for VIS instance.
Log file 04221002.log in
C:\Oracle\VIS\inst\apps\VIS_hplaptop\logs last lines display:
àHere stars the paste for captured error.
RC-50004: Fatal: Error occurred in ApplyAppsTechStack:
RC-50013: Fatal: Failed to instantiate driver
C:\oracle\VIS\apps\tech_st\10.1.3\appsutil\driver\regclone.drv
C:\Users\bobbya\AppData\Local\Temp>if 1 == 0 goto :REG_OK
C:\Users\bobbya\AppData\Local\Temp>echo Cannot execute registration
of Applications Techstack
Cannot execute registration of Applications Techstack
C:\Users\bobbya\AppData\Local\Temp>if "" ==
"TRUE" goto :INSIAS_OK
RW-50010: Error:
- script has returned an error: 1
RW-50004: Error code received when running external
process. Check log file for details.
Running APPL_TOP Install Driver for VIS instance
Log file ApplyAppsTechStack_04221159.log in
C:\Oracle\VIS\inst\apps\VIS_hplaptop\admin\log:
[AutoConfig Error Report]
The following report lists errors AutoConfig encountered
during each
phase of its execution.
Errors are grouped by directory and phase.
The report format is:
<filename>
<phase> <return code
where appropriate>
[APPLY PHASE]
AutoConfig could
not successfully execute the following scripts:
Directory:
C:\oracle\VIS\apps\tech_st\10.1.3\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe
-I
C:\oracle\VIS\apps\tech_st\10.1.3\perl\5.8.3\lib\MSWin32-x86-multi-thread
-I C:\oracle\VIS\apps\tech_st\10.1.3\perl\5.8.3\lib
-I C:\oracle\VIS\apps\tech_st\10.1.3\perl\site\5.8.3\lib\MSWin32-x86-multi-thread
-I
C:\oracle\VIS\apps\tech_st\10.1.3\perl\site\5.8.3\lib -I
C:\oracle\VIS\apps\apps_st\appl\au\12.0.0\perl -I
C:\oracle\VIS\apps\tech_st\10.1.3\Apache\Apache\mod_perl\site\5.8.3\lib\MSWin32-x86-multi-thread
C:\oracle\VIS\apps\tech_st\10.1.3\appsutil\clone
ouicli.pl style="mso-spacerun: yes"> INSTE8_APPLY style="mso-spacerun: yes"> -1
AutoConfig is exiting with status 1
RC-50013: Fatal: Instantiate driver did not complete
successfully.
C:\oracle\VIS\apps\tech_st\10.1.3\appsutil\driver\regclone.drv
C:\oracle\VIS\apps\tech_st\10.1.3\perl\5.8.3\bin\MSWin32-x86-multi-thread\perl.exe
-I
C:\oracle\VIS\apps\tech_st\10.1.3\perl\5.8.3\lib\MSWin32-x86-multi-thread
-I C:\oracle\VIS\apps\tech_st\10.1.3\perl\5.8.3\lib
-I C:\oracle\VIS\apps\tech_st\10.1.3\perl\site\5.8.3\lib\MSWin32-x86-multi-thread
-I
C:\oracle\VIS\apps\tech_st\10.1.3\perl\site\5.8.3\lib -I
C:\oracle\VIS\apps\apps_st\appl\au\12.0.0\perl -I
C:\oracle\VIS\apps\tech_st\10.1.3\Apache\Apache\mod_perl\site\5.8.3\lib\MSWin32-x86-multi-thread
C:\oracle\VIS\apps\tech_st\10.1.3\appsutil\cloneouicli.pl style="mso-spacerun: yes"> INSTE8_APPLY style="mso-spacerun: yes"> -1
àHere ends the paste for captured errors.
I Google this (r12 install fails on regclone.drv) and found
oracle forum discussions where people suggest the solution is
To have an older version of cygwin. Or Having Visual Studio
2005 Standard rather than express edition.
I do not have Visual C++ standard and it is expensive, but I
do have mks so I go ahead and clean up my failed install as described in step
5, then I install mks and re-install R12.
The rapidwiz install re-started after I installed mks and
all is progressing ok and this time it passed where it was failing and
completed adrunais.cmd and went into step 4 of five and started running
adrunat.cmd. adrunat.cmd runs close to 2 hours unzipping close to 1185 files.
It run for another 2 hours, no error, installation successful. Total rapidwiz
install 5 hours with Vision database.
http://hplaptop.idbasolutions.com:8000/OA_HTML/AppsLogin
default sysadmin password is sysadmin
Error 8):
After install concurrent managers do not startup:
Fix:
From Windows services set all Oracle VIS services to manual
and stop them. All except database service (OracleServiceVis) and db listner
(OracleVIS_db111_RDBMSTNSListnerVIS). DB and listner should be set to start
auto and be running. Then run apps stopall script from command prompt.
Then I run auto config (See Section:Run Autoconfig for
detail) first on DB then on Apps. Rerun if you get error.
Then I restart windows 7 host, and using apps startall
script. Wait 5 or 10 minutes, OAM (Oracle Application Manager) shows standard
manager actived successfully and I am able to run concurrent requests.
Each time you bounce the windows 7 laptop you must run apps
startall script:
cd C:\Oracle\VIS\inst\apps\VIS_hplaptop\admin\scripts
adstpall.cmd apps/apps style='mso-tab-count:1'>
style='font-family:Wingdings;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";mso-char-type:symbol;mso-symbol-font-family:
Wingdings'>àTo
stop all
adstrtal.cmd apps/apps style='mso-tab-count:1'>
style='font-size:14.0pt;mso-bidi-font-size:12.0pt;font-family:Wingdings;
mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman";
mso-char-type:symbol;mso-symbol-font-family:Wingdings'>àTo start all
Error 9):
When starting a browser to Vision R12:
http://hplaptop.idbasolutions.com:8000/OA_HTML
and logon as sysadmin
and click on a link such as system profile options that runs
a javascript to start an old forms page like it used to with 11.5.10.2 then it
goes no where, it does not give any error but it does not open new page with
the expected forms for profile option in apps.
Fix:
First make sure you have Java 6 installed on your desktop
and the browser is using it.
Then in my case I make sure I start the IE 8 64x bit, from
the start menu navigate to programs and to Internet Explorer 64 bit.
Also make sure you have javascrpts enabled: from IE8 x64 and
click tools–internet options–> security–>Internet and click custom
level setting and go all the way down to scripting and enable Active scripting
and scripting of java appletslooking for scr
For some reason IE 8 32x bit cannot launch Forms pages where
it is launed from a JavaScript, use IE 8 64x bit to browse E-Business VIS R12.
Error 10):
For E-Business R12 to run, Norton Internet Security should
look like this:
This is what I see on 2010 Norton Internet Security:
Computer Tab:
Insight Protection off
style='mso-tab-count:1'> I
set this On and E-Business R12 did not start up.
Antivirus off
style='mso-tab-count:1'> I set
this On and E-Business R12 and db started but later became non responsive.
Antispyware off
style='mso-tab-count:1'> I set this On and E-Business R12 and
db started but later became non responsive.
Network Tab:
Smart Firewall On
Intrusion Prevention on
Web Tab:
Identity Safe On
Browser Protection On
Safe Surfing On
Download Intelligence On
Windows
defender off I set this On and
E-Business R12 and db started but later became non responsive.
Appendix:
Content of prov_refhost.xml after I
inserted Windows 7:
<?xml version=’1.0′ encoding=’windows-1252′?>
<!– Copyright (c) 2004, Oracle. All Rights Reserved.
–>
<HOST PLATID="912">
<SYSTEM>
<MEMORY>
<PHYSICAL_MEMORY
VALUE="256" UNIT="MB"/>
<!–AVAILABLE_MEMORY VALUE="512" UNIT="MB"/–>
</MEMORY>
</SYSTEM>
<CERTIFIED_SYSTEMS>
<OPERATING_SYSTEM>
<VERSION
VALUE="5.0"/>
<SERVICE_PACK VALUE="1"/>
</OPERATING_SYSTEM>
<OPERATING_SYSTEM>
<VERSION
VALUE="5.1"/>
<SERVICE_PACK VALUE="1"/>
</OPERATING_SYSTEM>
<OPERATING_SYSTEM>
<VERSION
VALUE="5.2"/>
</OPERATING_SYSTEM>
<!–Microsoft
Windows Vista–>
<OPERATING_SYSTEM>
<VERSION
VALUE="6.0"/>
</OPERATING_SYSTEM>
<!–Microsoft
Windows 7–>
<OPERATING_SYSTEM>
<VERSION
VALUE="6.1"/>
</OPERATING_SYSTEM>
</CERTIFIED_SYSTEMS>
<ORACLE_HOME>
<COMPATIBILITY_MATRIX>
<ALLOW>
<COMP
NAME="oracle.rdbms" ATLEAST="11.1.0.0.0"
ATMOST="11.1.9.9.9"/>
<COMP
NAME="oracle.client" ATLEAST="11.1.0.0.0"
ATMOST="11.1.9.9.9"/>
<COMP
NAME="oracle.tg" ATLEAST="11.1.0.0.0"
ATMOST="11.1.9.9.9"/>
</ALLOW>
<DISALLOW>
<NEW_HOME/>
</DISALLOW> style="mso-spacerun: yes">
</COMPATIBILITY_MATRIX>
</ORACLE_HOME>
</HOST>
db appsutil scripts:
C:\Oracle\VIS\db\tech_st\11.1.0\appsutil\scripts\VIS_hplaptop
addlnctl.cmd style='mso-tab-count:1'> stop start db listner
addbctl style='mso-tab-count:1'> stop start db
apps start All stop All scripts:
cd C:\Oracle\VIS\inst\apps\VIS_hplaptop\admin\scripts
adstpall.cmd apps/apps style='mso-tab-count:1'>
style='font-family:Wingdings;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";mso-char-type:symbol;mso-symbol-font-family:
Wingdings'>àTo
stop all
adstrtal.cmd apps/apps style='mso-tab-count:1'>
style='font-family:Wingdings;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman";mso-char-type:symbol;mso-symbol-font-family:
Wingdings'>àTo
start all
Log files for stop or start all at:
C:\Oracle\VIS\inst\apps\VIS_hplaptop\logs\appl\admin\log
Concurrent managers start stop
scripts:
cd C:\Oracle\VIS\inst\apps\VIS_hplaptop\admin\scripts
adcmctl.cmd stop apps/apps
adcmctl.cmd start apps/apps
Status:
adcmctl.cmd status apps/apps
Or from command prompt
net stop OracleConcMgrVIS_hplaptop
net start OracleConcMgrVIS_hplaptop
Run Autoconfig:
select target_node from FND_CONCURRENT_QUEUES;
All pointing to hplaptop and some to null.
First stop all but database
Then logon as apps and run this:
EXEC FND_CONC_CLONE.SETUP_CLEAN;
commit;
Autoconfig on DB:
cd C:\Oracle\VIS\db\tech_st\11.1.0\appsutil\scripts\VIS_hplaptop
adautocfg.cmd
log file:
C:\Oracle\VIS\db\tech_st\11.1.0\appsutil\log\VIS_hplaptop\<DATE>\adconfig.log
Autoconfig on Apps:
cd C:\Oracle\VIS\inst\apps\VIS_hplaptop\admin\scripts
adautocfg.cmd
log file: C:\Oracle\VIS\inst\apps\VIS_hplaptop\admin\log\<DATE>\adconfig.log
adautocfg.cmd
Run autoconfig again,
run autoconfig first on db
cd
C:\Oracle\VIS\db\tech_st\11.1.0\appsutil\scripts\VIS_hplaptop
adautocfg.cmd
Logon as apps:
as apps:
EXEC FND_CONC_CLONE.SETUP_CLEAN;
commit;
Run autoconfig against apps
cd C:\Oracle\VIS\inst\apps\VIS_hplaptop\admin\scripts
adautocfg.cmd
Other related service:
Oracle
Fulfillment Server VIS_laptop:
àOK to set manual since it seems to be used to
automate sending email to customers. I do not need this.
Oracle VIS VSS Writer Service
àOK to set to manual. This is a 11g db feature to
interface with windows for some kind of backup.
OracleVIS_hplaptop_TOOLidbasolcntrol
à By Default was set to manual and I left as is.
OracleVIS_hplaptop_TOOLSProcessManager style='mso-tab-count:2'>
àBy Default was set to manual and I left as is.
OracleVIS_hplaptop_WEBOHProcessManager style='mso-tab-count:2'>
à By Default was set to manual and I left as is.
OracleJobSchedulerVIS style='mso-tab-count:2'>
à By Default was set to manual and I left as is.