1 Oracle Database Companion CD Installation Overview

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

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

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

4. Complete postinstallation steps.

http://www.legato.com/LSSV

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

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

1.3.1 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.3.2 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.