Oracle Cloud Infrastructure Documentation

Managing Autonomous Database Resources

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

  1. From the Google Cloud console, select Oracle Database@Google Cloud application.
  2. From the left menu, select Autonomous 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

  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

  1. Follow the steps to Access the resource console.
  2. Select the + Create icon at the top of the console.
  3. Follow the provisioning flow for Provisioning an Autonomous Database.

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

  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

  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

  1. Follow the steps to Access the OCI console.
  2. Navigate to the Autonomous Database Details page.
  3. Select the Database Connection.
  4. Select the Download wallet button.
  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 ADMIN.
    3. Password - Enter the password used when creating the Autonomous Database.
    4. Role - Select default.
    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 Cloud Wallet.
    7. Configuration File - Select Browse, and select the wallet you downloaded.
    8. Select the Test button. The Status at the bottom of the connections list, should show as Success. If the connection is not a success, the wallet is out of date, or the ADB is not currently running.
    9. Select the Save button.
    10. Select the Connect button.

Support for OracleDB@GCP

  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).