Getting Started with Oracle Data Mining on the Cloud

(1)

Getting Started with

Oracle Data Mining on the Cloud

A step-by-step graphical guide to launching

and connecting to the Oracle Data Mining

Amazon Machine Image (AMI)

version 0.86

(2)

How to use this guide…

• This guide is intended to be more pictorial

than textual.

• Screen captures of the various tool interfaces

you need to use have been annotated with

numbered steps , highlighted areas ,

and occasional guiding text.

• For textual descriptions, see the

ODM on the Cloud Detail webpage.

1

(3)

Before you start…

• Download and install

–

PuTTYgen

and

PuTTY

Download All

– Oracle Data Miner Classic GUI for 11g

Download

Installation Instructions

• Connecting to the cloud

– Connecting the first time requires some setup

– Connecting subsequently is very easy

(see slides 33 and 34)

(4)

1

Create an AWS Account

http://aws.amazon.com/ec2

(5)

1

Sign in to the AWS Management Console

(6)

1

Create and Download a Key Pair

(7)

7

1

(8)

8

1-save use in PuTTYgen

(9)

1

3-select the key pair .pem file created from AWS

4

Open PuTTYgen

2-select All Files

(10)

(11)

1

Restrict Access to Your Instance

(12)

Create a Security Group

12

1

2

(13)

13

1-populate fields with SSH, TCP, 22, 22, your IP or group

2-click save

Note: your host IP address can be

(14)

14

1-create a second row, populating fields with SSH, TCP, 1521, 1521, your IP or group

(15)

1

Launch the ODM AMI Instance

(16)

1

2

3

Look up the ODM AMI named

“ami-117b9778”

Note: It may take up to 30 seconds or more

(17)

1

(18)

1

(19)

2

1-select your key pair

(20)

2

(21)

1

Note: It will take several minutes

(22)

1-click to refresh 2-click to show details

(23)

1-copy this hostname for PuTTY

Copy the Instance Public DNS

(24)

1-paste Public DNS from AWS

2-provide a name 3

4 5

6-select .ppk file

created from PuTTYgen

Open

PuTTY

7

24

Note: The following

(25)

This step is needed only if

inside a firewall

25

1

2

(26)

(27)

6

(28)

If you are inside a firewall…

• You may require tunneling to allow Oracle Data Miner to

connect to the database instance

• The following steps enable tunneling

• IMPORTANT:

If you are outside a firewall

, you do not need to keep the

PuTTY window open to access your AMI instance using Oracle

Data Miner.

If you are inside a firewall

, you must keep the PuTTY window

open to access your AMI instance using Oracle Data Miner.

(29)

1-type ifconfig

2-copy inet address for PuTTY tunnels specification

8-specify an open port

9-paste inet addr and add “:1521” 10 4-Open PuTTY 6 3-exit 7 5-select name of saved session

29

Note: Remember the port number specified

(30)

Note: When within a firewall, you must keep this PuTTY

(31)

Open Oracle Data Miner Classic

Windows: <odminer folder>/bin/odminerw.exe

MacOS: cd <odminer folder>/bin (from terminal window)

chmod +x odminer

./odminer &

1-choose a previously created connection,

or click New…

(32)

1-assign a connection name

2-specify user dmuser and password dmuser

3-if inside a firewall specify host as localhost with port, e.g., 6000,

otherwise, specify host as the Public DNS with port 1521

4-specify SID as ‘odmdb’

5

6

Note: On Mac OS, to be able to cut and paste content, e.g., Public DNS in host field,

(33)

You’ve arrived. Start mining…

(34)

Connecting the second time…

outside the firewall

34

1-choose previously created connection Open Oracle Data Miner Classic

2

(35)

Connecting the second time…

inside the firewall

35

1-Open PuTTY

3

2-select name of saved session 4

5-login as root

Note: When within a firewall, you must keep this PuTTY

window open for the duration of your connection to the AMI instance.

(36)

To Shutdown Your AMI Instance

1

(37)

1-right click the instance row

Note: When you terminate an instance, all user

(38)

Notes

In Oracle Data Miner,

this error message may mean tunneling

is either not configured or configured incorrectly

(39)

To access the database via SQLPLUS

39

1-login as root

2- login as “oracle” using su - oracle 3-login to the dmuser schema

(40)