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

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

By submitting your information, you agree that databasejournal.com may send you databasejournal offers via email, phone and text message, as well as email offers about other products and services that databasejournal believes may be of interest to you. databasejournal will process your information in accordance with the Quinstreet Privacy Policy.

News Via RSS Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Feb 12, 2004

Installation Cookbooks: Installing Oracle9i Developer Suite - Page 4

By Steve Callan

Post-installation Tasks

Enable Java in the target/source database that 9i forms will access. This can be accomplished by running $ORACLE_HOME/javavm/install/initjvm as the user sys. In an Oracle9i database as the user sys, connect as sysdba and run the script. The process may appear to hang part way through, but allow the script to run its course.

Returning to where iDS is installed and logging in as ids, navigate to the $ORACLE_HOME/dbs directory. The following scripts must be run as system in the target database. Connect as system in your target database and issue the following commands at the SQL*Plus prompt:

SQL> @dejavins (may be prompted for the system password and service name)
SQL> @dejavaux (another prompt)
SQL> @derefls.plb (no prompt)
SQL> @dereflb.plb (no prompt)

Exit SQL*Plus.

Load a Java archive file using the loadjava utility. In the same directory, issue the following command at the UNIX prompt, supplying the password for system and the service name as appropriate:

ids@sun5: loadjava -user system/system_password@SID dedbjava.jar

Starting and stopping OC4J instances for Forms Developer

In the $ORACLE_HOME/j2ee/Oracle9iDS directory, you can use the startinst.sh and stopinst.sh scripts to start and stop Forms Services. Test your installation by stopping and starting the services.

If your installation was successful, you should be able to start Internet Explorer on a networked PC, enter the URL shown below and see the image below. The host name is the name of the UNIX node or host where you installed iDS (substitute your host name for "hostname" in the example below). If you are prompted to install Oracle JInitiator, follow the instructions to do so (it is a one-time step or process).

http://hostname:8888/forms90/l90servlet ("L" 90servlet, not "one" 90servlet)

Configuring Forms Services files

In $ORACLE_HOME/forms90/server, there are two files you must edit: formsweb.cfg and default.env. There are countless ways to configure your forms environment, and this guide will provide 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., form_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 locations where your 9i forms are located to the FORMS90_PATH variable.

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


You can view related information about Oracle9iAS and run some test samples at


Troubleshooting Forms Services Problems

Error: Error 404 Page not found
Problem: http://hostname:8888/forms90/f90servlet and /l90servlet return an error about page not found, but http://hostname:8888 shows a page with links to Sun documentation.

Description: During the installation of your Solaris operating system, a documentation server (AnswerBook2) from Sun may have been installed. AnswerBook2 uses a web-browser interface that enables you to view and print a variety of Sun information, including SGML-based AnswerBook(TM) collections, Display PostScript(TM) AnswerBook collections and man pages.

Resolution: The documentation server needs to be stopped by using the following command:

/usr/lib/ab2/bin/ab2admin -o stop

AnswerBook2 is probably configured to start during system startup. You can stop the automatic start of AnswerBook2 by altering the /etc/init.d/ab2mgr script or the /etc/rc2.d/SXXab2mgr script.

Error: hostname does not exist, cannot connect to the server (or variation thereof)
Problem: The startinst.sh command created a process, but the browser cannot connect to the host.

Description: If Oracle9iDS was installed after other Oracle products, the JRE link in the ORACLE_HOME directory may be pointing to a version other than 1.1.8.

Resolution: Re-create the link by pointing it to the jre directory in ORACLE_HOME for Oracle9iDS. An alternative approach is to reinstall Oracle9iDS and make the installer think iDS is the first and only Oracle product on the server. As root, rename oraInst.loc in /var/opt/oracle and let the installer create a new oraInst.loc file. Before using the Oracle Universal Installer utility to de-install or perform administrative tasks on the other existing Oracle products, swap the oraInst.loc files in /var/opt/oracle so the installer will be able to find the oraInventory directory previously established for those products.

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 . )

# Setup for Oracle Optimal Flexible Architecture (OFA) compliance
setenv ORACLE_BASE /opt1/ora9ids/app/oracle
setenv ORACLE_HOME $ORACLE_BASE/product/9.0.2
# change this path for your location
setenv TNS_ADMIN $ORACLE_HOME/network/admin
# Append the path
set path=( $path $ORACLE_PATH )
setenv NPX_PLUGIN_PATH /usr/j2se/jre/plugin/sparc/ns4
# shortcut environment variables used to save space
setenv OHJ $ORACLE_HOME/jlib
setenv OHF $ORACLE_HOME/forms90/java
setenv JDK $ORACLE_HOME/jdk
setenv FORMS90_PATH /path_to_where_your_forms_are_located
NOTE: Each of these is one line; shown this way for formatting purposes
setenv FORMS90_BUILDER_CLASSPATH $OHJ/importer.jar:$OHJ/debugger.jar:$OHJ/utj90.jar:$OHJ/dfc90.jar:
$OHJ/help3.jar:$OHJ/help3-nls.jar:$OHJ/oracle_ice5.jar:$OHJ/ewt3.jar: $OHJ/share.jar
setenv FORMS90_CLASSPATH $OHJ/importer.jar:$OHJ/debugger.jar:$OHJ/utj90.jar:$OHJ/share.jar
setenv REPORTS_CLASSPATH $OHJ/importer.jar:$OHJ/debugger.jar:$OHJ/utj90.jar:$OHJ/share.jar
setenv CLASSPATH $OHJ:$ORACLE_HOME/lib:$ORACLE_HOME/javavm/lib:$ORACLE_HOME/sqlj/lib:

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
  alias h    history
  alias fstop  '$ORACLE_HOME/j2ee/Oracle9iDS/stopinst.sh'
  alias fstart '$ORACLE_HOME/j2ee/Oracle9iDS/startinst.sh'

» See All Articles by Columnist Steve Callan

Oracle Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.



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