LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 10-06-2005, 01:31 PM   #1
marie@dk
Member
 
Registered: Sep 2005
Location: Denmark
Distribution: Fedora Core 28
Posts: 49

Rep: Reputation: 15
Question Tora on FC4?


I have Oracle Instant Client installed and working... now I need Tora. Unfortunately Tora is not part of Fedora Core 4, and I am not sure what to download and install.

Being new to rpm's I would like to know if this is the one I should get?
ftp://rpmfind.net/linux/sourceforge/...rhel4.i386.rpm

I am using Gnome...Do I have to do/install anything special regarding that in relation to Tora?
 
Old 10-06-2005, 05:23 PM   #2
MensaWater
LQ Guru
 
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, CoreOS, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 7,831
Blog Entries: 15

Rep: Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668
I'm not familiar with Tora but will give you my thoughts:

rhel4 = RedHat Enterprise Linux 4 (probably 4 AS) which is the commercial version of RedHat. It might or might not work on your Fedora which is the free version of Linux that was originally called RedHat (confusing isn't it?).

If it were me and I couldn't find one for Fedora 4 I'd probably look for one for Fedora 3 on the theory that Fedora 4 would be backwardly compatible with things designed for earlier versions.

Looking on rpmfind I see that would be:
http://rpmseek.com/rpm/tora-1.3.14.1...:0:0:0:1899315

The downside being that is a subrevision or 2 back from the one you mentioned.

Alternatively you could try downloading the src and following its instructions for building your own. Since the latest versions are at sourceforge you should get it there if that's what you want.

Just keep in mind that many packages have dependencies so you may see messages about failed dependencies when you try to install it. Don't let this drive you crazy - it just means there are other rpms you need to install first (which may in turn have their own dependencies). You can usually find all of them at rpmfind.

In any event you can always remove an rpm that doesn't do what you want so it likely won't hurt anything if you just try to install the one you mentioned.
 
Old 10-07-2005, 04:36 PM   #3
marie@dk
Member
 
Registered: Sep 2005
Location: Denmark
Distribution: Fedora Core 28
Posts: 49

Original Poster
Rep: Reputation: 15
Thank you for replying :-)

Well, I have now tried the Tora version from FC3 and the redhat rpm ... I had no problems installing, but none of them works with Oracle Instance Client. I did a search on fedoraforum.org, and it seems that people generally are compiling Tora from source, to get it to work.

So that is what I am trying to do now... But the configure script complains about not finding qt-mt - it is looking for QT version 3.1 and I have version 3.3. I have set the path to QT in the configure options, but that does not seem to help.

Any ideas?

Anyway... if/when I get it to compile, I will post everything I did here, and hopefully it will help others.... :-)
 
Old 10-08-2005, 09:43 AM   #4
MensaWater
LQ Guru
 
Registered: May 2005
Location: Atlanta Georgia USA
Distribution: Redhat (RHEL), CentOS, Fedora, CoreOS, Debian, FreeBSD, HP-UX, Solaris, SCO
Posts: 7,831
Blog Entries: 15

Rep: Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668Reputation: 1668
You might just try editing the configure script itself so that it looks for version 3.3 instead 3.1. Not sure that will do it but as noted previously a lot of stuff is backwardly compatible so it might.

Also keep in mind that some things you see in building your own stuff are just "warnings" rather than "fatal" errors. If its just a warning you can usually continue on so long as you know what it is telling you as you do in this case.
 
Old 10-10-2005, 03:27 AM   #5
marie@dk
Member
 
Registered: Sep 2005
Location: Denmark
Distribution: Fedora Core 28
Posts: 49

Original Poster
Rep: Reputation: 15
Tora is now running on my laptop

As mentioned earlier, I realized I had to compile it from source to get it to work with Oracle Instant Client. Some of the steps below may be superfluous as I am a

Prior to compiling Tora, I installed these packages with yum:
Code:
yum install qt-ODBC
yum install kdelibs
yum install kdevelop
yum install qt-devel
yum install gcc-c++
Then I downloaded and unpacked the source for Tora...
Code:
mkdir /root/tora
cd /root/tora
wget http://mesh.dl.sourceforge.net/sourc...-1.3.18.tar.gz
tar xzf tora-1.3.18.tar.gz
Configure, compile and install:
Code:
cd /root/tora/tora-1.3.18/
./configure --with-qt-dir=/usr/lib/qt-3.3 --with-oracle=$ORACLE_HOME --with-oci-version=10G --with-instant-client
make
make install
You can start Tora like this:
Code:
cd /usr/local/tora/bin/
./tora
... or you can add it to your Applications menu ( For example by using the SMEG menu editor: http://www.fedorafaq.org/#editmenus). You can find the icon to use in the menu in the source: /root/tora/tora-1.3.18/icons/tora.xpm

Voila! .. hope this helps someone...
 
Old 10-10-2005, 10:09 AM   #6
alleycat
LQ Newbie
 
Registered: Jun 2004
Location: Chicago, IL
Distribution: fedora / centos / rhel
Posts: 12

Rep: Reputation: 0
You don't need to build it

I just had to do this again on another workstation today, so i documented the steps i took to use the tora rhel4 rpms on fc4 here: Oracle instantclient and tora on fc4 (excuse the mess on that wiki - I'll eventually clean it up in some of my copious free time, but for now I just dump info there.)

One could probably rebuild the src rpm on fc4 to be on the safe side, but the binaries are working fine with everything i've tried so far, so i haven't bothered. Hope that helps somebody out.
 
Old 10-12-2005, 03:10 AM   #7
marie@dk
Member
 
Registered: Sep 2005
Location: Denmark
Distribution: Fedora Core 28
Posts: 49

Original Poster
Rep: Reputation: 15
I started out by trying the package included in FC3... and then the redhat rpm you mention. But both of them gave this error when connecting:
Code:
ORA-12545:Connect failed because target host or object does not exist
I noticed that a lot of other people also experinced this, and the overall solution was to compile from source. Did you not experience this error? If you did, how did you fix it? If not, do you think the difference lies with oracle.sh? Because that seems to be the only thing from your tutorial that I didn't do.
 
Old 10-12-2005, 03:12 AM   #8
marie@dk
Member
 
Registered: Sep 2005
Location: Denmark
Distribution: Fedora Core 28
Posts: 49

Original Poster
Rep: Reputation: 15
Oh.. forgot to mention. I don't have the oracle.sh but I did include the paths in .bash_profile
 
Old 10-12-2005, 09:25 AM   #9
alleycat
LQ Newbie
 
Registered: Jun 2004
Location: Chicago, IL
Distribution: fedora / centos / rhel
Posts: 12

Rep: Reputation: 0
there's no difference between using an /etc/profile.d/oracle.sh versus a ~/.bashrc script, except that the former is easily available to every user on the machine. you did make sure the .bashrc was executed before trying tora and that the variables were all set in the session and that the paths were correct? the tnanames.ora file is where the TNS_ADMIN env variable says it should be?

ultimately, compiling from source is ok, but it's extra trouble, and more importantly it doesn't get the software into the rpm database, so i avoid it when possible - it just makes machines simpler to manage when you can easily query rpm to see what's installed.

it just so happens i have a clean machine i was about to install something else on, but i'll repeat the tora install from the wiki later today or tomorrow and see if i missed anything - i wrote the wiki entry partly from memory, so perhaps i missed a small but crucial step in there somewhere.

i'm a bit harried these days, so if you don't see a post back by tomorrow eve, don't hesitate to remind me - i turn into a complete sieve brain when i get busy.
 
Old 10-12-2005, 12:19 PM   #10
marie@dk
Member
 
Registered: Sep 2005
Location: Denmark
Distribution: Fedora Core 28
Posts: 49

Original Poster
Rep: Reputation: 15
Well, I don't know about .bashrc, but I got all the variables when running 'env'. And I checked, double-checked and trible-checked the paths...

I know it's off topic for this thread... but is it completely impossible to tell rpm about an application compiled from source?
 
Old 10-13-2005, 08:08 AM   #11
alleycat
LQ Newbie
 
Registered: Jun 2004
Location: Chicago, IL
Distribution: fedora / centos / rhel
Posts: 12

Rep: Reputation: 0
well, looks to me like you're definitely not imagining things - i did the install on my clean fc4 and sure enough, it's not happy. sqlplus connections work, so it's probably something silly i'm missing with tora itself. i imagine i'll get it figured out - apparently i did once before. - lol.

re rpms - i used to use something called "checkinstall" for that, but it stopped working around fc2 and the switch to the 2.6 kernel, and i never bothered to figure it out, even tho there's supposedly a fix for it somewhere. if you install stuff from source, that's a very useful utility though - essentially you run the "make install" step through it, it runs it in a sandbox, figures out what files are being installed and builds a binary package out of them. i don't know if the problem has been fixed in the meantime or not.

alternatively, and better i think - i notice that the source tgz file has a spec file in it and a "rpm" target in the makefile. the spec claims to be mandrake specific, but i'll bet that can be worked out - it's obvious that *somebody's* building rpms for other distros somehow, since you can get some of them from sf.net. but i haven't messed with the build myself.
 
Old 10-13-2005, 01:06 PM   #12
alleycat
LQ Newbie
 
Registered: Jun 2004
Location: Chicago, IL
Distribution: fedora / centos / rhel
Posts: 12

Rep: Reputation: 0
Found it - turns out the problem is a bug in either qt or kde that makes tora miss the SQL*Net checkbox and try to connect as it the oracle server was running on localhost. It can be fixed by upgrading qt/kde - more details at the previously mentioned wiki page: http://www.mantic.org/wiki/Oracle_in...nd_tora_on_fc4

I also added instructions for removing the setting of the LD_LIBRARY_PATH path variable and adding the libs to the library search path using ldconfig. That's just cleaner - LD_LIBRARY_PATH is intended for development and testing, not everyday usage.

Hope that helps and that the wiki is correct now.
 
Old 10-14-2005, 04:19 AM   #13
marie@dk
Member
 
Registered: Sep 2005
Location: Denmark
Distribution: Fedora Core 28
Posts: 49

Original Poster
Rep: Reputation: 15
I wish I had your tutorial sooner ... but I'll definitely add a link to your tutorial on my site :-)

Another thing... I asked my boyfriend about the compile/rpm thing, He says that he always compiles from source, then he makes an rpm and uses it to install. I'll use that approach next time I need to compile something...
 
Old 10-14-2005, 05:59 AM   #14
alleycat
LQ Newbie
 
Registered: Jun 2004
Location: Chicago, IL
Distribution: fedora / centos / rhel
Posts: 12

Rep: Reputation: 0
Quote:
Originally posted by marie@dk
I wish I had your tutorial sooner ... but I'll definitely add a link to your tutorial on my site :-)

Another thing... I asked my boyfriend about the compile/rpm thing, He says that he always compiles from source, then he makes an rpm and uses it to install. I'll use that approach next time I need to compile something...
lol - well it didn't exist sooner. in any case, i think of it more as a howto. but i'm glad you told me there was a problem with it - i'm trying to make a habit of writing down stuff as i do it, both for my own benerfit, and if it helps out somebody else too, so much the better. apparently i'd only done it on machines i'd already upgraded kde on, so i didn't run into the problem myself.

as for the rpm thing - his approach makes sense. i tend to trust the rpmforge.net repositories and i use those in addition to the base fedora/centos ones - rpmforge.net is these folks - http://rpmforge.net/about.php - all pretty well known in making 3rd party rpms for various rpm based distros. it's a pretty big and good quality repo that works to be comaptible iwith the base dstro packages. here's the easy setup for 'em - http://rpmforge.net/user/packages/rpmforge-release/. i'm thinking that when i have time to figure out a good approach to building rpms, i might start contributing to their repo. it's work, but i'd feel like it was giving back for all of the great s/w i've been using for almost a decade now.

that all said, compiling from source gives you more control over the finished product, and using a repo is an act of trust - there are definitely logical arguments for his approach.

my main point is that using an rpm for the actual install instead of just running "make install" makes for a cleaner, more easily managed system. you don't find yourself wondering what stuff is or where it came from later.
 
Old 11-05-2005, 10:13 AM   #15
marie@dk
Member
 
Registered: Sep 2005
Location: Denmark
Distribution: Fedora Core 28
Posts: 49

Original Poster
Rep: Reputation: 15
I finally got around to adding my own tutorial... But of course I have recommended my readers to check out yours first :-)
http://www.nerdgirl.dk/linux/tora.php
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Installing TOra 1.3.18 & Qt 3.3.5 on CentOS 4.1 (RHEL 4 U1) box running Oracle 10g R2 dbaxps Linux - Software 2 02-22-2007 08:41 AM
Dual Boot Windows XP & FC4 with FC4 already installed kt8993 Linux - General 8 10-18-2006 04:26 PM
Tora mimsmall Linspire/Freespire 0 10-21-2004 08:05 PM
Connect to SQLite with Tora & ODBC kkempter Linux - Software 2 07-22-2004 03:00 PM
Using Tora to connect to remote database devinWhalen Linux - Software 0 02-18-2004 03:15 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:27 AM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration