Exadata Database

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

1. Obtain Exadata Database Connection String
   1. From the Google Cloud console, navigate to your Exadata 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
         demovm03-b72rz-scan.yykrhpnoxd.v1217cd62.oraclevcn.com:1521/demodb03.yykrhpnoxd.v1217cd62.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
         demovm03-b72rz-scan.yykrhpnoxd.v1217cd62.oraclevcn.com:1521/demodb03_DEMOPDB03.paas.oracle.com

      
   5. Take a note of Connection String for the following steps.
2. Connect Oracle SQL Developer to Exadata 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 Username field, enter the name of the user for whom this database connection is being created. For example, you can enter ADMIN.
      4. In the Password field, enter the password of the user.
      5. In the Role field, select the default role to assign to the user.
      6. Select the Save Password checkbox if your security rules allow.
      7. In the Connection Type field, select the Basic option as your database connection type.
      8. Enter the Hostname information by providing your Exadata Database private IP address.
      9. You can enter 1521 as the Port information or provide your listener port.
      10. Enter a descriptive Service name.
      11. Select the Test button. The Status at the bottom of the connections list should show Success. If the connection is not successful, the wallet may be out of date or the Exadata Database may not be running.
      12. Once the connection is successful, select the Save button.
      13. Select the Connect button to initiate the connection.