D Frequently Asked Questions About Installation

D.1 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.

• My site needs a database designed for transaction-heavy or data warehousing applications.

• I need to install multiple Oracle databases.

• My site requires client connections to the Oracle database.

• My Oracle Database client nodes have limited disk space.

• I need to upgrade my Oracle Database.

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

• I need to migrate my non-Oracle databases to Oracle Database.

I only need one instance of Oracle Database or I just want to install a test database to get familiar with the product.

• If you want a quick installation using the default installation settings, then refer to Oracle Database Quick Installation Guide for Linux x86.

• If your site has special requirements, then refer to Oracle Database Installation Guide for Linux x86.

My site needs a database designed for transaction-heavy or data warehousing applications.

If you want to create a starter database designed for transaction-heavy or data warehousing applications, then use Oracle Database Installation Guide for Linux x86. Select the Advanced Installation method, and then select the database type you want on the Select Database Configuration screen.

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 on the Available Product Components screen, select Oracle OLAP.

I need to install multiple Oracle databases.

Use Oracle Database Installation Guide for Linux x86 and consider running Oracle Universal Installer in noninteractive mode. This method lets you run Oracle Universal Installer at a command line using a response file that contains settings specific to each computer.

My site requires client connections to the Oracle database.

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

2. Use Oracle Database Client Installation Guide for Linux x86 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 noninteractive mode.

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

My Oracle Database client nodes have limited disk space.

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

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

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

I need to upgrade my Oracle Database.

Refer to Oracle Database Administrator's Guide.

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:

• If you want to run a single-instance Oracle Database in a clustered environment, then install Oracle Clusterware either before or after you install Oracle Database.

• If you want a consolidated pool of storage for all databases in a cluster, then install Oracle Clusterware first and use Automatic Storage Management to manage this storage. Afterwards, install Oracle Database (which can be either single instance or Real Application Clusters).

• If you plan to use Oracle Real Application Clusters, first install Oracle Clusterware, and then install Oracle Real Application Clusters.

Refer to Oracle Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for the platform to install Oracle Clusterware or Oracle Real Application Clusters. Oracle Clusterware is available on the Oracle Clusterware installation media. Oracle Database Installation Guide for Linux x86 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, as long as they are defined within the Oracle Clusterware environment using the High Availability API.

I need to 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/tech/migration/

D.2 Installing Oracle Database Tools

• I need to install Oracle Application Server.

• I need to administer and monitor my Oracle Database products.

• How do I manage security for my Oracle Database products?

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

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

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

I need to install Oracle Application Server.

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

• If you do not have Oracle Database installed or you do not want Oracle Application Server to use any of your existing Oracle Databases, the Oracle Universal Installer lets you install Oracle Application Server with its own Oracle Database. This database is populated with the metadata that Oracle Application Server needs in order to run.

• If you want Oracle Application Server to use an existing Oracle Database, do the following:

  1. From the Oracle Application Server installation media, run Oracle Application Server Repository Creation Assistant to populate your database with the metadata that Application Server needs.

  2. Install the remaining Oracle Application Server components by following the instructions in the Oracle Application Server Installation Guide.

I need to 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 only the single database and listener that you are installing:

1. Use Oracle Database Installation Guide for Linux x86 to install Oracle Database.

2. From Oracle Database, use 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 for Linux x86 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 for Linux.

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 Internet Directory client tools, including LDAP command-line tools, the Oracle Internet Directory SDK, and Oracle Directory Manager.

• Oracle Internet Directory server components, including the directory server, the directory replication server, the directory integration server, and various tools for starting and stopping them.

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 10g Application Server installation.

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:

• Select the Custom installation type, and in the Available Product Components screen, select Oracle OLAP.

  
  

  See Also: The following manuals after you install Oracle OLAP: 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

  
  

• Select the Enterprise Edition installation type, and then on the Select Database Configuration screen, select the Data Warehouse configuration.

  
  

  See Also: Oracle Database Data Warehousing Guide after installation

  
  

Does Oracle Database provide data mining tools that I can use to discover 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 for Linux x86 to install Oracle Data Mining:

1. Select the Enterprise Edition installation type.

2. On the Select Database Configuration screen, 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. Select the Custom installation type.

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

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 pressing demands of high-performance, manageable backup, and recovery. Recovery Manager is native to the database server, 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.

D.3 Installing Oracle Database with Oracle Applications

• How do I install my Oracle applications with Oracle Database?

• I need to create Web applications that communicate with Oracle Database.

• I need to automate and streamline my processes for both traditional applications-based workflow as well as e-business integration workflow.

• My Oracle applications need a Web Server.

• I need to migrate my non-Oracle applications to Oracle.

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, refer to Oracle Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide.

I need to create Web applications that communicate with Oracle Database.

Install Oracle HTML DB and Oracle HTTP Server:

1. Use Oracle Database Installation Guide for Linux x86 to install Oracle Database.

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

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

   • Oracle JDBC Development Drivers

   • Oracle SQLJ

   • Oracle Ultra Search

   • 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 Oracle HTML DB and Oracle HTTP Server using the default settings into a new Oracle home, consider using Oracle Database Companion CD Quick Installation Guide for Linux x86.

I need to automate and streamline my processes for both traditional applications-based workflow as well as e-business integration workflow.

Install Oracle Workflow:

1. Use Oracle Database Installation Guide for Linux x86 to install Oracle Database.

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

My Oracle applications need a Web Server.

Install Oracle HTTP Server:

1. Use Oracle Database Installation Guide for Linux x86 to install Oracle Database.

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

I need to migrate my non-Oracle applications to Oracle.

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/tech/migration/index.html

D.4 Installing Oracle Database Heterogeneous Connectivity Tools (Gateways)

• My AS/400 application needs to access data in an Oracle database.

• My Oracle applications need to access data in a non-Oracle database system.

My AS/400 application needs to 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, use Oracle Access Manager for AS/400 Installation and User's Guide for IBM iSeries OS/400.

My Oracle applications need to access data in a non-Oracle database system.

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

• Oracle Transparent Gateway: Integrates a non-Oracle database into your Oracle Database environment.

• Oracle Procedural Gateway: Enables Oracle PL/SQL applications to integrate with APPC-enabled transactions, or access messages in IBM Websphere MQ.

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:

• Oracle Database is installed on a Linux computer.

• The Oracle application is installed on a Microsoft Windows computer and accesses data from the Oracle database on the Linux computer.

• The Oracle application needs to join data in a DB2 database on Solaris Operating System and an Oracle Database on Linux.

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 D-1 lists the non-Oracle database systems that you can access from Oracle applications, and the Gateways products that are available for those systems.