Home > Database > Mysql Tutorial > 配置Oracle10g即时客户端plsql的配置

配置Oracle10g即时客户端plsql的配置

WBOY
Release: 2016-06-07 15:38:58
Original
1188 people have browsed it

Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications instantclient-basic-win32-10.2.0.1-20050930.zip (34,390,521 bytes) *Instant Client Package - Basic Lite: Smaller version of the Basic, with only

Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications
 
instantclient-basic-win32-10.2.0.1-20050930.zip (34,390,521 bytes)

*Instant Client Package - Basic Lite: Smaller version of the Basic, with only English error messages and Unicode, ASCII, and Western European character set support (10.2 only)(和上面那个文件相比这个在文字方面的支持只限于西欧文字,对于中文就不支持了,所以如果数据库的字符集为中文的话最好用第一个)
 
instantclient-basiclite-win32-10.2.0.1-20050930.zip (10,373,186 bytes)

*Instant Client Package - JDBC Supplement: Additional support for XA, Internationalization, and RowSet operations under JDBC
 
instantclient-jdbc-win32-10.2.0.1-20050930.zip (1,469,840 bytes)

*Instant Client Package - SQL*Plus: Additional libraries and executable for running SQL*Plus with Instant Client
instantclient-sqlplus-win32-10.2.0.1-20050930.zip (720,691 bytes)

*Instant Client Package - SDK: Additional header files and an example makefile for developing Oracle applications with Instant Client
instantclient-sdk-win32-10.2.0.1-20050930.zip (823,201 bytes)

*Instant Client Package - ODBC: Additional libraries for enabling ODBC applications
instantclient-odbc-win32-10.2.0.1-20050930.zip (718,159 bytes)


一般情况只要下载第一个就可以了,如果你要用sqlplus你也可以下载这个软件包
 

安装步骤:

1. 为您的平台下载相应的即时客户端程序包。所有的安装都要求 Basic 或 Basic Lite 程序包。

2. 将程序包解压缩到单个目录,如“c:\instantclient”。

3. 配置环境变量
将 c:\instantclient 添加到 PATH 中(位于其他 Oracle 目录之前)。

例如,在 Windows 2000 上,依次单击“开始”->“设置”->“控制面板”->“系统”->“高级”->“环境变量”,编辑系统变量列表中的 PATH。

如果使用了 tnsnames.ora 文件定义的 Oracle Net 服务名称,则将 tnsnames.ora 复制到 c:\instantclient,并添加用户环境变量 TNS_ADMIN 设置为你的解压目录如 c:\instantclient。(也可以在用户环境变量 LOCAL 中定义默认的服务名称。 )
设置必要的 Oracle 全球化语言环境变量, NLS_LANG           中文对应的字符集是
SIMPLIFIED CHINESE_CHINA.ZHS16GBK

一共设置以下三个环境变量(以解压缩目录c:\instantclient为例)
环境变量名                              变量值
path                                            c:\instantclient
TNS_ADMIN                            c:\instantclient
NLS_LANG                              SIMPLIFIED CHINESE_CHINA.ZHS16GBK

4.将tnsnames.ora从服务器或其他地方拷贝过来,或者建立一个文本文档将以下内容拷贝到你的文件里面
修改其中红色的部分为你自己的配置,存盘后再改名为tnsnames.ora

localdb =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = mysid)
    )
  )


5. 启动您的应用程序并开始使用。
例如启动sqlplus为

 c:\instantclient\sqlplus system/manager@localdb





5、Oracle ODBC 的安装

c:\instantclient\odbc_install
或者
c:\instantclient\odbc_install  ZHS




至此客户端就配置完了。

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template