Installing TOra with Oracle Support on Ubuntu 9.10 (Karmic Koala)

Oct 29, 2009 / By Brad Hudson

Tags: , ,

Good morning folks and welcome to chapter 3 in the ongoing saga of TOra and Oracle support for Ubuntu. In this edition we’re faced with a new Ubuntu, new TOra 2.0, and new and exciting adventures, all of which I have stripped out so you can get this up and running quickly.

All in all, the build process turned out to be simpler than it had on previous versions all thanks to a much smarter build system. The scripts that debian-ize the packages are much more robust and also much more complex at first glance. There was no configure line to change in this one, it’s smart enough to pick up all the elements you need provided they are where the build expects them to be. One such item is the Oracle include path, which I will say more about shortly. Enough snappy patter, let’s get on with . . .

Installing TOra with Oracle support on Ubuntu 9.10 (Karmic Koala)

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 (high five).
  • 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 is chatty.
  • Some instructions are pasted from the previous versions so you will not need to refer to my last howto to get this working. I shamelessly did not rewrite some bits if there was no change.
  • When I say “dep”, I actually mean dependancy.

Environment

This is based on a 64-bit install of Ubuntu 9.10 using the Oracle 11 clients. The system itself is an AMD Athlon 64 7750 Black Box Editions at 2.7GHz with 4GB DDR2. I also touch on the 32-bit install using the 11.2 client because it was mentioned in comments for the previous edition. For the record, the only difference is in the environment variables.

The desktop I am running this time is the KDE4.3.2 that is shipped with Kubuntu 9.10 (one day away as I write this, but I am running the release candidate patched to current which should be close to the final release). I like it. Nuff said. There was no issue with KDE development libraries this time around since I did not hack and slash the desktop together. The scripts also detect KDE for you, so no changes to the configure script necessary.

Get the packages

Find an acceptable build location in your filesystem, cd to there and then get the tora source deb package. This bit should not be done with sudo or else you’ll run into build problems later because all the files are owned by root.


mkdir -p /path/to/deb/source/
cd /path/to/deb/source/
apt-get source tora

That should drop and unpack the TOra source in your current directory. Now get the Oracle packages. Get them from the Oracle site..

Again, the login you need is free to register. The files we want this time around are:

  • oracle-instantclient11.1-basiclite-11.1.0.7.0-1.x86_64.rpm
  • oracle-instantclient11.1-devel-11.1.0.7.0-1.x86_64.rpm
  • oracle-instantclient11.1-sqlplus-11.1.0.7.0-1.x86_64.rpm

For those using 32-bit, the lastest packages are these:

  • oracle-instantclient11.2-basiclite-11.2.0.1.0-1.i386.rpm
  • oracle-instantclient11.2-devel-11.2.0.1.0-1.i386.rpm
  • oracle-instantclient11.2-sqlplus-11.2.0.1.0-1.i386.rpm

Install the prerequisites and development libraries

Next we’ll want to install the build dependencies via apt. To do this, run the following simple command.


sudo apt-get build-dep tora

From there, we’ll get all the other things that we need to prevent the build from failing. The list is a bit slimmer than last time, and weighed in around 68MB if I recall correctly.


sudo apt-get install libqt3-mt-dev libqt3-compat-headers libqscintilla-dev build-essential g++ gcc autoconf automake flex zlib1g-dev docbook-xsl debhelper alien libaio1 dpatch fakeroot xsltproc texi2html texinfo libqt3-mt-psql libqt3-mt-odbc config-package-dev cmake qt4-dev-tools

Next install the Oracle clients. In the directory where you installed them run the following to convert and install the packages in one fell swoop.


cd /path/to/oracle/rpms

When I ran it this time around, I found that I had both 32- and 64-bit packages in the same directory, and alien did not like that. Best to filter down to just the arch we want.


sudo alien -i oracle*x86_64.rpm

or for 32-bit:


sudo alien -i oracle*i386.rpm

This will take a bit of time, but should turn out okay.

Now that we have the packages, the deps, and the sources, it’s time to set up.

Environment Variables

Thanks to the new build scripts there is no longer a need to set the CFLAGS and CPPFLAGS environment variables. That was a nice surprise. We’re also not going to change the dynamic link library paths as we have in the past as it seems to be overkill, we’ll just specify it in the environment.

Here are the environment variables you’ll need. This is the only place where the instructions change depending on your version of Oracle and architecture.

For a 64-bit machine you’ll want to set this:


export ORACLE_HOME="/usr/lib/oracle/11.1/client64"
export LD_LIBRARY_PATH="${ORACLE_HOME}/lib"
export TNS_ADMIN="${ORACLE_HOME}"

For 32-bit using the new 11.2 instant client you need this instead:


export ORACLE_HOME="/usr/lib/oracle/11.2/client"
export LD_LIBRARY_PATH="${ORACLE_HOME}/lib"
export TNS_ADMIN="${ORACLE_HOME}"

For 32-bit and the 11.1 client use the above, but change 11.2 to 11.1.

Again, you will want to add the Oracle environment info (the last three lines above) to your .bashrc, so that they will be used after the required logout/login.

Again, for 64-bit use this:


echo export "ORACLE_HOME=/usr/lib/oracle/11.1/client64" >> ~/.bashrc
echo export "TNS_ADMIN=${ORACLE_HOME}" >> ~/.bashrc

And for 32-bit with 11.2 use this:


echo export "ORACLE_HOME=/usr/lib/oracle/11.1/client64" >> ~/.bashrc
echo export "TNS_ADMIN=${ORACLE_HOME}" >> ~/.bashrc

This will only take effect on next log-in. Until then, you can run TOra from the shell you install it in, as the menu will not work until you log out and in again.

Note: My install of Karmic did not have a .bashrc or .profile in my home directory by default. If this fails to work on next log-in, that’s a good place to look. To test it, log out and in again then run this in a terminal.


$ echo $ORACLE_HOME
/usr/lib/oracle/11.1/client64

Include path oddity

The last piece of the puzzle, which caused me the most grief, was the fact that the script could not find oci.h, which is an include header provided by the Oracle client. After much grinding of teeth and plumbing the depths of the scripts, I found that it was only looking in certain places for the file, places which did not exist on my system. It made some assumptions that may be right in certain conditions but not mine. I found the oci.h file and after a couple tries concocted a solution that does not require making any changes to the source or script—simply create a symbolic link to put the file where the script is looking.


sudo ln -s /usr/include/oracle/11.1/client64/ ${ORACLE_HOME}/include

Building and installing TOra

Go to your build directory and you’ll see there is a tora-2.0.0 directory. Change to this directory.


cd /path/to/deb/source/tora-2.0.0.0

Run the script to build the package.


fakeroot debian/rules binary

Those of you who have done this before will notice a marked difference in the look of the compile, complete with nifty progress counters that update as each file is processed. The results, however, are the same. On the test 64-bit machine, it took me seven minutes to compile the whole thing (while browsing and listening to music and other tasks); on my laptop it took about 30 (otherwise idle) minutes.

Once you are done, you should see the new deb package in the directory below where you are.


$ ls -al ../*.deb
-rw-r--r-- 1 hudson hudson 4900786 2009-10-28 18:47 ../tora_2.0.0-4build2_amd64.deb

And for you 32-bit people it would be tora_2.0.0-4build2_i386.deb.

Install it using the following (32-bit users can now extrapolate):


dpkg -i ../tora_2.0.0-4build2_amd64.deb

The Update Issue Again

This rehashed text brought to you compliments of me, the lazy blogger. A simpler way to stop the package from updating.


echo 'tora hold' | sudo dpkg --set-selections

End Game Redux

Don’t forget your tnsnames.ora. We set up the environment to use TNS_ADMIN=/usr/lib/oracle/11.1/client64 which means that tora will look for tnsnames.ora there. The easiest way I found was to get the production tnsnames.ora file from the Oracle server itself, and place it in the $TNS_ADMIN directory. Once you have done so, start TOra and enjoy. Remember to start it from the xterm session that has the environment variables set if you have not yet logged out/in.

Nifty KDE trick

I thought this was useful enough to repeat. I wanted it to work with my current menu without logging off. Time is money, and logging off means too much lost productivity. This still works the same in KDE 4.3.2 on Karmic. Here is what I did.

  1. Right click on the big blue “K” menu button.
  2. Select “Menu Editor”.
  3. In the KDE menu editor, on the left side, find the Development item and click the + to expand the tree.
  4. Right click the TOra and select Copy.
  5. Right click the TOra icon again and select Paste.
  6. Left click on the TOra-2 icon.
  7. In the command box enter

    ORACLE_HOME=/usr/lib/oracle/11.1/client64 LD_LIBRARY_PATH=/usr/lib/oracle/11.1/client64/lib TNS_ADMIN=/usr/lib/oracle/11.1/client64 tora
  8. Click the File menu, then Quit.
  9. Click the Save button to save your changes.

Now in the “K” menu click K->Applications->Development->TOra-2 and enjoy your selecting.

I have done a bit of testing and it’s working great. The last time I did this I had issues with advanced functions like the schema browser, which work properly now. I am not sure if this is because they fixed something, or I broke something. Either way, it’s all good.

Please feel free to ask questions or post your own experiences in the comments. My test environments are limited, so there may be issues that did not arise for me. Also, I am game to tackle writing up similar guides for other distributions like CentOS or Fedora, so let me know if there is interest. I do it on Ubuntu since it makes a better desktop than most others. Next stop, Lucid Lynx (in April ’10).

See you all on Friday for another exciting edition of Blogrotate.

References

The TOra homepage
Installing TOra with Oracle support on Ubuntu 8.04LTS (Hardy Heron)
Installing TOra with Oracle support on Ubuntu 9.10 (Jaunty Jackalope)
Kubuntu linux

43 Responses to “Installing TOra with Oracle Support on Ubuntu 9.10 (Karmic Koala)”

  • […] Brad Hudson-Installing TOra with Oracle Support on Ubuntu 9.10 (Karmic Koala) […]

  • Ryan N. says:

    I’d like to know how to work this without having to set ORACLE_HOME, etc.

    When I do not set those, I still have “Oracle (Instant Client)” listed. That would suffice for me, I just don’t know what to type into the boxes to get it to connect. If I do set all the vars, TNS does work.

    • Brad Hudson says:

      Hi Ryan. As far as I know you need the environment set properly for TNS to work. You at least need the TNS_ADMIN since that’s how Oracle knows where the tnsnames.ora file is. In the TOra 2 build it does autodetect some of the stuff so the rest of the env may not be required, but I have not tested this so ymmv. I would either set up a script to run TOra that sets the env for you, or use the command line I specified under the nifty KDE trick.

  • Jens says:

    Thanks a lot for this howto.

    I did like described as above on my machine, but for an unknown reason $ORACLE_HOME didn’t seem to be recognized by cmake. It always output “ORACLE not found”. I double-double-checked my setup, but everything was correct. My workround for it was to put the path information directly into the build script:

    Open cmake/modules/FindOracle.cmake in the TOra sources and add these lines to the top of it (adjusting the paths respectively, of course):
    SET(ORACLE_PATH_INCLUDES “/usr/lib/oracle/11.2/client/include”)
    SET(ORACLE_PATH_LIB “/usr/lib/oracle/11.2/client/lib”)

  • Jens says:

    Forgot to mention in my previous comment: this also works with the latest TOra sources 2.1.1 downloaded from SourceForge

  • Michael says:

    Hi,

    Thanks for this great howto. I did exactly what you describe and I successfuly install TOra and Oracle client but when I start TOra the option is to create a MySQL connection. How I can activate Oracle support. All the enviromental variables like ORACLE_HOME and TNS_ADMIN are set and also the tnsnames.ora is correct.

    Thanks for the help,

    Mike

    • Brad Hudson says:

      How and where did you set the ORACLE environment variables? If you set them in your profile, did you log out and in again? Open a console window and try to echo $ORACLE_HOME and see if that shows your settings. If it does verify they are right and make sure the other oracle variables are right as well. If your env variables are not there then that is your problem. Try setting them by hand and running tora from the command line and see if that works.

      Another thing to check is the version of tora installed. If you did not set the package to “hold” to prevent updates then it would have been overwritten by an update on your system. If you did set it to hold, and used a GUI package management tool, it may also have been overwritten as some of them do not honour the hold. Maybe try re-installing the package you compiled and run it again.

      Let me know if either of these worked for you, or what the results were.

      • Michael says:

        Brad thanks for the response. I checked my env variables and all of them are ok, also the version of Tora installed is 2.1.1 but still the only connection option is MySQL.

  • Martin says:

    Seems like my post has not arrived, so I will write it again, hoping that noone runs in the same dead-end as me:

    First of all thanks for the great HOWTO! I tried building TOra for Oracle 10.2.0.4, but when it comes to building, I got an error about unresolved symbols, or so. Consulting Google, I found out that the Oracle 10g binaries only support GCC up to 2.95 (2.96?) or 3.3. Ubuntu 9.10 doesn’t have them in its repositories.

    I’m giving up on this and testing SQL Developer, although one might install GCC from an old Ubuntu distribution, or compiling TOra for Oracle 11 and trying to connect to Oracle 10gR2.

    Best wishes,
    Martin

    • Brad Hudson says:

      Hi Martin. That’s an interesting point, I did not try it with the 10g libraries so I did not encounter this issue. I suppose this might be an issue if you need to connect to an Oracle 9 database, which would not be fully supported in the 11 clients. SQL developer will do what you need, it’ll just eat up your resources with it’s heavy java interface which was the reason I started the blog series in the first place.

      There may be a workaround, if I find some free time I will give it a shot.

  • Sung-Joon says:

    Hi,
    Thanks for this howto.
    Finally, I installed Tora with oracle.

  • Chris says:

    Hi,
    first of all thanks for the helpful howto. But I have the same problem as Michael. When I run tora I don’t have the Oracle connection provider. My env variables are ok and the version also.I also added the set variables in the cmake file but it doesn’t work.

    Is there anything else to do?

    Best wishes,
    Chris

    • Brad Hudson says:

      Is your tnsnames.ora set up, in the TNS_ADMIN directory? Is the tnsnames.ora copied from your database server’s production tnsnames.ora? Are the paths to oracle etc in the blog the same as your system?

      You might try opening a shell and using the command line in step 7 of the “Nifty KDE trick”, adjusting the paths if necessary, and see if that works. If it does, then it’s your environment.

      Another potential gotcha is that some GUI package managers will install the tora from apt over top of your custom install, without respecting the HOLD. Doing a dist-upgrade may also do this. Perhaps you could try to install your custom .deb again to clear this possibility.

      Let me know how it goes.

  • José Carlos says:

    Thanks for the howto, helped alot!

    My tora also ended up with ONLY mysql support.

    specs:
    oracle: 10.2.0.3
    distro: Ubuntu 9.10
    tora: 2.1.1

    I went over the process with more care, and the configure warns us straight away:

    ...
    QScintilla2 Found OK
    -- found sqlplus version: 10.2.0.3.0
    -- Guessed ORACLE_OCI_VERSION value: 10G_R2
    -- Oracle not found.
    -- Oracle: You can specify includes: -DORACLE_PATH_INCLUDES=/usr/include/oracle/10.2.0.3/client
    -- currently found includes: ORACLE_INCLUDES-NOTFOUND
    [...]
    -- No Oracle OCI found. TOra will be build without Oracle support

    This problem is described in the “Include path oddity”.

    Just an addon to help fix it:

    # get the correct oracle path
    locate oci.h

    #(my case: /usr/include/oracle/10.2.0.3/client

    # create symbolic link:
    sudo ln -s /usr/include/oracle/10.2.0.3/client ${ORACLE_HOME}/include

    • Brad Hudson says:

      Thanks Jose, that clears things up a lot.

      One thing I would point out is that if the Oracle client was just installed it’s unlikely that the oci.h would come up in a locate. So if it does not work the first time be sure to…

      sudo updatedb
      

      Once done the oci.h should be found by locate.

      • Prabhu says:

        I also have only MySQL support.
        tora: 2.0.0
        Oracle client: 10.2.0.4
        Ubuntu: 9.10

        I tried re-installing with no issues but still only MySQL support. My env’s are fine and did sudo updatedb and restarted with no luck. Any help?

        #locate oci.h

        /u01/app/oracle/product/10.2.0/db_1/precomp/public/sql2oci.h
        /u01/app/oracle/product/10.2.0/db_1/rdbms/public/oci.h
        /usr/include/oracle/10.2.0.4/client/oci.h
        /usr/include/qt4/Qt/qsql_oci.h
        /usr/include/qt4/QtSql/qsql_oci.h

        • Brad Hudson says:

          Hi Prabhu. I noticed that you have 2 different versions of Oracle installed based on the output of your locate command.

          /u01/app/oracle/product/10.2.0/db_1/rdbms/public/oci.h
          /usr/include/oracle/10.2.0.4/client/oci.h
          

          Using the same oci.h as your oracle versions is imperative. Oracle versions do not play well with each other when linking programs.

          Did you see any errors in the configure/compile process that would lead you to believe it did not find, or found the wrong, oci.h?

  • Diego Granito says:

    Hi,
    I get this error:

    dpkg-shlibdeps: error: no dependency information found for /lib/libqscintilla2.so.5 (used by debian/tora/usr/bin/tora).
    dh_shlibdeps: dpkg-shlibdeps returned exit code 2
    make: *** [binary-predeb-IMPL/tora] Errore 1

    when I try to build the package (sudo debian/rules binary).
    Can’t fix it :o(

    • Brad Hudson says:

      Hi Diego. I would check your library paths. The library you want should actually be

      /usr/lib/libqscintilla2.so.5
      

      For some reason yours is expected to be in /lib which is incorrect from what I see on my own system.

  • Michael says:

    I use Oracle Clinet 11.2 is this supported?
    see below my vars

    echo $ORACLE_HOME
    /usr/lib/oracle/11.2/client
    echo $TNS_ADMIN
    /usr/lib/oracle/11.2/client
    echo $LD_LIBRARY_PATH
    /usr/lib/oracle/11.2/client/lib

    Into ORACLE_HOME there is the tnsnames.ora

    I also did

    sudo ln -s /usr/include/oracle/11.2/client/ ${ORACLE_HOME}/include

    I installed tora 2.1.1 without updates.

    I still see only MySQL connections.

    Brad or anyone can you help?

  • paul says:

    hi great tutorial. i followed up to the build part with fakeroot and everything works fine.

    however, when i do the fakeroot command, i get the following error:

    root@rulebcn09:~/downloads/tora-2.0.0# fakeroot debian/rules binary
    test -x debian/rules
    dh_testroot
    dh_clean -k
    dh_installdirs -A
    mkdir -p “obj-x86_64-linux-gnu”
    if test -e /usr/share/misc/config.guess ; then \
    for i in ./config/config.guess ; do \
    if ! test -e $i.cdbs-orig ; then \
    mv $i $i.cdbs-orig ; \
    cp –remove-destination /usr/share/misc/config.guess $i ; \
    fi ; \
    done ; \
    fi
    if test -e /usr/share/misc/config.sub ; then \
    for i in ./config/config.sub ; do \
    if ! test -e $i.cdbs-orig ; then \
    mv $i $i.cdbs-orig ; \
    cp –remove-destination /usr/share/misc/config.sub $i ; \
    fi ; \
    done ; \
    fi
    /usr/bin/make -C obj-x86_64-linux-gnu
    make[1]: Entering directory `/home/pturner/downloads/tora-2.0.0/obj-x86_64-linux-gnu’
    make[1]: *** No targets specified and no makefile found. Stop.
    make[1]: Leaving directory `/home/pturner/downloads/tora-2.0.0/obj-x86_64-linux-gnu’
    make: *** [debian/stamp-makefile-build] Error 2
    root@rulebcn09:~/downloads/tora-2.0.0#

    here’s my system details:
    root@rulebcn09:~/downloads/tora-2.0.0# uname -a
    Linux rulebcn09 2.6.31-16-generic #53-Ubuntu SMP Tue Dec 8 04:02:15 UTC 2009 x86_64 GNU/Linux

    anyone got an idea what’s going wrong?

    best r

  • Richard Basile says:

    fakeroot produced an error but, I was able to proceed with sudo.

    However, now when I start Tora, I only have MySQL as an option in the drop down.

    I’m running the 11.2 client, have the three env vars set, and have rebooted.

    • Brad Hudson says:

      Hi Richard. Did you try the 11.1 Oracle package? This helped with a different issue for Paul. I would also reinstall the .deb package you built in case an update clobbered it.

  • paul says:

    …problem appears to be v11.2. i tried with v11.1 and it worked ok… thanks again

  • Lorenzo Eccher says:

    Hi, very useful, tnx.
    I follow your HOW TO to install tora on a x64 for oracle client 10.2.
    I had to install the libstdc++5 not included in karmic koala so I downloaded it from http://packages.ubuntu.com/jaunty/amd64/libstdc++5/download. It was needed while compiling tora and used by oci 10.2

    If you wanna improve your post with 10.2 oracle client. Tnx

    • Brad Hudson says:

      Did the libstdc++6 not work for you? I did not, and still do not, have libstdc++5 installed on my system.

      This may be one of the libraries that I had installed for something else unrelated and did not notice it was needed for this. I’ll keep it in mind when I do my 10.04 post in a couple of weeks. (I’ve been running the alphas for a while, it’s quite nice).

  • Jose says:

    Hi, thanks for the tutorial. I have the same problem that #13 : “I only have MySQL as an option in the drop down”. In addition, in debian/rules doesn’t appear the line “./configure …”. Although, config params appear in file: config.status (located in tora source folder). And apparently, these params are correct.

    Thanks.

  • Richard says:

    Great article,

    Your work was enormously helpful I built TOra with Oracle client 10.2. I wrote about my experiences here:

    http://crisppacketdatacentre.blogspot.com/2010/02/building-tora-with-oracle-support-on.html

  • Mario says:

    Hi!, thanx for the tutorial, really helpful. I just installed oracle 11G (11.1.0.6) enterprise for my ubuntu virtualbox, everything is fine there, now I wanted my old pal tora up with me again, and follow your steps here BUT as it’s the same machine, I made the assumption that I didn’t need to install the client as the oci.h is on $ORACLE_HOME/rdbms/public so I just point the ln there, plus the TNS_ADMIN is pointed to network/admin. It seems everything was fine, until it throw this error at the end of the fakeroot process:

    dh_shlibdeps -ptora
    dpkg-shlibdeps: error: no dependency information found for /u01/app/oracle/product/11.1.0/db_1/lib/libclntsh.so.11.1 (used by debian/tora/usr/bin/tora).
    dh_shlibdeps: dpkg-shlibdeps returned exit code 2
    make: *** [binary-predeb-IMPL/tora] Error 1

    I checked that path and found that file “libclntsh.so.11.1″ is there… so what just happened?

    Any help is welcome man, I don’t want to dl the client just for that, plus don’t wanna switch to that sqldeveloper or jdeveloper or any related. Thnx in advance.

    • Hi,

      To fix this error :

      dh_shlibdeps -ptora
      dpkg-shlibdeps: error: no dependency information found for /u01/app/oracle/product/11.1.0/db_1/lib/libclntsh.so.11.1 (used by debian/tora/usr/bin/tora).
      dh_shlibdeps: dpkg-shlibdeps returned exit code 2
      make: *** [binary-predeb-IMPL/tora] Error 1

      Try that :

      echo “libclntsh 11.1″ >> /etc/dpkg/shlibs.override

      Hope it help ;-)

      A++

      • Drask says:

        Worked for me. I edited the /etc/dpkg/shlibs.override file which now looks like:

        #
        libclntsh 11.1
        libocci 11.1

        (no line-feed on the last line)

        This was the final piece I needed to install Tora 2.1.1 on Karmic. Thank you.

  • Excusatio says:

    I ran “apt-get source tora”. The debian/rules script lacks a configure line. If I run ./configure by hand I get a tora binary with oracle support after a while. But if I build a .deb using “debian/rules binary” then I lose oracle stuff.

    Ubuntu 9.10 x86_64, Instant client 11.2.

    Ideas? Thanks…

  • Alex says:

    Hi, installing TOra on Ubuntu Karmic is being quite an adventure for me… I found this post late. So far I have Oracle XE client installed and I’m trying to compile TOra. This is what I get when I try to compile:

    /usr/src/tora-2.0.0$ fakeroot debian/rules binarytest -x debian/rules
    dh_testroot
    dh_clean -k
    dh_installdirs -A
    install: Can’t change permissions on «debian/tora»: Files or folder doesn’t exist
    dh_installdirs: install returned exit code 1
    make: *** [common-install-prehook-impl] Error 1

    This is what I have under debian:
    tora-2.0.0/debian$ ls tora*
    tora.desktop tora.install tora.links tora.wrapper tora.xml

    Thanks.

  • Alex says:

    Please ignore my question above… I used sudo instead fakeroot. Anyway, I got to a new dead end and I’m about to give up installing tora.

    I got this message when trying to build the package(the message that starts with ALEX is added by me):


    — Found Qt-Version 4.5.2
    Qt4 Found OK
    — ALEX custom messg: qt_library_dir /usr/lib;/usr/lib
    CMake Error at cmake/modules/FindQScintilla.cmake:54 (MESSAGE):
    Could not find QScintilla library
    Call Stack (most recent call first):
    CMakeLists.txt:181 (FIND_PACKAGE)

    I looked for the library and found it where I think it should be…

    /usr/lib/libqscintilla2.so.5

    I edited FindQScintilla.cmake and added two lines to find out where it was looking for the library:

    #ONLY THE FOLLOWING TWO LINES ARE ADDED BY ME
    SET(QT_LIBRARY_DIR ${QT_LIBRARY_DIR} /usr/lib)
    MESSAGE(STATUS “ALEX custom messg: qt_library_dir ${QT_LIBRARY_DIR}”)
    SET(QSCINTILLA_NAMES ${QSCINTILLA_NAMES} qscintilla2 libqscintilla2)
    FIND_LIBRARY(QSCINTILLA_LIBRARY
    NAMES ${QSCINTILLA_NAMES}
    PATHS ${QT_LIBRARY_DIR}
    )

    As shown at the beginning it was looking inside /usr/lib even before I edited FindQScintilla.cmake since the path appears twice.

    Ubuntu 9.10, Tora already installed through synaptic but without Oracle support.

    I wouldn’t want to go back to windows…
    Thanks.

    • Brad Hudson says:

      Hi Alex. What does this command give you?


      $ dpkg-query -l | egrep "^ii.*qscintilla"

      This will show you what packages are installed that match the search query for qscintilla. It’s likely that you are missing libqscintilla2-dev (the dev package). I did not have to do this by hand, did you my chance miss the step to apt-get build-dep tora? The packages you need should all be satisfied by that. Also make sure you installed all the other build tools and deps I have listed in the blog.

      Good luck!

    • jkings says:

      Hi.

      I resolved this issue installing the library libqscintilla2.

      The command is:

      sudo apt-get install libqscintilla2-dev

      I hope this helps somebody

  • akshay says:

    i just want to run pl/sql queries on tora! i’m using 10.04 and mysql.

    whenever i connect, i get this message ‘The tool PL/SQL Editor doesn’t support the current database’ and then there are not pl/sql editor n debugger!

    how do i fix this???

    • Brad Hudson says:

      akshay mysql support is out of scope for this article. Normally that would mean that mysql support is not compiled into the tOra build, which is a side effect of the recompile (I did not include mysql in this build). The tOra that comes with 10.04 should have mysql support by default, so you can use the vendor supplied package.

  • James says:

    dpkg-shlibdeps: warning: shared libs info file `/etc/dpkg/shlibs.override’ line 9: bad line `libocci.so.11.1′
    dpkg-shlibdeps: error: no dependency information found for /opt/oracle/product/11.2.0/db_1/lib/libocci.so.11.1 (used by debian/tora/usr/bin/tora).
    dh_shlibdeps: dpkg-shlibdeps -Tdebian/tora.substvars debian/tora/usr/bin/tora returned exit code 2

    dpkg-shlibdeps: warning: shared libs info file `/etc/dpkg/shlibs.override’ line 9: bad line `libocci.11.1′
    dpkg-shlibdeps: error: no dependency information found for /opt/oracle/product/11.2.0/db_1/lib/libocci.so.11.1 (used by debian/tora/usr/bin/tora).
    dh_shlibdeps: dpkg-shlibdeps -Tdebian/tora.substvars debian/tora/usr/bin/tora returned exit code 2
    make: *** [binary-predeb-IMPL/tora] 9
    I added the line like below.
    #
    libocci.so.11.1
    libclntsh 11.1

    or
    libocci.11.1
    libclntsh 11.1

    But I met same error. Is there any other solution?

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>