Installing Oracle Database Tools

The following are frequently asked questions about installing Oracle Database tools:

How do I install Oracle WebLogic Server?

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. Use Oracle Universal Installer 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 Cloud Control, which is installed by default with Oracle Database. Oracle Enterprise Manager Cloud Control requires an agent which is not installed by default.

    Oracle Enterprise Manager Cloud Control includes the Oracle Management Agent, Oracle Management Service, and Oracle Management Repository, as well as Cloud Control, a browser-based central console through which administrators can perform all monitoring, administration, and configuration tasks for the enterprise.

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 Universal Installer to install Oracle Database.

    If you plan to use Oracle Real Application Clusters, then install Oracle Database by using the platform-specific guides.

  2. Use Oracle Enterprise Manager Cloud Control Advanced Installation and Configuration Guide to install and configure Oracle Enterprise Manager. For postconfiguration tasks, use Oracle Enterprise Manager Cloud Control Administrator's Guide.

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 WebLogic 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 with 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, see Oracle Identity Management documentation on Oracle Help Center at:

How do I use Oracle Database to manage my XML data?

Use Oracle XML DB, which is installed as part of Oracle Database. Oracle XML DB enables you to efficiently store, generate, retrieve, query, and manage XML data on your site. Oracle XML DB provides all the advantages of a relational database, for example, allowing you to control the referential integrity of XML data with constraints and triggers. It works well with large amounts of XML data by storing it in a parsed, relational form, which improves access performance.

Oracle XML DB supports XML Type, which is a native data type for XML data, for which you can choose various storage options depending on your needs. In addition, Oracle XML DB supports XML Schema processing, structured and unstructured storage, a content repository that you can access by using common protocols (FTP, HTTP(S), and WebDAV), and SQL/XML, which is a standard for SQL with XML. For Oracle Database 11g Release 1 (11.1), Oracle XML DB introduced support for the XQuery language for querying, transforming, and constructing XML; the ability for users to define their own metadata for schema-based XML; a set of new SQL functions for DML operations on XML data; and more.

You can use Oracle XML DB with Oracle XML Developer's Kit (XDK) to build applications that run on either Oracle Database or Oracle WebLogic Server.

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

Yes, Oracle OLAP is available as part of an Oracle Database Enterprise Edition installation. Oracle OLAP provides optimal support for database environments that must meet OLAP requirements.

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, you must have an Oracle Enterprise Edition license to use Oracle Data Mining tools. Oracle Data Mining is an option of the Enterprise Edition, as described in Table 6–2, in the Select Database Edition row.

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 to install Oracle Data Mining:

  1. When you run Oracle Universal Installer, select the Enterprise Edition installation type.
  2. In the Select Database Configuration screen, select the General Purpose/Transaction Processing configuration.

See Also:

The following manuals for information about Oracle Data Mining:

Example G-4 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.

Example G-5 Is Oracle Workflow included with Oracle Database?

Starting with Oracle Database 11g, Oracle Workflow is no longer released with the database. Oracle Workflow is available with the Oracle E-Business Suite releases.

See Also:

Oracle Workflow statement of direction:

Example G-6 Is there a migration plan for customers that have built solutions using Oracle Workflow?

Starting January 2006, customers are encouraged to re-create and implement workflows using Oracle SOA Suite. Refer to the following technical migration guide for detailed recommendations about migrating Oracle Workflow processes to Oracle SOA Suite (formerly known as Oracle BPEL Process Manager) at

See Also:

Oracle Workflow statement of direction: