TOra Oracle Mac "plugins probably missing"

From: Ryan Hughes <gnebulon_at_gmail.com>
Date: 28 Jan 2007 11:07:32 -0800
Message-ID: <1170011252.460276.238320_at_v45g2000cwv.googlegroups.com>

Hi. I seem to have a somewhat unusual setup -- I'm trying to get TOra with Oracle support working on my Mac OS X system, showing up in X11. I've followed all the instructions I can find. I've had to alter them a little to translate them from Linux to MacOSX. Finally, I compiled a version of TOra with Oracle support... Or so I thought...

When I start tora (which I can do), it insists that there is "no available connection provider. plugins probably missing".

I don't know what else to do to convince it. I compiled it with -- with-instant-client, --with-oracle-includes, --with-oracle-libraries. What am I missing, at this point?

I hope someone has an idea. To facilitate this, I am now going to dump a large amount of highly technical information.

Thanks.

--Ryan

Here's the output of otool -L tora. You can see that it has found libclntsh. Perhaps it needs other libraries?

/usr/bin/tora:

/sw/lib/libqt-mt.3.dylib (compatibility version 3.3.0, current
version 3.3.7)

/usr/lib/libresolv.9.dylib (compatibility version 1.0.0,
current version 369.5.0)

/usr/lib/libz.1.dylib (compatibility version 1.0.0, current
version 1.2.3)

/usr/X11R6/lib/libGL.1.dylib (compatibility version 1.2.0,
current version 1.2.0)

/usr/X11R6/lib/libXmu.6.dylib (compatibility version 6.2.0,
current version 6.2.0)

/usr/X11R6/lib/libXrender.1.dylib (compatibility version
1.2.0, current version 1.2.0)

/usr/X11R6/lib/libXrandr.2.dylib (compatibility version 2.0.0,
current version 2.0.0)

/usr/X11R6/lib/libXcursor.1.dylib (compatibility version
1.0.0, current version 1.0.0)

/usr/X11R6/lib/libXinerama.1.dylib (compatibility version
1.0.0, current version 1.0.0)

/usr/X11R6/lib/libXft.2.dylib (compatibility version 2.1.0,
current version 2.1.0)

/usr/X11R6/lib/libfreetype.6.dylib (compatibility version
6.3.0, current version 6.3.0)

/usr/X11R6/lib/libfontconfig.1.dylib (compatibility version
1.0.0, current version 1.0.0)

/usr/lib/libSystem.B.dylib (compatibility version 1.0.0,
current version 88.1.5)

/sw/lib/libdl.0.dylib (compatibility version 0.0.0, current
version 0.0.0)

/sw/lib/libjpeg.62.dylib (compatibility version 63.0.0,
current version 63.0.0)

/usr/X11R6/lib/libXext.6.dylib (compatibility version 6.4.0,
current version 6.4.0)

/usr/X11R6/lib/libX11.6.dylib (compatibility version 6.2.0,
current version 6.2.0)

/usr/X11R6/lib/libSM.6.dylib (compatibility version 6.0.0,
current version 6.0.0)

/usr/X11R6/lib/libICE.6.dylib (compatibility version 6.3.0,
current version 6.3.0)

/sw/lib/libqscintilla.7.dylib (compatibility version 7.0.0,
current version 7.0.1)

/usr/lib/libstdc++.6.dylib (compatibility version 7.0.0,
current version 7.4.0)

/b/729/rdbms/lib/libclntsh.dylib.10.1 (compatibility version
0.0.0, current version 0.0.0)

/usr/lib/libgcc_s.1.dylib (compatibility version 1.0.0,
current version 1.0.0)

This was my configure string:
  $ ./configure --prefix=/usr --with-instant-client --without-rpath -- disable-new-check --without-kde --enable-libsuffix= --with-oracle- libraries=/usr/local/lib/instantclient_10_1 --with-oracle-includes=/ usr/local/lib/instantclient_10_1/sdk/include --with-qscintilla- libraries=/sw/lib/qt3/lib/

In fact, here's the notes I've made on everything I've done so far: == Instructions ==
Here's what I (Ryan) did to get TOra on Mac OS X:

# Go to [[http://www.oracle.com/technology/software/tech/oci/ instantclient/htdocs/macsoft.html]] and download the oracle instant client thingies. I got "Basic", "SQL*Plus", "SDK", and "ODBC". Note! You have to sign up for a stupid account in order to download. # I unzipped all the "zip" files. They all went into one big directory called "instantclient_10_1".
# I did: mv instantclient_10_1 /usr/local/lib # Go to /usr/local/lib/instantclient_10_1 and make these symlinks:   # ln -s libclntsh.so.10.1 libclntsh.so   # ln -s libocci.so.10.1 libocci.so
# I made a file /usr/lib/oracle/tnsnames.ora, like this: <pre>
MCKESSONDEV =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.2)(PORT = 1521))     )

    (CONNECT_DATA =

      (SID = ora1)
      (SERVER = DEDICATED)

    )
  )
</pre>
# I added this: export TNS_ADMIN=/usr/lib/oracle to my ~/.bashrc, and then sourced it.

# I did the same with: export ORACLE_HOME=/usr/lib/oracle
# Also, PATH=$PATH:/usr/local/lib/instantclient_10_1/
# I made a symlink: ln -s /usr/local/lib/instantclient_10_1 /usr/lib/

oracle/lib
# For some reason, the libclntsh library is messed up. To fix it, make a weird symlink.
  # mkdir -p /b/729/rdbms/lib/
  # ln -s /usr/local/lib/instantclient_10_1/libclntsh.dylib.10.1 /b/ 729/rdbms/lib
  # mkdir -p /b/729/sqlplus/lib
  # ln -s /usr/local/lib/instantclient_10_1/libsqlplus.dylib /b/729/ sqlplus/lib/
  # mkdir -p /b/729/network/lib
  # ln -s /usr/local/lib/instantclient_10_1/libnnz10.dylib /b/729/ network/lib

# mkdir $ORACLE_HOME/bin
# ln -s `which sqlplus` $ORACLE_HOME/bin/
# Now, we're going to compile tora with oracle support.  By using 

'fink', you can get most of the dependancies. Try 'fink install kdebase3'. That downloaded and compiled most everything I needed. # Oops, I actually needed QScintilla. I downloaded it from [[http:// www.riverbankcomputing.co.uk/qscintilla/index.php]].

  # I moved it to /usr/src and untarred it
  # I cd'ed to its directory
  # It has a file that warns that Qt is broken on MacOS, and gives a 

patch. My sincere hope is that this patch has already been applied because my qt was installed from the mac repository. This is probably not the case.

  # cd qt
  # qmake qscintilla.pro
  # make
  # make install
  # ln -s /sw/lib/qt3/lib/libqscintilla.7.dylib /sw/lib/

# TOra itself doesn't have a package, for MacOSX. So I had to download the source from [[http://tora.sourceforge.net/]]. # I unpacked the tarball and cd'ed to the directory. There, I issued: ./configure --prefix=/usr --with-instant-client --without-rpath -- disable-new-check --without-kde --enable-libsuffix= --with-oracle- libraries=/usr/local/lib/instantclient_10_1 --with-oracle-includes=/ usr/local/lib/instantclient_10_1/sdk/include # make Received on Sun Jan 28 2007 - 20:07:32 CET