安装 Oracle 即时客户端
我似乎不知道如何在 Windows Server 2008 上安装 Oracle 客户端。
我下载了 x64 版本 (列表中的第一个文件）位于此处。该页面底部有安装说明：
步骤 2（“instantclient”）
我应该运行哪个可执行文件？
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?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（5）
Instantclient 仅通过在 Windows PATH 环境变量中定义文件夹来工作。 但您可以手动“安装”以在 Windows 注册表中创建一些项。 如何？
1) 下载 instantclient (http://www.oracle.com/technetwork/topics/winsoft-085727.html">http:// /www.oracle.com/technetwork/topics/winsoft-085727.html)
2) 解压缩 ZIP 文件（例如 c:\oracle\instantclient）。
3) 将上述路径包含在 PATH 中。
4) 创建注册表项：
[HKEY_LOCAL_MACHINE \SOFTWARE\ORACLE][HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE]5) 在上述注册表项中，创建一个以“KEY_”开头的子项，后跟您想要的安装名称：
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_INSTANTCLIENT][HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE\KEY_INSTANTCLIENT]6) 现在在上述键中至少创建三个字符串值：
NLS_LANG = BAZILIAN PORTUGUESE_BRAZIL.WE8MSWIN1252 （此处的完整列表：http://docs.oracle.com/cd/B19306_01/install.102/b14317/gblsupp。 htm)ORACLE_HOME = c:\oracle\instantclient（路径中的同一文件夹）ORACLE_HOME_NAME = MY_INSTANTCLIENT（选择任意名称）对于那些使用 Quest SQL Navigator 或 Quest Toad for Oracle 的人来说，它会起作用。显示消息“Home is valid.”：
现在显示用于选择 Oracle 客户端的注册表项：
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:
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE][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:
[HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_INSTANTCLIENT][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:
我能够在 32 位 Windows 7 PC 上设置 Oracle Instant Client（基本）11g2 和 Oracle ODBC（32 位）驱动程序。注意：您需要一个“tnsnames.ora”文件，因为它没有附带该文件。您可以 Google 示例并复制/粘贴到文本文件中，更改您环境的参数。
设置 Oracle Instant Client-Basic 11g2（Win7 32 位）
（我认为如果您使用 64 位，还需要执行一两个步骤）
Oracle Instant Client
ODBC 驱动程序
注意：“未记录的“那些把我挂在哪里的东西......
- 所有文件（客户端和驱动程序）都需要位于同一文件夹中（子文件夹中没有任何文件）。
- 从命令提示符运行 ODBC 驱动程序将允许您查看它是否安装成功。双击安装程序只是在屏幕上闪烁了一个框，不知道它失败了，因为没有错误对话框。
完成此操作后，您应该能够使用 Oracle ODBC 驱动程序设置新的 DSN 数据源。
-希望这对其他人有帮助。
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
ODBC Drivers
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.
指示指出：
建议提取/解压缩到新目录。他们建议
instantclient，但您可以将目录命名为您喜欢的任何名称。如果您愿意，请将其命名为C:\OracleInstantClient\。然后在步骤 3 中，打开 Windows 命令提示符。类型：
这就是全部了！
The directions state:
Suggest extracting/unzipping into a new directory. They've suggested
instantclient, but you can name the directory anything you like. Name itC:\OracleInstantClient\if you choose.Then in Step 3, open a Windows Command Prompt. Type:
That's all there is to it!
如果要使用 SQL Server Management Studio，则需要安装完整的 Oracle 客户端，而不是即时客户端。完整的 Oracle 客户端位于与 Oracle 数据库相同的下载页面。假设您要在 64 位版本的 Windows 上安装，我希望您需要下载“适用于 Microsoft Windows (x64) 的 Oracle Database 11g Release 2 Client (11.2.0.1.0)”。对于即时客户端来说，这需要几百 MB 而不是几 MB。
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.
尝试 SQLDeveloper - 那里有一个迁移工作台
http:// www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html
Try SQLDeveloper - there is a migration workbench there
http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html