Shulou(Shulou.com)06/01 Report--

This article introduces the knowledge of "how to install Oracle provider in Ubuntu Tora". Many people will encounter such a dilemma in the operation of actual cases, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

In particular, it is worth mentioning that Tora has a lot to learn, here we mainly introduce Ubuntu Tora, including Ubuntu Tora and other aspects. The contents of the book include Ubuntu introduction, system installation and rapid configuration, Linux file system, APT software package management mechanism, network management, graphical desktop application system, network service management and so on. Ubuntu Tora is a database tool similar to toad under unix/linux.

Ubuntu Tora installed directly with apt-get under Ubuntu (version Dapper Drake) has only PostgreSQL provider. I added Oracle support to Ubuntu Tora as I did in this article. The general steps are as follows (there are several differences from the article, including solutions that can't be compiled by Ubuntu Tora):

1. Install Oracle Instant Client

The directory after QUOTE:$ sudo apt-get install oracle-xe-clientOIC installation is / usr/lib/oracle/xe/app/oracle/product/10.2.0/client

two。 Add the OIC installation directory to the / etc/ld.so.conf file, and then execute the ldconfig command to refresh

QUOTE:$ sudo ldconfig

3. Modify / etc/profile to add some new environment variables

QUOTE:export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/client

Export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

Export TNS_ADMIN=/usr/lib/oracle

After the export PATH=$PATH:$ORACLE_HOME/bin is saved, log in again to make it effective, which can be checked with the env or printenv command.

4. Install Ubuntu Tora and its source code (source source is required)

QUOTE:$ sudo apt-get install Ubuntu Tora

$sudo apt-get source Tora

5. Install compilation tools

QUOTE:$ 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-headers

6. Modify the debian/rules file in the source code to change this line

QUOTE:./configure-prefix=/usr-without-oracle-without-rpath-disable-new-check-with-kde-enable-libsuffix=

QUOTE:./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= notice that this is different from the one in that article (here are the changes in the article). According to the reform in the article, we will encounter the problem of not finding OIC.

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

7. Compile Ubuntu Tora, and install the generated deb file after success (in the directory above)

QUOTE:$ debian/rules binary

$sudo apt-get remove Tora

$sudo dpkg-I Tora_1.3.18-4ubuntu1_i386.deb

8. Create a file tnsnames.ora in the / usr/lib/oracle directory and add the connection information to your Oracle database

9. Now run Ubuntu Tora, and you can see Oracle's provider.

This is the end of the content of "how to install Oracle provider in Ubuntu Tora". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.