tora (Toolkit for Oracle) without oracle support???

[Jivicin]

I managed to get TOra up and running, but am still having trouble getting it to work with Oracle. I compiled it using the options for Oracle support, but when I start TOra, the only selection option I have is for MySQL.

I also get this error when I try to fire it up, but it still works:

X Error: BadDevice, invalid or uninitialized input device 157
  Major opcode:  148
  Minor opcode:  3
  Resource id:  0x0
Failed to open device
X Error: BadDevice, invalid or uninitialized input device 157
  Major opcode:  148
  Minor opcode:  3
  Resource id:  0x0
Failed to open device

I'm not sure if that has anything to do with my problem or not.

Any ideas?

[nwgray]

trying compile this again, i get this error:

:/usr/src/tora-1.3.18$ sudo debian/rules binary
dh_testdir
make: dh_testdir: Command not found
make: *** [configure-stamp] Error 127


I've never seen this make error before. Any Ideas?

Thx

[spiderwort]

nwgray, you need to install debhelper to get rid of that error.

I have been following the instructions that thermans pointed to in post #5 of this thread. I have the Oracle instant client installed. My current hurdle that I have not been able to leap looks like this (this is in the debian/rules binary step):

checking for oracle... checking oci works... configure: error: Couldn't compile and run a simpile OCI app.
Try setting ORACLE_HOME or check config.log.
Otherwise, make sure ORACLE_HOME/lib is in /etc/ld.so.conf or LD_LIBRARY_PATH
make: *** [configure-stamp] Error 1


I have ORACLE_HOME, LD_LIBRARY_PATH, and TNS_ADMIN all pointing to the top of the instant client install.

Anyone have any suggestions?

[nwgray]

spiderwort
Thx for the info on debhelper. I installed it and then I noticed that if you copy and paste pinter's text from the webpage, it doesn't have the -- that is needed in the rules file. I changed this:

./configure –prefix=/usr –with-instant-client –without-rpath –disable-new-check –without-kde –enable-libsuffix=

with this:

./configure –prefix=/usr --with-instant-client --without-rpath --disable-new-check --without-kde --enable-libsuffix=

and I'm almost there. I get an Oracle-includes error. Here's the term output from my debian/rules binary run:

checking for a BSD-compatible install... /usr/bin/install -c
checking for -p flag to install... yes
checking whether build environment is sane... yes
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking build system type... i686-pc-linux-gnu
checking host system type... i686-pc-linux-gnu
checking for a sed that does not truncate output...
checking for a BSD-compatible install... /usr/bin/install -c -p
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ANSI C... none needed
checking for style of include used by make... GNU
checking dependency style of gcc... gcc3
checking for g++... g++
checking whether we are using the GNU C++ compiler... yes
checking whether g++ accepts -g... yes
checking dependency style of g++... gcc3
checking for egrep... grep -E
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for /usr/bin/ld option to reload object files... -r
checking for BSD-compatible nm... /usr/bin/nm -B
checking whether ln -s works... yes
checking how to recognise dependent libraries... pass_all
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking dlfcn.h usability... yes
checking dlfcn.h presence... yes
checking for dlfcn.h... yes
checking how to run the C++ preprocessor... g++ -E
checking for g77... no
checking for f77... no
checking for xlf... no
checking for frt... no
checking for pgf77... no
checking for fort77... no
checking for fl32... no
checking for af77... no
checking for f90... no
checking for xlf90... no
checking for pgf90... no
checking for epcf90... no
checking for f95... no
checking for fort... no
checking for xlf95... no
checking for ifc... no
checking for efc... no
checking for pgf95... no
checking for lf95... no
checking for gfortran... no
checking whether we are using the GNU Fortran 77 compiler... no
checking whether accepts -g... no
checking the maximum length of command line arguments... 32768
checking command to parse /usr/bin/nm -B output from gcc object... ./configure: line 5783: s/^[ABCDGIRSTW][ABCDGIRSTW]* \(.*\) \(.*\)$/ {"\2", (lt_ptr_t) \&\2} ,/: No such file or directory
ok
checking for objdir... .libs
checking for ar... ar
checking for ranlib... ranlib
checking for strip... strip
checking if gcc static flag works... yes
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC
checking if gcc PIC flag -fPIC works... yes
checking if gcc supports -c -o file.o... yes
checking whether the gcc linker (/usr/bin/ld) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
configure: creating libtool
appending configuration tag "CXX" to libtool
checking for ld used by g++... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking whether the g++ linker (/usr/bin/ld) supports shared libraries... yes
checking for g++ option to produce PIC... -fPIC
checking if g++ PIC flag -fPIC works... yes
checking if g++ supports -c -o file.o... yes
checking whether the g++ linker (/usr/bin/ld) supports shared libraries... yes
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
appending configuration tag "F77" to libtool
checking for ANSI C header files... (cached) yes
checking for unistd.h... (cached) yes
checking sys/param.h usability... yes
checking sys/param.h presence... yes
checking for sys/param.h... yes
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking time.h usability... yes
checking time.h presence... yes
checking for time.h... yes
checking sys/mkdev.h usability... no
checking sys/mkdev.h presence... no
checking for sys/mkdev.h... no
checking sys/sysmacros.h usability... yes
checking sys/sysmacros.h presence... yes
checking for sys/sysmacros.h... yes
checking for string.h... (cached) yes
checking for memory.h... (cached) yes
checking fcntl.h usability... yes
checking fcntl.h presence... yes
checking for fcntl.h... yes
checking dirent.h usability... yes
checking dirent.h presence... yes
checking for dirent.h... yes
checking sys/ndir.h usability... no
checking sys/ndir.h presence... no
checking for sys/ndir.h... no
checking ndir.h usability... no
checking ndir.h presence... no
checking for ndir.h... no
checking alloca.h usability... yes
checking alloca.h presence... yes
checking for alloca.h... yes
checking locale.h usability... yes
checking locale.h presence... yes
checking for locale.h... yes
checking whether time.h and sys/time.h may both be included... yes
checking utime.h usability... yes
checking utime.h presence... yes
checking for utime.h... yes
checking for struct utimbuf... yes
checking whether sys/types.h defines makedev... yes
checking for working alloca.h... yes
checking for alloca... yes
checking for stdlib.h... (cached) yes
checking for GNU libc compatible malloc... yes
checking for snprintf... yes
checking for vsnprintf... yes
checking for stdbool.h that conforms to C99... yes
checking for _Bool... yes
checking whether struct tm is in sys/time.h or time.h... time.h
checking for struct stat.st_blocks... yes
checking for dirent.h that defines DIR... yes
checking for library containing opendir... none required
checking whether closedir returns void... no
checking for size_t... yes
checking enable plugin support... no
checking if monolithic build... no
checking whether to link plugins into binary... need link
not using lib directory suffix
checking for extra includes... no
checking for extra libs... no
checking for X... libraries /usr/X11R6/lib, headers in standard search path
checking for gethostbyname... yes
checking for connect... yes
checking for remove... yes
checking for shmat... yes
checking for IceConnectionNumber in -lICE... yes
checking for pthread_create in -lpthread... yes
checking for libz... -lz
checking have kde... no
checking for libpng... -lpng -lz -lm
checking for libjpeg6b... no
checking for libjpeg... -ljpeg
checking for Qt... checking for X... libraries /usr/X11R6/lib, headers
checking for IceConnectionNumber in -lICE... (cached) yes
checking for libXext... yes
checking for Xinerama... no

libqt: -lqt-mt -lpng -lz -lm -ljpeg -lSM -lICE -lXext -lX11 -lSM -lIC E ,
libraries: /usr/lib,
headers: /usr/include/qt3 using -mt
checking for lrelease... /usr/bin/lrelease
checking for lupdate... /usr/bin/lupdate
checking for moc... /usr/bin/moc
checking for uic... /usr/bin/uic
checking whether uic supports -L ... yes
checking whether uic supports -nounload ... yes
checking if STL implementation is SGI like... yes
checking for oracle... configure: error: /usr/include/oracle/tnsnames.ora/client doesn't exist. Please install the sdk package or use --oracle-includes.
make: *** [configure-stamp] Error 1


I dont' know where the ref for oracle is coming from. Any ideas?

Thx

[spiderwort]

Even though this is _supposed_ to work gracefully with the instant client, I'm finding that it doesn't seem to. I've come up with some work-arounds. My configure line in debian/rules now looks like this:

./configure --prefix=/usr --with-instant-client --without-rpath --disable-new-check --without-kde --with-oracle-includes=/usr/lib/oracle/sdk/include --with-oracle-libraries=/usr/lib/oracle --enable-libsuffix=

I also added some symbolic links within the instant client directories:
ln -s /usr/lib/oracle /usr/lib/oracle/bin # needs this to find sqlplus
ln -s libclntsh.so.10.1 libclntsh.so # needs this to find the libclntsh library
ln -s libocci.so.10.1 libocci.so # just to make sure it doesn't complain

I've got it to ths point where it is complainig about qscintilla. I saw a post about that somewhere.......hope I can find it again.....

Edit: Duh! Install libqscintilla-dev! It is now compiling.....NO idea how long it will take!

[nwgray]

Spiderwort,
When I changed my ./configure line to match yours, I get this error:

checking for oracle... checking oci works... configure: error: Couldn't compile and run a simpile OCI app.
Try setting ORACLE_HOME or check config.log.
Otherwise, make sure ORACLE_HOME/lib is in /etc/ld.so.conf or LD_LIBRARY_PATH
make: *** [configure-stamp] Error 1

I dont' have an sdk directory under oracle and I set the links that you have listed below:

ln -s /usr/lib/oracle /usr/lib/oracle/bin # needs this to find sqlplus
ln -s libclntsh.so.10.1 libclntsh.so # needs this to find the libclntsh library
ln -s libocci.so.10.1 libocci.so # just to make sure it doesn't complain

Where do I get the sdk stuff? How can I verify what my Oracle_home is set to? I followed pinter's stuff but I want to make sure.

Thx

[spiderwort]

nwgray, to answer your specific issue, the sdk stuff is part of the Oracle Instant Client. There are 3 separate pieces you need to install.

I have actually gotten my TOra talking to my Oracle database....8i, no less! That version is a little long in the tooth, and I would expect to have the most trouble with it rather than a newer version.

Here are the step-by-step instructions I went through. This is for a fairly straightforward Dapper installation. YMMV, etc. I assume a certain amount of basic knowledge....

- Download Oracle Instant Client from OTN
- Unzip basic & sqlplus & sdk into "some directory somewhere"
- Copy tnsnames.ora & sqlnet.ora to "some directory somewhere" (if you copy it over from Windows MAKE SURE the line termination character is correct...I don't know how many times this one has bitten me....do a hex dump on it if you have to!)
- Create symlink /usr/lib/oracle pointing to "some directory somewhere"/instantclient_xx (this is the directory created by unzipping the OTN download)
- ln -s /usr/lib/oracle /usr/lib/oracle/bin # this is so that configure will find sqlplus to get the Oracle version
- ln -s libclntsh.so.10.1 libclntsh.so # this is so that configure will find this library
- ln -s libocci.so.10.1 libocci.so # preventive....just in case
- Edit (or create) /etc/ld.so.conf, add /usr/lib/oracle
- Reload library cache: sudo ldconfig
- Edit ~/.bashrc, add:
- LD_LIBRARY_PATH=/usr/lib/oracle:$LD_LIBRARY_PATH
- export TNS_ADMIN=/usr/lib/oracle
- export ORACLE_HOME=/usr/lib/oracle
- re-login or open new terminal window (this picks up the new environment variables from your .bashrc)
- Install TOra (apt-get install tora) (this installs a whole bunch of dependencies for you)
- Get TOra source (cd /usr/src; apt-get source tora) (better: get source from sourceforge....some fixes have been applied for instant client) [EDIT 10/9/2006: Since it has been reported that the Dapper source does not work, don't use it with these instructions]
- Get build tools:
- g++
- gcc
- autoconf
- automake
- flex
- zlib1g-dev
- docbook-xsl
- libqt3-mt-dev
- libq3-compat-headers
- debhelper
- libqscintilla-dev
- In TOra source tree, edit debian/rules:
./configure --prefix=/usr --with-instant-client --without-rpath --disable-new-check --without-kde --with-oracle-includes=/usr/lib/oracle/sdk/include --with-oracle-libraries=/usr/lib/oracle --enable-libsuffix=
- from source directory: debian/rules binary
- ~ 45 minutes to compile
- End up with a .deb package just above source directory
- Remove TOra installed above (use synaptic or sudo apt-get remove ...)
- Install new package: dpkg -i tora_1.3.21-1_i386.deb (or whatever your file ended up being called)
- Test out your instant client setup: sqlplus schema_name/password@database.name.in.tnsmames.ora
- If that works, try starting up TOra from command line from same directory as where tnsnames.ora lives

Good luck!

[nwgray]

I get this when trying to compile:

debian/rules:22: *** commands commence before first target. Stop.

?

[nwgray]

okay, fixed that problem but I'm still getting this error after about two minutes of compiling:

checking for oracle... checking oci works... configure: error: Couldn't compile and run a simpile OCI app.
Try setting ORACLE_HOME or check config.log.
Otherwise, make sure ORACLE_HOME/lib is in /etc/ld.so.conf or LD_LIBRARY_PATH
make: *** [configure-stamp] Error 1

This is from the config.log

configure:32474: gcc -o conftest -g -O2 -I/usr/lib/oracle/instantclient_10_2/sdk/include -L/usr/lib/oracle/instantclient_10_2 conftest.c -lclntsh >&5
/usr/bin/ld: cannot find -lclntsh
collect2: ld returned 1 exit status

[spiderwort]

Oops....looks like you didn't read my mind when I typed up those lousy instructions . I have adjusted them....your symbolic link in /usr/lib which is called oracle should point to the directory which was created when you unzipped the instant client download. Thus, "some directory somewhere"/instantclient_xx (where xx is whatever version).

Also, make certain you have the symbolic link libclntsh.so pointing to libclntsh.so.10.1. But it is possible it is getting confused because /usr/lib/oracle is one level too high.

Let me know how it goes....sorry you have to be the guinea pig on my instructions.