Administering Your Database Cloud Service

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.

To view the details of a database instance and perform patching and scaling of that database, click the name of the instance.

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.

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.

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.

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.

From the Consoles drop-down menu, select Compute Cloud Service.

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.

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.

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.

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.

Click the menu to the right of one of the access rules, and select Update.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.