Companion CD Installation Guide

Companion CD Installation Guide

This guide explains how to install and configure the products available on the Oracle
Database Companion CD for 64-bit Windows. Only the features of Oracle Database
Companion CD for 64-bit Windows software installed on Windows XP Professional
and Windows Server 2003 operating systems are discussed in this guide.

Send Us Your Comments
Oracle Database Companion CD Installation Guide 10g Release 1 (10.1.0.2.0) for
64-Bit Windows
Part No. B13806-02
Oracle welcomes your comments and suggestions on the quality and usefulness of this
publication. Your input is an important part of the information used for revision.
■ Did you find any errors?
■ Is the information clearly presented?
■ Do you need more information? If so, where?
■ Are the examples correct? Do you need more examples?
■ What features did you like most about this manual?
If you find any errors or have any other suggestions for improvement, please indicate
the title and part number of the documentation and the chapter, section, and page
number (if available). You can send comments to us in the following ways:
■ Electronic mail: ntdoc_us@oracle.com
■ FAX: (650) 506-7357. Attn: Oracle Database for Windows Documentation
■ Postal service:
Oracle Corporation
Oracle Database for Windows Documentation Manager
500 Oracle Parkway, Mailstop 1op46
Redwood Shores, CA 94065
USA
If you would like a reply, please give your name, address, telephone number, and
electronic mail address (optional).
If you have problems with the software, please contact your local Oracle Support
Services.
vii

Documentation Accessibility
Our goal is to make Oracle products, services, and supporting documentation
accessible, with good usability, to the disabled community. To that end, our
documentation includes features that make information available to users of assistive
technology. This documentation is available in HTML format, and contains markup to
facilitate access by the disabled community. Standards will continue to evolve over
time, and Oracle is actively engaged with other market-leading technology vendors to
address technical obstacles so that our documentation can be accessible to all of our
customers. For additional information, visit the Oracle Accessibility Program Web site
at
http://www.oracle.com/accessibility/
Accessibility of Links to External Web Sites in Documentation
This documentation may contain links to Web sites of other companies or
organizations that Oracle does not own or control. Oracle neither evaluates nor makes
any representations regarding the accessibility of these Web sites.
Structure
This document contains:
Chapter 1, "Oracle Database Companion CD Installation Overview"
Provides an overview of the products available on the Oracle Database Companion
CD and describes issues that you must consider before installing the products.
Chapter 2, "Oracle Database Companion CD Requirements"
Describes the requirements for installing the products available on the Oracle
Database Companion CD.
Chapter 3, "Installing the Oracle Database Companion CD Software"
Describes how to start Oracle Universal Installer and install the products available on
the Oracle Database Companion CD.
Chapter 4, "Oracle Database Companion CD Postinstallation Tasks"
Describes tasks that you might need to complete after you install the software.
Appendix A, "Oracle Database Companion CD Advanced Installation Topics"
Describes how to install the Oracle Database Companion CD products by using
response files. This appendix also describes how to run Oracle Universal Installer and
use Oracle components in different languages.
Appendix B, "Oracle Database Companion CD Troubleshooting"
Contains information on troubleshooting installation issues.
x

Related Documents
For more information, see these Oracle resources:
■ Oracle Database Release Notes for Windows
■ Oracle Database Installation Guide for Windows
■ Oracle Database Client Installation Guide for Windows
■ Oracle Database Concepts
For information about Oracle error messages, see Oracle Database Error Messages.
Oracle error message documentation is available only in HTML. If you only have
access to the Oracle Documentation CD, you can browse the error messages by range.
Once you find the specific range, use your browser's "find in page" feature to locate the
specific message. When connected to the Internet, you can search for a specific error
message using the error message search feature of the Oracle online documentation.
Many of the examples in this book use the sample schemas, which are installed by
default when you select the Basic Installation option with an Oracle Database
installation. Refer to Oracle Database Sample Schemas for information on how these
schemas were created and how you can use them yourself.
Printed documentation is available for sale in the Oracle Store at
http://oraclestore.oracle.com/
To download free release notes, installation documentation, white papers, or other
collateral, please visit the Oracle Technology Network (OTN). You must register online
before using OTN; registration is free and can be done at
http://otn.oracle.com/membership/
If you already have a username and password for OTN, then you can go directly to the
documentation section of the OTN Web site at
http://otn.oracle.com/documentation/
Conventions
This section describes the conventions used in the text and code examples of this
documentation set. It describes:
■ Conventions in Text
■ Conventions in Code Examples
■ Conventions for Windows Operating Systems
Conventions in Text
We use various conventions in text to help you more quickly identify special terms.
The following table describes those conventions and provides examples of their use.
Convention Meaning Example
Bold Bold typeface indicates terms that are When you specify this clause, you create an
defined in the text or terms that appear in a index-organized table.
glossary, or both.
Italics Italic typeface indicates book titles or Oracle Database Concepts
emphasis.
Ensure that the recovery catalog and target
database do not reside on the same disk.
xi

Convention Meaning Example
UPPERCASE Uppercase monospace typeface indicates You can specify this clause only for a NUMBER
monospace elements supplied by the system. Such column.
(fixed-width) elements include parameters, privileges,
You can back up the database by using the
font datatypes, Oracle Recovery Manager
BACKUP command.
keywords, SQL keywords, SQL*Plus or
utility commands, packages and methods, Query the TABLE_NAME column in the
as well as system-supplied column names, USER_TABLES data dictionary view.
database objects and structures,
Use the DBMS_STATS.GENERATE_STATS
usernames, and roles.
procedure.
lowercase Lowercase monospace typeface indicates Enter sqlplus to start SQL*Plus.
monospace executable programs, filenames, directory
The password is specified in the orapwd file.
(fixed-width) names, and sample user-supplied
font elements. Such elements include computer Back up the datafiles and control files in the
and database names, net service names /disk1/oracle/dbs directory.
and connect identifiers, user-supplied
The department_id, department_name, and
database objects and structures, column
location_id columns are in the
names, packages and classes, usernames
hr.departments table.
and roles, program units, and parameter
values. Set the QUERY_REWRITE_ENABLED initialization
parameter to true.
Note: Some programmatic elements use a
mixture of UPPERCASE and lowercase. Connect as oe user.
Enter these elements as shown.
The JRepUtil class implements these methods.
lowercase Lowercase italic monospace font represents You can specify the parallel_clause.
italic placeholders or variables.
Run old_release.SQL where old_release
monospace
refers to the release you installed prior to
(fixed-width)
upgrading.
font
Conventions in Code Examples
Code examples illustrate SQL, PL/SQL, SQL*Plus, or other command-line statements.
They are displayed in a monospace (fixed-width) font and separated from normal text
as shown in this example:
SELECT username FROM dba_users WHERE username = 'MIGRATE';
The following table describes typographic conventions used in code examples and
provides examples of their use.
Convention Meaning Example
[ ] Anything enclosed in brackets is optional. DECIMAL (digits [ , precision ])
{ } Braces are used for grouping items. {ENABLE | DISABLE}
| A vertical bar represents a choice of two {ENABLE | DISABLE}
options. [COMPRESS | NOCOMPRESS]
... Ellipsis points mean repetition in syntax CREATE TABLE ... AS subquery;
descriptions.
In addition, ellipsis points can mean an SELECT col1, col2, ... , coln FROM
omission in code examples or text. employees;
Other symbols You must use symbols other than brackets acctbal NUMBER(11,2);
([ ]), braces ({ }), vertical bars (|), and acct CONSTANT NUMBER(4) := 3;
ellipsis points (...) exactly as shown.
Italics Italicized text indicates placeholders or CONNECT SYSTEM/system_password
variables for which you must supply DB_NAME = database_name
particular values.
xii

Convention Meaning Example
UPPERCASE Uppercase typeface indicates elements SELECT last_name, employee_id FROM
supplied by the system. We show these employees;
terms in uppercase in order to distinguish SELECT * FROM USER_TABLES;
them from terms you define. Unless terms DROP TABLE hr.employees;
appear in brackets, enter them in the order
and with the spelling shown. Because these
terms are not case sensitive, you can use
them in either UPPERCASE or lowercase.
lowercase Lowercase typeface indicates user-defined SELECT last_name, employee_id FROM
programmatic elements, such as names of employees;
tables, columns, or files. sqlplus hr/hr
Note: Some programmatic elements use a CREATE USER mjones IDENTIFIED BY ty3MU9;
mixture of UPPERCASE and lowercase.
Enter these elements as shown.
Conventions for Windows Operating Systems
The following table describes conventions for Windows operating systems and
provides examples of their use.
Convention Meaning Example
From the Start How to start a program. From the Start menu, select Programs, then
menu, select Oracle - HOME_NAME, then Configuration and
menu_item Management Tools, then Database
Configuration Assistant.
File and directory File and directory names are not case c:\WINDOWS"\"system32 is the same as
names sensitive. The following special characters C:\WINDOWS\SYSTEM32
are not allowed: left angle bracket (), colon (:), double
quotation marks ("), slash (/), pipe (|), and
dash (-). The special character backslash (\)
is treated as an element separator, even
when it appears in quotes. If the filename
begins with \\, then Windows assumes it
uses the Universal Naming Convention.
C:\> Represents the Windows command C:\oracle\oradata>
prompt of the current hard disk drive. The
escape character in a command prompt is
the caret (^). Your prompt reflects the
subdirectory in which you are working.
Referred to as the command prompt in this
manual.
Special characters The backslash (\) special character is C:\>exp HR/HR TABLES=employees
sometimes required as an escape character QUERY=\"WHERE job_id=’SA_REP’ and
for the double quotation mark (") special salary

Convention Meaning Example
ORACLE_HOME This release complies with Optimal Go to the
and Flexible Architecture (OFA) guidelines. All ORACLE_BASE\ORACLE_HOME\rdbms\admin
ORACLE_BASE subdirectories are not under a top level directory.
ORACLE_HOME directory. There is a top
level directory called ORACLE_BASE that
by default is
C:\oracle\product\10.1.0. If you
install the latest Oracle release on a
computer with no other Oracle software
installed, then the default setting for the
first Oracle home directory is
C:\oracle\product\10.1.0\db_n,
where n is the latest Oracle home number.
The Oracle home directory is located
directly under ORACLE_BASE.
All directory path examples in this guide
follow OFA conventions.
Refer to the Oracle Database Installation
Guide for Windows for additional
information about OFA compliances and
for information about installing Oracle
products in non-OFA compliant
directories.
xiv

1
Oracle Database Companion CD
Installation Overview
This chapter provides an overview of the products available on the Oracle Database
Companion CD and describes issues to consider before you install the products.
This chapter contains these topics:
■ Overview of the Installation Process
■ Products Available in the Oracle Database 10g Products Installation Type
■ Products Available in the Oracle Database 10g Companion Products Installation
Type
Overview of the Installation Process
The installation process consists of four parts:
1. Plan your installation: This chapter describes the products in the two installation
types that you can install and provides information that you must understand
before installing the software. The installation types are the Oracle Database 10g
Products and the Oracle Database 10g Companion Products.
2. Verify system requirements: Chapter 2, "Oracle Database Companion CD
Requirements" describes the minimum requirements that your system must meet
before you install the software.
3. Install the software: Use the following sections to install the Oracle Database
Companion CD products:
■ Chapter 3, "Installing the Oracle Database Companion CD Software" describes
how to use Oracle Universal Installer to install the software.
■ Appendix A describes how to install Java Access Bridge, which enables the
use of a screen reader with Oracle components.
■ Appendix A describes advanced installation topics: performing noninteractive
(silent) installations and how to install and use Oracle components in different
languages.
■ Appendix B provides installation troubleshooting advice.
4. Complete postinstallation tasks: Chapter 4, "Oracle Database Companion CD
Postinstallation Tasks" describes recommended and required postinstallation
tasks.
Oracle Database Companion CD Installation Overview 1-1

Products Available in the Oracle Database 10g Products Installation Type
Products Available in the Oracle Database 10g Products Installation Type
The following sections describe the products that are installed by the Oracle Database
10g Products installation type. You must install these products in an existing Oracle
Database release 1 (10.1) Oracle home:
■ Oracle Database Examples
■ JPublisher
■ Legato Single Server Version
■ Natively Compiled Java Libraries
■ Oracle Text Supplied Knowledge Bases
Oracle Database Examples
Oracle Database Examples include a variety of examples and product demonstrations
that you can use to learn about the products, options, and features of Oracle Database.
Many of these examples are designed to work with the Sample Schemas which you
can optionally install in any Oracle database. Many of the documents in the Oracle
Documentation Library use the example programs and scripts provided with the
Oracle Database Examples.
Required Products
Before you can use the Oracle Database Examples, you must install the Sample
Schemas into an Oracle database. When you install Oracle Database, or use Database
Configuration Assistant (DBCA) to create a new database, you can choose to include
the Sample Schemas when you create the database. You can also manually install the
Sample Schemas into an existing database.
See Also: Oracle Database Sample Schemas for information about
manually installing the Sample Schemas into an existing database
JPublisher
JPublisher is a Java utility that generates Java classes to represent the following
user-defined database entities a the Java program:
■ SQL object types
■ Object reference types (REF types)
■ SQL collection types (VARRAY types or nested table types)
■ PL/SQL packages
■ Server-side Java classes
■ SQL queries and DML statements
You can use JPublisher to specify and customize the mapping of SQL object types,
object reference types, and collection types (VARRAYs or nested tables) to Java classes
in a strongly typed paradigm.
JPublisher also can generate classes for PL/SQL packages. These classes have wrapper
methods to invoke the stored procedures in the PL/SQL packages.
In addition, JPublisher simplifies access to PL/SQL-only types from Java. You can
employ predefined or user-defined mappings between PL/SQL and SQL types, as
well as use PL/SQL conversion functions between such types. With such type
1-2 Oracle Database Companion CD Installation Guide

Products Available in the Oracle Database 10g Products Installation Type
correspondences in place, JPublisher can automatically generate the required Java and
PL/SQL code.
In a similar way that SQL or PL/SQL entities publish to Java, you can publish
server-side Java classes to client-side Java classes. Doing this enables applications to
make direct calls to Java classes in the database.
JPublisher lets you expose generated Java classes as Web services, for example. You
can publish either SQL or PL/SQL entities or server-side Java entities.
JPublisher uses SQLJ code in most Java classes that it generates, so it includes Oracle
SQLJ Translator and Oracle SQLJ Runtime. Oracle SQLJ is a standard way to embed
SQL statements in Java programs.
Oracle SQLJ Translator
Because JPublisher uses SQLJ code in its generated classes, it automatically invokes the
Oracle SQLJ translator during the code generation process, as necessary. The translator
converts embedded SQL statements into JDBC calls.
Oracle SQLJ Runtime
Oracle SQLJ Runtime is used during program execution to execute most classes that
were generated by JPublisher. SQLJ Runtime is a thin layer of pure Java code that runs
above the JDBC driver. It acts as an intermediary that reads information about SQL
operations and passing instructions along to the JDBC driver.
See Also: Oracle Database JPublisher User's Guide
Legato Single Server Version
Legato Single Server Version (LSSV) is a backup and recovery application developed
by Legato Systems, Inc. LSSV is a subset of Legato NetWorker and Legato NetWorker
Module for Oracle products. You can use it to back up and restore Oracle data on a
single server only. It lets you perform online or offline backups of Oracle data stored
on file systems, Automatic Storage Manager disk groups, or raw devices.
LSSV software includes a media management layer. The Oracle Recovery Manager
(RMAN) requires this layer when using tape storage for database backups and
restoration. LSSV manages the backup schedule and communicates with Oracle
Recovery Manager (RMAN) to copy the Oracle data to tape.
Because Legato Single Server Version works in conjunction with Oracle Database for
Oracle data storage management, you must install Legato Single Server Version on the
same system as Oracle Database. The Legato Single Server Version and Oracle
Database software components provide a storage management solution for Oracle
Database data.
The Legato Single Server Version Administrator program has a graphical user
interface for administering the Legato Single Server Version configuration. The
Administrator program is installed during the Legato Single Server Version
installation on the Oracle Server system.
To fully install and configure Legato Single Server Version, you must complete the
following tasks:
1. Remove Legato Storage Manager or Legato Networker if they are installed.
2. Verify that the required software and hardware is available.
3. Install the Legato Single Server Version in the same Oracle home directory as
Oracle Database.
Oracle Database Companion CD Installation Overview 1-3

Products Available in the Oracle Database 10g Companion Products Installation Type
4. Complete postinstallation steps.
See Also: Legato Single Server Version Installation Guide, release 6.1 or
the Legato documentation available on the Legato Web site:
http://www.legato.com/LSSV
Natively Compiled Java Libraries
The Oracle Database 10g Products installation type installs JAccelerator and Oracle
interMedia Image Accelerator which contains the natively compiled Java libraries
(NCOMPs) for Oracle JVM and Oracle interMedia. These libraries are required to
improve the performance of these products on your platform.
Oracle Text Supplied Knowledge Bases
The Oracle Database 10g Products installation type installs two Oracle Text knowledge
bases, English and French. You can extend the supplied knowledge bases depending
on your requirements. Alternatively, you can create your own knowledge bases, in
languages other than English and French.
See Also: Oracle Text Reference for more information about creating
and extending knowledge bases
Products Available in the Oracle Database 10g Companion Products
Installation Type
The following sections describe the products that you can install with the Oracle
Database 10g Companion Products installation type:
■ Oracle HTTP Server
■ Oracle HTML DB
Oracle HTTP Server
Oracle HTTP Server is a Web server that is based on Apache HTTP Server version
1.3.28. Use the Oracle Database 10g Companion Products installation type to install
Oracle HTTP Server in a new Oracle home. This standalone release of Oracle HTTP
Server provides the following features:
■ A robust and reliable Web server that you can use to serve Web pages
■ Support for Perl and Fast CGI scripts using mod_perl and mod_fastcgi
■ Support for PL/SQL applications using mod_plsql
■ High-availability, through the use of Oracle Process Manager and Notification
server (OPMN)
OPMN monitors Oracle HTTP Server processes and restarts them if they fail.
■ Support for secure transactions using secure socket layer (SSL)
■ Single sign-on capabilities using mod_osso
To enable single sign-on, you must use Oracle HTTP Server in conjunction with
Oracle Internet Directory and Single Sign-On Server, both of which are available
with Oracle Application Server 10g.
■ Many standard Apache modules, in addition to modules provided by Oracle
1-4 Oracle Database Companion CD Installation Guide

Products Available in the Oracle Database 10g Companion Products Installation Type
See Also: Oracle Application Server Installation Guide for more
information on Oracle Internet Directory and Single Sign-On Server
Where to Install Oracle HTTP Server
You must install Oracle HTTP Server in a new Oracle home directory. You can install
Oracle HTTP Server more than once on the same system, as long as each installation
uses a separate Oracle home directory.
Oracle HTML DB
Oracle HTML DB is a hosted development environment that enables
non-programmers to create database-centric Web applications. It provides developers
with the productivity of a desktop database, but with the security, reliability, and
performance of the Oracle database. Any information technology organization can
host Oracle HTML DB environments for departments in the company that do not have
Oracle development skills available.
Where to Install Oracle HTML DB
Oracle HTML DB must have access to
You can install Oracle HTML DB with Oracle HTTP Server in a new Oracle home
directory. Alternatively, you can install this product in an existing Oracle HTTP Server
Oracle home that contains Oracle HTTP Server with mod_plsql. The Oracle home
directory for Oracle HTTP Server 10g meets this requirement.
Oracle Database Companion CD Installation Overview 1-5