Call now: 252-767-6166  
Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

 
 


Installation Cookbooks: Installing Oracle Forms & Reports 6i

Expert Oracle Tips by Steve Callan

January 8, 2004

Installation Cookbooks: Installing Oracle Forms & Reports 6i

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 Solaris

Introduction

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

  • "6i" refers to Oracle Forms Developer and Reports Developer Release 6i.
  • oradev6 is the UNIX account owner of the 6i files.
  • oradev6 belongs to two groups - oinstall and dba (dba is the primary group)
  • The home directory created/used for oradev6 is /opt1/ora6i
  • The ORACLE_HOME path used in examples is /opt1/ora6i/app/oracle/product/6.0
  • ORACLE_HOME for oradev6 is separate from any other ORACLE_HOME
  • ORACLE_HOME and the UNIX home directory for oradev6 is not the same thing. The home directory is where oradev6's .cshrc file is located and is the working directory when oradev6 first logs in. ORACLE_HOME refers to the directory path structure where the 6i program files are located.
  • Text in courier, such as "cd $ORACLE_HOME" is text you explicitly type or enter, or identifies explicit values or names, such as the UNIX user "root."
  • <...> = anything between the angle brackets is user-supplied and varies from user to user. "#" represents the UNIX prompt on your workstation.
  • <mnt_pt> is a mount point where the start of the Oracle installation tree begins (e.g., /opt1/ora6i)
  • All instructions to edit a file refer to using a text editor such as vi.
  • A key post-installation task includes installing an Oracle patch for 6i. The instructions for doing this are also covered in this guide. The 2.62GB disk space requirement includes the patch.

System Requirements

 Solaris 8
128MB RAM
CPU that is SPARC-based
Swap space two to four times the size of physical RAM
Sun OpenWindows to display GUI tools
2.62GB of hard disk space
No Sun Motif patches are necessary for Solaris 8 

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:x:104:20002::/opt1/ora6i:/bin/csh

where:

  • 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

dba::20002:oracle9,oradev6
oinstall::20001: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
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="">
$ORACLE_HOME/network/jre11/lib/sparc/native_threads
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.

preamble.txt

Click OK.

/cdrom/oracle/orainst/README.FIRST

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.

Oracle

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.

Confirmation

Click Yes.

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

Result: Success

Post-installation tasks

1. 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
  /usr/bin/lp d<printer name> n $4 $1
else
  /usr/bin/lp d<printer name> n $4 $1

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
make -f ins_procbuilder.mk install

cd $ORACLE_HOME/forms60/lib
make -f ins_forms60w.mk install

cd $ORACLE_HOME/graphics60/lib
make -f ins_graphics60w.mk install

cd $ORACLE_HOME/reports60/lib
make -f ins_reports60w.mk install

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.

 

 
Get the Complete
Oracle SQL Tuning Information 

The landmark book "Advanced Oracle SQL Tuning  The Definitive Reference"  is filled with valuable information on Oracle SQL Tuning. This book includes scripts and tools to hypercharge Oracle 11g performance and you can buy it for 30% off directly from the publisher.

 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright ? 1996 -  2014

All rights reserved by Burleson

Oracle ? is the registered trademark of Oracle Corporation.


 

  
 

 
 
 
 
 

 
 
 
 
 
 
Oracle training Excel
 
Oracle performance tuning software