How to Setup Oracle Application Server Forms and Reports

Process for Setting up the Oracle Application Server and Reports
1. Install a Loopback adapter to create a virtual static Internet Protocol (IP). Oracle is dependent on network functionality and a static IP address is required.
2. Adjust the paging file size--the paging file is required to be at least 256 megabytes (MB); this will eliminate a potential error that may interrupt the install of the Oracle Developer Suite.
3. Install Oracle Database Server 10g.
4. Install JInitiator 1.3.1.22 next. My XP Pro has Internet Explorer version six service pack three installed which is supported by Oracle. **Note: If Internet Explorer version seven or higher is installed on your XP machine, a fix is necessary. The \'jvm.dll\' files for Java and JIniator must be the same.
5. Create shortcuts for the executable files on the desktop for the Forms Builder executable file (frmbld.exe). By locating the “c:\\DevSuiteHome_1\\bin\\frmbld.exe,” right-click and send to desktop, then rename it “Forms Builder.” In a similar fashion, create shortcuts for the \'Starting and Shutting\' down of the Oracle containers for J2EE (OC4J) instance as well as the SQLPlus by locating their paths, creating the shortcut and renaming appropriately. For example, \'c:\\DevSuiteHome_1\\j2ee\\DevSuite\\startinst.bat,\' \'c:\\DevSuiteHome_1\\j2ee\\DevSuite\\shopinst.bat,\' and \'c:\\DevSuiteHome_1\\bin\\sqlplusw.exe.\'
6. Configure additional software. The \'tnsnames.ora\' file in the \'DevHome_1\\network\\admin\' directory to include a new entry for the database as shown below:EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
ADDRESS = (PROTOCOL = TCP)(HOST = youraddress) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSEXTPROC)
)
)
FORMSDB =
(DESCRIPTION =
(ADDRESS_LIST =
ADDRESS = (PROTOCOL = TCP)(HOST = youraddress) (PORT = 1521))
)
(CONNECT_DATA = (SID = ORCL)
)
)The Web configuration file located in the \'DevHome_1\\forms\\server\\formsweb.cfg\' is checked for validity and edited if necessary. The forms environment \'default.env\' file in the \'DevHome_1\\forms\\server directory\' is checked for validity and edited with values for the \'FORMS_PATH,\' the \'PATH\' and the entry \'FORMS_RESTRICT_ENTER_QUERY=TRUE.\' The \'WebUtil\' configuration file located in the \'vHome_1\\forms\\server\\webutil.cfg\' is also checked for validity and edited if necessary. Once all of these housekeeping chores are addressed, the setup is ready to be tested.