Home >Database >Mysql Tutorial >ORACLE 简易客户端配置

ORACLE 简易客户端配置

WBOY
WBOYOriginal
2016-06-07 15:13:441069browse

欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入 1、从 ORACLE 下载客户端的简易包,加压缩到磁盘上的任意目录,例如 E:\Utility\Oracle\Win32 2、将该路径增加到系统环境变量 PATH 中,然后将下面的注册表文件导入到注册表中 Windows Registry Edi

欢迎进入Oracle社区论坛,与200万技术人员互动交流 >>进入

  1、从 ORACLE 下载客户端的简易包,加压缩到磁盘上的任意目录,例如 E:\Utility\Oracle\Win32

  2、将该路径增加到系统环境变量 PATH 中,然后将下面的注册表文件导入到注册表中

  Windows Registry Editor Version 5.00

  [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\ORACLE]

  "NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

  "TNS_ADMIN"="E:\\Utility\\Oracle"

  [HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE]

  "NLS_LANG"="SIMPLIFIED CHINESE_CHINA.ZHS16GBK"

  "TNS_ADMIN"="E:\\Utility\\Oracle"

  3、在 E:\Utility\Oracle 目录下增加 tnsnames.ora 文件,文件内容如下所示:

  DB_CENTER =

  (DESCRIPTION =

  (ADDRESS_LIST =

  (ADDRESS = (PROTOCOL = TCP)(HOST = DB_SERVER)(PORT = 1521))

  )

  (CONNECT_DATA =

  (SERVICE_NAME = DB_CENTER)

  )

  )

  4、使用 P/L SQL Developer 工具即可正常访问

ORACLE 简易客户端配置

Statement:
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