Purpose

This tutorial will show you how to use SSH to connect from your local machine to the Administration server where Oracle Data Integrator is to be installed.

Time to Complete

The tutorial will take about fifteen minutes to complete.

Background

You should be familiar with how to install and configure ODI on premises. You can find most of that information on the web in the ODI home page, documentation, and in Oracle Learning Library (OLL) tutorials such as ODI Getting Started.

Scenario

ODI can run on Windows or Linux, can be managed with a web-based Console or standalone Studio GUI, with or without WebLogic Server (WLS). It can use agents deployed in Standalone, Collocated, and Java Enterprise Edition (JEE) mode. This tutorial will assume Linux for both the client workstation and server, managed by the Weblogic Administration Console, with WLS installed as JCS, and the agents deployed in JEE mode.

The topology of the domain you create can vary, depending upon how many virtual machines and how many Managed Servers you provision as part of your Java Cloud Service subscription.

Note — Only the Enterprise Installation is supported on ODI Cloud Service.

Context

This tutorial assumes a single node JCS deployment.

What Do You Need?

You will need to be familiar with the Oracle Java Cloud Service. If you are not then it is strongly recommended that you run through the Getting Started with Oracle Java Cloud Service tutorial before attempting this one.

Make sure you are familiar with the prerequisites required for Oracle Java Cloud Service on OCI.

The instructions in this tutorial assume that you have performed all of these tasks:

1. Ensure that you have subscriptions for Oracle Storage, Oracle Cloud Infrastructure (OCI) Database, Oracle Virtual Cloud Network, and Oracle Java Cloud Service environments.

   For more information, see Signing Up for Oracle Cloud Infrastructure.

2. Create the VM public and private keys.

   The VM public key is used by the new instance's VM for authentication when you connect to it using an SSH client. When you connect, you must provide the private key that matches the public key.

   When creating an OCI Database instance and Java Cloud Service (JCS) instance you need to specify the public key. You generate an SSH public/private key pair using a standard SSH key generation tool. For more information, see Creating SSH Keys for Use with Oracle Cloud Services in the Oracle Learning Library.

3. Configure an OCI Database instance that meets the Java Cloud Service deployment requirements, including adding a specific policy so that the database appears on the Oracle Java Cloud Service web console as an infrastructure schema database choice.

   For instructions, see:

   • Create an Oracle Cloud Infrastructure Database in the Administering Oracle Java Cloud Service guide.
   • Overview of the Database Service in the Oracle Cloud Infrastructure documentation.

Note: When creating the OCI Database instance to use with the Oracle Java Cloud Service, make sure you have created a policy to permit Oracle Platform Services to create instances in your VCN. Keep the policy current. The policy should include:

• Allow service PSM to inspect vcns in compartment
• Allow service PSM to use subnets in compartment
• Allow service PSM to use vnics in compartment
• Allow service PSM to manage security-lists in compartment
• Allow service PSM to manage all-resources in compartment
Set up the credentials to provide access to the object storage bucket, so that you can select Automatic Backup as the backup option for the database.

When you create an instance of the Oracle Java Cloud Service, all the Oracle Compute Cloud Service VMs required to support the service are provisioned and configured for you. You can access the services and resources provided by the VMs by logging in to the machine through an SSH tunnel. You'll access the VMs from your local machine by using the ssh command in a UNIX command shell.

1. To connect to the Oracle Java Cloud Service instance through SSH, you must find the IP address of the Administration Server VM hosting the instance.
   1. On the Oracle Java Cloud Service Instances page, click the instance you just created.
   2. The public IP address of the Administration Server is available under the Resources section. Make a note of the IP address.

      Note: You must wait for the instance creation to complete before you can see the IP address.

      

2. Start a Linux terminal shell and run the SSH utility.

   ssh -i path_to_private_key opc@IP_of_JCS_Instance_Admin_Server

   In the preceding command:

   Parameter	Description
   path_to_private_key	is the path to the SSH private key file that matches the public key used when your instance was created
   IP_of_JCS Instance_Admin_Server	is the public IP address of the Admin Server VM in n.n.n.n format.
   opc	is the user account.

   For example:

   ssh -i keys/id_rsa opc@10.10.10.10

   You are now logged in as user opc.

3. Switch to user oracle on the JCS Admin Server VM.

   sudo su oracle

4. Turn off the lock screen on the JCS Admin server.

   gconftool-2 -s -t bool /apps/gnome-screensaver/lock_enabled false

5. Start the VNC Server. If prompted for a password, enter one. Make a note of it.

   vncserver -nolisten local -geometry 1680x1050

6. Open a new local terminal to create an SSH tunnel the VNC server port on the Administration Server VM.

   ssh -i path_to_private_key -L 5901:IP_of_Tunnel_Server:5901 opc@IP_of_Admin_Server -N 

   In the preceding command:

   Parameter	Description
   path_to_private_key	Path to your private key file.
   IP_of_Tunnel_Server	The address of the server through which the tunnel is run.
   IP_of_Admin_Server	The destination server (the address of the administration server for your Oracle Java Cloud instance).

   For example:

   ssh -i keys/id_rsa -L  5901:127.0.0.1:5901 opc@10.10.10.10 -N 

7. To get desktop access for the Oracle Java Cloud Server instance,use the VNC Viewer on your local machine to connect to localhost:5901. You will be prompted for the password you entered in step 4.

vncviewer

In the Window that opens, enter localhost:5901 and click OK.

Install the ODI software onto the managed server, as shown in the Installing Oracle Data Integrator OBE.

Once you have installed ODI on the managed server, close the VNC Viewer and then shut the two terminal sessions you opened on the Administration server for the SSH tunnel.

Now you can create the ODI repository using the Repository Creation Utitlity.

• Configuring the Domain for the Java EE Agent, part of Oracle Fusion Middleware Installing and Configuring Oracle Data Integrator documentation.
• Oracle Data Integrator Cloud Service: Getting Started Series on Oracle Learning Library (OLL).
• Oracle WebLogic Server 12c: Administration I, the root of all WLS (and therefore JCS) training. Includes Training on Demand (ToD), Instructor-Led Training (ILT), and Live Virtual Class (LVC) formats.
• Leveraging On-Premises Licenses in the Oracle Public Cloud. This document will tell you which middleware products can be used in conjunction with the Oracle Java Cloud Service.
• Oracle® Fusion Middleware Developer's Guide for the Oracle Data Integrator. This document will tell you how to get started with the Oracle Data Integrator.
• Creating the Oracle Data Integrator repository using the Repository Creation Utitlity.
• Installing Oracle Data Integrator on the Java Cloud Service
• Updating the Java Cloud Service Domain
• Using Oracle Data Integrator to Test Your Domain