通过设置 events '1017 trace name context forever, level 3'; 找到帐号登录失败或者那个帐号被锁住

  背景:开发业务升级,更改了系统密码,由于设定了profile,输错达到阀值后就会被锁。

            但是业务自认为是改了所有程序里的由号密码,但是账号还是因为输错被错。

            通过设置event ,生成trace 文件,可以查看该帐号是由那个主机发起,从而找到程序的设置,而更新密码。

Here is an excerpt from errorstack when you set errorstack by the follow sql:

  SQL> alter system set events '1017 trace name context forever, level 3';

üª In this verification, we build the environment as below.

-------------------------
Domain: TEST_DOMAIN
Machine name: ORACLE
-------------------------

[From errorstack]
==============================================================
   PROCESS STATE
   --------------
   Process global information:
   Process: 0x000007FCAB521BA8, call: 0x000007FCAB8F81A8, xact: 0x0000000000000000, curses: 0x000007FCAB857210, usrses: 0x000007FCAB857210
   In_exception_handler: no
   -----------------------------------------------
   SO: 0x000007FCAB857210, type: 4, owner: 0x000007FCAB521BA8, flag: INIT /-/-/ 0x00 if: 0x3 c: 0x3
   Proc = 0x000007FCAB521BA8, name = session, file = ksu.h LINE: 12729, pg = 0
   (Session) sid: 31 ser: 89 trans: 0x00000000000000000, creator: 0x000007FCAB521BA8
   Flags: (0x41) USR /-flags_idl: (0x1) BSY /-/-/-/-/-
   Flags2: (0x40009)-/-/ INC
   DID:, short-term DID:
   Txn branch: 0x0000000000000000
   Edition #: 0 oct: 0, prv: 0, sql: 0x0000000000000000, psql: 0x000007FCAA6C2FB0, user: 0 / SYS
   Ksuxds FALSE at location: 0
   Service name: SYS $ USERS
   Client details:
   O / S info: user: üÜ TEST_DOMAINORACLE$,  term: ORACLE, ospid: 3980: 1320
   Machine: TEST_DOMAINORACLE$ program: sqlplus.exe
   Application name: sqlplus.exe, hash value = 254292535
   Current Wait Stack:

参考文档: CONN AS SYSDBA FAILS WITH ORA-1017 IF ACTIVE DIRECTORY INSTALLED (文档 ID 2534451.1)

原文地址:https://www.cnblogs.com/cqdba/p/10980340.html