環境：Oracle 11.2.0.3

客戶端使用錯誤的用戶密碼登陸數據庫

查詢最近1天由于密碼錯誤登陸失敗的信息

查詢當前審計中有哪些returncode值

1. 客戶端使用錯誤的用戶密碼登陸數據庫

PS C:\Users\Administrator> sqlplus jingyu/ludan@jingyuSQL*Plus: Release 11.2.0.1.0 Production on 星期一 9月 7 11:28:08 2015Copyright (c) 1982, 2010, Oracle. All rights reserved.ERROR: ORA-01017: invalid username/password; logon denied

2. 查詢最近1天由于密碼錯誤登陸失敗的信息

select sessionid, userid, userhost, comment$text, spare1, ntimestamp#from aud$where returncode = 1017and ntimestamp# > sysdate - 1;

查詢結果如下：

22479 JINGYU WORKGROUP\WIN-3KBILBGK27B Authenticated by: DATABASE; Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.99.12)(PORT=49843)) Administrator 07-SEP-15 03.28.05.293986 AM

可以根據查詢結果定位到是哪臺機器使用錯誤的用戶密碼嘗試登陸數據庫。

3. 查詢當前審計中有哪些returncode值

SQL> select distinct returncode from aud$;RETURNCODE ----------2002101719201005028009280007 rows selected

查詢這些值對應的相關錯誤信息：

[oracle@JY-DB01 u01]$ oerr ora 28009 28009, 00000, "connection as SYS should be as SYSDBA or SYSOPER" // *Cause: connect SYS/<password> is no longer a valid syntax // *Action: Try connect SYS/<password> as SYSDBA or // connect SYS/<password> as SYSOPER // [oracle@JY-DB01 u01]$ oerr ora 28000 28000, 00000, "the account is locked" // *Cause: The user has entered wrong password consequently for maximum // number of times specified by the user's profile parameter // FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account // *Action: Wait for PASSWORD_LOCK_TIME or contact DBA [oracle@JY-DB01 u01]$ oerr ora 1017 01017, 00000, "invalid username/password; logon denied" // *Cause: // *Action: [oracle@JY-DB01 u01]$ oerr ora 1920 01920, 00000, "user name '%s' conflicts with another user or role name" // *Cause: There is already a user or role with that name. // *Action: Specify a different user name. [oracle@JY-DB01 u01]$ oerr ora 1005 01005, 00000, "null password given; logon denied" // *Cause: // *Action: [oracle@JY-DB01 u01]$ oerr ora 2002 02002, 00000, "error while writing to audit trail" // *Cause: // *Action:

總結

以上是生活随笔為你收集整理的aud$定位错误用户密码登陆数据库的具体信息的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。