instant client 的配置

instant client 的配置

oracle server developer自带了客户端

解压目录：D:\Toolkit\instantclient_11_2

设置环境变量

Ø  在Path变量中加入：D:\Toolkit\instantclient_11_2

Ø  NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

Ø  ORACLE_HOME=D:\Toolkit\instantclient_11_2

可以省略变量：

Ø  TNS_ADMIN=D:\Toolkit\instantclient_11_2

n  默认目录为%ORACLE_HOME%\network\admin

SQL_PATH=D:\Toolkit\instantclient_11_2

LD_LIBRARY_PATH=D:\Toolkit\instantclient_11_2

tnsnames.ora与sqlnet.ora

一般不需要，但个别软件会认这些文件，碰到了再添加这些文件不迟。

tnsnames.ora示例

ORACLR_CONNECTION_DATA =

 (DESCRIPTION =

   (ADDRESS_LIST =

     (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

   (CONNECT_DATA =

     (SID = CLRExtProc)

     (PRESENTATION = RO)

    )

  )

 

ORCL =

 (DESCRIPTION =

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

   (CONNECT_DATA =

     (SERVER = DEDICATED)

     (SERVICE_NAME = orcl)

    )

  )

sqlnet.ora示例

# 这是安装客户端验证配置，在即时客户端上会报“ORA-12638: 身份证明检索失败的解决方法”错误。

#SQLNET.AUTHENTICATION_SERVICES= (NTS)

 

# 即时客户端的验证配置：

SQLNET.AUTHENTICATION_SERVICES= (NONE)

 

NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

转载于:https://www.cnblogs.com/Tty725/p/8918546.html