Administering Your Database Cloud Service

Overview

Purpose

This tutorial covers how to administer your Oracle Database Cloud Service environment and databases.  

Last Updated

March 2016, Release 16.1.5

Please note that Oracle develops its cloud services in an agile manner and makes rapid changes to meet our users' needs. Therefore this tutorial may not reflect all of the changes since the last update to this service. For the very latest information see Oracle Database Cloud Service on Oracle Help Center.

Time to Complete

Approximately 40 minutes.

Introduction

After you create database instances in Oracle Database Cloud Service, you can administer and monitor the databases and your Oracle Database Cloud Service using a variety of provided tools.

For detailed information on using Oracle Database Cloud Service, including connecting to database instances, see Oracle Database Cloud Service on Oracle Help Center.

Scenario

In this tutorial, you explore the tools provided for administering your Oracle Database Cloud Service and your database instances. You will:

  • Access the Database Cloud Service console for:
    • Creating and deleting database instances
    • Scaling up a database 
    • Patching a database
  • Access the Compute console for:
    • Creating a storage volume
    • Enabling access rules
    • Locating SSH public keys
    • Updating users
  • Access the DBaaS Monitor console for:
    • Checking database status, storage, user sessions, wait events, alert logs
    • Configuring database parameters
  • Access the Enterprise Manager console for:
    • Monitoring a database
  • Access the GlassFish Administration console for:
    • Restarting and stopping the Oracle GlassFish Server

Software Requirements

  • You need one of the supported browsers listed in the following table:

  • Browser Version
    Microsoft Internet Explorer 9 or 10; set Browser Mode to IE9 or IE10
    Mozilla Firefox 24 and later
    Google Chrome 29 and later
    Apple Safari 6
Note: This release does not support mobile browsers.

Prerequisites

Before starting this tutorial, you should:

Logging In to the Database Cloud Service Console

Log in to the Oracle Database Cloud Service console using the credentials provided by your Oracle Cloud account administrator. For details on accessing the console, see Accessing the Oracle Database Cloud Service Console.

  • Your administrator may provide you a link to the My Services console, from which you can choose Oracle Database Cloud Service.
  • Or, your administrator may provide you a direct link to the Oracle Database Cloud Service console.
  1. At the cloud.oracle.com sign-in page, in the Select Data Center drop-down menu, select Public Cloud Services.

    select data center
  2. Click Sign In to My Services.

    sign in to my services

  3. You are prompted to sign in. Enter your user name and password, and the identity domain for your Oracle Database Cloud Service. Click Sign In.

    sign in dialog

  4. The My Services dashboard lists the services for which you have subscriptions. From the Consoles drop-down menu, select Database Cloud Service.

    from consoles select dbcs

  5. The Database Cloud Service console is displayed.
dbcs console is displayed

Examining the Database Cloud Service Console


The Database Cloud Service console presents an interface for creating, deleting, and managing database instances. You can click an instance to examine the details of the instance and perform patching and scaling of resources for the instance.
  1. Across the top of the console is a summary display of the amount of database instances, OCPUs, memory, storage, and public IPs in your Oracle Database Cloud Service. Below that is a list of your database instances.  To create a database instance, you would click Create Instance.

    Note: This tutorial does not cover database creation. To learn how to create a database instance in Oracle Database Cloud Service, see the tutorial Creating a Database Cloud Service Instance
    click create instance
  2. To view the details of a database instance and perform patching and scaling of that database, click the name of the instance.

    click to view details
  3. The database details page presents details using two tiles along the left of the page: OVERVIEW and ADMINISTRATION. The details page opens at the OVERVIEW tile. Examine the information listed, including the public IP address, SID, pluggable database name, and more.

    database details page
  4. You may need to scale up your Oracle Database Cloud Service instance compute shape to improve performance, add storage, or switch to a high-memory option. To scale up the compute shape of your service instance, click Scale Up.

    click scale up
  5. The Database Cloud Service Scaling overlay is displayed. Note that the overlay includes information about the instance's current compute shape. You can use the drop-down menu to select a new compute shape. Click Cancel.
    Note: Currently, there is no support for scaling down a service.

    scaling up overlay
  6. Returning to the database details page, click the ADMINISTRATION tile to manage patching. If any patches are available, they will be listed in the Available Patches section. You can apply a patch by clicking Patch.
    Note:
    See Patching Database Cloud Servicefor details about prerequisites for patching, and alternatively using the dbpatchm subcommand of the dbaascli utility on the service instance’s VM.

    administration tab

Examining the Compute Console


You use the Compute console to create storage volumes, manage access rules, locate SSH public keys, and manage users. You can access the Compute console from My Services or the Database Cloud Service console.
  1. From the Consoles drop-down menu, select Compute Cloud Service.

    select compute cloud service
  2. The Compute console Overview page presents information using two tiles along the left of the page: Instances and Storage. The console opens at the Instances tile, which displays a list of your instances.

    compute overview page
  3. Click the Storage tile to see a list of your storage volumes. Click Create Storage Volume to see how to create a new storage volume.

    storage tile
  4. You define a new storage volume by providing the name, size in gigabytes, a description, the storage property (choose /oracle/public/storage/default), and the name of the instance to which you want to attach this storage volume.
    Note: When you create a database instance using the Database Cloud Service wizard, a storage volume is automatically created, partitioned, formatted and mounted for you. However, if you wish to add additional storage, you will need to create, partition, format, and mount the additional storage volumes. For details, see Scaling a Database Deployment.

    Examine the drop-down fields and click Cancel.

    storage volume details
  5. Next, let's look at the facilities for controlling network access between your instances and the Internet.
    Note: for details on managing network access to your database instances, see Enabling Access to a Compute Node Port in Using Oracle Database Cloud Service.

    Click the Network tab at the top of the page. A set of tiles appear vertically along the left side of the page: Access Rules, Network Groups, Protocols, and IP Lists.

    By default, the Access Rules tile is opened. A list of access rules and their enablement status is displayed. You can create, delete, and update access rules from this page.

    network tab for access rules
  6. Click the menu to the right of one of the access rules, and select Update.

    click update access rule
  7. The Update Access Rule window is displayed. Observe how you can toggle the status between Enabled and Disabled.
    Note: enabling the rule allows the protocol to be initiated from the source to the destination, thus overriding the network group policies.
    Click Cancel.

    update access rule page
  8. Click the Security tab at the top of the page. Use the Security page to view the keys associated with your services.

    When you create a database instance, you need to specify a public key, either by uploading a key file or by entering the name of a key that was uploaded earlier, using the full hierarchical name of the key. To discover the full hierarchical name of a key, hover over the short name of the key in the Security page.

    security page
  9. Click the Users tab at the top of the page. This brings you out of the Compute console and into the My Services console's Users page. Here you can add, import, and modify users, as well as reset passwords and manage roles.

    Note that the Users page opens at the Users tab. There are also tabs for managing SFTP Users, Roles, Custom Roles, Identity Self Service, and Contacts.

    From the menu to the right of one of your users, select Manage Roles.

    manage roles
  10. The Manage Roles window lets you assign or remove roles for a user.
    Note: these roles grant privileges in specific service consoles and are unrelated to database roles.
    Click Cancel.

    manage roles window
  11. At the top right corner of the My Services console, click Consoles and select Database Cloud Service to return to the Database Cloud Service console.

    return to database cloud service console

Examining DBaaS Monitor

 
Use DBaaS Monitor to monitor your Oracle Database Cloud Service and the database instances in it. You connect to the Monitor via Port 443 of your Database Cloud Service VM. For detailed information about either opening Port 443 or creating an SSH tunnel to Port 443, see either the documentation topic Accessing Oracle DBaaS Monitor or the video Monitoring a Database Instance in the Oracle Database Cloud Service.
  1. At the end of the previous section, you returned from the My Services console to the Database Cloud Service console.
    To the right of the database instance you wish to monitor, click the menu and note the four choices: Open DBaaS Monitor Console, Open Application Express Console, Open GlassFish Administration Console, and Open EM Console.
    Click Open DBaaS Monitor Console.

    open dbaas monitor console
  2. At the prompt, enter dbaas_monitor as the user name. For the password, use whatever password was specified when your database instance was created. Click Log In.

    monitor login dialog
  3. The Monitor home appears, displaying generic information about the database status, storage, sessions, and alerts.

    To access the Monitor page, click Monitor at the top of the page and select RDBMS.

    monitor home page
  4. The Database Monitor page contains four sections: Storage, Alert Log, Session, and Wait Events. Each section links to a more detailed view of the monitored area.
    Click Storage and wait a few seconds for the diagram to appear.

    database monitor page
  5. The Storage page displays a breakdown of the storage currently allocate to the database. The inner ring shows the distribution of the allocated space among the different tablespaces, while the outer ring represents the used space in each tablespace. The outer ring also shows the free space in a tablespace.
    To get details about the segments that use space in one of the tablespaces, click the tablespace name on the right of the page. Click Example.

    storage page
  6. The tablespace detailed page provides an interactive report on the segments that exist within the tablespace. Most segments are user objects, and they include tables, large objects, and indexes.

    click update access rule
  7. Returning to the Database Monitor page, click Alert Log. An interactive report displays the entries in the database's alert log. The alert log is a chronological log of messages and errors commonly used to learn whether the background processes have encountered errors.

    click alert log

    database alert log
  8. Returning to the Database Monitor page, click Sessions to view open user sessions. An interactive report displays information about all currently opened sessions in the database. The top-most table shows summarized data about each open session. If you click certain rows in this table, you can scroll down to the bottom of the window to see more detailed information about that session.

    click sessions

    sessions page

    session detailed row info

  9. Returning to the Database Monitor page, click Wait Events to view the wait events in real time. Your database may not show wait events. In this example, the wait events are essentially of CPU consumption, plus a little bit of system I/O, and various waits categorized as "Other".

    click wait events

    wait events

  10. Returning to the Database Monitor page,click the Configure tab at the top of the page, and select RDBMS. The Database Configuration page displays two sections: Configure Database and Features. The Features section reports the enablement status of major Oracle database features. In this example, RAC is disabled, while Application Express, Multimedia, Spatial, OLAP, RAC, and XDB are enabled. 

    click configure select rdbms

    database configuration page

  11. In the Configure Database section, click Parameter Settings to view or modify current parameter values. 

    click parameter settings
The Database Parameters page appears. To modify the value of a parameter, select the parameter, change its value, and click the Save changes button at the top. You will have an opportunity to review your change before applying it. Changes that are saved to memory will take effect immediately across all sessions, but will be lost upon the next instance shutdown. Changes that are saved to the SPFILE will take effect upon the next instance startup and are persistent.

change a parameter

Summary

In this tutorial, you learned to:

  • Access the tools provided in the Oracle Database Cloud Service to administer the service and your database instances

Resources

Credits

  • Lead Curriculum Developer: Rick Green
  • Other Contributors: Brian Spendolini, Jim Spiller, Mike Fitch

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

Topic List:
Click a topic to navigate to that section.
Expand All Topics:
Click the button to show or hide the details for the sections. By default, all topics are collapsed.
Hide All Images:
Click the button to show or hide the screenshots. By default, all images are displayed.
Print:
Click the button to print the content. The content that is currently displayed or hidden is printed.

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