Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Mar 11, 2004

Installation Cookbook: Installing Oracle Application Server 10g (9.0.4)Forms and Reports Services - Page 3

By Steve Callan

Operating System and Hardware Requirements

The table shown below is a summary of the requirements shown in Oracle's installation guide. Oracle's installation guide contains several errors, and the differences are noted below.



IP address

Must be static, do not use DHCP

Processor type/CPU

A SPARC v9 processor. The output from /usr/bin/psrinfo -v will reflect sparcv9 if this requirement is met.

Processor speed

Oracle states a 300MHz requirement, but the installer only checks for >250MHz. /usr/bin/psrinfo -v will also show the processor speed.


512MB, can be checked via /usr/sbin/prtconf | grep Memory

Disk Space

1GB on a single partition, but just under 800MB is used after installation is complete. Checked by using df -k.

Space in /tmp

Oracle states 256MB, but the installer only checks for >150MB. You can also set and use a TMP environment variable if /tmp does not have enough space (can be checked using df -k /tmp).

Swap space

Oracle states 640MB, but the installer may check for a higher value (such as >1536MB on a 768MB RAM machine), can be checked using

/usr/sbin/swap -s. If you need to add more space, create a swapfile and add it to the system using the mkfile and swap -a commands.


256 color viewing capability, which can be checked using /usr/openwin/bin/xwininfo (look for an "8" in the "Depth" line)

Operating system

Solaris 8 or 9, checked via uname -r (look for 5.8 or 5.9)

Download and install the latest Sun OS and J2SE patch clusters (e.g., 9_Recommended.zip and J2SE Solaris 9) at


Operating system patches

Solaris 8 has an extensive list of patches, whereas Oracle states no patches are required for Solaris 9. However, the installer checks for two patches on Solaris 9 (113096-03 and 112705-26, or higher). Installing the latest recommended OS patch cluster will ensure the patch level requirement is met (see page 5-3 in the installation guide for Solaris 8 patches). Installed patches can be viewed/checked using the showrev -a command (you can grep for a patch or pipe the output to a file for viewing with a text editor).

Operating system packages

The following packages must be installed (these typically are installed with most OS installations), and can be checked using pkginfo name.

SUNWarc SUNWbtool SUNWhea SUNWlibm

SUNWlibms SUNWsprot SUNWsprox SUNWtoo

SUNWi1of SUNWxwfnt SUNWi1cs* SUNWi15cs*

See the script and the end of this guide you can use to check for package info. (*=required for the ISO8859-1 & ISO8859-15 codesets)

NOTE: If using Solaris 8, the version of Java (java -version at a UNIX prompt shows the current version) found in the /usr directory needs to be upgraded to at least 1.3.1 (Solaris 8 installs with version 1.2). Instructions for this are covered here . Sun recommends you install 1.4.2, but 1.3.1 is still available. Solaris 9 ships with 1.4.0, and no upgrade is needed.

General Information

Required software

If the software is not shipped to you, you can download the software at http://otn.oracle.com/software/products/forms/index.html. Select "Oracle Application Server Forms and Reports Services 10g ( for Solaris Operating System (SPARC)." Follow the instructions to extract the downloaded file.

Environment variables

The sample C-shell resource (.cshrc) file at the end of this guide shows a list of environment variables that need to be set prior to starting the installation.

Your forms can be distributed anywhere on the UNIX or network file system, and in more than one location. The only permissions requirement is that the fmx files are accessible by the forms services.

Note about setting the DISPLAY environment variable
The DISPLAY environment variable must be set to the server where 10gAS is being installed. If you use the sample C-shell resource file at the end of this guide, enter the host name as appropriate when editing the file. As the user ias, verify that you can see GUI displays by running /usr/dt/openwin/xclock. If you see a clock appear on the screen, enter Control-C to kill the process. If you receive an error message, exit the shell and return to a shell window as the UNIX account owner who initially logged on to the machine. Enter xhost + at the command line, then become ias again and attempt to run xclock. Once you are able to see the clock, you are ready to insert the CD-ROM and start the installation.

Setting ports

If the target machine for this installation is a typical machine (current OS, latest patches applied, no other third party web server applications running on it), then there is nothing you have to do with respect to the /etc/services file in terms of assigning port numbers. Oracle will reserve and assign the ports it needs. Otherwise, refer to chapter 3 of the installation guide for information about configuring ports.

Oracle Archives

Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM