Alfred von Campe
2006-Oct-10 20:58 UTC
[CentOS] Anyone have tora running on CentOS 4.X talking to an Oracle DB?
I was looking for a tool to access an Oracle database (the lack of readline support in SQL*Plus is really annoying) and stumbled across tora. I successfully did a "yum install tora" , but I can not access my Oracle database, as expected after reading the following in the RPM description: Tora ("Toolkit for Oracle") is a GUI-based database development program, offering SQL worksheets and a database browser. Please note that the Oracle plugin is not shipped. I can't find any instructions on how to get and/or install the Oracle plugin. Most Google queries I found suggest building tora from scratch, but I'd rather stick with using the RPM if possible. In case it matters, I'm trying to access an Oracle 10g instance that is running on a CentOS 4.4 system. Are there any other tools people use to access Oracle instead of SQL*Plus? I'll use anything that provides decent command line editing (e.g. readline support) and can automatically figure out the size of my terminal. SQL*PLus is pretty brain damaged in those departments. Thanks, Alfred
Will McDonald
2006-Oct-10 22:28 UTC
[CentOS] Anyone have tora running on CentOS 4.X talking to an Oracle DB?
On 10/10/06, Alfred von Campe <alfred at 110.net> wrote:> I was looking for a tool to access an Oracle database (the lack of > readline support in SQL*Plus is really annoying) and stumbled across > tora.There are a ton of SQL*Plus CLI replacements with extended functionality on sourceforge/freshmeat IIRC. No first-hand experience but I'm sure some of them are prefectly functional. http://sourceforge.net/search/?type_of_search=soft&words=sqlplus Will
Jay Leafey
2006-Oct-11 00:42 UTC
[CentOS] Anyone have tora running on CentOS 4.X talking to an Oracle DB?
Alfred von Campe wrote:> Are there any other tools people use to access Oracle instead of > SQL*Plus? I'll use anything that provides decent command line editing > (e.g. readline support) and can automatically figure out the size of my > terminal. SQL*PLus is pretty brain damaged in those departments.Yup, the SQL*Plus editing functions are... awkward, yeah, that's a good word! I looked at Tora, but it was overkill for us. I found a very nice readline wrapper in Perl named uniread (http://unread.sourceforge.net) that works great for us. As a bonus, uniread is very general and can be used for just about any program that does not support readline editing. I even use it for nsupdate. It's very easy to install, but I wrote a specfile if you want to roll your own RPM. -- Jay Leafey - Memphis, TN jay.leafey at mindless.com