Skip Headers
Oracle® Database Installation Guide
10g Release 2 (10.2) for Microsoft Windows (x64)

Part Number B15681-06
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

A Frequently Asked Questions about Installation

This appendix provides the following guidelines to decide how to install Oracle Database components:

Note:

Some Oracle Database components may not be available on all platforms. Consult your platform-specific installation guide or release notes.

Installing Oracle Database or Oracle Database Client

I only need one instance of Oracle Database, or I just want to install a test database to get familiar with the product. How do I install Oracle Database for these situations?

How do I create an Oracle database that can handle transaction-heavy or data warehousing applications?

If you want to create a starter database designed for transaction-heavy or data warehousing applications, then see Oracle Database Installation Guide. When you run Oracle Universal Installer, select the Advanced Installation method, and then select the database type you want in the Select Database Configuration window.

See Also:

Oracle Database Data Warehousing Guide after installation

Alternatively, you can install Oracle OLAP during the Oracle Database installation. Oracle OLAP provides optimal support for database environments that must meet OLAP requirements. To do so, select Advanced Installation, then Custom, and from the Available Product Components window, select Oracle OLAP.

See Also:

  • Oracle OLAP Application Developer's Guide

  • Oracle OLAP Reference

  • Oracle OLAP DML Reference

  • Oracle OLAP Java API Reference

  • Oracle OLAP Analytic Workspace Java API Reference

In an existing Oracle Database installation, you can run Oracle Database Configuration Assistant (DBCA) to create databases designed for data warehousing or transaction processing. To start DBCA, select Start, then Programs, then Oracle - HOME_NAME, then Configuration and Migration Tools, and then Database Configuration Assistant.

What's the best way to install multiple Oracle databases?

Use Oracle Database Installation Guide to install Oracle Database using either of the following methods:

How do I configure client connections to an Oracle database?

  1. Install Oracle Database onto your server by using Oracle Database Installation Guide.

  2. Use Oracle Database Client Installation Guide to install Oracle Database Client on each client node.

    If you have many client nodes, consider staging the software centrally, mapping the drive, and running Oracle Universal Installer in silent or noninteractive mode.

    If your client nodes only require a default installation into a new Oracle home directory, consider using Oracle Database Client Quick Installation Guide.

What is the best way to install Oracle Database Client if my client nodes have limited disk space?

  1. Use Oracle Database Installation Guide to install Oracle Database onto your server.

  2. Use Oracle Database Client Installation Guide or Oracle Database Client Quick Installation Guide to install Oracle Database Client on each client node, and select the Instant Client installation type.

    If you have many client nodes, consider running Oracle Universal Installer in silent or noninteractive mode.

How do I upgrade Oracle Database?

See Oracle Database Upgrade Guide.

See Also:

Oracle Database Administrator's Guide if you want to use software cloning to upgrade Oracle Database

The computers at my site have been configured to run as a cluster. How should I install Oracle Database?

Use any of the following installation scenarios:

See Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for your platform to install Oracle Clusterware or Oracle Real Application Clusters. Oracle Clusterware is available on the Oracle Clusterware installation media. Oracle Database Installation Guide explains how to install Automatic Storage Management as well as Oracle Database.

Oracle Clusterware is a key component required by Oracle Real Application Clusters installations. Oracle Clusterware is an integrated cluster management solution that can bind multiple servers together to act as a single system referred to as a cluster. It performs workload management and component restart. For example, when an instance supporting a particular service fails, Oracle Clusterware restarts the service on the next available instance that you have configured for that service. Oracle Clusterware can monitor non-Oracle programs, if they are defined within the Oracle Clusterware environment using the High Availability API.

How do I migrate my non-Oracle databases to Oracle Database?

Use Oracle Migration Workbench to migrate your non-Oracle databases and applications to Oracle. Oracle Migration Workbench software and documentation are available at

http://www.oracle.com/technology/migration/index.html

Installing Oracle Database Tools

How do I install Oracle Application Server?

See Oracle Application Server Installation Guide. How you install Application Server depends on whether you already have Oracle Database installed:

How do I administer and monitor my Oracle Database products?

To perform regular administrative functions such as creating, configuring, or deleting databases, or managing database templates, use one of the following methods:

To manage the single database and listener that you are installing:

  1. Use Oracle Database Installation Guide to install Oracle Database.

  2. From Oracle Database, use Oracle Database Configuration Assistant to manage your databases.

    You can also administer and monitor the database with Oracle Enterprise Manager Grid Control, which is installed by default with Oracle Database. Oracle Enterprise Manager Grid Control includes the Oracle Management Agent, Oracle Management Service, and Oracle Management Repository, as well as Grid Control, a browser-based central console through which administrators can perform all monitoring, administration, and configuration tasks for the enterprise.

    See Also:

    Oracle Enterprise Manager Grid Control Installation and Basic Configuration available on the Enterprise Manager Grid Control installation media

To perform advanced administration tasks, such as monitoring Oracle Database and managing multiple hosts, application servers, and databases including the one that you are installing, install Oracle Enterprise Manager as follows:

  1. Use Oracle Database Installation Guide to install Oracle Database.

    If you plan to use Oracle Real Application Clusters, then install Oracle Database by using Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide.

  2. Use Oracle Enterprise Manager Grid Control Installation and Basic Configuration to install and configure Oracle Enterprise Manager. For postconfiguration tasks, use Oracle Enterprise Manager Advanced Configuration.

How do I manage security for my Oracle Database products?

Oracle provides a wide range of security solutions for your enterprise environment, including centralized administration and security features integrated with Oracle Internet Directory. The set of Oracle security services called Oracle Platform Security integrates the security features built into Oracle Database, Oracle Application Server, and the Oracle Identity Management infrastructure. Combined, these features enable the development and deployment of secure e-business applications.

Oracle Identity Management includes Oracle Internet Directory, a centralized repository that simplifies administration of users and applications in the Oracle environment by means of the following components:

Oracle Database includes the Oracle Internet Directory client tools, but not the Oracle Internet Directory server components. To install the Oracle Internet Directory server components, run Oracle Universal Installer from an Oracle Application Server 10g installation.

See Also:

  • Oracle Application Server Installation Guide (to install Oracle Identity Management)

  • Oracle Database Security Guide

  • Oracle Database Advanced Security Administrator's Guide

  • Oracle Database Enterprise User Administrator's Guide

  • Oracle Label Security Administrator's Guide

  • Oracle Application Server Security Guide

  • http://www.oracle.com/technology/deploy/security/index.html for Oracle Technology Network topics on database security

Does Oracle Database provide OLAP tools so that I can analyze data such as trends and time series in my database?

Yes, install Oracle OLAP, which is provided in the Oracle Database installation. Oracle OLAP provides optimal support for database environments that must meet OLAP requirements.

Use either of the following methods in Oracle Database Installation Guide to install Oracle OLAP:

Does Oracle Database provide data mining tools that I can use to find hidden meaning in my data and predict likely outcomes based on my data?

Yes. Install Oracle Data Mining, which is provided in the Oracle Database installation. With the Oracle Data Mining option, you can create and execute predictive and descriptive data mining models that use a variety of algorithms.

Use the following method in Oracle Database Installation Guide to install Oracle Data Mining:

  1. When you run Oracle Universal Installer, select the Enterprise Edition installation type.

  2. In the Select Database Configuration window, select the General Purpose configuration.

If you want the database to execute predefined mining models, but not support model creation, install the Data Mining Scoring Engine instead of Oracle Data Mining. Use the following method in Oracle Database Installation Guide to install the Data Mining Scoring Engine:

  1. When you run Oracle Universal Installer, select the Custom installation type.

  2. In the Available Product Components window, select Data Mining Scoring Engine.

See Also:

The following manuals after you have installed Oracle Data Mining:
  • Oracle Data Mining Concepts

  • Oracle Data Mining Administrator's Guide

  • Oracle Data Mining Application Developer's Guide

  • Oracle Data Mining Java API Reference

  • Oracle Database PL/SQL Packages and Types Reference (search for Data Mining"

  • Oracle Database SQL Reference (search for Data Mining)

How do I perform backup and recovery operations for Oracle Database?

Use Oracle Database Recovery Manager (RMAN), which is a backup and recovery tool integrated into Oracle Database. This tool satisfies the demands of high-performance, manageable backup and recovery. Recovery Manager is native to the database, automatically tracks database structure changes, and optimizes operations accordingly. In addition, Recovery Manager is integrated with leading tape media management products, so that Oracle database backups can be integrated with your existing networked data protection infrastructure.

See Also:

  • Oracle Database Backup and Recovery Basics

  • Oracle Database Backup and Recovery Advanced User's Guide

  • Oracle Database Backup and Recovery Reference

  • Oracle Database Backup and Recovery Quick Start Guide

Installing Oracle Database with Oracle Applications

How do I install my Oracle applications with Oracle Database?

In most cases, install Oracle Database itself, then install the Oracle application. The Oracle Universal Installer for that application prompts you for the connection information. Check the application documentation requirements.

If you need to implement your applications with Oracle Real Applications Clusters databases, see Oracle Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide.

How do I create Web applications that communicate with Oracle Database?

Install Oracle HTML DB and Oracle HTTP Server:

  1. Use Oracle Database Installation Guide to install Oracle Database.

  2. Use Oracle Database Companion CD Installation Guide to install Oracle HTML DB and Oracle HTTP Server.

    The following components are available on the Oracle Database Companion CD installation media:

    • JPublisher

    • Natively Compiled Java Libraries

    • Oracle Database Examples

    • Oracle HTML DB

    • Oracle HTTP Server

    • Oracle Workflow server and middle-tier components

    • Oracle Text Supplied Knowledge Bases

    If you only need to install these products using the default settings into a new Oracle home, consider using Oracle Database Companion CD Quick Installation Guide.

How do I automate and streamline my processes for both traditional applications-based workflow and as e-business integration workflow?

Install Oracle Workflow:

  1. Use Oracle Database Installation Guide to install Oracle Database.

  2. Use Oracle Database Companion CD Installation Guide to install Oracle Workflow.

Which Web server can my Oracle applications use?

Install Oracle HTTP Server:

  1. Use Oracle Database Installation Guide to install Oracle Database.

  2. Use Oracle Database Companion CD Installation Guide to install Oracle HTTP Server.

How do I migrate my non-Oracle applications to Oracle Database?

Use Oracle Migration Workbench to migrate your non-Oracle applications to Oracle. Oracle Migration Workbench software and documentation are available at:

http://www.oracle.com/technology/migration/index.html

Installing Oracle Database Heterogeneous Connectivity Tools (Gateways)

How can my AS/400 application access data in an Oracle database?

Use Oracle Access Manager for AS/400, which enables AS/400 applications to access data in an Oracle database. To install Oracle Access Manager for AS/400, see Oracle Access Manager for AS/400 Installation and User's Guide for IBM iSeries OS/400.

How can my Oracle applications access data in a non-Oracle database system?

Use the following connectivity tools to enable Oracle applications to access data in non-Oracle databases:

You can install the Gateway product on a computer independent of the Oracle application, Oracle database, and non-Oracle database.

For example, suppose you have the following scenario:

You have the option of installing the Transparent Gateway for DRDA on the Solaris computer where DB2 is running, on Linux where Oracle is running, or on a third computer.

Table A-1 lists the non-Oracle database systems that you can access from Oracle applications, and the Gateway products that are available for those systems.

Table A-1 Oracle Gateway Products

Non-Oracle Database Oracle Gateway Products and Documentation

IBM DB2 Universal Database (UDB)

Transparent Gateway for DRDA. Available on the following platforms:

  • Linux x86: Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • Linux Itanium: Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • Microsoft Windows (32-bit): Use Oracle Transparent Gateway for DRDA Installation and User's Guide for Microsoft Windows.

  • Solaris Operating System (SPARC 64-Bit): Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • AIX 5L Based Systems (64-Bit): Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • IBM zSeries Based Linux: Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • hp-ux PA-RISC (64-Bit): Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

IBM DB2 z/OS

Transparent Gateway for DB2. Available on z/OS. Use Oracle Transparent Gateway for DB2 Installation and User's Guide for IBM z/OS (OS/390).

Transparent Gateway for DRDA. Available on the following platforms:

  • Linux x86: Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • Linux Itanuim: Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • Microsoft Windows (32-bit): Use Oracle Transparent Gateway for DRDA Installation and User's Guide for Microsoft Windows.

  • Solaris Operating System (SPARC 64-Bit): Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • AIX 5L Based Systems (64-Bit): Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • IBM zSeries Based Linux: Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • hp-ux PA-RISC (64-Bit): Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

IBM DB2/400

Transparent Gateway for DB2/400. Available on IBM AS/ 400. Use Oracle Transparent Gateway for DB2/400 Installation and User's Guide for IBM iSeries OS/400.

Transparent Gateway for DRDA. Available on the following platforms:

  • Linux x86: Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • Linux Itanuim: Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • Microsoft Windows (32-bit): Use Oracle Transparent Gateway for DRDA Installation and User's Guide for Microsoft Windows.

  • Solaris Operating System (SPARC 64-Bit): Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • AIX 5L Based Systems (64-Bit): Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • IBM zSeries Based Linux: Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

  • hp-ux PA-RISC (64-Bit): Use Oracle Transparent Gateway for DRDA Installation and User's Guide for UNIX.

IBM MQSeries

Procedural Gateway for WebSphere MQ. Available on the following platforms:

  • Linux x86: Use Oracle Procedural Gateway for WebSphere MQ Installation and User's Guide for UNIX.

  • Microsoft Windows (32-bit): Use Oracle Procedural Gateway for WebSphere MQ Installation and User's Guide for Microsoft Windows.

  • Solaris Operating System (SPARC 64-Bit): Use Oracle Procedural Gateway for WebSphere MQ Installation and User's Guide for UNIX.

  • AIX 5L Based Systems (64-Bit): Use Oracle Procedural Gateway for WebSphere MQ Installation and User's Guide for UNIX.

  • hp-ux PA-RISC (64-Bit): Use Oracle Procedural Gateway for WebSphere MQ Installation and User's Guide for UNIX.

Adabas

Advantage CA-Datacom/DB

Advantage CA-IDMS

Advantage CA-IDMS/SQL

FOCUS

IMS/DB-DL/1

ISAM

Model 04

QSAM

Supra

System 2000

TOTAL

VSAM

Transparent Gateway for iWAY. Available on z/OS. Use Oracle Transparent Gateway for iWay Installation and User's Guide for IBM z/OS (OS/390).

Advantage CA-IDMS/DC Transaction Server

CICS/TS

IMSTM

Procedural Gateway for APPC. Available on the following platforms:

  • Linux x86: Use Oracle Procedural Gateway for APPC Installation and Configuration Guide for UNIX.

  • Microsoft Windows (32-bit): Use Oracle Procedural Gateway for APPC Installation and Configuration Guide for Microsoft Windows.

  • Solaris Operating System (SPARC 64-Bit): Use Oracle Procedural Gateway for APPC Installation and Configuration Guide for UNIX.

  • AIX 5L Based Systems (64-Bit): Use Oracle Procedural Gateway for APPC Installation and Configuration Guide for UNIX.

  • hp-ux PA-RISC (64-Bit): Use Oracle Procedural Gateway for APPC Installation and Configuration Guide for UNIX.

Microsoft SQL Server

Transparent Gateway for SQL Server. Available on Microsoft Windows (32-Bit). Use Oracle Transparent Gateway Installation Guide for Microsoft Windows (32-Bit), and then Oracle Transparent Gateway for Microsoft SQL Server Administrator's Guide for Microsoft Windows.

Sybase Adaptive Server

Transparent Gateway for Sybase. Available on the following platforms:

  • Microsoft Windows (32-bit): Use Oracle Transparent Gateway Installation Guide for Microsoft Windows (32-Bit), then Oracle Transparent Gateway for Sybase Administrator's Guide for Microsoft Windows.

  • Solaris Operating System (SPARC 64-Bit): Use Oracle Transparent Gateway Installation Guide for Solaris Operating System, hp-ux, IBM AIX, and hp Tru64 UNIX, then Oracle Transparent Gateway for Sybase Administrator's Guide for Solaris Operating System (SPARC 64-Bit).

  • AIX 5L Based Systems (64-Bit): Use Oracle Transparent Gateway Installation Guide for Solaris Operating System, hp-ux, IBM AIX, and hp Tru64 UNIX, and then Oracle Transparent Gateway for Sybase Administrator's Guide for IBM AIX.

  • hp-ux PA-RISC (64-Bit): Use Oracle Transparent Gateway Installation Guide for Solaris Operating System, hp-ux, IBM AIX, and hp Tru64 UNIX, then Oracle Transparent Gateway for Sybase Administrator's Guide for hp-ux.

  • hp Tru64 UNIX: Use Oracle Transparent Gateway Installation Guide for Solaris Operating System, hp-ux, IBM AIX, and hp Tru64 UNIX, then Oracle Transparent Gateway for Sybase Administrator's Guide for hp Tru64 UNIX.

Teradata

Transparent Gateway for Teradata. Available on the following platforms:

  • Microsoft Windows (32-bit): Use Oracle Transparent Gateway Installation Guide for Microsoft Windows (32-Bit), then Oracle Transparent Gateway for Teradata Administrator's Guide for Microsoft Windows

  • Solaris Operating System (SPARC 64-Bit): Use Oracle Transparent Gateway Installation Guide for Solaris Operating System, hp-ux, IBM AIX, and hp Tru64 UNIX, then Oracle Transparent Gateway for Teradata Administrator's Guide for Solaris Operating System (SPARC 64-Bit).

  • hp-ux PA-RISC (64-Bit): Use Oracle Transparent Gateway Installation Guide for Solaris Operating System, hp-ux, IBM AIX, and hp Tru64 UNIX, then Oracle Transparent Gateway for Teradata Administrator's Guide for hp-ux.

Informix Server

Transparent Gateway for Informix. Available on the following platforms:

  • Solaris Operating System (SPARC 64-Bit): Use Oracle Transparent Gateway Installation Guide for Solaris Operating System, hp-ux, IBM AIX, and hp Tru64 UNIX, then Oracle Transparent Gateway for Informix Administrator's Guide for Solaris Operating System (SPARC 64-Bit).

  • hp-ux PA-RISC (64-Bit): Use Oracle Transparent Gateway Installation Guide for Solaris Operating System, hp-ux, IBM AIX, and hp Tru64 UNIX, then Oracle Transparent Gateway for Informix Administrator's Guide for hp-ux.

Ingres II

Transparent Gateway for Ingres II. Available on the following platforms:

  • Solaris Operating System (SPARC 64-Bit): Use Oracle Transparent Gateway Installation Guide for Solaris Operating System, hp-ux, IBM AIX, and hp Tru64 UNIX, then Oracle Transparent Gateway for Ingres II Administrator's Guide for Solaris Operating System (SPARC 64-Bit).

  • hp-ux PA-RISC (64-Bit): Use Oracle Transparent Gateway Installation Guide for Solaris Operating System, hp-ux, IBM AIX, and hp Tru64 UNIX, then Oracle Transparent Gateway for Ingres II Administrator's Guide for hp-ux.

Rdb

Transparent Gateway for Rdb. Available on hp OpenVMS Alpha. Use Oracle Transparent Gateway Installation Guide for hp OpenVMS, then Oracle Transparent Gateway for Rdb Administrator's Guide for hp OpenVMS.

RMS

Transparent Gateway for RMS. Available on hp OpenVMS Alpha. Use Oracle Transparent Gateway Installation Guide for hp OpenVMS, then Oracle Transparent Gateway for RMS Administrator's Guide for hp OpenVMS.