Oracle Cloud Infrastructure Documentation

Exadata Database

This topic explains the required steps to connect to Exadata Database from Azure Virtual Machine (VM). Configuring Network Security Group (NSG) and connection to Azure VM are prerequisites for connecting to Exadata Database.

Configuring Network Security Group (NSG) and connection to Azure VM are prerequisites for connecting to Exadata Database.

  1. Obtain Exadata Database Connection String
    1. From the Azure Portal, navigate to your Exadata VM Cluster, and then select the Go to OCI button from the Overview section.
    2. From VM Cluster information tab, switch to the 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
demovmc04-y6qpc-scan.ocidemosubneto.ocidemovnet02.oraclevcn.com:1521/GGDB01.ocidemosubneto.ocidemovnet02.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
demovmc04-y6qpc-scan.ocidemosubneto.ocidemovnet02.oraclevcn.com:1521/GGDB_PDB01.paas.oracle.com
        This screenshot shows how to obtain connection string information.
      5. Take a note of Connection String for the following steps.
  2. Connect Oracle SQL Developer to Exadata Database
    1. On Azure VM, 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 a descriptive name to identify the database connection.
      2. From the Database Type dropdown list, select Oracle.
      3. From the Authentication Type dropdown list, 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. From the Role dropdown list, select the database role to assign to the user.
      7. Select the Save Password checkbox to save password with connection in SQL Developer.
      8. From the Connection Type dropdown list, 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 connection list should show Success.
      13. Once the connection is successful, select the Save button.This screenshot shows how to connect to Exadata Database.
      14. Select the Connect button to initiate the connection.This screenshot shows how to connect to Exadata Database.