View DB systems information

This page describes how to view information for a DB system and its databases in Google Cloud.

Before you begin

Make sure that you have the required Identity and Access Management (IAM) roles and permissions to view details of a DB system and its databases:

  • roles/oracledatabase.dbSystemViewer
  • roles/oracledatabase.databaseViewer
  • roles/oracledatabase.pluggableDatabaseViewer

For information about how to assign roles, see Apply IAM roles.

View DB system details

To view details of a DB system and its databases, do the following:

Console

  1. Go to the Base Database Service page.

    Go to Base Database Service

  2. Click the name of the DB system.

    The DB system details page shows you the details of the DB system.

  3. To view change logs, select the Operations tab.

  4. To view the details of the databases, do the following:

    1. Go to the Databases section.

    2. Click the name of the container database to view its details.

      The Database details page shows you the details.

    3. To view the details of the pluggable databases, on the Database details page, go to the Pluggable databases section.

    4. Click the name of a pluggable database to view its details.

      The Pluggable database details page shows you the details.

    5. To view the connection strings of the pluggable database, select the Connections tab.

API

  • List DB systems

    curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json" \
"https://oracledatabase.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/dbSystems"

    Replace the following:

    • PROJECT_ID: the ID of your Google Cloud project. If you're using a Shared VPC, then this project ID is the ID of your host project.
    • REGION: the region of your DB systems.

  • View DB system details

    curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json" \
"https://oracledatabase.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/dbSystems/DB_SYSTEM_ID"

    Replace the following:

    • PROJECT_ID: the ID of your Google Cloud project. If you're using a Shared VPC, then this project ID is the ID of your host project.
    • REGION: the region of your DB systems.
    • DB_SYSTEM_ID: the ID of your DB system.

  • List container databases of a DB system

    curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json" \
"https://oracledatabase.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/databases?filter="dbSystem=\"projects/PROJECT_ID/locations/REGION/dbSystems/DB_SYSTEM_ID\""

    Replace the following:

    • PROJECT_ID: the ID of your Google Cloud project which contains your DB system. If you're using a Shared VPC, then this project ID is the ID of your host project.
    • REGION: the region of your DB system.
    • DB_SYSTEM_ID: the ID of your DB system.

  • View container database details

    curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json" \
"https://oracledatabase.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/databases/CONTAINER_DB_ID"

    Replace the following:

    • PROJECT_ID: the ID of your Google Cloud project. If you're using a Shared VPC, then this project ID is the ID of your host project.
    • REGION: the region of your DB system.
    • CONTAINER_DB_ID: the ID of your container database.

  • List pluggable databases of a container database

    curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json" \
"https://oracledatabase.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/pluggableDatabases?filter="database=\"projects/PROJECT_ID/locations/REGION/databases/CONTAINER_DB_ID\""

    Replace the following:

    • PROJECT_ID: the ID of your Google Cloud project which contains your DB system. If you're using a Shared VPC, then this project ID is the ID of your host project.
    • REGION: the region of your DB system.
    • CONTAINER_DB_ID: the ID of your container database.

  • View pluggable database details

    curl -X GET \
-H "Authorization: Bearer $(gcloud auth print-access-token)" \
-H "Content-Type: application/json" \
"https://oracledatabase.googleapis.com/v1/projects/PROJECT_ID/locations/REGION/pluggableDatabases/PLUGGABLE_DB_ID"

    Replace the following:

    • PROJECT_ID: the ID of your Google Cloud project. If you're using a Shared VPC, then this project ID is the ID of your host project.
    • REGION: the region of your DB system.
    • PLUGGABLE_DB_ID: the ID of your pluggable database.