ORA-01031 While Connecting As Sysdba On Windows With A Domain User [ID 1071638.1]
Applies to:
Oracle Server - Enterprise Edition - Version: 9.2.0.1 to 11.2.0.2.0 - Release: 9.2 to 11.2Information in this document applies to any platform.
Symptoms
While trying to connect to a database running on Windows using "/ as sysdba" from an OS session started as a domain user the following error occurs:sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on M Mar 8 17:22:36 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
ERROR:
ORA-1031: Insufficient privileges.
The domain user is a direct member of the local ORA_DBA group. If the Oracle Service is started as a domain user and not as Local System Account then the OS authentication will work for any user.
Cause
The settings of Active Directory are not allowing any user to read the MemberOf attribute of the domain user. The inability to read the MemberOf attribute of a domain user prevents Oracle from determining what groups that user belongs to. Oracle is not able to read the attributes of the domain user as long as it's service is started as Local System Account.Solution
Discuss with the System Administrators and change the AD settings so that all the members of the Authenticated Users group(dynamically evaluated for membership) will be able to read the MemberOf attribute of any domain user.References
- CANNOT USE OS AUTHENTICATION AS SYSDBA FOR A DOMAIN USER: ORA-1031- WIN: OS Authentication - CONNECT AS SYSDBA Without a Password
[@more@]
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/161195/viewspace-1054820/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 再談ORA-01031 when sqlplus '/as sysdba'SQL
- ORA-600[13013] Error While Creating a User. [ID 297595.1]ErrorWhile
- sqlplus / as sysdba登入提示ORA-01031: 許可權不足SQL
- 系統中的User角色和Domain的說法AI
- Oracle 12C ORA-12545 While Connecting to RAC through SCAN NameOracleWhile
- 在windows上以sysdba登陸oracleWindowsOracle
- windows 下用 as sysdba登陸報錯Windows
- sqlplus / as sysdba報錯ORA-01031: insufficient privileges的原因分析SQL
- conn / as sysdba 出現ORA-01031: insufficient privileges 解決辦法
- AD中如何檢視一個Domain User對一個Domain Group具備哪些許可權AI
- sqlplus / as sysdba 提示許可權不足(ORA-01031)問題處理SQL
- SYSDBA and SYSOPER Privileges in Oracle [ID 50507.1]Oracle
- sqlplus "/ as sysdba" 連不上,報ora-01031:insufficient privileges解決方法SQL
- Oracle所有者不是dba 引起sqlplus / as sysdba 登入報錯ORA-01031OracleSQL
- SQL> conn sys/sys@vm_sigle as sysdba; 報ORA-01031: insufficient privileges錯誤SQL
- Video教程的Domain設計IDEAI
- Hide the User MenuIDE
- Oracle 軟體克隆後sysdba登入提示沒有許可權ora-01031: insufficient privilegesOracle
- sys使用者用sysdba許可權連線時報ORA-01031問題解決方法
- sqlplus / as sysdba 登入報許可權不足 for windowsSQLWindows
- job中呼叫儲存過程,儲存過程使用AUTHID CURRENT_USER,還出現ORA-01031儲存過程
- Connecting to Nomounted databaseDatabase
- Connecting to the MySQL ServerMySqlServer
- linux環境下sqlplus sys/sys@ORCL as sysdba報錯 ORA-01031: insufficient privilegesLinuxSQL
- [絕對原創] SAP Get User data by User ID
- How to rebuild and replicate the SYSVOL tree and its content in a Windows domainRebuildWindowsAI
- Forgot Password for user id SAP*Go
- sysdbaでログイン失敗、ORA-01031 権限が不足が出たの解決方案
- Hide RMAN Passwords when Connecting to a Target Database (Doc ID 183377.1)IDEDatabase
- MyBatis-maven-User例子-根據id查詢UserMyBatisMaven
- Oracle SYSDBA稽核Oracle
- PRVF-4007 : User equivalence check failed for user "grid"UIAI
- 2.4、User’s guide (Coroutines)GUIIDE
- 獲取 Windows Phone 的 User-Agent 字串Windows字串
- HANGFG User Guide (Doc ID 362094.1)GUIIDE
- Connecting Oracle with MS-AccessOracle
- 域名(domain)AI
- eminent domainAI