Oracle Forms and Reports is an Oracle tool that assists with creating forms and reports that are available through the Internet. These forms and reports based on Oracle tables created by using Oracle Designer or SQL Plus commands provide an end-user with a productive and positive experience. Oracle 10g Forms and Reports is a key component of Oracle 10g Development Suite.
- Skill level:
Other People Are Reading
Things you need
- Computer with XP PRO Operating System
Install a Loopback adaptor to create a virtual static Internet Protocol (IP). Oracle is dependent on network functionality and a static IP address is required.
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.
Install Oracle Database Server 10g.
Install JInitiator 126.96.36.199 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.
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."
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 set-up is ready to be tested.
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for