Tora is an Oracle toolkit designed to help DBAs or database application developers. Features PL/SQL debugger, SQL work orders highlighted by syntax, DB browser, and a comprehensive DBA tool set. TOra also supports MySQL and PostgreSQL. Similar to toad in windows. Tora Project address: http://tora.sourceforge.net/install and use Tora on fedora8to install oraclec
Tora is an Oracle toolkit designed to help DBAs or database application developers. Features PL/SQL debugger, SQL work orders highlighted by syntax, DB browser, and a comprehensive DBA tool set. TOra also supports MySQL and PostgreSQL. Similar to toad in windows.
Tora project: http://tora.sourceforge.net/
To install and use tora on Fedora 8, you must install the oracle client. Therefore, this document is divided into two parts:
Install oracle client on Fedora 8
Install and configure tora on Fedora 8
1. Install the oracle client on Fedora 8
The installation of the oracle client is detailed on the official oracle website.
Oracle Database 10g Client Release 2 (10.2.0.1.0) for Linux x86, Release.
Installation Process:
1. Memory and swap
Minimum Memory requirement: 256 MB of physical RAM
2. Check the required software package
Make-3.81-10.fc8 gcc-4.1.2-33 glibc-2.7-2 glibc-devel-2.7-2 compat-db-4.5.20-3.fc8 compat-gcc-34-3.4.6-8 compat-gcc-34-c devel-8-3.3.4.2 + +-3.4.6-8 compat-libstdc + +-8-3.3.4.2 compat-libstdc + +-openmotif-2.3.0-0.3.fc8.ccrma gnome-libs-1.4.2-7.fc8 libaio-devel-0.3.106-3.2 libaio-0.3.106-3.2 util-linux-ng-2.13-3.1.fc8
Note: The util-linux-ng-2.13-3.1.fc8 is named setarch in the previous fedora, for example, setarch-2.0-4.fc7.i386.rpm in fc7
3. create user groups and users
# Groupadd dba
# Groupadd oinstall
# Useradd-m-g oinstall-G dba oracle
# Passwd oracle
Changing password for user oracle.
New UNIX password:
Bad password: it is based on a dictionary word
Retype new UNIX password:
Passwd: all authentication tokens updated successfully.