Link to home
Start Free TrialLog in
Avatar of diteps06
diteps06Flag for United States of America

asked on

Link to download Oracle client 9i for a 64-bit machine

Does anyone knows of a reliable link to download Oracle client 9i for a 64-bit machine with OS Windows 7.  The version in my possession have compatibility problems when I try to install it.
Checked the Oracle official site without much success
ASKER CERTIFIED SOLUTION
Avatar of OP_Zaharin
OP_Zaharin
Flag of Malaysia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of diteps06

ASKER

Installing Oracle 10.2.0.5 will it be able to connect to an Oracle 9i db
- what the actual version of your database? 
: with 9.0.1 database, you can only use 10.1 client. 
: with 9.2.0 database, you can use 10.1.0, 10.2.0 and 11.1.0 client. bare in mind that there might be fixes that you need to get from Oracle support on certain issues that might arrise when using it.

: download the x86-64 bit version here:
http://www.oracle.com/technetwork/topics/winx64soft-089540.html
- i would recommend you to download the instant client Basic Package and ODBC/SQL Package (if you use ODBC). extract both package file to the same directory.  as for the ODBC package, you will need to run the installer after extracted the file.

- next setup the following. assuming that you extract it to c:\OracleInstantClient:

1- setting up the path variables:
- right-click on My Computer/Computer icon. choose "Properties". in the windows that pop-up, click the "Advanced" tab.  Next, click the button "Environment Variables". on the "System Variable" click "Edit" button and add this to PATH:
PATH=<there will be other path here>;c:\OracleInstantClient;

- then add TNS_ADMIN to the system variable: TNS_ADMIN=c:\OracleInstantClient\Network\ADMIN

2- copy tnsnames.ora from your database server and paste it in c:\OracleInstantClient\Network\ADMIN 

- i hope this links helps you to setting up instant client:
http://164.100.150.68/downloads/oracle/README.doc
http://thetendjee.wordpress.com/2006/08/11/oracle-10g-instant-client-hard-to-make-it-work/
What are the advantages of using  instant client Basic Package
- simply because its the only oracle client installer that we can download? ;)

- its actually a lite version that install very quick than the nomal client installer that enables you to connect to Oracle database. it comes in few packages whereby the basic is the one you must install first then use the odbc, jdbc, sqlplus and other packages. so you can choose to download and use only if you need the other packages.

- with instant client, you can bundled it in your application installer
"simply because its the only oracle client installer that we can download?"

- i type too fast, sorry about that. if you need a full client install, its available here for Oracle 10g (but look at the total file size compared to instant client basic):
http://www.oracle.com/technetwork/database/10204-winx64-vista-win2k8-082253.html