View DB systems information

Console

1. Go to the Base Database Servicepage.

   Go to Base Database Service

2. Click the name of the DB system.

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

3. To view change logs, select the Operationstab.

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

   1. Go to the Databasessection.

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

      The Database detailspage shows you the details.

   3. To view the details of the pluggable databases, on the Database detailspage, go to the Pluggable databasessection.

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

      The Pluggable database detailspage shows you the details.

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

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.