通过设置 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_DOMAIN\ORACLE$, term: ORACLE, ospid: 3980: 1320 Machine: TEST_DOMAIN\ORACLE$ 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)