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 denied
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:708040800346734217
And in oracle 10g
C:\>sqlplus scott/tiger
SQL*Plus: Release 10.1.0.5.0 - Production on Sun Mar 23 10:12:46 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.1.0.5.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> conn scott/TIGER
Connected.
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_logon
http://download.oracle.com/docs/cd/B28359_01/server.111/b28320/initparams211.htm#REFRN10299
No comments:
Post a Comment