Use tora to connect to oracle in ubuntu

Apt-get install zlib1g-devapt-get install libqt3-mt-dev libqt3-compat-headers sudo apt-get install qt3-dev-tools. /configure -- prefix =/opt/tora -- without-kde. /configure -- prefix =/opt/tora -- with-oracle =/opt/oracle/product/10.2/db -- without-rpath -- disable-new-check -- without-kde -- enable -libsuffix = Tora installed with apt-get in Ubuntu has only one PostgreSQL provider. 1. install Oracle Instant Client $ sudo apt-get install oracle-xe-client // if the corresponding software package cannot be found, update your apt software source and modify/etc/apt/sources. list file, refer to the article on modifying apt source on the Internet. The OIC installation directory is/usr/lib/oracle/xe/app/oracle/product/10.2.0/client2. Add the OIC installation directory to/etc/ ld. so. in the conf file, and then execute the ldconfig command to refresh $ sudo ldconfig3. Modify/etc/profile, add some new environment variables: export ORACLE_HOME =/usr/lib/oracle/xe/app/oracle/product/10.2.0/clientexport LD_LIBRARY_PATH = $ ORACLE_HOME/lib: $ LD_LIB RARY_PATHexport TNS_ADMIN =/usr/lib/oracleexport PATH = $ PATH: $ ORACLE_HOME/bin save the file and log on again to make it take effect. You can run the ench $ ORACLE_HOME command to check the file. 4. install Tora and its source code (a source is required) $ sudo apt-get install tora $ sudo apt-get source tora5. install the compilation tool www.2cto.com $ sudo apt-get install build-essential $ sudo apt-get install autoconf automake flex zlib1g-dev docbook-xsl $ sudo apt-get install libqt3-mt-dev libqt3-compat-headers6. modify the debian/rules file in the source code to put this line. /configure-prefix =/usr-without-oracle-without-rpath-disable-new-check-with-kde-enable-libsuffix = is changed./ Configure -- prefix =/usr -- with-oracle =/usr/lib/oracle/xe/app/oracle/product/10.2.0/client -- without-rpath -- disable-new-check -- without-kde -- enable-libsuffix = The following is a change in the article, the OIC cannot be found when running rules later .. /Configure-prefix =/usr-with-instant-client-without-rpath-disable-new-check-without-kde-enable-libsuffix = 7. compile Tora. After successful installation, the generated deb file (in the upper-level directory) $ debian/rules binary // it takes a long time to log on to the root user to compile and compile the file, wait. After compiling the deb package, you can install $ sudo dpkg-I tora_1.3.18-4ubuntu1_i386.deb8. create a file named tnsnames in the/usr/lib/oracle directory. add the connection information of your Oracle database. now, run Tora to view the Oracle provider. Author: piaoliuxiong