Teradata Express 15.10 Installation using Oracle VirtualBox


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 a new VM
  • Depending on your local resources assign a memory size (greater than 1GB)
Set the RAM memory
  • Do not add a hard disc and click on “Create”


Do not add a virtual hard disk
  • On the Warning pop-up click on “Continue”


Ignore the warning


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


Storage settings

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

  • Delete SATA Controller
Delete SATA controller
  • Add SCSI Controller
Add SCSI controller
  • Add a hard disk
Add hard disk
  • Choose existing disk
  •  Go to the location where you extracted the TDExpress15.10…………disk1.vmdk file and selected


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


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

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:

Log into the virtual machine in console mode
  • In order to fix it login and issue the following commands:
mv /etc/X11/xorg.conf /etc/X11/xorg.conf.vmware

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

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/
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…
Create new connection
  • Select “Teradata Database” and give it a name
Teradata Database connection profile
  • Connection Details:
    • Database Server Name:
    • User Name: dbc
    • Password: dbc
    • Use the default values for the other fields
  • Click on “Test Conection”
  • Click on “Finish”
Test created connection
  • ENJOY!!!


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


24 responses to “Teradata Express 15.10 Installation using Oracle VirtualBox”

  1. 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. 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
    -jar /opt/teradata/TeradataStudioExpress//plugins/org.eclipse.equinox.launcher_1.3.0.v20140415-2008.jar
    -os linux
    -ws gtk
    -arch x86_64
    -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
    -exitdata 70008
    -vm /opt/teradata/jvm64/jdk7/bin/java
    -jar /opt/teradata/TeradataStudioExpress//plugins/org.eclipse.equinox.launcher_1.3.0.v20140415-2008.jar

    Any feedback appreciated.

  3. 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. Thank you so much for posting this article. It worked beautifully with Teradata 15.10. But, sadly no luck booting Teradata 16.

    1. 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

  5. Love this idea! I am using the exact TD Expression version you’ve included in this post. However I’m using VirtualBox Version 5.2.0 r118431 (Qt5.6.2) and find Linux crashes as soon as I start tpa after PanicLoopDetected is removed. What Version of VirtualBox are you using?

    1. Hi Jack,
      I did it with an older version, I cannot remember it. Now I am using the version “Version 5.1.22 r115126 (Qt5.6.2)” and it’s still working.
      What kind or error is being logged? Try to find the log files, maybe in /var/log
      Kind regards,

  6. Been looking at /var/log and pde is doing something that makes the kernel unhappy. The server is completely stable until tpa start; once tpa start happens it’s like setting on a timer to the big event. There is a kernel dump left behind.

    I tried using SCSI Controller with and without Host Cache, and both hardware choices, LSI and the other.

    I also attempted 16.10 earlier today, but couldn’t get it rolling.

    I’m pretty sure I was using the version of VirtualBox you’re on until this morning when I decided it would be fantastic to upgrade to the latest Virtual Box to be uber careful.

  7. Hi, has anyone had any luck with Teradata 16.xx ? I’ve been running TDExpress15 in virtual box for quite some time, but I’m now trying to get Teradata Express 16.20 running on VirtualBox 5.2.8- without any luck. It starts the boot process but then hangs on:
    Detected 2494.226 MHz processor.

  8. Like everybody mentioned 16.xx doesn’t port to VB. Freezes after the “dected XXX processor.” Don’t think the error is related to the processor, that’s just the last thing displayed before it freezes.

  9. Try this: Ports/SerialPorts/Port1/Enable Serial Port (keep all defaults). It boots after that!!

  10. Adding a serial port got me past the “detected xxx Mhz Processor” hang.

    The VM then booted to the console but I was not able to login. That is because the system is configured to deny root login at the various text consoles.

    Here is the fix for that:
    1. Boot into “Single User Mode: SUSE Linux Enterprise Server 11”
    2. When asked, provide the root password, which is “root”.
    3. `vim /etc/securetty`
    4. Add these entries:

  11. Thanks jfmackey! What TD Express version did you apply this fix to? Also, could you post your Virtual Box version so I can replicate your results?

  12. jfmackey’s fix gets past the “Detected Mhz Processor” but Teradata database is in HARD/STOP mode once logged in. Removing the PanicLoopDetected and trying to start the DB causes the OS to hang.

  13. Great comments and advice. After a few months break I’m having another try… !

    VirtualBox 5.2.18 and TD Express, downloaded @ 18Aug2018
    The Serial Port and securetty suggestions worked OK and I can now login with Teradata at DOWN/HARDSTOP status.
    A tpa start successfully starts the Teradata Database Initiator Service, but the database remains at a DOWN/HARDSTOP status.
    The final step was to remove the PanicLoopDetected file and after one more tpa start, it is now running !!! Woo Hoo.

  14. Have you been able to detect a difference in network speed with the host? The default VMWare/Windows network configuration is insanely slow. By turning off all non-essential drivers bound the adapter I was able to get VMWare’s NIC throughput from 500kb/s to 29mb/s. This means only IPv4 and MSFT LLDP Protocol are enabled on Windows 10.

    This makes for a noticeable improvement, but there is so much left on the table. NIC tuning/replacement does not affect the TD database – i.e., it won’t cause a PanicLoop. But the insanely slow NIC throughput makes for a horrible user experience.

  15. Not sure what’s different with my setup. Keeps locking up after rm Panic* and tpa start.

  16. Murugesan Rajasekaran Avatar
    Murugesan Rajasekaran

    Thank you so much for this great article. You made my day!

  17. can you please tell me how to create table and insert data in teradata express studio 16.20
    is it same as that we do it in ssms using sql .

  18. Whoever has issues with network connection indise the VM:
    1) select PCnet-FAST III (Am79C973) as Adapter Type, the default one is useless
    2) adjust /etc/resolv.conf accordingly with the IP address of your gateway (home) and/or DNS Servers (company network) as for example “nameserver 123.456.78.9”
    3) reboot and it should work

  19. i get “DBS not running” . on TD 16 on virtual box. Anyone seen this?

  20. It may not be starting automatically when you start the VM. Try :
    START /etc/init.d/tpa start

  21. Sorry, it’s just /etc/init.d/tpa start

  22. For Teradata Express v17.10 there is an official VirtualBox version:https://quickstarts.teradata.com/docs/17.10/getting.started.vbox.html

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 )

Facebook photo

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

Connecting to %s

%d bloggers like this: