D Frequently Asked Questions About Installation

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 can I create an Oracle database that can handle transaction-heavy or data warehousing applications?

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

• How do I configure client connections to an Oracle database?

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

• How do I upgrade Oracle Database?

• How do I 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. How do I install Oracle Database for these situations?

For installation procedures and special requirements, refer to Oracle Database Installation Guide for Apple Mac OS X (Intel).

How can 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 refer to Oracle Database Installation Guide for Apple Mac OS X (Intel). 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.

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

Use Oracle Database Installation Guide for Apple Mac OS X (Intel) to install Oracle Database using either of the following methods:

• Installing with response files: This method lets you run Oracle Universal Installer at a command line using a response file that contains settings specific to each computer.

• Cloning an existing Oracle home: Install Oracle Database in one computer using interactive mode. Afterwards, you can clone its existing Oracle home in each location and then create a new database from there. You can also clone databases, which is described in Oracle Database Administrator's Guide.

How do I configure client connections to an Oracle database?

1. Install Oracle Database on a server by referring to Oracle Database Installation Guide for Apple Mac OS X (Intel).

2. Refer to Oracle Database Client Installation Guide for Apple Mac OS X (Intel) 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.

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

1. Install Oracle Database onto a server by referring to Oracle Database Installation Guide for Apple Mac OS X (Intel).

2. Refer to Oracle Database Client Installation Guide for Apple Mac OS X (Intel) 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.

How do I upgrade Oracle Database?

Refer to Oracle Database Upgrade Guide.

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

Installing Oracle Database Tools

• How do I install Oracle Application Server?

• How can I 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?

How do I install Oracle Application Server?

Refer to 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, then 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 to run.

• If you want Oracle Application Server to use an existing Oracle Database, then 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.

How can 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 only the single database and listener that you are installing:

1. Refer to Oracle Database Installation Guide for Apple Mac OS X (Intel) to install Oracle Database.

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

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

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:

  • 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 Apple Mac OS X (Intel) 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.

Installing Oracle Database with Oracle Applications

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

• How can I 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.

How can I 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