Looking for free oracle client to use to access oracle databases

Posted on 2013-10-02
Medium Priority
Last Modified: 2013-10-18
Hello, I was wondering if someone can link me to a free oracle client that I can use to access oracle databases. Thanks
Question by:DancingFighterG
LVL 38

Expert Comment

by:Geert G
ID: 39539579
all the oracle clients are free

like this for oracle 32-bit


Expert Comment

ID: 39539589
try MySQL Workbench.


FYI - MySQL is now under Oracle, therefore you may expect an even much better support to MySQL Workbench from Oracle later.

Author Comment

ID: 39539597
I just installed SQL Server 2012 so is there anyway I can download something that will allow me to access my oracle databases so i only have to use one client for all my db?
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

LVL 74

Accepted Solution

sdstuber earned 2000 total points
ID: 39539607
if by "client" you mean the software libraries needed for communication then the first post above has what you're looking for

if by "client" you mean a user friendly interface then try oracle's SQL Developer


it is free and regularly updated, it does require java, but can be downloaded with a java bundle if you don't have an up-to-date instalation

another option is SQUIRREL, which supports any database you can connect to with jdbc

LVL 38

Expert Comment

by:Geert G
ID: 39539618
fwiw, sql developer is part of the oracle client installation now

"one client (or front-end gui) for all databases" is ... a myth

every database has it's own peculiarities which a client takes advantage (or disadvantage) of
LVL 74

Expert Comment

ID: 39539635
sql developer is part of the oracle client installation now

if you have the full client, not with the instant client,  however, the link you provided does go to the full client.

The bundled client is often several versions behind though, so, even if you get SQL Developer with your client bundle, you'll probably want to download a new version anyway
LVL 38

Expert Comment

by:Geert G
ID: 39539676
Sean, thanks for putting the dots on the i

if you install the runtime option from the link you have 95% of what you need for oracle

if you run the Universal installer, custom and add the odbc to it, even excel should be able to link to the db

however ...
you'll need at least the tnsnames.ora file or the location of it from your dba to make connection to the db
if you have setup the database yourself (like XE edition), check the network/admin folder where you installed it

and off course a user and password for it

Featured Post

7 new features that'll make your work life better

It’s our mission to create a product that solves the huge challenges you face at work every day. In case you missed it, here are 7 delightful things we've added recently to monday to make it even more awesome.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question