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 Jan 8, 2004

Installation Cookbooks: Installing Oracle Forms & Reports 6i - Page 3

By Steve Callan

Files edited or modified by the UNIX users root and oradev6

The 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 is the name of the Oracle user
  • x is related to a password value
  • 104 is the userid of this UNIX account
  • 20002 is the primary group ID to which oradev6 belongs
  • /opt1/ora6i is the home directory (where .cshrc for oradev6 is located)
  • /bin/csh is the default startup shell.

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


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
	chown oradev6:dba /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>
	setenv ORACLE_SID <name of a database>

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
	setenv DISPLAY <machinename>:0.0
	setenv ORACLE_TERM sun5
	setenv ORACLE_SID <database name> 
	setenv ORACLE_BASE /<mount point>/app/oracle
	setenv ORACLE_HOME $ORACLE_BASE/product/6.0
	setenv TNS_ADMIN <as stated in the previous step>
	setenv LD_LIBRARY_PATH $ORACLE_HOME/lib: <img src="/img/return.gif" width=14 height=9 border=0 alt="">
	setenv ORACLE_AUTOREG $ORACLE_HOME/guicommon6/tk60/admin
	setenv TK_PRINT_STATUS 'echo %n is valid'
	setenv TK_PRINTER <enter printer name>
	setenv PATH <should include $ORACLE_PATH, /usr/ccs/bin, 
	             /usr/bin, /etc, /usr/openwin, /usr/local/bin and .> 

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 installation

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

Window Name

Action to take

Install Type

Select Default Install. Click OK.


Click OK.


Click OK.

Installation Activity Choice

Select Install, Upgrade, or De-Install Software (the first button). Click OK.

Installation Options

Select Install New Product - Do Not Create DB Objects (second item in the list). Click OK.

Environment Variables

Confirm the paths for ORACLE_BASE and ORACLE_HOME. Click OK.

/<ORACLE_HOME path>/orainst/defaults

Click OK.

Software Asset Manager

Highlight/select the following in the "Products available" list box on the left side of the window:


Oracle Forms Server and Forms Developer

Oracle Reports Server and Reports Developer


Single-click on each item. After BOTH have been selected, Click Install.

X Libraries

Verify the path for the files shown. Click OK.

Motif Library

Verify the path for the file shown. Click OK.

GUI Choice

Select Motif Bitmapped Interface. Click OK.

Component Selection

De-select Forms Server for Web deployment and select Motif Bitmapped Interface. Click OK.

Component Selection

(same title appears again)

De-select Reports Multitier Server for Web deployment and select Motif Bitmapped Interface. Click OK.


Progress bar appears. Wait for next window to appear (>>20 minutes).

Installer Actions Completed

Ignore instructions to run root.sh (you will do this later). Click OK.

Software Asset Manager

Installed components appear in the right pane. Click Exit.


Click Yes.

The command line in the UNIX window where you initiated orainst should show

	Result: Success

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