- Oracle Forms Developer and Reports Developer Release 6i: Procedure Builder Reference PDF Oracle Forms Developer and Reports Developer Release 6i: Common Built-in Packages.
- This is an excellent Guide but for Forms 4.5 developed with Oracle Developer/Developer Server 6.x/2000. I do not think there is a similar document for Forms6i nor new Forms9i.
| Home E-mail Us Oracle Articles New Oracle Articles
|
ORACLE FORMS 6i Total Manual 2. A single library can contain many program units that can be shared among the Oracle Developer modules and applications.
By Steve Callan The Oracle9i installation guide included in last month's Installation Cookbook series established the concept of applying an installation methodology to Oracle products. This cookbook article on installing Forms & Reports 6i (on a Solaris system) illustrates the same methodology. 'But wait, I'm a DBA, not a software installer,' so you say. True, you may be the DBA, but whom else to turn to when it comes to anything having to do with Oracle? More often than not, the DBA owns everything related to Oracle, whether or not the DBA has anything to do with that 'other' Oracle stuff. Additionally, it is not uncommon to find people working in DBA/developer positions, so shake off the narrow-minded view about what a DBA does and expand your knowledge of Oracle's installation process. The previous article included a suggested outline of the installation process. You will find that when it comes to Oracle products, database or otherwise, the outline works just the same. A general outline of installation steps The seven steps shown below are the same steps from the Oracle9i installation cookbook. 1. Verify that hardware and software minimums are met or exceeded 2. Prepare or update the operating system 3. Create administrative/owner accounts and file structures 4. Reserve, specify, or designate disk space 5. Start the Oracle Universal Installer (OUI) and provide information as necessary 6. Perform post-installation tasks 7. Test your installation The first four steps can be considered as pre-installation tasks, step five as THE installation task and steps six and seven as post-installation tasks. Moreover, as I stated in the previous article, I like to include an introduction along with a list of assumptions or standards, and a list of references from which the information was drawn. As an added bonus, you can include a short troubleshooting section at the end of the installation guide. Including this section begs the question of, 'Why those particular problems and not others?' Part of that comes from personal experience and observation. Experience, of course, comes from making mistakes, so that's part of the answer, and the observation part may stem from having observed others (customers) make those mistakes or face similar problems. The next article in this series will discuss some additional planning considerations and ways to 'dummy up' the inventory location. This comes in handy when working with different versions of the Oracle Universal Installer. Therefore, without further ado, here is a detailed, step-by-step installation cookbook for installing Oracle Forms & Reports 6i on a Sun Solaris platform. Installation Guide for Oracle Forms Developer and Reports Developer - Release 6i for Sun SPARC SolarisIntroductionThis document guides you through installing the server components of Oracle Forms & Reports for Sun SPARC Solaris, Release 6i, on the Solaris 8 operating system. The installation is performed using Oracle's Oracle Universal Installer (OUI), a GUI-based tool similar to the OUI for Oracle9i and other Oracle products. This guide takes you through the pre-installation, installation, and post-installation tasks referenced in the Oracle Forms Developer and Reports Developer Installation Guide dated March 2000 (Oracle Part No. A82817-01). Oracle Forms Server and Reports Server Installation Guide dated March 2000 (Oracle Part No. A82818-01) can also be used. The following conventions are used in this installation guide:
System RequirementsSolaris 8 Files edited or modified by the UNIX users root and oradev6The user oracle (or oracle9) may have been created for installation of Oracle9i. You can use the same Oracle user for both 9i and 6i, but separating the users is a practical safeguard related to configuration issues and preventing the overwriting of important files. 1. Create a user called oradev6 who is a member of the dba and oinstall groups. As root, edit your /etc/passwd file and enter the following line: oradev6:x:104:20002::/opt1/ora6i:/bin/csh where:
2. As root, edit the /etc/group file and add the user oradev6 to the list of users under the dba group. For example, the entries for the dba and oinstall groups line could look like dba::20002:oracle9,oradev6 3. When all changes have been made, execute pwconv as root at a UNIX prompt. Create the mount point and assign ownership for oradev6 by entering the following commands: mkdir -p /opt1/ora6i 4. As root, edit root's .cshrc file and add the following environment variables: setenv ORACLE_HOME <ex: /opt1/ora6i/app/oracle/product/6.0> The ORACLE_HOME environment variable should match the path you will be setting in oradev6's .cshrc file. The ORACLE_SID value does not have to be the name of an actual database. 5. Login as oradev6. Check to see that your home directory is automatically set to /opt1/ora6i. Copy a generic .cshrc file from /etc/skel by typing cp /etc/skel/local.cshrc .cshrc 6. Using a text editor such as vi, edit the .cshrc file for oradev6. Modify the file so that the following settings and environment variables are set, and source the file (source .cshrc) when finished with the editing. umask 022 width=14 height=9 border=0 alt='> Note: Place $ORACLE_HOME/lib at the beginning of LD_LIBRARY_PATH. Otherwise, the patch installation will fail. You are now ready to install the CD-ROM and begin using the Oracle Universal Installer. Performing the installationInsert the CD-ROM. Solaris Volume Management should automatically mount the CD-ROM for you. Minimize the 'File Manager - oracle' window after the CD-ROM is mounted. Refer to the table below for actions to take in each window displayed by the Oracle Universal Installer. As the UNIX user oradev6, start the installation by typing /cdrom/oracle/orainst/orainst /m You may encounter other windows during the installation process for a variety of reasons (improper system setup, lack of file permissions, non-existent paths, etc.). The OUI windows are fairly self-explanatory as to what needs to be done to correct a problem. In the windows that appear below, take the action(s) indicated.
The command line in the UNIX window where you initiated orainst should show Result: Success Post-installation tasks1. Forms and Reports executables need a tnsnames.ora file, or you can use the TNS_ADMIN environment variable to point to a directory where the Oracle Net Services (or Net8) configuration files are located. If you already configured this file for an Oracle9i installation, set TNS_ADMIN to the directory where the tnsnames.ora file for Oracle9i is located. Otherwise, Oracle products will look for the tnsnames.ora file in the following order: .tnsnames.ora in the user's home directory (note the dot before the file name) $TNS_ADMIN (you can set this in the .cshrc file) /var/opt/oracle $ORACLE_HOME/network/admin (this is the default location) 2. As oradev6, edit the spoolcmd.sh file. Change the working directory to $ORACLE_HOME/reports60/admin/printer. 3. Beginning at line 36 in the file, where it says if test $3 = 'delete' make the changes shown below (you are replacing the 'then' and 'else' statements with what is shown below): then Without these changes, you will see error messages related to REP-3300/UI-9 and REP-1809 when trying to print reports from forms. Oracle documentation refers to adding a printer definition in the $ORACLE_HOME/guicommon6/tk60/admin/uiprint.txt file. This file does not need to be modified. 4. Log in as root and change your working directory to $ORACLE_HOME/orainst. Type root.sh at the UNIX prompt. If the settings are correct, press Enter. Otherwise, exit and reset the variables to the appropriate values and run root.sh again. 5. Enter the pathname for the local bin directory (use /usr/bin) and press Enter. 6. Type Y to continue at the warning about ORACLE_HOME not matching the home directory for the Oracle user oradev6 (these values do not have to match). 7. If your group ID is dba, press Enter at the line prompting for the UNIX group that has DBA permissions. 8. You can now eject/un-mount the CD-ROM. Installing Patch 12 (Oracle patch p2648892_600_SOLARIS.zip)1. Log in as oradev6. 2. Insert the Forms & Reports 6i Patch 12 CD-ROM. 3. Navigate to the /cdrom/6i_patch12 directory. 4. Copy the patch file to the ORACLE_HOME directory cp p* $ORACLE_HOME 5. Navigate to ORACLE_HOME. Unzip the patch file with unzip p2648892_600_SOLARIS.zip This step will create the patch directory under the ORACLE_HOME directory. 6. Navigate to the developer6i_patch12 directory. 7. As oradev6 at a UNIX prompt, start the patch installation process by executing ./patch_install.sh If you want a log file of the installation, execute ./patch_install.sh | & tee patch_install_p12.log 8. As the patch is installed, you will see an Oracle installation window. No action on your part is required. 9. When the installation finishes, re-link the following: cd $ORACLE_HOME/procbuilder60/lib This completes the patch installation process. You can delete the patch zip file to recover some disk space. 10. As the user oradev6, you can test the installation by typing f60runm at the UNIX command line and then see the 'Forms Runtime Options' window. If the 'Forms Runtime Options' window does not appear, check the path statement in the .cshrc file for oradev6. The path should include $ORACLE_HOME/bin.
| ||||||||||||||||||||||||||||||||||||||
|