oracle禁用操作系统认证方式登陆解析

2014-11-24 08:16:36 · 作者: · 浏览: 3

WINDWOS 平台:
  到oracle的安装目录下 cd %ORACLE_Home%/network/admin目录下,找到一个sqlnet.ora的文件(若没有,可以手工创建)
  编辑以下内容:
  # This file is actually generated by netca. But if customers choose to
  # install "Software Only", this file wont exist and without the native
  # authentication, they will not be able to connect to the database on NT.
  #SQLNET.AUTHENTICATION_SERVICES = (NTS)
  ----
  注: 若有此文件,默认-www.2cto.com-的是 SQLNET.AUTHENTICATION_SERVICES = (NTS), 此时,只要在其前面增加一个#,
  注释掉此行,就可以了
LINUX平台:
  到cd $ORACLE_HOME/network/admin目录下:
  查看是否有sqlnet.ora文件,若没有手工创建,
  [oracle@rh4-db2 admin]$ more sqlnet.ora
  # sqlnet.ora Network Configuration File: /ora10g/product/10.2.0/network/admin/sqlnet.ora
  # Generated by Oracle configuration tools.
  NAMES.DIRECTORY_PATH= (TNSNAMES)
  sqlnet.authentication_services=(none)
作者 coollifer