举报
2017-09-30 09:21
oracle禁用操作系统认证方式登陆: 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) ---- 注: 若有此文件,默认的是 SQLNET.AUTHENTICATION_SERVICES = (NTS), 此时,只要在其前面增加一个#, 注释掉此行,就可以了 范例: C:\>sqlplus /nolog SQL*Plus: Release 10.2.0.3.0 - Production on 星期四 5月 6 10:30:43 2010 Copyright (c) 1982, 2006, Oracle. All Rights Reserved. SQL> conn / as sydsba SP2-0306: 选项无效。 用法: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] 其中 ::= [/
][@] | / SQL> conn sys/password as sysdba 已连接。
以上是我对于这个问题的解答,希望能够帮到大家。
|