Tora is 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
[Content navigation] |
Page 1st: simple modification to support Oracle for Tora in Ubuntu |
Page 2nd: simple modification to support Oracle for Tora in Ubuntu |