Tuesday, June 3, 2008

Oracle 11g Password CaSe SEnsiTivE

Now Oracle 11g Database password is Case Sensitive.
C:\Users\ian>sqlplus CHEST/norma@m SQL*Plus: Release 11.1.0.6.0 - Production on Mon Mar 10 22:56:47 2008 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL> exit Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Pr oduction With the Partitioning, OLAP, Data Mining and Real Application Testing options C:\Users\ian>sqlplus CHEST/NORMA@m SQL*Plus: Release 11.1.0.6.0 - Production on Mon Mar 10 22:56:59 2008 Copyright (c) 1982, 2007, Oracle. All rights reserved. ERROR: ORA-01017: invalid username/password; logon deniedhttp://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:708040800346734217And in oracle 10g
C:\>sqlplus scott/tigerSQL*Plus: Release 10.1.0.5.0 - Production on Sun Mar 23 10:12:46 2008Copyright (c) 1982, 2005, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - ProductionWith the Partitioning, OLAP and Data Mining optionsSQL> conn scott/TIGERConnected.How can disable password case sensitive option in oracle 11g
In 11g there is one password for enable / disable password case sensitive option.sec_case_sensitive_logonhttp://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams211.htm#REFRN10299

No comments: