Installing Oracle Instant Client

Question

I can t seem to figure out how to install the Oracle client on Windows Server 2008   I downloaded x64 version  the first file on the list  here  There are installation instructions on the bottom of that page    Step 2   instantclient    Which executable should I run

User · Answer

Try SQLDeveloper - there is a migration workbench there  http   www oracle com technetwork developer-tools sql-developer overview index html

User · Answer

I was able to setup Oracle Instant Client  Basic  11g2 and Oracle ODBC  32bit  drivers on my 32bit Windows 7 PC   Note  you ll need a  tnsnames ora  file because it doesn t come with one   You can Google examples and copy paste into a text file  change the parameters for your environment   Setting up Oracle Instant Client-Basic 11g2  Win7 32-bit   I think there s another step or two if your using 64-bit   Oracle Instant Client     Unzip Oracle Instant Client - Basic   Put contents in folder like  C  instantclient      Edit PATH evironment variable  add path to Instant Client folder to the Variable Value    Add new Variable called  TNS ADMIN   point to same folder as Instant Client    I had to create a  tnsnames ora  file because it doesn t come with one   Put it in same folder as the client    reboot or use Task Manager to kill  explorer exe  and restart it to refresh the PATH environment variables      ODBC Drivers     Unzip ODBC drivers   Copy all files into same folder as client  C  instantclient    Use command prompt to run  odbc install exe   should say it was successful      Note   The  un-documented  things that were hanging me up where     - All files  Client and Drivers  needed to be in the same folder  nothing in sub-folders    - Running the ODBC driver from the command prompt will allow you to see if it installs successfully  Double-clicking the installer just flashed a box on the screen  no idea it was failing because no error dialog   After you ve done this you should be able to setup a new DSN Data Source using the Oracle ODBC driver  -Hope this helps someone else

User · Answer

The directions state         Download the appropriate Instant Client packages for your platform  All installations REQUIRE the Basic package     Unzip the packages into a single directory such as  instantclient      Set the library loading path in your environment to the directory in Step 2   instantclient    On many UNIX platforms  LD LIBRARY PATH is the appropriate environment variable  On Windows  PATH should be used    Start your application and enjoy       Suggest extracting unzipping into a new directory  They ve suggested instantclient  but you can name the directory anything you like  Name it C  OracleInstantClient  if you choose   Then in Step 3  open a Windows Command Prompt  Type   PATH C  OracleInstantClient   PATH     That s all there is to it

User · Answer

The instantclient works only by defining the folder in the windows PATH environment variable  But you can  install  manually to create some keys in the Windows registry  How   1  Download instantclient  http   www oracle com technetwork topics winsoft-085727 html   2  Unzip the ZIP file  eg c  oracle instantclient     3  Include the above path in the PATH    4  Create the registry key    Windows 32bit   HKEY LOCAL MACHINE SOFTWARE ORACLE   Windows 64bit   HKEY LOCAL MACHINE SOFTWARE Wow6432Node ORACLE    5  In the above registry key  create a sub-key starts with  KEY   followed by the name of the installation you want    Windows 32bit   HKEY LOCAL MACHINE SOFTWARE ORACLE KEY INSTANTCLIENT   Windows 64bit   HKEY LOCAL MACHINE SOFTWARE Wow6432Node ORACLE KEY INSTANTCLIENT    6  Now create at least three string values   in the above key    NLS LANG   BRAZILIAN PORTUGUESE BRAZIL WE8MSWIN1252  complete list here  http   docs oracle com cd B19306 01 install 102 b14317 gblsupp htm  ORACLE HOME   c  oracle instantclient  the same folder in PATH  ORACLE HOME NAME   MY INSTANTCLIENT  choose any name      For those who use Quest SQL Navigator or Quest Toad for Oracle will see that it works  Displays the message  Home is valid       The registry keys are now displayed for selecting the oracle client

User · Answer

If you want to use SQL Server Management Studio  you want to install the full Oracle client  not the Instant Client   The full Oracle client is on the same download page as the Oracle database   Assuming that you are installing on a 64-bit version of Windows  I expect you want the  Oracle Database 11g Release 2 Client  11 2 0 1 0  for Microsoft Windows  x64   download   This is several hundred MB rather than a couple of MB for the Instant Client

[oracle] Installing Oracle Instant Client

Examples related to oracle

Examples related to installation