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

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
已连接。
SQL>

 

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)

以上黑体字部分为默认的sqlnet.ora内容,增加红色内容;

增加好后，测试结果如下:

[oracle@rh4-db2 admin]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed May 5 10:17:51 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn / as sysdba
ERROR:
ORA-01031: insufficient privileges

SQL> conn sys/password as sysdba
Connected.
SQL>

-----------

 

SQLNET.AUTHENTICATION_SERVICES
SQLNET.AUTHENTICATION_SERVICES = (method [,method...])

method := {NONE | ALL | BEQ | NDS | NTS | KERBEROS5 | SECURID | CYBERSAFE | IDENTIX | DCEGSSAPI | RADIUS}
The SQLNET.AUTHENTICATION_SERVICES parameter enables Net8 support for various services used to authenticate users when they log in to a database. Note that this parameter just enables the various methods; it does not select the method to be used for a given connection. The default value for this parameter is NONE.

Parameters

NONE - No special authentication is performed. Users log in using their usernames and passwords.
ALL - Enable all the authentication methods.
BEQ - Enable the BEQ authentication method.
CYBERSAFE - Allows users to be authenticated using CyberSafe.
DCEGSSAPI - Allows users to be authenticated using DCE GSSAPI.
IDENTIX - Allows users to be authenticated using Identix.
KERBEROS5 - Allows users to be authenticated using Kerberos.
NDS - Allows users to be authenticated using Netware Directory Services.
NTS - Allows users to be authenticated using Windows Native security.
RADIUS - Allows users to be authenticated using RADIUS.
SECURID - Allows users to be authenticated using SecureID.
TCPS - Allows users to be authenticated using SSL.