[KLUG Members] SQL*Plus client for linux.

Kevin Mitchell members@kalamazoolinux.org
Wed, 5 Jun 2002 15:10:59 -0400 (EDT)


> 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.

Sounds like a reboot waiting to happen. ;)

> 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.

You can download the 600MB install and only install the Oracle client.
You can pick and choose some options (if I'm remembering correctly) and
get it the size down.  Really what you should just need is just the SQLNet
& SQLPlus.

Or you could try something like YASQL:
http://sourceforge.net/projects/yasql/

I've never used it, but it looks pretty cool.

Kevin