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

您当前所在位置：IT猫扑网 > 数据库 > Oracle > oracle禁用操作系统认证方式登陆

oracle禁用操作系统认证方式登陆 时间：2015-06-28 00:00 来源：IT猫扑网|http://www.itmop.com/ 作者：网管联盟 我要评论(0)

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

　　WINDWOS 平台:

　　到oracle的安装目录下 cd %ORACLE_Home%/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

　　SQL> conn / as sydsba

　　SP2-0306: 选项无效。

　　用法: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}]

　　其中 <logon> ::= <username>[/<password>][@<connect_identifier>] | /

　　SQL> conn sys/password as sysdba

　　已连接。

　　SQL>

　　LINUX平台:

　　到cd $ORACLE_HOME/admin目录下:

　　查看是否有sqlnet.ora文件，若没有手工创建,

　　[oracle@rh4-db2 admin]$ more sqlnet.ora

　　# sqlnet.ora Network Configuration File: /ora10g/product/10.2.0/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

　　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.