[KLUG Members] SQL*Plus client for linux.

[Bruce Damkoehler]

Adam Bultman wrote:

> I've got an Oracle database running on a windows machine. It's also
> running coldfusion, making it a very ugly sight to see indeed.
>
> But I digress. I have a few users who would like command line interfaces
> to Oracle -- SQL*Plus.  Now:  My problem is that I haven't found many
> programs that will allow you to connect like this from afar. They have no
> shell on the system, although I could add openSSH for windows on there
> (but some terminal handling is poor, i.e. backspace, etc) but if possible,
> I'dl ike a linux version of SQL*Plus that I can set up to connect to it
> from say, another server.  So far, the only way I know how to get a
> command line interface to Oracle is to download the entire 600 MB install
> file for oracle and install it. I'd rather not do this, so if you know of
> a linux variant of SQL*Plus that allows me to connect, it would be swell
> if you told me.
>
> Adam
>
> --
> Adam Bultman
> adam@glaven.org
> [ http://www.glaven.org ]
>
> _______________________________________________
> Members mailing list
> Members@kalamazoolinux.org
> 

Are you running an Oracle listener on the Windows machine?  If so, I would
recomend that you use sqlwork from www.mattshouse.com. I run regularly use
the version 3 code on Linux and Aix. I know that there is a 5.0 beta out
there but I haven't tried it.

Back in the days of kde 1.x there was a GUI frontend to sqlplus called
ksqlplus. I don't know if its ever been ported to kde2 and later. If you
don't have sqlplus it won't do you any good though.

Another open source GUI sql tool for Oracle is copper. Its a clone of a 3rd
party Oracle SQL tool called Golden32. I just discovered it recently and
haven't got around to trying it yet.

If you prefer a java solution try ViennaSQl.

You will have to have your tnsnames.ora file on the client machine setup
appropriately. It has been my experience that on Windows  Oracle listeners
listen on port 1526 and on Unix machines they listen on port 1521.  You can
typically find examples of tnsnames.ora in $ORACLE_HOME/network/admin on the
server name.