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 5

By Steve Callan

Post-installation steps

Testing the installation

On any PC in your network, you should be able to see the following welcome screen when using this URL address - http://hostname:7778 - where hostname is the name of machine where 10gAS is installed

Test the installation by connecting to the Application Server's Enterprise Manager web page using the following URL: http://hostname:1810.

After entering the password for ias_admin, you should see a window similar to the one shown below.

Configuring Forms Services files

In $ORACLE_HOME/forms90/server, edit the formsweb.cfg and default.env files to customize your setup. There are countless ways to configure your forms environment, so here is an example where a master form is used to call child forms. The following assumptions are used: a user must log on at the beginning of a browser session, and all forms are located in a common directory.

In the formsweb.cfg file, make the following changes in the USER PARAMETERS section:

1) Runform arguments, "form=" line: enter the name of your master form (e.g., master_menu.fmx). Leave "userid=" commented out to force the user logon process.

2) Values for the Forms applet parameters, width and height values can be adjusted to size the applet window that appears on the web page. "lookAndFeel" can be Oracle or Windows.

In the default.env file, add the location where your 9i/10g forms are located to the FORMS90_PATH variable (e.g., /opt1/ias10g/forms).

Add database/instance information to the 10gAS tnsnames.ora file

In the $ORACLE_HOME/network/admin directory, edit the tnsnames.ora file and include the descriptor information for each database you want users to be able to access via forms on the web.

Viewing Forms on the Web

To view your forms on the web, use the following URL, where hostname is the name of the host where you installed 10gAS. This will prompt users for logon information, and then call your master form by default.


To view a specific form available in the FORMS90_PATH

To view the test.fmx form that ships with 10gAS, as an example of a specific form to launch, and assuming you have this form available in one the directories specified in FORMS90_PATH, use the following URL:

	http://hostname:7778/forms90/f90servlet?form=test (add "?form=form_name" after f90servlet)

Starting and stopping the Application Server

To start the instance (after a reboot, power outage, etc.), two commands need to be issued at the command line interface (UNIX prompt). As the user ias, issue the following commands:

	ias@hostname: $ORACLE_HOME/opmn/bin/opmnctl startall 
	ias@hostname: $ORACLE_HOME//bin/emctl start iasconsole

To stop the instance:

	ias@hostname: $ORACLE_HOME//bin/emctl stop iasconsole 
	ias@hostname: $ORACLE_HOME/opmn/bin/opmnctl stopall

Reference: Chapter 3, Starting and Stopping, Oracle Application Server 10g Administrators Guide (starting and stopping a middle-tier instance).

Sample .cshrc file

umask 022
set filec
stty erase ^H
setenv DISPLAY your_host_name:0.0
setenv ORACLE_TERM sun5
setenv LPDEST your_printer_name
setenv PRINTER your_printer_name
setenv TMP /tmp

set path=( /usr/bin /usr/dt/bin /usr/openwin/bin /usr/sbin )
set path=( $path /usr/ccs/bin /usr/ucb /etc /usr/local/bin . )

# Next variable is used for Netscape browsers
setenv NPX_PLUGIN_PATH /usr/j2se/jre/plugin/sparc/ns4

setenv FORMS90_PATH /path_to_where_your_forms_are_located

if ( $?prompt ) then
  set history=50              # previous commands to remember.
  set savehist=10             # number to save across sessions.
  set system=`uname -n`       # name of this system.
  set prompt = "$USER"@"$system":"{!} "
  set ignoreeof noclobber
  unset autologout

UNIX script to check packages

Copy this script into a file and save as pkg_info.sh on your UNIX file system. Make the file executable with chmod 755 pkg_info.sh and run at the command line interface. Output will look like

system 	package_name	description_of_package

pkginfo SUNWarc;
pkginfo SUNWbtool;	
pkginfo SUNWhea;
pkginfo SUNWlibm;
pkginfo SUNWlibms;	
pkginfo SUNWsprot;	
pkginfo SUNWsprox;	
pkginfo SUNWtoo;
pkginfo SUNWi1of;	
pkginfo SUNWxwfnt;	
pkginfo SUNWi1cs;	
pkginfo SUNWi15cs;

» See All Articles by Columnist Steve Callan

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