Exascale Database

Configuring Network Security Group (NSG) and connection to Google Cloud VM instance are prerequisites for connecting to Exascale Database.

1. Obtain Exascale Database Connection String
   1. From the Google Cloud console, navigate to your Exascale VM Cluster and then select the Manage in OCI button from the Details page.
   2. From the VM Cluster information tab, switch to Databases tab.
   3. For obtaining Container Database (CDB) connection string, complete the following:
      1. Select the three dots (...) at the end of row item, and then select the View DB connection option.
      2. Copy the Connection String information where the Format is set to Easy Connect.

         # Example CDB Easy connection string
         demodr02-scan-nutvo.qrlnrkxgak.vc98a9ea4.oraclevcn.com:1521/fsdrdb01_b.qrlnrkxgak.vc98a9ea4.oraclevcn.com

   4. For obtaining Pluggable Database (PDB) connection string, complete the following:
      1. Select the Container Database (CDB) name in the list.
      2. Switch to the Pluggable Databases (PDB) tab.
      3. Select the three dots (...) at the end of row item, and then select the PDB connection option.
      4. Copy the Connection String information where the Format is set to Easy Connect.

         # Example PDB Easy connection string
         demodr02-scan-nutvo.qrlnrkxgak.vc98a9ea4.oraclevcn.com:1521/fsdrdb01_PDB1.paas.oracle.com

      
   5. Take a note of Connection String for the following steps.
2. Connect Oracle SQL Developer to Exascale Database
   1. Launch the SQL Developer application and select the + icon to create a new database connection.
   2. To configure SQL Developer, complete the following substeps:
      1. In the Name field, enter the Name to use for this database connection.
      2. In the Database Type field, select Oracle.
      3. In the Authentication Type field, select Default.
      4. In the Username field, enter the name of the database user.
      5. In the Password field, enter the password of the user.
      6. In the Role field, select the database role to assign to the user.
      7. Select the Save Password checkbox to save password with connection in SQL Developer.
      8. In the Connection Type field, select the Basic option as your database connection type.
      9. Enter the Hostname information from the Easy connect connection string. For example, first part is known as SCAN DNS Name.
      10. You can enter 1521 as the Port information or provide your listener port.
      11. Enter a Service name from the Easy connect connection string. For example, second part after forward slash "/".
      12. Select the Test button. The Status at the bottom of the connections list should show Success.
      13. Once the connection is successful, select the Save button.
      14. Select the Connect button to initiate the connection.