How to Setup Oracle Application Server Forms and Reports

Written by ginny putscher
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Setup Oracle Application Server Forms and Reports
Set-up Oracle Application Server Forms and Reports (business report image by Christopher Hall from Fotolia.com)

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:
Easy

Other People Are Reading

Things you need

  • Computer with XP PRO Operating System

Show MoreHide

Instructions

  1. 1

    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.

  2. 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. 3

    Install Oracle Database Server 10g.

  4. 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. 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. 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 set-up is ready to be tested.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.