I found here very good image for VirtualBox with oracle DB and Oracle Linux. But problem is, that I want to use Oracle 11g, but not 12c as in this image. I can't find link for this iso, but I am sure, that it must be in offcial Oracle site.
- Oracle VM VirtualBox Extension Pack. Free for personal, educational or evaluation use under the terms of the VirtualBox Personal Use and Evaluation License on Windows, Mac OS X, Linux and Solaris x-86 platforms.
- Oracle® Data Integrator. Getting Started. 12c (12.1.3) E57393-01. This document provides instructions on how to install the Oracle Data Integrator (ODI) 12c Getting Started Virtual Machine (VM).
Getting Started
You can load your own data into the VM or use the Oracle MoviePlex demo data that's provided. Oracle has created videos, sample code and hands-on labs based on Oracle MoviePlex that will help you learn how to develop big data applications using Oracle's big data platform. All of the collateral used to develop this application is included in the VM.
Odi 12c Download
Oracle MoviePlex
Oracle MoviePlex is a fictitious on-line movie streaming company. Customers log into Oracle MoviePlex where they are presented with a targeted list of movies based on their past viewing behavior. Because of this personalized experience and reliable and fast performance, customers spend a lot of money with the company and it has become extremely profitable :).
Hands-on Labs
There are several hands-on-labs available to help you get started with the platform:
Training Collateral | Description |
---|---|
Oracle Big Data Learning Library | Numerous hands on labs and videos for capabilities that span the Oracle Big Data platform. |
Implementing Big Data Projects | Provides the top 10 steps to consider when implementing big data projects |
Oracle Big Data Administration Series | The tutorials in this series teach you how to perform administration tasks for the Oracle Big Data Appliance. They also cover:
|
Analyze All Your Data with Oracle Big Data SQL | Learn how to securely analyze all your data - across both Hadoop and Oracle Database 12c - using Oracle Big Data SQL |
Big Data SQL Tutorial Series | Series of videos that introduces you to Big Data SQL, describes performance features, highlights usage with information lifecycle management and more. |
Oracle Big Data Spatial and Graph: Using Property Graph | Use BGDSG's Property Graph feature to inspect graph properties, query property graph data, and visualize property graph data:
|
Oracle Big Data Spatial and Graph: Spatial Vector Analysis | This tutorial covers the use of Oracle Big Data Spatial and Graph to perform analysis using Spatial Vector functionality. You will learn how to:
|
Oracle Big Data Spatial and Graph: Spatial Raster Analysis | This tutorial covers the use of Oracle Big Data Spatial and Graph to perform analysis using Spatial Raster functionality. You will learn how to:
|
Oracle NoSQL Database - Installation/cluster topology deployment (pdf | scripts) | Learn how simple and intuitive it is to deploy a highly available (production ready) Oracle NoSQL Database cluster. |
Oracle NoSQL Database on Oracle Learning Library | Access data in Oracle NoSQL Database from Oracle Database 12c using external tables. |
Data Manipulation with Hive and Pig (pdf) | Quick introduction to HDFS, Pig and Hive. |
Data Integration Product Library | Wide breadth of content covering Oracle Data Integrator 12c |
Tame Big Data with Oracle Data Integration | Learn about how to design Hadoop data integration using Oracle Data Integrator and Oracle GoldenGate. |
Integrate Hadoop Data with Oracle Database using Oracle Big Data Connectors (pdf) | Use Oracle Loader for Hadoop to efficiently load data into the Oracle Database using MapReduce jobs. Access data in HDFS directly from the Oracle Database using Oracle SQL Connector for Hadoop. |
Using SQL Pattern Matching | This series features both OBEs and recorded webcasts. Learn how to use SQL for Pattern Matching. Row pattern matching in native SQL improves application and development productivity and query efficiency for row-sequence analysis. |
Oracle Data Mining 12c Tutorial Series | Oracle Data Mining is a key component to Oracle Advanced Analytics, providing powerful data mining algorithms inside Oracle Database 12c. The OBE's in this series provide you with instructions on how to perform data mining with Oracle Database 12c, by using Oracle Data Miner 4.1. Oracle Data Miner 4.1 is included as an extension of Oracle SQL Developer, version 4.1. |
Oracle R Enterprise v 1.4 - Tutorial Series | Oracle R Enterprise (ORE), a component of the Oracle Advanced Analytics Option, makes the open source R statistical programming language and environment ready for the enterprise and big data. This series teaches you how to use Oracle R Enterprise, version 1.4. |
Web Sites / White Papers / EBook / Blogs
Listed below are some resources to help you learn more about the Oracle big data platform:
- Big Data on oracle.com and Oracle Technology Network
- The Data Warehouse Insider Blog - Technical details, ideas and news on data warehousing and big data from the Oracle Team
- Connecting Hadoop with Oracle Database Blog - learn how to optimize connectivity between Hadoop and Oracle Database
- Oracle NoSQL Blog -this blog is about 'everything NoSQL'
- Adding Location and Graph Analysis to Big Data Blog - Technical examples on Oracle Big Data Spatial and Graph
Oracle Odi 12c Vm Download Free
Getting Started
12c (12.2.1.3.0)
E96509-02
March 2019
Oracle Data Integrator Getting Started
This document provides instructions on how to install the Oracle Data Integrator (ODI) 12c Getting Started Virtual Machine (VM). The VM is intended to be used with this guide.
Topics
Please visit http://www.oracle.com/technetwork/middleware/data-integrator/overview/index.html for more information about ODI.
Introduction
Oracle Data Integrator (ODI) Enterprise Edition 12c delivers unique next-generation, Extract Load and Transform (E-LT) technology that improves performance, and reduces data integration costs, even across heterogeneous systems. Unlike conventional ETL tools, Oracle Data Integrator EE offers the productivity of a declarative design approach, as well as the benefits of an active integration platform for seamless batch and real-time integration. In addition, hot-pluggable Knowledge Modules provide modularity, flexibility, and extensibility.ODI addresses multiple enterprise data integration needs including:
Data Warehousing and Business Intelligence
Service-Oriented Architecture
Master Data Management (MDM)
Migration and Consolidations
Modernization Initiatives
The demonstration highlights how ODI can be used to populate a Data Warehouse schema. Several facts and dimensions are loaded to demonstrate key ETL capabilities (complex transformations, slowly changing dimensions, incremental updates, constraints checking, and others), ease-of-use and productivity.
Oracle Data Integrator 'Getting Started' Virtual Machine
The virtual machine (entitled ODI 12c Getting Started) is a stand-alone environment for running Oracle Data Integration products. It is used to provide a complete environment for learning and demonstrating key Oracle Data Integration technologies.
The virtual machine includes the following products:
Oracle Database 11g Enterprise Edition (11.2.0.4)
JVM 1.7.0_15
Oracle Data Integrator (12.2.1.0.0)
Oracle GoldenGate (12.1.2.0.0)
Technical Deployment
The ODI virtual machine is delivered as an Oracle VirtualBox appliance and requires both the ODI 12c Getting Started archive and an installation of the Oracle VirtualBox product. In this document, the terms VM (Virtual Machine) and appliance are synonymous.
Oracle VirtualBox Introduction
VirtualBox is a cross-platform virtualization application. What does that mean? For one thing, it installs on your existing Intel or AMD-based computers, whether they are running Windows, Mac, Linux or Solaris operating systems. Secondly, it extends the capabilities of your existing computer so that it can run multiple operating systems (inside multiple virtual machines) at the same time. For example, you can run Windows and Linux on your Mac, run Windows Server 2008 on your Linux server, run Linux on your Windows PC, and so on, all alongside your existing applications. You can install and run as many virtual machines as you like; the only practical limits are disk space and memory.
For more information, see https://www.virtualbox.org/manual/ch01.html
Installation and Configuration
This section details the steps necessary to install and configure VirtualBox.
Download VirtualBox Software and User Manual
Go to the following URL to download the appropriate VirtualBox binary and documentation:
Figure - Oracle VirtualBox Download
Description of 'Figure - Oracle VirtualBox Download'
To install the VirtualBox software, click the link for the appropriate platform (such as Windows hosts), and you will be guided to install the software.
Extract the VirtualBox VM
After downloading the archive files, extract the first archive file (for example, using 7-Zip). The remaining archive files will automatically unzip. The extracted file, ODI 12c Getting Started.ova
will be used to create the virtual machine through a VirtualBox appliance import.
Here is an example using 7-Zip to extract the VM (only need to extract the first file).
- From Windows Explorer, select the first file of the archive and right-click to select the extraction tool, such as 7-Zip.
Figure - Extracting the VirtualBox Archive
Description of 'Figure - Extracting the VirtualBox Archive' - Select a target directory for the VirtualBox appliance:
Figure - Extraction location
Description of 'Figure - Extraction location'The extracted VirtualBox appliance import will be created in the designated directory.
Import the Appliance into VirtualBox
- Start Oracle VM VirtualBox Manager
- Click File and then Import Appliance.
The Appliance Import Wizard window appears.
Figure - VirtualBox Import
Description of 'Figure - VirtualBox Import' - Click Open Appliance.
- Specify the OVA file location and click Open to choose the VirtualBox file.
Figure - VirtualBox Import Selection
Description of 'Figure - VirtualBox Import Selection' - Confirm the file selection and click Next.
- Confirm the Appliance (VM) settings and click Import.
Figure - Appliance (VM) settings
Description of 'Figure - Appliance (VM) settings' - Click Agree in the Software License Agreement window to start the import process. The license terms are available at:
http://www.oracle.com/technetwork/licenses/odi-vm-license-2035237.html
The import is complete and the appliance (virtual machine) is now available in the VirtualBox Manager. The appliance may be started by clicking Start, or customized further for your environment.
Customize VirtualBox Appliance Settings
Depending on the host operating system limitations, network configuration or file sharing requirements, VirtualBox appliance settings may be modified. For further information about VirtualBox, see the VirtualBox documentation:
To continue to customize settings for the appliance, highlight the ODI 12c Getting Started appliance and click the Settings icon in the menu bar.
Memory (Optional)
The recommended amount of memory for the VirtualBox is 4GB.
Note:
In situations where less memory is available on the physical host, the memory for the ODI Getting Started appliance may be reduced to 2GB with some additional shared memory settings in the unix appliance itself. Use the following command to create a shared memory space to enable an Oracle database to start in low memory situations:
$ mount -t tmpfs shmfs -o size=2g /dev/shm
To change the appliance memory setting, click System.
Shared Folders (Optional)
Shared Folders may be used to move files between the host operating system and the VirtualBox Appliance (for example, moving future ODI projects into the appliance). The project could potentially be another ODI tutorial, which is delivered as a separately downloadable ODI Smart Import.
Use of shared folders begins with defining a locally-available directory on your computer (host) and one on the VirtualBox appliance, along with a share name.
Note:
Use the same string for the share name and folder names, for example ODIshared.
To configure a shared folder:
- Click the Shared Folders shortcut on the left panel.
- Click the Add Folder icon on the right:
Figure - Configuring Shared Folders
Description of 'Figure - Configuring Shared Folders' - The Add Share dialog appears, select Other… for the Folder Path and the following options.
Figure - Shared Folder Options
Description of 'Figure - Shared Folder Options'In this example, the following values are used:
Folder Path:C:ODIshared
Folder Name:ODIshared
Auto-mount: checked
Figure - Using ODIshared as the local folder and share name
Description of 'Figure - Using ODIshared as the local folder and share name' - The Vitural Box share has been configured. You must create a directory in the ODI Getting Started Appliance (VM).
Note:
Log on instructions to the Appliance (VM) are available in Table -.
Start the ODI Getting Started VM.
In the VM, open a terminal window.
su to super user (root) – password oracle
Create the directory, for example:
$ mkdir ODIshared
Note:
Examine the permissions of the directory and modify accordingly. As this is a tutorial, sharing to all users and groups may be approprite
$chmod -777 ODIshared
Figure - Creating a directory
Description of 'Figure - Creating a directory'
- To access the shared directory from the Getting Started Appliance, a Unix mount must be performed from a terminal shell (as root):
Mount follows the syntax:
$ mount [-t fstype] something somewhere
The mount for the ODI Getting Started Appliance and the example in this document would be:
$ mount -t vboxsf ODIshared ODIshared
The shared folder is now available between the host operating system and the ODI Getting Started vitural box appliance.
Starting the ODI Getting Started Appliance
To start the appliance from within the Oracle VirtualBox client, do ONE of the following:
Double-click on the ODI 12c Getting Started entry in the list within the Manager window.
OR
Select its entry in the list in the Manager window and click Start.
Once started, the appliance will boot into Oracle Linux and the desktop will be displayed.
Beginning the Getting Started Tutorial
The Getting Started appliance desktop includes the objects detailed in Table -.
Table - ODI Getting Started 12c Desktop Objects
Object | Purpose |
---|---|
ODI 12c Getting Started | This document provides the introduction and exercises to drive the tutorial. Open this first. |
ODI 12c Studio | Double-click this launcher to start ODI Studio. The ODI Studio will load; multiple clicks may result in more than one Studio loading. |
ORACLE_HOME | A shortcut to the default user's directory. |
Demo | A shortcut to the demo directory located in ODI_HOME.
The directory structure and objects are defined in the Getting Started guide. For the purpose of running the tutorial from the Appliance, you should not need to open this directory. |
Information about this machine | A text file listing basic attributes of the machine. |
- To begin with the ODI Getting Started Tutorial, open the ODI 12c Getting Started Guide on the desktop and follow the self-paced instructions.
- Start ODI Studio using the desktop launcher.
Figure - ODI Studio Desktop Launcher
Description of 'Figure - ODI Studio Desktop Launcher'
Note:
The startup script for ODI may alternatively be found in:
/home/oracle/Oracle/Middleware/Oracle_Home_1221/odi/studio/bin/odi.sh
The ODI 12c Getting Started Appliance and tutorial is now ready to be used!
Reference
Table - Appliance Credentials
Appliance | Credentials |
---|---|
Appliance LinuxOS | Default user: oracle; Password: oracle Su user: root; Password: oracle |
Table - Oracle Product Access Information
Appliance | Credentials |
---|---|
Oracle RDBMS | SID: ORCL Port: 1521 System: user; Password: oracle Sys: user; Password: oracle ODI repository user: prod_odi_repo; Password: oracle ODI sample data user: odi_demo; Password: oracle |
Oracle Data Integrator | ODI username: SUPERVISOR ODI password: SUPERVISOR |
Learn More
You can learn more about creating your own integration projects with Oracle Data Integrator in the guides listed in Table -
Table - Oracle Data Integrator Documentation
Document | Description |
---|---|
Oracle Fusion Middleware Installation Guide for Oracle Data Integrator | Provides Oracle Data Integrator installation information including pre-installation requirements and troubleshooting. |
Oracle Fusion Middleware Upgrade Guide for Oracle Data Integrator | Provides 12c upgrade information for Oracle Data Integrator. |
Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator | Provides guidelines for developers interested in using Oracle Data Integrator for integration projects. |
Oracle Fusion Middleware Connectivity and Knowledge Modules Guide for Oracle Data Integrator | Describes Oracle Data Integrator Knowledge Modules and technologies and how to use them in integration projects. |
Oracle Fusion Middleware Knowledge Module Developer's Guide for Oracle Data Integrator | Describes how to develop your own Knowledge Modules for Oracle Data Integrator. |
You can find all Oracle Data Integrator documentation on the Oracle Data Integrator documentation page on the Oracle Technology Network, at: http://www.oracle.com/technetwork/middleware/data-integrator/documentation/index.html
The Oracle Data Integrator home page on the Oracle Technology Network also provides the following resources to learn more about other features of Oracle Data Integrator: View the Oracle by Example Series for ODI. The Oracle by Example (OBE) series provides step-by-step instructions on how to perform a variety of tasks using Oracle Data Integrator Suite.To learn more about the new features that have been introduced in Oracle Data Integrator 12c, see 'What's New in Oracle Data Integrator?' in the Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator and the Release Notes.Thank you for choosing Oracle Data Integrator.
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Getting Started with Oracle Data Integrator Getting Started, 12c (12.2.1.3.0)
E96509-02
Copyright © 2010, 2019, Oracle and/or its affiliates. All rights reserved.
Primary Author: Oracle Corporation
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, then the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are 'commercial computer software' pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information about content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services unless otherwise set forth in an applicable agreement between you and Oracle. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services, except as set forth in an applicable agreement between you and Oracle.