|Oracle® Database Companion CD Installation Guide
10g Release 2 (10.2) for Linux x86
|PDF · Mobi · ePub|
This chapter provides an overview of the products available on the Oracle Database Companion CD installation media and describes issues that you must consider before installing them. It includes the following sections:
The installation process consists of the following steps:
Read the release notes: Read Oracle Database Release Notes for Linux x86-64 before you begin the installation. The release notes are available with the platform-specific documentation. The latest version of the release notes is available on Oracle Technology Network at
Plan the installation: This chapter describes the products that you can install and provides information that you must know before installing the software.
See Also:The "Frequently Asked Questions About Installation" appendix of Oracle Database Installation Guide for Linux x86-64 for information about the best way to install Oracle products depending on the requirements of your site
Verify system requirements: Chapter 2 describes the minimum system requirements for installing Companion CD products.
Installing the software: The following chapter and appendixes provide information about installing Companion CD products:
Getting started on using the Companion CD products: Chapter 5 provides information about using the Companion CD products.
The following sections describe the products available in the Oracle HTML DB installation type:
Note:The Summary screen of Oracle Universal Installer provides a detailed list of the products available in the Oracle HTML DB installation type.
Oracle HTML DB is a tool for rapid development and deployment of Web applications on an Oracle Database installation. It provides the productivity benefits of a desktop database, and the security, reliability, and performance of Oracle Database. With little programming or scripting and only a Web browser, you can build reporting and data entry applications on existing tables, views, or data imported from spreadsheets.
You can install Oracle HTML DB with Oracle HTTP Server in a new Oracle home. Alternatively, you can install this product in an existing Oracle home that contains Oracle HTTP Server, which you installed from the installation media. If you have an existing Oracle HTML DB installation, then this installation is upgraded to the current release of Oracle HTML DB. Do not install Oracle HTML DB in any other Oracle HTTP Server Oracle home.
Note:Installations of Oracle HTML DB in other Oracle homes that may include Oracle HTTP Server are not supported.
Note:If you are installing Oracle Workflow middle-tier components, then Oracle HTTP Server is available in the Oracle Database 10g Companion Products installation type.
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
OPMN monitors Oracle HTTP Server processes and restarts them if they fail.
Support for secure transactions using Secure Sockets Layer (SSL)
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
See Also:Oracle Application Server Installation Guide for more information about Oracle Internet Directory and Single Sign-On Server
The following are the differences between the standalone version of Oracle HTTP Server and the version shipped with other releases of Oracle software:
Oracle9i release 2 or earlier, and Oracle9iAS release 1
Apache JServ is not shipped with this release of Oracle HTTP Server, nor does this release support Apache JServ. Because Apache JServ is not supported, the
mod_oprocmgr module is not loaded in the default configuration.
"Step 9: Migrating Your Server Certificate and Private Key" for more information about migrating SSL certificates to the format required by
"Enabling the High Availability Features of Oracle HTTP Server" for more information about using OPMN
Oracle9iAS release 2 or later
You cannot configure the standalone release of Oracle HTTP Server in an Oracle9iAS or Oracle Application Server 10g cluster.
You cannot use the Oracle Enterprise Manager Application Server Control to administer this release of Oracle HTTP Server.
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 10g release 2 (10.2) Oracle home:
The Summary screen of Oracle Universal Installer provides a detailed list of the products available in the Oracle Database 10g Products installation type.
Refer to Oracle Database Backup and Recovery Basics for more information about RMAN.
Oracle SQLJ enables application programmers to embed SQL operations in Java code in a way that is compatible with the Java design philosophy. A SQLJ program is a Java program containing embedded SQL statements. Oracle SQLJ offers extensions to support dynamic SQL operations, which are operations that can change in real time. It is also possible to use dynamic SQL operations through JDBC code or PL/SQL code within a SQLJ application. Typical applications contain much more static SQL than dynamic SQL. SQLJ consists of both a translator and a run-time component and is smoothly integrated into your development environment.
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 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.
Before you can use the Oracle Database Examples, you must install the Sample Schemas in 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 in an existing database.
See Also:Oracle Database Sample Schemas for information about manually installing the Sample Schemas in an existing database
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
Oracle Workflow provides a complete workflow management system that supports business process-based integration. It also enables modeling, automation, and continuous improvement of business processes, routing information of any type according to user-defined business rules. The Oracle Workflow installation includes Oracle Workflow Server and Oracle Workflow Manager in the Oracle Database 10g Products installation type and the Oracle Workflow middle-tier components on the Companion Products installation type.
In this release, starting the Oracle Application Server Containers for J2EE (OC4J) instances for Oracle Workflow Manager has been simplified to running two scripts.
Note:Do not install Oracle Workflow Server in an Oracle E-Business Suite database. If you want to use the version of Oracle Workflow available with Oracle Database 10g, or any Oracle Database components that depend on this version of Oracle Workflow, then you must install the Oracle Workflow Server in a database that is not used for an Oracle E-Business Suite instance.
For an Oracle E-Business Suite database, you can continue to use the version of the Oracle Workflow Server embedded in Oracle E-Business Suite.
See Also:The Oracle Workflow Client installation software is available on the Oracle Technology Network Web site at
Oracle Workflow is also installed by some installation types of the following products:
Oracle Application Server 10g
Oracle Content Management SDK 10g
If you installed either of these products, then you may have already installed Oracle Workflow. In this case, you do not need to install Oracle Workflow again.
Oracle Ultra Search lets you index and search Web sites, database tables, files, mailing lists, Oracle Application Server Portals, and user-defined data sources. You can use Oracle Ultra Search to build different kinds of search applications.
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.
JPublisher is a Java utility that generates Java classes to represent the following user-defined database entities in a Java program:
SQL object types
Object reference types (REF types)
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 can also 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. You can also use PL/SQL conversion functions between such types. With such type correspondences in place, JPublisher can automatically generate the required Java and PL/SQL code.
Just like SQL and PL/SQL entities publish to Java, you can also 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.
Because JPublisher uses SQLJ code in its generated classes, it automatically calls the Oracle SQLJ translator during the code generation process, as required. The translator converts embedded SQL statements into JDBC calls.
Oracle SQLJ Runtime is used during program run time to run 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 passes instructions to the JDBC driver.
See Also:Oracle Database JPublisher User's Guide
The following sections describe the products that you can install with the Oracle Database 10g Companion Products installation type:
Oracle Workflow middle-tier components enable the Oracle Workflow user interface Web pages, including the database access descriptor (DAD) and virtual directory mappings for Oracle Workflow. Before you can use Oracle Workflow Server, you must install Oracle Workflow middle-tier components.
You can use the Oracle Database 10g Companion Products installation type to install the Oracle Workflow middle-tier components after you install Oracle Workflow Server.
Refer to "Oracle HTTP Server" for information about Oracle HTTP Server.