Looking for free oracle client to use to access oracle databases

Hello, I was wondering if someone can link me to a free oracle client that I can use to access oracle databases. Thanks
DancingFighterGAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Geert GOracle dbaCommented:
all the oracle clients are free

like this for oracle 11.2.0.1 32-bit

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html
0
peeaCommented:
try MySQL Workbench.

http://www.oracle.com/us/products/mysql/mysql-workbench-066221.html

FYI - MySQL is now under Oracle, therefore you may expect an even much better support to MySQL Workbench from Oracle later.
0
DancingFighterGAuthor Commented:
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?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

sdstuberCommented:
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

http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

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

http://squirrel-sql.sourceforge.net/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Geert GOracle dbaCommented:
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
0
sdstuberCommented:
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
0
Geert GOracle dbaCommented:
Sean, thanks for putting the dots on the i

>DancingFighterG
if you install the runtime option from the link you have 95% of what you need for oracle
http://download.oracle.com/otn/nt/oracle11g/112010/win32_11gR2_client.zip

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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.