時間：2015-06-28 00:00:00 來源：IT貓撲網(wǎng) 作者：網(wǎng)管聯(lián)盟 我要評論(1)
oracle禁用操作系統(tǒng)認證方式登陸:
WINDWOS 平臺:
到oracle的安裝目錄下 cd %ORACLE_Home%/admin目錄下,找到一個sqlnet.ora的文件(若沒有，可以手工創(chuàng)建)
編輯以下內(nèi)容:
# 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/admin目錄下:
查看是否有sqlnet.ora文件，若沒有手工創(chuàng)建,
[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內(nèi)容,增加紅色內(nèi)容;
增加好后，測試結(jié)果如下:
[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.
關鍵詞標簽：oracle,操作系統(tǒng)
相關閱讀
熱門文章
Oracle中使用alter table來增加,刪除,修改列的語法
oracle中使用SQL語句修改字段類型-oracle修改SQL語句案例
誤刪Oracle數(shù)據(jù)庫實例的控制文件
為UNIX服務器設置Oracle全文檢索
人氣排行 oracle中使用SQL語句修改字段類型-oracle修改SQL語句案例 Oracle中使用alter table來增加,刪除,修改列的語法 ORACLE SQL 判斷字符串是否為數(shù)字的語句 ORACLE和SQL語法區(qū)別歸納(1) oracle grant 授權(quán)語句 ORACLE修改IP地址后如何能夠使用 如何加速Oracle大批量數(shù)據(jù)處理 Oracle刪除表的幾種方法