Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to install Oracle Instant CLient Basic + ODBC

Posted on 2011-05-02
11
Medium Priority
?
8,733 Views
Last Modified: 2012-05-11
Sorry totally new to Oracle, downloaded the Windows 64bit Oracle Instant Client + ODBC for WIndows 7.

How do you install the Instant Client and how do you configure so that it will connect to an Oracle Database.

Any reference will help Thanks.
0
Comment
Question by:hongning2009
  • 6
  • 5
11 Comments
 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 35509681
- the basic instantclient does not comes with an installer (but i'm not sure about the ODBC package). you only need to extract it for eg to c:\Oracle_InstantClient

- next you need to add the following to the environment variables:
PATH=c:\Oracle_InstantClient;%PATH%
TNS_ADMIN=c:\Oracle_InstantClient
SQLPATH=c:\Oracle_InstantClient
LD_LIBRARY_PATH=c:\Oracle_InstantClient

- then copy the tnsnames.ora file from your database server into the client machine  c:\Oracle_InstantClient\TNS_ADMIN folder. you need to create the TNS_ADMIN folder

- then setup the ODBC using the Data Sources from the Administrative tool
0
 

Author Comment

by:hongning2009
ID: 35513727
Thanks, I will try that,  One more question we have Oracle 10g,  just to be sure I downloaded from

http://www.oracle.com/technetwork/topics/winx64soft-089540.html

the

Version 11.2.0.2.0

is this correct version Is should use or should I download

Version 10.2.0.5

Thanks a lot
0
 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 35513854
- check you database version then check the instant client compatibility matrix below. basically the latest  instant client version support older database but some version requires fixes via oracle support (must have contract with oracle):

http://blog.whitehorses.nl/2010/02/19/database-version-compatibility-and-support-matrix/
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:hongning2009
ID: 35513858
I did your instructions and run the odbc_install there was no error, but I cannot fijnd the odbc drivers when I run odbcad32->Add

Any ideas?
0
 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 35513942
- are you installing DSN for 32bit or 64bit application?
if 32bit run from c:\windows\syswow62\odbcad32.exe
if 64bit run from c:\windows\system32\odbcad32.exe
0
 

Author Comment

by:hongning2009
ID: 35514003
I did both I did not see the new ODBC driver, although I will be accessing the using 32 bit and I did

c:\windows\syswow64\odbcad32.exe

In our the XP client after the add I usually see

Oracle in OraDB10g_home1

but here what I saw is Microsoft ODBC for Oracle which says I need to install Oracle components
0
 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 35514098
lets do some check:
- check that you download the right instant client version - check the compatibility matrix
- check that you add the variables in ID 35509681 above on SYSTEM (not user) environment variables
- both basic and odbc package is to be extract in the same directory then run the odbc_install
0
 
LVL 23

Accepted Solution

by:
OP_Zaharin earned 2000 total points
ID: 35514297
- even if you were running Windows 7 64bit, I would recommend you download the the Oracle 11 32bit ODBC client (it work fine on 64bit machine).
0
 

Author Comment

by:hongning2009
ID: 35514633

Thanks for the answer let me try the 64 bit one last time

With regards to environment variables, I had the SQLPath and LD_Library in user environment variables, I deleted and moved to System.  I am not sure how it got there as I press new in the System variables.

However it still did not work.

With regards to version I  downloaded the Windows 64 Version 11.2.0.2.0

I downloaded from this link

http://www.oracle.com/technetwork/topics/winx64soft-089540.html

All the files is in extracted in the following directory

C:\Oracle_InstantClient\instantclient_11_2

The  tnsnames.ora file is in

C:\Oracle_InstantClient\TNS_ADMIN

When I tried to run odbc_uninstall I got

Some problem occured while deleting the registry key.

When I tried running again the odbc_install I got

Oracle ODBC Driver with same name already exists.

If you do not see any problems I will try the 32 bit version although I am not sure how to fix the odbc_uninstall option

Thanks again





0
 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 35514788
- create the tns_admin in C:\Oracle_InstantClient\instantclient_11_2 folder
- i would suggest you to read the Instant client release notes. look for your version:

http://www.oracle.com/technetwork/database/features/oci/odbc-ic-releasenotes-094306.html
0
 

Author Comment

by:hongning2009
ID: 35515567
Success!  The 32 bit version worked after the odbc_install

 However some corrections on variable path should be

TNS_ADMIN=C:\Oracle_InstantClient\instantclient_11_2\TNS_ADMIN

Its working perfectly Thank you very much
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
Unable to change the program that handles the scan event from a network attached Canon/Brother printer/scanner. This means you'll always have to choose which program handles this action, e.g. ControlCenter4 (in the case of a Brother).
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…
This Micro Tutorial will teach you how to the overview of Microsoft Security Essentials. This is a free anti-virus software that guards your PC against viruses, spyware, worms, and other malicious software. This will be demonstrated using Windows…
Suggested Courses

564 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