Subject: Step-by-Step Install Guide for Applications Rel. 11.0 on Windows NT Creation Date: 16-NOV-1998 PURPOSE ------- This is a step-by-step installation guide for Oracle applications Release 11.0 on Windows NT. The instructions assume that there are separate machines are being used for the Database Tier and the Web Application Server Tier. The guide can be tailored to do the full Applications Release 11 installation for Windows NT on 1 machine for Database Server and the Web Application Server) SCOPE & APPLICATION ------------------- This document should be considered to be a reference in addition to the below mentioned documents. RELATED DOCUMENTS ----------------- Oracle Applications Installation Manual for Windows NT and Release Notes for Release 11. Step-by-Step Instructions to Install Oracle Applications Release 11 on Windows NT (Database Tier) 1. Install the following components into the Oracle_Home: Oracle RDBMS 8.0.4 Enterprise Edition (Oracle Enterprise Edition CD 8.0.4) Select ConText Cartridge Option only Select Database as None Select No for Legato Drivers Exit Oracle Networking Products (Oracle Enterprise Edition CD 8.0.4) Choose Custom Installation Option Oracle N/W Products Ver. 2.3.4 Exit JDK1.1.5 (Oracle Application Release 11 Interoperability CD) JDK1.1.5 \ 1.1.5.16.7o \ JDK.EXE Unzip the File at E:\orant\ Exit Oracle Reports ( Developer 2000 1.6.1 CD ) Select Setup, Install in E:\orant Select Developer 2000-Reports 2.5.7.4.3 Select OK for install Reports, Forms45 Yes to update the Windows NT variables Select OK to install Books22, Graph25 (If you get Error E:\orant\Bin\core40.dll check services in control panel and stop all Oracle Services and RETRY) Exit 2. Database-tier Patches (Oracle Application Release 11 Interoperability CD) (Refer to the Installation Release Notes) RDBMS 8.0.4.1.4 Patch RDBMS804 \ 8.0.4.1.4\Readme.txt (Please follow instructions in the readme.txt) Check that all Oracle Services are stopped RDBMS804\ 8.0.4.1.4\Setup.exe (Since you do not have the database DO NOT run CATREP.SQL) Net80 Patch Interopcd\net8\8.0.4.0.4\setup.exe JDBC Patch Interopcd\jdbc\8.0.4.0.4\readme (Please follow instructions in the readme.txt) Copy these two files from Interopcd\jdbc\8.0.4.0.4\oci804jdbc.dll Interopcd\jdbc\8.0.4.0.4\oci804jdbc_g.dll to E:\Orant\bin Copy these two files from Interopcd\jdbc\8.0.4.0.4\classes111.zip Interopcd\jdbc\8.0.4.0.4\classes102.zip to E:\Orant\jdbc\lib RSF Patch (Required Support Files Patch) Interopcd\RSF73\readme.txt (Please follow instructions in the readme.txt) Copy all files from Interopcd\RSF73\*.* to E:\Orant\Bin 3. Stop and start all Oracle services through the services control panel 4. Create directory for data and log for database creation E:\mkdir database E:\mkdir log 5. Run the MAKDB804.CMD file (Oracle Applications Release 11 for Windows NT) \APPL110\ADMIN\makedb\makdb804.CMD apps e:\orant E:\database E:\log manager This will create: Oracle Database (Windows NT Service also) Required Applications tablespaces for each product ADPREPDB.SQL INIT.ORA 6. Reboot the system Start the Oracle Service for the database Set ORACLE_SID in a DOS window Start the database using svrmgr30 Svrmgr30> connect internal Startup pfile= 7. Create a Windows NT account (applmgr) to manage Oracle Applications and give it admin privileges 8. Logout and login using the new applmgr account 9. Create an APPL_TOP directory E:\APPL_TOP 10. Create an ENV.BAT file with the following environnment variables (save it in your APPL_TOP) set ORACLE_HOME=E:\orant set ORACLE_SID=APPS set LOCAL= set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 set NLS_DATE_FORMAT=DD-MON-RR set NLS_DATE_LANGUAGE=AMERICAN set NLS_NUMERIC_CHARACTERS=., set APPL_TOP=E:\APPL_TOP Save and Exit 11. Copy the ADOVARS.CMD file from the CDROM\APPL110\ADMIN\) to your E:\ APPL_TOP 12. Set the following variables in your E:\appl_top\adovars.cmd file to point to the correct locations. ORACLE_HOME=E:\ORANT JAVA_TOP=E:\APPL_TOP\JAVA (Location of Java Files) OA_JDK_TOP=E:\ORANT\JDK (Location of JRE) CLASSPATH=%ORACLE_HOME%\jdbc\lib\classes111.zip;%ORACLE_HOME%\forms45\java ;%OA_JDK_TOP%\LIB\CLASSES.ZIP;%JAVA_TOP%; OAH_TOP=E:\APPL_TOP\HTML (Location of HTML Files) OAD_TOP=E:\ APPL_TOP\DOC (Location of Documentation Files) PATH=\CDROM\APPL110; %PATH% PATH=%OA_JDK_TOP%\BIN; %PATH% 13.Create directories E:\APPL_TOP>MKDIR JAVA E:\APPL_TOP>MKDIR HTML E:\APPL_TOP>MKDIR DOC 14. Make sure your database is up and running sqlplus username/password@tnsalias 15. Run the env.bat file at the command line in a DOS window 16. Run the adovars.cmd file in the same DOS window 17. Configure Sql*Net Configure the tnsnames.ora in \ORANT\NETWORK\ADMIN Configure the tnsnames.ora and listener.ora in \ORANT\NET80\ADMIN Open E:\orant\net80\admin\listener.ora with notepad and go to the end of the list and edit the SID_NAME to APPS Open E:\orant\net80\admin\tnsnames.ora Edit the SID to APPS, and host= Copy the edited tnsnames.ora to E:\orant\network\admin\ This will update the current tnsnames.ora e:\orant\network\admin 18. Start AutoInstall (adaimgr.exe) from the /APPL110/ Q: Choose the correct APPL_TOP Q: Choose an AutoInstall log file Q: Certified version of the Database ??? Yes Q: Batchsize setting ??? 1000 - Leave at default Q: Files used for installing or upgrading your database ??? YES Q: Java and HTML files for HTML-based functionality ??? NO Q: Oracle applications forms files ??? NO Q: Concurrent Program files ??? YES Q: Correct database and oracle_home combination ? Check Yes (Database is referring to the TNS alias) AutoInstall Main Menu Install all the products Option 1 enter ALL Option 3 database parameters choose defaults Option 4 - set everything to YES Option 5 take defaults Create the temp directory e:\orant\plsql80\mkdir temp Utl_files_dir=%ORACLE_HOME%\plsql80\temp (Type exactly as this or it will fail) %ORACLE_HOME %\plsql80\temp Q: Number of workers 2 (no more than 2 workers) For all the output files take the defaults. (If anything fails in the run always restart adaimgr.exe and not resume) Run AutoInstall and monitor it for errors Q: Enter the temp tablespace APPLTEMP Step-by-Step Instructions to Install Oracle Applications Release 11 on Windows NT Forms Middle-Tier 1. Install the following components into the oracle_home * Oracle Web Application Server 3.0.1 (WAS 3.0.1 CD) - Choose Single Node Install and all the defaults - Don't overwrite the latest versions of installed software * Oracle JDBC Drivers 7.3 (WAS 3.0.1 CD) - Installed during Web Server installation (Choose the JDBC Driver Beta Option) * Developer 2000 -Forms 4.5.10.6.0 (Developer 2000 1.6.1 CD) * Oracle Networking Products Ver. 2.3.4 (Oracle Enterprise Edition 8.0.4 CD) - Select custom option and install Oracle Networking products * Oracle JDBC Drivers 8.0.4.0.0 (Oracle Enterprise Edition 8.0.4 CD) 2. Install all the Forms tier patches (Refer to the Installation Release Notes) (Interoperability Patch CD) JDBC Patch Interopcd\jdbc\8.0.4.0.4\readme (Please follow instructions in the readme.txt) Copy these two files from Interopcd\jdbc\8.0.4.0.4\oci804jdbc.dll Interopcd\jdbc\8.0.4.0.4\oci804jdbc_g.dll to E:\Orant\bin Copy these two files from Interopcd\jdbc\8.0.4.0.4\classes111.zip Interopcd\jdbc\8.0.4.0.4\classes102.zip to E:\Orant\jdbc\lib Forms patch Interopcd\forms45\4.5.10.8.0\setup.exe Install Developer 2000-Forms 4.5.10.8 Required Support Files Patch Copy all files from Interopcd\rsf73\*.* to G:\orant\bin Web Application Server patch Copy the following files to orant\bin * Interopcd\ows301\bug683196\wrl.dll * Interopcd\ows301\bug702034\domestic\wwwlsnr30.dll (for international user export directory) * Interopcd\ows301\bug702034\domestic\wwwlsnr30.exe * Interopcd\ows301\bug752207\wrb30.dll * Interopcd\ows301\bug752210\javai.dll 3. Create an APPL_TOP directory E:\mkdir APPL_TOP 4. Create an ENV.BAT file with the following environment variables: (save it in your APPL_TOP) set ORACLE_HOME=E:\orant set ORACLE_SID=APPS set LOCAL= set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 set NLS_DATE_FORMAT=DD-MON-RR set NLS_DATE_LANGUAGE=AMERICAN set NLS_NUMERIC_CHARACTERS=., set APPL_TOP=E:\APPL_TOP Save and Exit 5. Copy the ADOVARS.CMD file from the (CDROM\APPL110\ADMIN\) to your E:\APPL_TOP 6. Set the following variables in your E:\appl_top\adovars.cmd file to point to the correct locations: ORACLE_HOME=E:\ORANT JAVA_TOP=E:\APPL_TOP\JAVA (Location of Java Files) OA_JDK_TOP=E:\ORANT\JDK (Location of JRE) CLASSPATH=%ORACLE_HOME%\jdbc\lib\classes111.zip;%ORACLE_HOME%\forms45\ java;%OA_JDK_TOP%\LIB\CLASSES.ZIP;%JAVA_TOP%; OAH_TOP=E:\APPL_TOP\HTML (Location of HTML Files) OAD_TOP=E:\APPL_TOP\DOC (Location of Documentation Files) PATH=\CDROM\APPL110;%PATH% PATH=%OA_JDK_TOP%\BIN;%PATH% 7. Create the following directories: E:\APPL_TOP>MKDIR JAVA E:\APPL_TOP> MKDIR HTML E:\APPL_TOP> MKDIR DOC E:\ORANT>MKDIR JDK 8. Configure Sql*Net Configure the tnsnames.ora in \ORANT\NETWORK\ADMIN Configure the tnsnames.ora in \ORANT\NET80\ADMIN Open E:\orant\net80\admin\Tnsnames.ora (Configure to connect to the Database Server) Edit the SID to APPS Copy the edited tnsnames.ora to E:\orant\network\admin\ This will update the current tnsnames.ora in e:\orant\network\admin 9. Test the above connection using tnsping80 10. Stop all Oracle related services through the services control panel 11. Start AutoInstall (adaimgr.exe) from the /APPL110/ (Oracle Applications Release 11 for Windows NT) Q: Choose the correct APPL_TOP Q: Choose an AutoInstall log file Q: Certified version of the Database ??? Yes Q: Batchsize setting ??? 1000 - Leave at default Q: files used for installing or upgrading your database ? NO Q: Java and HTML files for HTML-based functionality? YES Q: Oracle applications forms files? YES Q: Concurrent Program files? NO Q: Correct Database and Oracle_Home combination ? Check Yes (Database is referring to the TNS alias) AutoInstall Main Menu Install all the products Option 1 enter ALL Option 3 database parameters, choose defaults Option 4 choose the default tasks for the middle-tier ONLY Option 5 take defaults Create the temp directory e:\orant\plsql80\mkdir temp Utl_files_dir=%ORACLE_HOME%\plsql80\temp (Type exactly as is or this will fail) %ORACLE_HOME%\plsql80\temp Q: Number of workers 2 (no more than 2 workers) For all the output files take the defaults. (If anything fails in the run always restart adaimgr.exe and not resume) Run AutoInstall and monitor it for errors Q: Enter the temp tablespace APPLTEMP 12. Reboot the system 13. Start the Web Server Services through the (Control Panel > Services) in the following order: OracleWRBPrimaryService OracleWWWListener30Admin OracleWWWListener30WWW 14. Configure the Web Application Server (Log file is under \OH\OWS30\) - Installation manual pg. 4 - 8 ex. Http://www.testmachine.com:8888/ (Enter the username/password for the admin listener) Click on Web Listener (Configure Virtual Mappings) * These entries are case sensitive. Please use the right case. g:\temp NR /OA_TEMP/ g:\appl_top\html\html\ NR /OA_HTML/ g:\appl_top\html\html\bin NR /OA_HTML/BIN/ g:\appl_top\java\ NR /OA_JAVA/ g:\appl_top\doc\ NR /OA_DOC/ g:\appl_top\java\oracle\apps\media\ NR /OA_MEDIA/ 15. Modify the initial signon files: (follow page 4-17 of Installation manual) Copy the afsamples.html files to a unique name (ex. test.htm) E:\appl_top\html\html\copy afsamples.htm test.htm Open test.htm with an editor. Edit the parameters in the follow line