THE WORLD DISCUSSES #PYTHIAN ON TWITTER. HAVE A QUESTION? USE OUR HASHTAG AND ASK AWAY.

Installing TOra with Oracle Support on Ubuntu 9.04 (Jaunty Jackalope)

Considering my recent update to Ubuntu 9.10, I decided to have another go at getting TOra up and running. This time I am tackling a 64-bit system rather than the 32-bit “Hardy Heron” I had done previously.

On my way, I found some odd issues that I will describe here. All in all, it was a good few hours of cobbling together the pieces I needed to proudly present to you . . .

Installing TOra with Oracle support on Ubuntu 9.04 (Jaunty Jackalope)

Conventions and Caveats

  • I use sudo for everything because logging in to root shells is just bad practice.
  • I plug vi whenever possible, because vi is the greatest (and to annoy emacs people).
  • I did this all in a KDE desktop, which means that some things I say may sound like I use KDE. Commands issued are in pre-formatted text without any prompt gunk in front of them, so cut and paste to your heart’s content.
  • Output is also in pre-formatted text and I use it sparingly where relevant. Apt likes to output lots of text. I think it’s lonely.
  • Some instructions are pasted from the original so you will not need to refer to my last howto to get this working. For an all-new jocular experience, no attempts at humour were recycled.
  • When I say “dep”, I actually mean dependancy.

Read the rest of this entry . . .

Installing Oracle 11gR1 on Ubuntu 9.04 Jaunty Jackalope

Welcome, readers! It’s time for another update to our series of posts on installing Oracle on Ubuntu Linux. In this edition, we’ll be installing Oracle 11g R1 on Ubuntu 9.04, both 32-bit.

This time, I’ve used VirtualBox to run a virtual machine (VM) to perform our work. (Virtualization has a number of advantages; in this case, I made several trial installs, trying different combinations and configurations. Having a pristine, basic set-up accelerated the whole process, since I didn’t had to reinstall from scratch on every new attempt.)

You might want to review the previous editions of this series, as there are technical references on this text fully detailed on previous posts. See these HOWTOs for Ubuntu:

Since we’re installing on a VM, we’ll be using Ubuntu 9.04 32-bit Server edition, , so let’s download it and check the MD5sum:

user@jackalope:/media/trezentos/downloads$ md5sum ubuntu-9.04-server-i386.iso
20480057590ff8b80ad9094f40698030  ubuntu-9.04-server-i386.iso
user@jackalope:/media/trezentos/downloads$

Download Oracle Database 11g Release 1 (11.1.0.6.0), and verify the provided cksum:

Read the rest of this entry . . .

Ubuntu 9.04 (Jaunty Jackalope), vpnc, and resolvconf

The environment

  • Ubuntu 9.04 Jaunty Jackalope
  • vpnc 0.5.3
  • resolvconf 1.43

The problem

Connecting to a cisco vpn device with vpnc on jaunty. If you use vpnc and vpnc-disconnect to bring the connection up and down, all works fine. If you leave the connection idle too long and are disconnected from the other end, the resolv.conf is not always updated. This is a problem because, when you do a DNS lookup in a browser you’ll experience delays, the DNS servers from your vpn connection are no longer available.

The easiest way to check this is to login to your vpn and check the contents of /etc/resolv.conf. For example, before you log in, your resolv.conf may look something like this (only the IPs have been changed to protect the innocent).

# cat /etc/resolv.conf
# Dynamic resolv.conf(5) file for glibc resolver(3) generated by resolvconf(8)
#     DO NOT EDIT THIS FILE BY HAND -- YOUR CHANGES WILL BE OVERWRITTEN
nameserver 192.168.0.1
nameserver 192.168.0.2
search yourdomain.com

After connecting, you’ll see a different resolv.conf.

# cat /etc/resolv.conf
# Dynamic resolv.conf(5) file for glibc resolver(3) generated by resolvconf(8)
#     DO NOT EDIT THIS FILE BY HAND -- YOUR CHANGES WILL BE OVERWRITTEN

nameserver 192.168.50.1
nameserver 192.168.50.2
nameserver 192.168.0.1
nameserver 192.168.0.2
search yourVPNdomain.com

Read the rest of this entry . . .

Start NowWith Pythian - database design, management and emergency handling capabilities...

Live Updates

pythian: RT @sheeri: #confoo talk "Bending Queries to your Will with EXPLAIN" slides http://bit.ly/explainslides & handout
more



Testimonials

  • Serge Racine

    DBA, Brookfield Energy

    We are very satisfied by the service given to us by Andre and Shakir in support of our recent data quality and reorganization initiative.... more