Brief Analysis on the Impact of prompt about Password Expiration

Brief Analysis of the Impact of prompt about Password Expiration when a user's password is about to expire, Oracle will prompt ORA-28002 error at login, but does not affect normal login. I didn't think this information would have a big impact, but I didn't expect this error to cause the set autotrace function to fail: solaris * orcl-/home/oracle $ sqlplus test/test www.2cto.com SQL * Plus: release 11.2.0.3.0 Production on Fri Jul 13 11:27:28 2012 Copyright (c) 1982,201 1, Oracle. tb All rights reserved. ERROR: ORA-28002: the password will expire within 1 days Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Partitioning, Oracle Label Security and Real Application Testing options SQL> set autot onERROR: ORA-28002: the password will expire within 1 days SP2-0619: Error while connectingSP2-0611: error enabling STATISTICS reportSQL> alter user test identified by test; User altered. SQL> set autot onERROR: ORA-24315: illegal attribute type SP2-0619: Error while connectingSP2-0611: Error enabling STATISTICS reportSQL> exi T www.2cto.com Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Partitioning, oracle Label Security and Real Application Testing optionssolaris * orcl-/home/oracle $ sqlplus test/test SQL * Plus: Release 11.2.0.3.0 Production on Fri Jul 13 11:27:52 2012 Copyright (c) 1982,201 1, oracle. all rights reserved. connected to: Oracle Database 11g memory is E Edition Release 11.2.0.3.0-64bit ProductionWith the Partitioning, Oracle Label Security and Real Application Testing options SQL> set autot onSQL> insert into t values (1, 'A'); 1 row created. execution Plan Execution ------------ | Id | Operation | Name | Rows | Bytes | Cost (% CP U) | Time | --------------------------------------------------------------------------------- | 0 | insert statement | 1 | 12 | tb 1 (0) | 00:00:01 | 1 | load table conventional | T | www.2cto.com Statistics limit 71 recursive cballs 9 db block gets 75 consiste Nt gets 10 physical reads 1284 redo size 829 bytes sent via SQL * Net to client 785 bytes encoded ed via SQL * Net from client 3 SQL * Net roundtrips to/from client 9 sorts (memory) 0 sorts (disk) 1 rows processed apparently encountered an error when the set autotrace on feature was enabled due to a ORA-28002 error. When the current user password is modified, the function of set autotrace on becomes normal when the ORA-28002 no longer appears. Based ON the above information, it can be determined that when the set autotrace on function is enabled, sqlplus will automatically create a new session to record the statistics of the current session. The new session is enabled using the password saved when the current session is logged on. Therefore, you can use the following example to verify this inference: solaris * orcl-/home/oracle $ sqlplus test/test SQL * Plus: Release 11.2.0.3.0 Production on Sun Jul 15 01:28:38 2012 Copyright (c) 1982,201 1, Oracle. all rights reserved. connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionWith the Partitioning, Oracle Label Security and Real Application Testing options www.2cto.com SQL> set autot onSQL> set autot offSQL> alter user test identified by test1; User altered. SQL> set autot onERROR: ORA-01017: invalid username/password; logon denied SP2-0619: Error while connectingSP2-0611: Error enabling STATISTICS report indeed, if the current password is modified after the user logs on, this will cause incorrect username and password when set autotrace on is enabled.