Manage VM Clusters
Learn how to manage your VM clusters on Oracle Exadata Database Service on Exascale Infrastructure.
- Using the Console to Manage VM Clusters on Oracle Exadata Database Service on Exascale Infrastructure
Learn how to use the console to create, edit, and manage your VM Clusters on Oracle Exadata Database Service on Exascale Infrastructure. - Adding or Removing a VM From a VM Cluster
You can scale VM Clusters horizontally by adding or removing VMs to or from an existing VM Cluster. - Overview of Automatic Diagnostic Collection
By enabling diagnostics collection and notifications, Oracle Cloud Operations and you will be able to identify, investigate, track, and resolve guest VM issues quickly and effectively. Subscribe to Events to get notified about resource state changes. - Incident Logs and Trace Files
This section lists all of the files that can be collected by Oracle Support if you opt-in for incident logs and trace collection. - Health Metrics
Review the list of database and non-database health metrics collected by Oracle Trace File Analyzer. - Using the API to Manage Oracle Exadata Database Service on Exascale Infrastructure Instance
Use these API operations to manage Exadata Cloud Infrastructure virtual machines (VMs) and databases on Oracle Exadata Database Service on Exascale Infrastructure (ExaDB-XS).
Parent topic: How-to Guides
Using the Console to Manage VM Clusters on Oracle Exadata Database Service on Exascale Infrastructure
Learn how to use the console to create, edit, and manage your VM Clusters on Oracle Exadata Database Service on Exascale Infrastructure.
- To create a cloud VM cluster
Create a VM cluster in an Oracle Exadata Database Service on Exascale Infrastructure instance. - Using the Console to Enable, Partially Enable, or Disable Diagnostics Collection
You can enable, partially enable, or disable diagnostics collection for your Guest VMs after provisioning the VM cluster. Enabling diagnostics collection at the VM cluster level applies the configuration to all the resources such as DB home, Database, and so on under the VM cluster. - Using the Console to Update the License Type on a VM Cluster
To modify licensing, be prepared to provide values for the fields required for modifying the licensing information. - To scale VM Clusters
Increase or decrease the ECPUs, memory or storage available to a VM cluster in Oracle Exadata Database Service on Exascale Infrastructure - To add SSH keys to a VM cluster
The VM cluster exists, and you wish to add a another user which requires another SSH key. - Using the Console to Add SSH Keys After Creating a VM Cluster
- Using the Console to Stop, Start, or Reboot a VM Cluster Virtual Machine
Use the console to stop, start, or reboot a virtual machine. - Using the Console to Check the Status of a VM Cluster Virtual Machine
Review the health status of a VM cluster virtual machine. - Using the Console to Move a VM Cluster to Another Compartment
To change the compartment that contains your VM cluster on Oracle Exadata Database Service on Exascale Infrastructure, use this procedure. - To change the VM cluster display name
- Using the Console to Terminate a VM Cluster
Before you can terminate a VM cluster, you must first terminate the databases that it contains. - To view details about private DNS configuration
Parent topic: Manage VM Clusters
To create a cloud VM cluster
Create a VM cluster in an Oracle Exadata Database Service on Exascale Infrastructure instance.
- Open the navigation menu. Click Oracle Database, then click Exadata Database Service on Exascale Infrastructure
- Click Exadata VM Clusters.
-
Click Create VM Cluster.
The Create VM Cluster page is displayed. Provide the required information to configure the VM cluster.
- Compartment: Select a compartment for the VM cluster resource.
- Display name: Enter a user-friendly display name for the VM cluster. The name doesn't need to be unique. An Oracle Cloud Identifier (OCID) will uniquely identify the DB system. Avoid entering confidential information.
- Provide the cluster name: Select the name of the VM cluster.
- Select an availability domain: Select the availability domain from the displayed options available.
- Configure the VM cluster: Provide the following
information:
- Number of VMs in the cluster: Specify the number of the VMs that you want to configure for the cluster, between 2 and 10.
- ECPUs enabled per VM: Specify the number of ECPU cores that you want to enable for the VM cluster. The minimum is 8 ECPU. The maximum number of ECPUs is 200 per VM, or limited by the number of total ECPUs you have specified for the VM. The value you select must be a multiple of 4. You can open the reserve additional ECPU section to reserve additional ECPUs.
-
Total ECPUs enabled across cluster per VM: Provide a total number of ECPUs to allocate per VM. The total must be a number between 8 and 200.
- (Optional) To reserve additional ECPUs, click Show reserve
additional ECPU. Provide the following
information:
- ECPUs additional reserved per VM (read only): Indicates the additional reserved ECPUs. The number of additional ECPUs will be automatically calculated based on the total enabled ECPUs. Additional reserved ECPUs are not active for licensing purposes but are reserved for your VM, and ready and waiting for scaling the Enabled ECPUs.
-
Total ECPUs per VM: Provide a total number of ECPUs to allocate per VM. The total must be a number between 8 and 200.
- Memory per VM (GB): This is a read-only field. It displays amount of memory allocated to each VM. Memory is calculated based on 11 GB per total cores. The Total memory across VM Cluster (GB) field automatically updates to provide you with the total amount of memory allocated across the VM cluster, based on the memory allocation per VM that you specify.
-
VM file system storage capacity per VM (GB): Specify storage capacity per VM in gigabytes (GB).
Provide how much storage you want for all VM file systems together. The VM file systems storage includes
/u02
capacity, where your Database Homes will go, along with all of the other VM file systems (/
,/boot
,/tmp
,/var
,/var/log
,/var/log/audit
,/home
,swap
,kdump
,/u01
,grid
,/u02
). Any extra capacity selected beyond system minimums will go into/u02
.Note
For information about reserved and enabled cores, and an overview of the ExaDB-XS architecture, see "About Exadata Database Service on Exascale Infrastructure" -
Exascale Database Storage Vault: Select either Create new vault or Select existing vault. If you select an existing vault, then select the vault in the compartment. Click Change compartment to select a vault in a different compartment.
When you create a new vault, the Provisioning status window opens to provide you with the status of vault creation, and the name of the vault that is being created in the format
Vault-YYYYMMDDHHMM
indicating the creation date, where YYYY is the year, MM is the month, DD is the day, HH is the hour, and MM is the minute.Note
If the vault creation failed, then the Provisioning status window provides you with the work request error message indicating the point where the vault creation operation failed, and the work request ID. Make a note of this work request ID, and open a Service Request with My Oracle Support. -
Configure Exascale Database Storage Vault: Select the storage configuration to use for your database's storage. To begin, select whether you want to create a new Vault, or use an existing Vault.
For a new Vault, specify the following:
-
Storage Vault Name: Name the new Exascale Vault. Optional: Use the link provided to change to another compartment where you want to place the Vault.
- Enter the Storage Capacity for Databases: The amount of usable disk storage capacity that will be available for storing databases that is desired. Specify the size in gigabytes (GB) between 300 to 100,000.
- (Optional) Add smart flash as a percentage of storage capacity provisioned (%): Select this option to purchase and specify an additional amount of flash cache over and above the amount of default flash cache that is included in the normal Storage capacity for Databases. Additional flash cache can potentially enable increased performance without adding additional storage capacity in some workloads. Additional flash cache also includes additional memory cache. Specify the additional flash cache as a percentage of the total storage provisioned. If you wish to provision additional flash cache, you must add at least 100 GB of additional flash cache. The amount of smart flash cache in GB that will be added is specified in the read-only field Smart flash cache to be added (GB).
The minimum size configuration for an Exascale Database Storage Vault is 300 GB. 50 GB of the space that you allocate in your Vault is reserved for a 200 GB ACFS file system. This ACFS file system resides within your Exascale Database Storage Vault, but is reserved for system use. Thus, if you provisioned the minimum of 300 GB in your Exascale Database Storage Vault, then 250 GB of that 300 GB capacity will be available storage for your databases.
-
- Select the Oracle Grid Infrastructure version: This field displays the Oracle Grid Infrastructure versions available for deployment in the VM cluster.
-
Add SSH key:Add the public key portion of each key pair that you want to use for SSH access to the DB system:
- Generate SSH key pair (Default
option) Select this option to generate an SSH keypair. Then in the
dialog below click Save private key to download
the key, and optionally click Save public key to
download the key.
Note
Download the private key so that you can connect to the database system using SSH. It will not be shown again. - Upload SSH key files: Select this
option to browse or drag and drop
.pub
files. - Paste SSH keys: Select this option to paste in individual public keys.
- Generate SSH key pair (Default
option) Select this option to generate an SSH keypair. Then in the
dialog below click Save private key to download
the key, and optionally click Save public key to
download the key.
-
Configure the network settings: Specify the following:
- Virtual cloud network: Select the virtual cloud network (VCN) for the compartment in which you want to create the VM cluster. Click Change Compartment to select a VCN in a different compartment.
-
Client subnet: Select the client subnet in the compartment. This is the subnet to which the VM cluster should attach. Click Change Compartment to select a subnet in a different compartment.Note
You must select the VCN before you can select a client subnet.Do not use a subnet that overlaps with 192.168.16.16/28, which is used by the Oracle Clusterware private interconnect on the database instance. Specifying an overlapping subnet causes the private interconnect to malfunction.
-
Backup subnet: Select the subnet to use for the backup network, which is typically used to transport backup information to and from the Backup Destination, and for Data Guard replication. Click Change Compartment to select a subnet in a different compartment, if applicable.
Do not use a subnet that overlaps with 192.168.128.0/20. This restriction applies to both the client subnet and backup subnet.
Note
You must select the VCN before you can select a backup client subnet. -
Use network security groups to control traffic: Optionally, you can specify one or more network security groups (NSGs) for both the client and backup networks. NSGs function as virtual firewalls, allowing you to apply a set of ingress and egress security rules to your Oracle Exadata Database Service on Exascale Infrastructure VM cluster.
Note that if you choose a subnet with a security list, then the security rules for the VM cluster will be a union of the rules in the security list and the NSGs.
To use network security groups:
- Check the Use network security groups to control traffic check box. This box appears under both the selector for the client subnet and the backup subnet. You can apply NSGs to either the client or the backup network, or to both networks. Note that you must have a virtual cloud network selected to be able to assign NSGs to a network.
- Specify the NSG to use with the network. You might need to use more than one NSG. If you're not sure, contact your network administrator.
-
Hostname prefix Provide your choice of hostname for the Exadata DB system. The host name must begin with an alphabetic character and can contain only alphanumeric characters and hyphens (-). The maximum number of characters allowed for an Exadata DB system is 12.
Caution:
The hostname must be unique within the subnet. If it is not unique, then the VM cluster will fail to provision. -
Host domain name: The domain name for the VM cluster. This is a read-only field. Make a note of the host domain name for your reference.
If you plan to store database backups in Object Storage or Autonomous Recovery service, Oracle recommends that you use a VCN Resolver for DNS name resolution for the client subnet because it automatically resolves the Swift endpoints used for backups.
- Host and domain URL This read-only field combines the host and domain names to display the fully qualified domain name (FQDN) for the database. The maximum length is 63 characters.
Note
To provide your cloud VM Cluster resources with additional security, you can use Oracle Cloud Infrastructure Zero Trust Packet Routing to ensure that only resources identified with security attributes have network permissions to access your resources. Oracle provides Database policy templates that you can use to assist you with creating policies for common database security use cases. To configure it now, you must already have created security attributes with Oracle Cloud Infrastructure Zero Trust Packet Routing. Click Show Advanced Options at the end of this procedure.
Be aware that when you provide security attributes for a cluster, as soon as it is applied, all resources require a Zero Trust Packet policy to access the cluster. If there is a security attribute on an endpoint, then it must satisfy both network security group (NSG) and Oracle Cloud Infrastructure Zero Trust Packet Routing policy (OCI ZPR) rules.
-
Choose a license type: The type of license that you want to use for the VM cluster. Your choice affects metering for billing.
- License Included means the cost of the cloud service includes a license for the Database service.
- Bring Your Own License (BYOL) means you are an Oracle Database customer with an Unlimited License Agreement or Non-Unlimited License Agreement, and you want to use your license with Oracle Cloud Infrastructure. This option removes the need for separate on-premises licenses and cloud licenses.
- Click Create Exadata VM Cluster.
- (Optional) Provide a contact for your VM Cluster. Exadata Database Service on Exascale Infrastructure leverages the OCI Announcements Service. Oracle recommends that you provide your contact details here. Oracle then automatically subscribes you to announcements relevant to this service, including maintenance and outage notifications, among others. If you do not choose to provide a contact now, then you will have to subscribe to announcements manually later, leveraging the OCI Announcements Service directly. To learn more about subscribing, see Subscribing to Announcements.
-
Click Show Advanced Options to specify advanced options for the VM cluster:
-
Time zone: This option is located in the Management tab. The default time zone for the DB system is UTC, but you can specify a different time zone. The time zone options are those supported in both the
Java.util.TimeZone
class and the Oracle Linux operating system. For more information, see DB System Time Zone .Note
If you want to set a time zone other than UTC or the browser-detected time zone, and if you do not see the time zone you want, try selecting the Select another time zone, option, then selecting "Miscellaneous" in the Region or country list and searching the additional Time zone selections.
- SCAN Listener Port: This option is
located in the Network tab. You can assign a SCAN
listener port (TCP/IP) in the range between 1024 and 8999. The default is
1521
Note.
Manually changing the SCAN listener port of a VM cluster after provisioning using the backend software is not supported. This change can cause Data Guard provisioning to fail. - Zero Trust Packet Routing (ZPR): This option is located in the Security attributes tab. Select a namespace, and provide the key and value for the security attribute. To complete this step during configuration, you must already have set up security attributes with Oracle Cloud Infrastructure Zero Trust Packet Routing. You can also add security attributes after configuration, and add them later.
- Tags: If you have permissions to create a resource, then you also have permissions to apply free-form tags to that resource. To apply a defined tag, you must have permissions to use the tag namespace. For more information about tagging, see Resource Tags. If you are not sure whether to apply tags, skip this option (you can apply tags later) or ask your administrator.
-
Using the Console to Enable, Partially Enable, or Disable Diagnostics Collection
You can enable, partially enable, or disable diagnostics collection for your Guest VMs after provisioning the VM cluster. Enabling diagnostics collection at the VM cluster level applies the configuration to all the resources such as DB home, Database, and so on under the VM cluster.
- You are opting in with the understanding that the list of events, metrics, and log files collected can change in the future. You can opt-out of this feature at any time.
- Oracle may add more metrics in the future, but if you have already chosen to collect metrics, you need not update your opt-in value. It will remain enabled/disabled based on your current preference.
- If you have previously opted in for incident log and trace file collection and decide to opt out when Oracle Cloud operations run a log collection job, then the job will run its course and will not cancel. Future log collections won't happen until you opt-in again to the incident logs and trace file collection option.
Using the Console to Update the License Type on a VM Cluster
To modify licensing, be prepared to provide values for the fields required for modifying the licensing information.
To scale VM Clusters
Increase or decrease the ECPUs, memory or storage available to a VM cluster in Oracle Exadata Database Service on Exascale Infrastructure
Scaling up or down VM cluster resources requires thorough auditing of existing usage and capacity management by the customer DB administrator. Review the existing usage to avoid failures during or after a scale down operation. While scaling up, consider how much of these resources are left for the next VM cluster you are planning to create. Oracle Exadata Database Service on Exascale Infrastructure tooling calculates the current usage of memory, local disk, and ASM storage in the VM cluster, adds headroom to it, and arrives at a minimum value below which you cannot scale down, and expects that you specify the value below this minimum value.
- You can scale ECPUs enabled per VM. Keep in mind that memory scales with the total ECPU count.
-
Navigate to the VM Cluster Details page
-
Click Scale VM Cluster.
The Configure the VM Cluster window opens, and displays the current configuration of your VM cluster. .
-
Scale your VM cluster as required:
-
ECPUs enabled per VM: Specify the number of ECPU cores that you want to enable for the VM cluster. The minimum is 8 ECPU. The maximum number of ECPUs is 200 per VM, or limited by the number of total ECPUs you have specified for the VM. The value you select must be a multiple of 4. You can open the reserve additional ECPU section to reserve additional ECPUs.
-
ECPUs additional reserved per VM (read only): Indicates the additional reserved ECPUs. The number of additional ECPUs will be automatically calculated based on the total enabled ECPUs. Additional reserved ECPUs are not active for licensing purposes but are reserved for your VM, and ready and waiting for scaling the Enabled ECPUs.
-
Total ECPUs per VM: Provide a total number of ECPUs to allocate per VM. The total must be a number between 8 and 200.
- Memory per VM (GB): This is a read-only field. It displays amount of memory allocated to each VM. Memory is calculated based on 11 GB per total cores. The Total memory across VM Cluster (GB) field automatically updates to provide you with the total amount of memory allocated across the VM cluster, based on the memory allocation per VM that you specify.
-
-
VM file system storage capacity per VM (GB): Specify storage capacity per VM in gigabytes (GB).
Provide how much storage you want for all VM filesystems together. The VM Filesystems storage includes
/u02
capacity, where your Database Homes will go, along with all of the other VM filesystems (/
,/boot
,/tmp
,/var
,/var/log
,/var/log/audit
,/home
,swap
,kdump
,/u01
,grid
,/u02
). Any extra capacity selected beyond system minimums will go into/u02
.Note
For information about reserved and enabled cores, and an overview of the ExaDB-XS architecture, see "About Exadata Database Service on Exascale Infrastructure"
To add SSH keys to a VM cluster
The VM cluster exists, and you wish to add a another user which requires another SSH key.
- Open the navigation menu. Click Oracle Database, then click Exadata Database Service on Exascale Infrastructure
- Choose your Compartment.
- Click Exadata VM Clusters.
- In the list of VM clusters, find the cluster you want to manage and click its highlighted name.
- Click Add SSH Keys.
- Select one of the following options:
-
Generate SSH key pair: Use this option to create a new SSH key pair. Click both Save Private Key and Save Public Key when using this option. The private key is downloaded to your local machine, and should be stored in a safe location. You cannot download another copy of the private key generated during this operation after completing the operation.
-
Upload SSH key files: Select this option to browse or drag and drop .pub files.
-
Paste SSH keys: Select this option to paste in individual public keys. To paste multiple keys, click + Another SSH Key, and supply a single key for each entry.
-
- Click Save Changes.
Using the Console to Stop, Start, or Reboot a VM Cluster Virtual Machine
Use the console to stop, start, or reboot a virtual machine.
Using the Console to Check the Status of a VM Cluster Virtual Machine
Review the health status of a VM cluster virtual machine.
Using the Console to Move a VM Cluster to Another Compartment
To change the compartment that contains your VM cluster on Oracle Exadata Database Service on Exascale Infrastructure, use this procedure.
When you move a VM cluster, the compartment change is also applied to the virtual machines and databases that are associated with the VM cluster. However, the compartment change does not affect any other associated resources, such as the Exadata infrastructure, which remains in its current compartment.
To change the VM cluster display name
This topic only applies to Oracle Exadata Database Service on Exascale Infrastructure instances using the new Oracle Exadata Database Service on Exascale Infrastructuree instance resource model.
- Open the navigation menu. Click Oracle Database, then click Exadata Database Service on Exascale Infrastructure
- Choose your Compartment.
- Click Exadata VM Clusters under Oracle Exadata Database Service on Exascale Infrastructure.
-
In the list of Exadata VM Clusters resources, click the name of the VM Cluster you're interested in
- On rthe Infrastructure Details page, click More Actions and Update Display Name .
- In the Update Display Name dialog, Enter the New display name, and the current display name as instructed.
- Click Update Display Name.
Using the Console to Terminate a VM Cluster
Before you can terminate a VM cluster, you must first terminate the databases that it contains.
To view details about private DNS configuration
- Open the navigation menu. Under Database, click Exadata Database Service on Exascale Infrastructure.
- Choose the Region that contains your Exadata infrastructure.
- Choose the Compartment that contains your Exadata infrastructure.
- Click VM Clusters.
- Click the name of the VM cluster that is configured with a private DNS you want to view.
- Under the Network section, Private DNS and Private Zone are displayed, if a private DNS is configured.
- Click the Private View name to edit the configuration.
Adding or Removing a VM From a VM Cluster
You can scale VM Clusters horizontally by adding or removing VMs to or from an existing VM Cluster.
- Add a VM to a VM Cluster
Add a Virtual Machine to a VM Cluster - Terminate a VM from a VM Cluster
To remove a virtual machine from a provisioned cluster, use this procedure.
Parent topic: Manage VM Clusters
Add a VM to a VM Cluster
Add a Virtual Machine to a VM Cluster
- This operation is only available with Multi-VM enabled Infrastructure.
- To add a VM to a VM Cluster requires that all TCP ports are open for the client subnet CIDR for ingress and egress.
- Open the navigation menu. Under Oracle Database, click Exadata Database Service on Exascale Infrastructure.
- Choose the Region and Compartment that contains the VM cluster that you want to scale.
- Click VM Clusters.
- Click the name of the VM cluster to which you want to add a virtual machine.
- Under Resources, select Virtual Machines, and click the Add Virtual Machines button.
- In the Add Virual Machines window, select the DB
server where you want the new VM to reside.
Note
The VM that is added will have the same resources as the other VMs in the cluster. - Click Add Virtual Machine.
Add a VM to a VM Cluster is NOT supported using Terraform.
Parent topic: Adding or Removing a VM From a VM Cluster
Terminate a VM from a VM Cluster
To remove a virtual machine from a provisioned cluster, use this procedure.
- Open the navigation menu. Under Oracle Database, click Exadata Database Service on Exascale Infrastructure.
- Choose the Region and Compartment that contains the VM cluster that you want to scale.
- Click VM Clusters.
- Click the name of the VM cluster for which you want to remove a virtual machine.
- On the Exadata VM Cluster Details page, in the Virtual Machines section, select the Virtual Machine that will be removed, click the more commands symbol (three dots) and click Terminate
Remove a VM from a VM Cluster is not supported using Terraform at this time.
Parent topic: Adding or Removing a VM From a VM Cluster
Overview of Automatic Diagnostic Collection
By enabling diagnostics collection and notifications, Oracle Cloud Operations and you will be able to identify, investigate, track, and resolve guest VM issues quickly and effectively. Subscribe to Events to get notified about resource state changes.
-
Enable Diagnostic Events
Allow Oracle to collect and publish critical, warning, error, and information events to you. For more information, see Database Service Events.
-
Enable Health Monitoring
Allow Oracle to collect health metrics/events such as Oracle Database up/down, disk space usage, and so on, and share them with Oracle Cloud operations. You will also receive notification of some events. For more information, see Health Metrics.
-
Enable Incident Logs and Trace Collection
Allow Oracle to collect incident logs and traces to enable fault diagnosis and issue resolution. For more information, see Incident Logs and Trace Files.
Diagnostics Collection is:
- Enabled: When you choose to collect diagnostics, health metrics, incident logs, and trace files (all three options).
- Disabled: When you choose not to collect diagnostics, health metrics, incident logs, and trace files (all three options).
- Partially Enabled: When you choose to collect diagnostics, health metrics, incident logs, and trace files (one or two options).
Disabling diagnostic events and health monitoring will only stop the collection and notification of data/events from the time you uncheck the checkboxes tied to the options. However, historical data will not be purged from Oracle Cloud Operations data repositories.
Parent topic: Manage VM Clusters
Incident Logs and Trace Files
This section lists all of the files that can be collected by Oracle Support if you opt-in for incident logs and trace collection.
- Oracle will create a service request (SR) against the infrastructure Customer Support Identifier (CSI) when an issue is detected and needs customer interaction to resolve.
- The customer's Oralce Cloud Infrastructure tenancy admin email will be used as the CSI contact to create SR and attach logs to it. Ensure tenancy admin is added as a CSI contact in My Oracle Support (MOS).
Oracle Trace File Analyze (TFA) Component Driven Logs Collections
The directories are generally assigned to a component and that component can then be used to guide TFA to the files it needs to collect, for example, requesting the CRS component would tell TFA to look at directories mapped to the CRS component and find files that match the required collection time frame.
If have previously opted in for incident log and trace file collection and decide to opt out when Oracle Cloud operations run a log collection job, then the job will run its course and will not cancel. Future log collections won't happen until you opt-in again to the incident logs and trace file collection option.
TFA is shipped with scripts that run when a particular component
is requested, for example, for CRS component,
crscollect.pl
will run a number
of crsctl
commands and gather the input. By
default, TFA does not redact collected logs.
Table 5-1 Oracle Trace File Analyze (TFA) Component Driven Logs Collections
Component | Script | Files/Directories |
---|---|---|
|
|
|
|
|
|
|
No DB Specific Script - runs |
|
Cloud Tool Logs
- Creg files:
/var/opt/oracle/creg/*.ini
files with masked sensitive info - Cstate file:
/var/opt/oracle/cstate.xml
-
Database related tooling logs:
If
dbName
specified,/var/opt/oracle/log/<dbName>
, else collect logs for all databases/var/opt/oracle/log/
If
dbName
specified,/var/opt/oracle/dbaas_acfs/log/<dbName>
, else collect logs for all databases/var/opt/oracle/log/<dbName>
- Database env files: If
dbName
specified,/home/oracle/<dbName>.env
, else collect logs for all databases/home/oracle/*.env
- Pilot logs:
/home/opc/.pilotBase/logs
- List of log directories:
/var/opt/oracle/log
/var/opt/oracle/dbaas_acfs/log
/var/opt/oracle/dbaas_acfs/dbsystem_details
/var/opt/oracle/dbaas_acfs/job_manager
/opt/oracle/dcs/log
DCS Agent Logs
/opt/oracle/dcs/log/
Tooling-Related Grid Infrastructure/Database Logs
- Grid Infrastructure:
GI_HOME/cfgtoollogs
- Database alertlog:
/u02/app/oracle/diag/rdbms/*/*/alert*.log
Parent topic: Manage VM Clusters
Health Metrics
Review the list of database and non-database health metrics collected by Oracle Trace File Analyzer.
Oracle may add more metrics in the future, but if you have already chosen to collect metrics, you need not update your opt-in value. It will remain enabled/disabled based on your current preference.
Guest VM Health Metrics List - Database Metrics
Table 5-2 Guest VM Health Metrics List - Database Metrics
Metric Name | Metric Display Name | Unit | Aggregation | Interval | Collection Frequency | Description |
---|---|---|---|---|---|---|
|
CPU Utilization |
Percentage |
Mean |
One minute |
Five minutes |
The CPU utilization is expressed as a percentage, which is aggregated across all consumer groups. The utilization percentage is reported with respect to the number of CPUs the database is allowed to use, which is two times the number of ECPUs. |
|
Storage Utilization |
Percentage |
Mean |
One hour |
One hout |
The percentage of provisioned storage capacity currently in use. Represents the total allocated space for all tablespaces. |
|
DB Block Changes |
Changes per second |
Mean |
One minute |
Five minutes |
The Average number of blocks changed per second. |
|
Execute Count |
Count |
Sum |
One minute |
Five minutes |
The number of user and recursive calls that executed SQL statements during the selected interval. |
|
Current Logons |
Count |
Sum |
One minute |
Five minutes |
The number of successful logons during the selected interval. |
|
Transaction Count |
Count |
Sum |
One minute |
Five minutes |
The combined number of user commits and user rollbacks during the selected interval. |
|
User Calls |
Count |
Sum |
One minute |
Five minutes |
The combined number of logons, parses, and execute calls during the selected interval. |
|
Parse Count |
Count |
Sum |
One minute |
Five minutes |
The number of hard and soft parses during the selected interval. |
|
Storage Space Used |
GB |
Max |
One hour |
One hour |
Total amount of storage space used by the database at the collection time. |
|
Storage Space Allocated |
GB |
Max |
One hour |
One hour |
Total amount of storage space allocated to the database at the collection time. |
|
Storage Space Used By Tablespace |
GB |
Max |
One hour |
One hour |
Total amount of storage space used by tablespace at the collection time. In the case of container databases, this metric provides root container tablespaces. |
|
Allocated Storage Space By Tablespace |
GB |
Max |
One hour |
One hour |
Total amount of storage space allocated to the tablespace at the collection time. In the case of container databases, this metric provides root container tablespaces. |
|
Storage Space Utilization By Tablespace |
Percentage |
Mean |
One hour |
One hour |
This indicates the percentage of storage space utilized by the tablespace at the collection time. In the case of container databases, this metric provides root container tablespaces. |
Guest VM Health Metrics List - Non-Database Metrics
Table 5-3 Guest VM Health Metrics List - Non-Database Metrics
Metric Name | Metric Display Name | Unit | Aggregation | Collection Frequency | Description |
---|---|---|---|---|---|
|
Filesystem Utilization |
Percentage |
Max |
One minute |
Percent utilization of provisioned filesystem. |
|
CPU Utilization |
Percentage |
Mean |
One minute |
Percent CPU utilization. |
|
Memory Utilization |
Percentage |
Mean |
One minute |
Percentage of memory available for starting new applications, without swapping.
The available memory can be obtained via the following command: |
|
Swap Utilization |
Percentage |
Mean |
One minute |
Percent utilization of total swap space. |
|
Load Average |
Number |
Mean |
One minute |
System load average over 5 minutes. |
|
Node Status |
Integer |
Mean |
One minute |
Indicates whether the host is reachable. |
Parent topic: Manage VM Clusters
Using the API to Manage Oracle Exadata Database Service on Exascale Infrastructure Instance
Use these API operations to manage Exadata Cloud Infrastructure virtual machines (VMs) and databases on Oracle Exadata Database Service on Exascale Infrastructure (ExaDB-XS).
For information about using the API and signing requests, see REST APIs and Security Credentials. For information about SDKs, see Software Development Kits and Command Line Interface.
Use these API operations to manage Oracle Exadata Database Service on Exascale Infrastructure instance components.
Exascale Database Storage Vault resource
Parent topic: Manage VM Clusters