SSH to Oracle Exadata Database Service from a Google Cloud Compute Engine Linux VM in Oracle Database@Google Cloud

Introduction

In order to verify the Oracle Exadata Database Service connectivity within Oracle Database@Google Cloud service and locally test database queries quickly, developers can access the command line and connect to an Exadata compute node.

In this tutorial, we will guide you how to Secure Shell (SSH) into the Oracle Exadata Database Service that makes up the Exadata virtual machines (VM) cluster within the Oracle Exadata Cloud Infrastructure in Google Cloud.

Objectives

Prerequisites

Task 1: Connect to Google Cloud Compute Engine as Jump Host

Exadata VM cluster compute nodes are accessible from the Google Cloud VPC selected during its deployment. To access the Exadata VM cluster by SSH, connect to a Google Cloud Compute Engine VM as a jump host in the same VPC.

To connect to the compute instance, click SSH to open a SSH-in-browser window.

SSH-in-browser

Task 2: Authorize your Google Cloud Compute Engine VM to Access the Oracle Exadata Database Service VM Cluster

  1. In SSH-in-browser, click UPLOAD FILE to upload the SSH key provided to access the Exadata VM cluster compute nodes.

    image

  2. Run the following command to move the SSH key file exadata-private-key-file to the local SSH folder and change the permissions.

    mv exadata-private-key-file .ssh
    chmod 600 .ssh/exadata-private-key-file
    

Or

You can generate a new SSH key and add the SSH key to the Exadata VM cluster.

Follow these steps to generate a new SSH key:

  1. In Google Cloud VM, run the ssh-keygen command to create a new SSH authentication key pair.

  2. Copy the content of the generated public key using the following command.

    cat .ssh/id_rsa.pub
    
  3. Go to the Google Cloud Console and click MANAGE IN OCI to open the OCI Console.

    Manage in OCI

  4. In the Exadata VM Cluster Details page, click Add SSH Keys to add the SSH Rivest–Shamir–Adleman (RSA) public key.

    OCI VMC Details

  5. Select Paste SSH keys, paste the SSH key copied from the previous step, and click Save changes.

    Add SSH keys

Task 3: Connect to the Oracle Exadata Database Service VM Cluster

  1. Go to the Google Cloud Console, click MANAGE IN OCI to open the OCI Console and note the Private IP addresses for each of the two database servers.

    Exadata VMs

    Initiate a connection to the Oracle Exadata Database Service from the Google Cloud Compute Engine VM in the same VPC.

    By default, Oracle Exadata Database Service is configured to enable SSH connections using the opc operating system user account.

  2. Run the following command.

    $ ssh -i opc@node-ip-address
    

    You are now logged into the Exadata VM.

    Exadata VMs

Acknowledgments

More Learning Resources

Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit education.oracle.com/learning-explorer to become an Oracle Learning Explorer.

For product documentation, visit Oracle Help Center.