Simple modification allows Tora in Ubuntu to support Oracle

Source: Internet
Author: User
Tora is a database tool similar to toad in unix/linux. In Ubuntu (DapperDrake), Tora installed with apt-get has only one provider of PostgreSQL. Method to add Oracle Support to Tora. The general steps are as follows (there are several differences from the article, including the solution to Tora compilation failure): 1. install OracleInstantClient $ sudoapt-Tora as a database tool similar to toad in unix/linux.

In Ubuntu (Dapper Drake), Tora installed with apt-get has only one provider of PostgreSQL. Method to add Oracle Support to Tora. The general steps are as follows (there are several differences from the article, including the solution to Tora compilation failure ):

1. Install Oracle Instant Client

$ Sudo apt-get install oracle-xe-client

The directory after OIC installation is/usr/lib/oracle/xe/app/oracle/product/10.2.0/client.

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

$ Sudo ldconfig

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

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

Export PATH = $ PATH: $ ORACLE_HOME/bin

After saving it, log on again to make it take effect. You can run the env or printenv command to check the effect.

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

$ Sudo apt-get install tora

$ Sudo apt-get source tora
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.