Monitoring Your Database Cloud Service

Overview

    Purpose

    This tutorial covers how to monitor your Database Cloud Service in the Oracle Cloud.

    Time to Complete

    Approximately 30 minutes

    Introduction

    Oracle Cloud provides two windows for monitoring and operating services:

    • My Services - Monitor and operate all activated services within a single identity domain in My Services.

    • My Account - Monitor the status of all services for an entire account, across all data centers and identity domains in My Services. Active, expired, and pending services are displayed in My Account.

    In this tutorial, you perform the steps to monitor your account and database cloud services.

    Prerequisites

    Before starting this tutorial, you should have performed the Signing Up for a Database Cloud Service tutorial.

Logging into Your Database Cloud Service

    You will first need to login to your Database Cloud Service. Perform the following steps:

    Open a browser and enter the following URL:

    http://cloud.oracle.com

    Click Sign In.

    You want to see all the services for your account. Click the Sign In to My Account button.

    Enter your Oracle.com credentials and click Sign In.

    Click My Account.



    You see a list of services that you have requested a trial (pending processing) or you have a pending trial waiting for activation. Click Status History.
     

    The status history shows the % of time a service is up and running. In this case, you are looking at the daily view. Click Account Administrators.

    A list of administrators for each service is listed. You can add additional administrators from this page. Click Add Account Administrator.

    If you want to add an Account Administrator, enter the valid account information and click Add Account Administrator. In this case, you can click the close icon in the upper right.

    Click About.

    A list of tasks that an account administrator can perform is displayed. Click Services.

Reviewing a Service

    In this section, you review a particular service that your account has access to. Perform the following steps:

    Select a service name link from the list.

    On the Services Overview page, you see that the service is active and when it was created. Click the Utilization tab.

    The Utilization tab provides a history of the Storage and Objects utilization within the service. Since this service was just created, there is currently no history. Click the Status tab.

    The Current Monthly calendar is displayed and shows the availability % of the service for each day of the month. Click the Overview tab.

    Your are ready to access the service. Click the My Services URL link.

    Login with your Service Credentials and click Sign In.

    The service for the identity domain is displayed. Click Notifications.

    You may receive system wide notifications and/or service level notifications which will be displayed on this page. Click Status History.

    This represents the uptime percent. If a second number is noted (e.g. 90 % / 10 %), that is unknown, meaning the service could have been up or down. If 'na', the service was not active during the timeframe. Click About.

    A list of tasks that can be performed for a service is displayed. Click Services.

Monitoring Your Database Cloud Service

    In this section, you review varied information about the database cloud service. Perform the following steps:

    The status indicator to the left of each activated service gives you a quick overview of the status. If the icon is green, the service is up and running. Other statuses are color coded with the meaning shown in the hover text. You see that for this service you have a database trial.

    The actions on the right of this window mean the following:

    is the Details icon that goes to the Overview tab of the service. You examine this tab in the next section.

    is the Utilization icon that goes to the Utilization tab of the service. You examine this tab in the next section.

    is the Launch button which launches the service. You can also launch the server on the service page which you review in the next section.

    Click the Details icon.

    From the Overview tab, you see details about your database cloud service. You also can select the various section links to review the current usage and additional details about this database cloud service. Select Additional Details.

    Under Additional Details, you see the number of objects and which objects they are. At any point, you can click Refresh Now to update the information presented. Click the Utilization tab.

    The service utilization data helps you determine whether the service resource allocations are under or over utilized. If a service is under utilized, you may want to evaluate and consider deployment of additional applications or increase http traffic from end users to this service. If it is over utilized, you may want to consider adding additional services and also consider clustering to better load manage.

    The latest usage displays a snapshot of the last set of metrics collected and when those metrics were collected. The history displays usage metrics per day for the last seven days.

    Click the Applications tab.

    From the Applications tab, you can see the applications that have been installed or created in this database cloud service. For more information on how to install or create an application, perform the Installing a Application into your Database Cloud Service. To see an application that has been created or installed, you must click the Refresh Now button explicited. It is not refreshed automatically. Click the Data Export tab.

    From the Data Export tab, you can create a data pump export of your data and data structures. Click the Administration tab..

    From the Administration tab, you can enable application archiving which will create a backup of your application any time it changes. Click Update.

    Keep the following in mind when enabling application archiving:

    • The archive is stored in your database tables within your schema which will be counted against your tablespace quota.
    • By default, 5 versions are kept.
    • Archives are created based on changes in the application.
    • Each night a check is made to see if there are application changes, if so, an archive is created. If no change was made, then an archive is not created.
    • If there are already 5 versions and an archive is to be created, the oldest version will be deleted and the new one will be created.

    Select the Enable Application Archive checkbox and click Update Application Archiving.

    Your applications will automatically be archived daily when changes occur. On the Administration page, you can also add a description. click the Edit button.

    Enter a Description and click Update Description.

    Your description was updated. Click the Resources tab.

    The Resources tab offers links to service-specific resources. In this example, there are links for database and Oracle Cloud resources.

Summary

    In this tutorial, you have learned how to:

    • Review your account
    • Review a service
    • Monitor your database cloud service

    Resources

To help navigate this Oracle by Example, note the following:

Hiding Header Buttons:
Click the Title to hide the buttons in the header. To show the buttons again, simply click the Title again.
Topic List Button:
A list of all the topics. Click one of the topics to navigate to that section.
Expand/Collapse All Topics:
To show/hide all the detail for all the sections. By default, all topics are collapsed
Show/Hide All Images:
To show/hide all the screenshots. By default, all images are displayed.
Print:
To print the content. The content currently displayed or hidden will be printed.

To navigate to a particular section in this tutorial, select the topic from the list.