Use tora to connect to oracle in ubuntu

Source: Internet
Author: User


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

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.