Installing Oracle Database or Oracle Database Client
The following are the frequently asked questions about installing 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?
If you want a quick installation using the default installation settings, then see this guide.
See Also:
Oracle Database Installation Checklist if your site has special requirements
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 see this guide for more details. Select the Advanced Installation method, and then select the database type you want on the Select Database Configuration screen.
Alternatively, you can use Oracle OLAP. The OLAP option is provided with Oracle Database Enterprise Edition. Oracle OLAP provides optimal support for database environments that must meet OLAP requirements.
See Also:
What's the best way to install multiple Oracle databases?
Use Oracle Universal Installer 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 a database: Install Oracle Database on one computer using interactive mode. You can also clone databases.
See Also:
Oracle Database Administrator's Guide about instructions for cloning databasesHow do I configure client connections to an Oracle database?
-
Install Oracle Database on a server by using Oracle Universal Installer.
-
Use Oracle Universal Installer to install Oracle Database Client on each client node, and select the Instant Client installation type.
If you have many client nodes, consider staging the software centrally, mapping the drive, and running Oracle Universal Installer in the silent or response file mode.
If the client nodes only require a default installation into a new Oracle home directory, consider using Oracle Universal Installer.
What is the best way to install Oracle Database Client if my client nodes have limited disk space?
Example G-1 How do I upgrade Oracle Database?
See Also:
Oracle Database Upgrade GuideExample G-2 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 Grid Infrastructure 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 Grid Infrastructure, and use Oracle Automatic Storage Management (Oracle ASM) to manage this storage. Then, install Oracle Database or Oracle Real Application Clusters.
-
If you plan to use Oracle Real Application Clusters, first install Oracle Grid Infrastructure, and then install Oracle Real Application Clusters.
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 to act as a single system. This is 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.
See platform-specific instructions for your platform to install Oracle Grid Infrastructure and Oracle Real Application Clusters. Oracle Clusterware is installed in an Oracle Grid Infrastructure installation.
Example G-3 How do I migrate my non-Oracle databases to Oracle Database?
Use Oracle SQL Developer to migrate your non-Oracle databases and applications to Oracle. Oracle SQL Developer software and documentation is available on Oracle Help Center at:
http://docs.oracle.com/en/database/database.html?tab=2#sqldev