Overview of Oracle databases

 

There are two main types of Oracle databases.

  • Single instance: In a single instance Oracle database, only one instance is handling client requests at any time. In this configuration, one node or database server contains a single database and a single instance. The hardware node connects to a SAN or NAS storage device.
  • Clustered: In an Oracle cluster, there are two or more hardware nodes across which a single database is replicated, allowing access to the same data from any node. The addition of Oracle RAC or Symantec Veritas Cluster Server (VCS) software adds clustering capability.

Interaction with Automatic Storage Management

Automatic Storage Management (ASM) collects information that is needed to create an ASM Instance.

ASM is available to serve data files to databases on that cluster. Oracle databases are clients to ASM, which is configured in the cluster.

When you create an Oracle cluster or database within BMC Database Automation, you have the option of enabling the use of ASM.

If ASM is enabled during the cluster create process, then ASM is automatically created on nodes that are added to that cluster. When a node is removed, ASM is removed. When a cluster is removed, ASM is removed with that cluster.

When ASM is enabled, it collects information needed to create an ASM instance.

As an alternative to ASM for storing data files and redo logs, BMC Database Automation also supports all clustered file systems supported by Oracle.

Interaction with listeners

You can use BMC Database Automation to provision listeners while creating a new single instance Oracle database and while creating Oracle clusters. Every listener that is created is registered with all database instances running on the local node. A single listener can be used to allow access to all instances running on the local node. There is no requirement for more than one listener for each node, which is the easiest configuration to manage.

Oracle Restart

Oracle Restart is a feature of Oracle that runs from the Oracle grid infrastructure home. When you install an Oracle grid infrastructure home, you enable support for a single node Oracle Restart configuration. This configuration enables BMC Database Automation to run periodic check operations to monitor the health of Restart-enabled components. If a check operation fails for a component, the component is shut down and restarted.

The following components are automatically restarted by Oracle Restart:

  • Database instance
  • Oracle Net listener
  • Oracle ASM instance
  • Oracle ASM disk groups

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*