Oracle Cloud Infrastructure Documentation

Managing Exadata Database Services in Google Cloud

After provisioning any OracleDB@GCP resource, you can use the Google Cloud console for a limited set of management functions.

Common Management Functions from the Google Cloud Console

The following management functions are available for all resources from the Google Cloud console for that resource.

Access the Resource Console

These are the steps to perform to access the resource console.

  1. From the Google Cloud console, select Oracle Database@Google Cloud application.
  2. From the left menu, select Exadata Database.
  3. If the console lists and manages several resources, select the resource type at the top of the console.

List Status for all Resources of the Same Type

These are the steps to perform to list status for all resources of the same type.

  1. Follow the steps to Access the resource console.
  2. Resources will be shown in the list as Succeeded, Failed, or Provisioning.
  3. Access the specifics of that resource by selecting the link in the Name field in the table.

Provision a New Resource

These are the steps to provision a new resource.

  1. Follow the steps to Access the resource console.
  2. Select the + Create icon at the top of the console.
  3. Follow the provisioning flows for Task 1: Provisioning Exadata Infrastructure for Google Cloud or Task 2: Provisioning an Exadata VM Cluster for Google Cloud as needed.

Refresh the Console's Info

These are the steps to perform to refresh the console's info.

  1. Follow the steps to Access the resource console.
  2. Select the Refresh icon at the top of the console.
  3. Wait for the console to reload.

Remove a Resource

These are the steps to perform to remove a resource.

  1. Follow the steps to Access the resource console.
  2. You can remove a single resource from the console by selecting the vertical elipsis on the right side of the table. Once you have selected the resource(s) to remove, you can then select the Delete icon.

Access the OCI Console

These are the steps to perform to access the OCI console.

  1. Follow the steps to Access the resource console.
  2. Select the link to the resource from the Display name field in the table.
  3. Select the MANAGE IN OCI icon at the top of the details page.
  4. Manage the resource from within the OCI console.

Perform a Connectivity Test

These are the steps to perform a connectivity test.

  1. Follow the steps to Access the OCI console.
  2. Navigate to the Pluggable Database Details page.
  3. Select the PDB Connection.
  4. Select Show to expand the Connection String information.
  5. Open Oracle SQL Developer. If you don't have SQL Developer installed, download SQL Developer and install.
  6. Within SQL Developer, open a new connection with the following information.
    1. Name - Enter a name of your choice used to save your connection.
    2. Username - Enter SYS.
    3. Password - Enter the password used when creating the PDB.
    4. Role - Select SYSDBA.
    5. Save Password - Select the box if you security rules allow. If not, you will need to enter the PDB password every time you use this connection in SQL Developer.
    6. Connection Type - Select Basic.
    7. Hostname - Enter one of the host IPs from the Connection Strings above.
    8. Port - The default is 1521. You only need to change this if you have altered default port settings for the PDB.
    9. Service Name - Enter the SERVICE_NAME value from the host IP you previously selected. This is from the Connection Strings above.
    10. Select the Test button. The Status at the bottom of the connections list, should show as Success. If the connection is not a success, one or more of the Hostname, Port, and Service Name fields is incorrect, or the PDB is not currently running.
    11. Select the Save button.
    12. Select the Connect button.

Support for OracleDB@GCP

These are the steps to access support resources.

  1. Follow the steps to Access the OCI console.
  2. From the OCI console, there are two ways to access support resources.
    1. At the top of the page, select the Help (?) icon at the top-right of the menu bar.
    2. On the right-side of the page, select the floating Support icon. NOTE: This icon can be moved by the user, and the precise horizontal location can vary from user to user.
  3. You have several support options from here, including documentation, requesting help via chat, visiting the Support Center, posting a question to a forum, submitting feedback, requesting a limit increase, and creating a support request.
  4. If you need to create a support request, select that option.
  5. The support request page will auto-populate with information needed by Oracle Support Services, including resource name, resource OCID, service group, service, and several other items dependent upon the specific OracleDB@GCP resource.
  6. Select the support option from the following options:
    1. Critical outage for critical production system outage or a critical business function is unavailable or unstable. You or an alternate contact must be available to work this issue 24x7 if needed.
    2. Significant impairment for critical system or a business function experiencing severe loss of service. Operations can continue in a restricted manner. You or an alternate contact are available to work this issue during normal business hours.
    3. Technical issue where functionality, errors, or a performance issue impact some operations.
    4. General guidance where a product or service usage question, product or service setup, or documentation clarification is needed.
  7. Select the Create Support Request button.
  8. The support ticket is created. This ticket can be monitored within the OCI console or via My Oracle Support (MOS).

Access Control for Google Cloud Projects

These are steps to manage access to resources, and specify roles for users in Google Cloud projects.

  1. From the Google Cloud console, navigate to Identity and Access management (IAM) page.
  2. The VIEW BY PRINCIPALS section lists all the principals who have been granted some roles for the project.
  3. To grant access to the principal who does not have any existing roles on the resource, select the + GRANT ACCESS link, and then enter an identifier for the principal.
    Note

    Principals are users, groups, domains and service accounts.
  4. To grant access to the principal who already has other roles on the resource, click the checkbox located near to the Type field, and then select the pencil icon to Edit principal.
  5. Select a role from the dropdown list located under the Assign roles section.
  6. If you want to add a condition to the role, click on the + ADD IAM CONDITION link.
    Note

    Adding a condition to the role is optional.
  7. If you want to add other roles to the principal, select + ADD ANOTHER ROLE, and then click the SAVE button.

Required Permission for Google Cloud Cross-Projects

If you want to provision an Exadata VM Cluster in a Google Cloud project where your Exadata Infrastructure is located in different project, you , or the admin with the required privileges, must assign the Oracle Database@Google Cloud Exadata Infrastructure User role.

Request a Limit Increase for OracleDB@GCP

Learn how to request a service limit increase.

If you need to increase a service limit for your OracleDB@GCP , see Requesting a Limit Increase for Database Resources.