[ILUG] Oracle-compatible client

[Martin Feeney]

On 29 Mar 00, at 15:12, Jeremy Smyth wrote:

> Round 7 in our "Let's squeeze a few linux boxes into an MS-Partner site":
> 
> Is there anything I can use to run arbitrary SQL commands against an NT
> Oracle server?
> 
> I'm effectively looking for something like Oracle's own SQL worksheet, only
> it'll run on Linux. And I haven't a bog about getting a connect-string to
> work from linux to NT...
> (...and the less money I have to ask Mr IT manager for the better)

You could try and find the Oracle Client libraries and/or Enterprise 
Manager for Linux (downloading the entire installation would probably be a 
bit of overkill).  Client libs will give you sqlplus, enterprise manager 
should give you all the nifty gui tools.

You could get the oracle jdbc thin drivers (very small download) and run a 
jdbc sql-worksheet-style java app (lots to choose from) if you've got a 
JVM on the linux box.

Connect strings to NT should be the same as to any other platform.  Hint: 
copy tnsnames.ora and sqlnet.ora from the NT box if you're installing the 
client libs on the linux box.