Teradata Express 15.10 Installation using Oracle VirtualBox

Introduction

For professional reasons I needed to start learning Teradata after some years of intensive Microsoft BI projects. To start breaking the ice and have a playground to test everything I want, I decided to download the newest Teradata Express virtual machine (TDE), which comes with the 15.10 engine plus some additional tools. In my current company I am not able to use VMware (for some dark reasons) and I am only allowed to use Oracle VirtualBox. I would like to share the steps I followed with you.

1.  Download Teradata Express 15

The latest virtual machine could be downloaded from: http://downloads.teradata.com/download/database/teradata-express-for-vmware-player

The image is only available for VMware and an account is required to download it.

2.  Create a new Virtual Box Machine

Open Oracle Virtual Box

  • Click on “New”
  • Enter a name for the new machine
  • Select Linux as the type
  • The openSUSE (64-bit) is the most similar Linux Vesion.

 

create-virtual-machine

Create a new VM

  • Depending on your local resources assign a memory size (greater than 1GB)
create-virtual-machine2

Set the RAM memory

  • Do not add a hard disc and click on “Create”

 

create-virtual-machine3

Do not add a virtual hard disk

  • On the Warning pop-up click on “Continue”

 

create-virtual-machine4

Ignore the warning

 

  • Select the created VM, click on “Settings” and go to the “Storage” section:

 

create-virtual-machine5

Storage settings

VMWare image comes with SATA hard disks. Oracle Virtual Box needs SCSI Controller for the Teradata Express machine.

  • Delete SATA Controller
create-virtual-machine6

Delete SATA controller

  • Add SCSI Controller
create-virtual-machine7

Add SCSI controller

  • Add a hard disk
create-virtual-machine8

Add hard disk

  • Choose existing disk
  •  Go to the location where you extracted the TDExpress15.10…………disk1.vmdk file and selected

 

create-virtual-machine9

Select virtual hard disk file

  • Repeate the previous step for the disks 2 and 3
  • Go to the “System” section and in the “Acceleration” Tab select “Hyper-V” as the paravirtualization interface

 

create-virtual-machine10

Adjust virtualization settings

  • Click “Ok” and close the VM settings.
  • Click on “Start” to run the VM

3.  Start and log into the VM

Start the VM. The first screen you should see is the following

Default login and password is root

logintothemachine1

Start virtual machine

  • Select the highlighted option

The first time you start the machine the Gnome Interface is not started. You should see a login screen similar to this:

logintothemachine2

Log into the virtual machine in console mode

  • In order to fix it login and issue the following commands:
vmware-uninstall-tools.pl
mv /etc/X11/xorg.conf /etc/X11/xorg.conf.vmware
reboot

If everything was properly set in the previous step you should be able to see a similar login screen:

logintothemachine4

Log into the virtual machine – Gnome

4.  Add the Virtual Box Linux Guest Additions

  • Mount the ISO image of the guest additions by clicking onDevices menu -> CD/DVD devices and point to the GuestAdditions ISO file. The Guest additions is available in Program Files\Oracle\VirtualBox folder
  • Open a terminal and excute the following commands:
cd /media
mkdir vbox
sudo mount /dev/sr0 vbox/
cd vbox/
./VBoxLinuxAdditions.run
reboot
add-guest-additionals

Install VBox additions

5.  Test the Teradada Installation

  • Open the Teradate Studio Express (The icon is available on the Desktop)
  • Right click on “Database Connections” –> New…
test-installation-1

Create new connection

  • Select “Teradata Database” and give it a name
test-installation-2

Teradata Database connection profile

  • Connection Details:
    • Database Server Name: 127.0.0.1
    • User Name: dbc
    • Password: dbc
    • Use the default values for the other fields
  • Click on “Test Conection”
  • Click on “Finish”
test-installation-3

Test created connection

  • ENJOY!!!

References

Migrating from VMware to VirtualBox (Part 1): Oracle Enterprise Linux

Teradata Express 14.0 for VMware User Guide

Teradata Express Edition 14.10 converting from VMWare to VirtualBox

Advertisements

About Paul Hernandez

I'm an Electronic Engineer and Computer Science professional, specialized in Data Analysis and Business Intelligence Solutions. Also a father, swimmer and music lover.
This entry was posted in Business Intelligence, Teradata, VirtualBox and tagged , , , , , , . Bookmark the permalink.

5 Responses to Teradata Express 15.10 Installation using Oracle VirtualBox

  1. Gary Opendek says:

    have you been able to get the internet connection working from within the vm? I can connect from my desktop into the database but when i try to connect to viewpoint from firefox within the vm i cannot connect to it to configure viewpoint. i can connect to it from my desktop but not from within the vm. in fact there is no internet connection from within the vm. i have tried brigdged, nat and a variety of solutions but i am stuck. if you know anything please email me.
    thanks Gary

  2. tjattesco says:

    Have tried this. All was good until the final Teradata start-up. This appears to have failed immediately with JAVA related issues as follows:

    JVM terminated. Exit code=1
    /opt/teradata/jvm64/jdk7/bin/java
    -Dosgi.requiredJavaVersion=1.6
    -Xms256m
    -Xmx256m
    -XX:MaxPermSize=256m
    -Djava.util.Arrays.useLegacyMergeSort=true
    -jar /opt/teradata/TeradataStudioExpress//plugins/org.eclipse.equinox.launcher_1.3.0.v20140415-2008.jar
    -os linux
    -ws gtk
    -arch x86_64
    -showsplash
    -launcher /opt/teradata/TeradataStudioExpress/TeradataStudioExpress
    -name TeradataStudioExpress
    –launcher.library /opt/teradata/TeradataStudioExpress//plugins/org.eclipse.equinox.launcher.gtk.linux.x86_64_1.1.200.v20150204-1316/eclipse_1607.so
    -startup /opt/teradata/TeradataStudioExpress//plugins/org.eclipse.equinox.launcher_1.3.0.v20140415-2008.jar
    –launcher.overrideVmargs
    -exitdata 70008
    -vm /opt/teradata/jvm64/jdk7/bin/java
    -vmargs
    -Dosgi.requiredJavaVersion=1.6
    -Xms256m
    -Xmx256m
    -XX:MaxPermSize=256m
    -Djava.util.Arrays.useLegacyMergeSort=true
    -jar /opt/teradata/TeradataStudioExpress//plugins/org.eclipse.equinox.launcher_1.3.0.v20140415-2008.jar

    Any feedback appreciated.

  3. Helmut says:

    Hi Paul, many thanks for your tips on TD 14.10 & 15.10 getting up & running with VirtualBox.

    However TD16 seems to struggle with the time sync. So far I didn’t manage to get TD16 running under VB. Did you?

  4. Tim K says:

    Thank you so much for posting this article. It worked beautifully with Teradata 15.10. But, sadly no luck booting Teradata 16.

    • Hi Tim, thanks for your comment. We are working right now in a project with Teradata 15.10. As soon as we upgrade the database I will have to migrate the 16 version to OVB, let’s see if I could do it and post it.
      Regards, Paul

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s