Oracle 11g Set User Password case sensitivity test, oracle11g

Oracle 11g Set User Password case sensitivity test, oracle11g

The 11g password is case sensitive by setting a parameter. The following is an experiment:

C: \ Documents and Settings \ guogang> sqlplus gg_test/gg_test@10.10.15.25 _ gg
SQL * Plus: Release 10.2.0.1.0-Production on Monday August 4 17:54:19 2014
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Connect:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select * from v $ version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
PL/SQL Release 11.2.0.1.0-Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0-Production
NLSRTL Version 11.2.0.1.0-Production
SQL> show parameter sec_case_sensitive_logon
NAME TYPE VALUE
-----------------------------------------------------------------------------
Sec_case_sensitive_logon boolean TRUE

C: \ Documents and Settings \ guogang> sqlplus gg_test/gg_tesT@10.10.15.25 _ gg
SQL * Plus: Release 10.2.0.1.0-Production on Monday August 4 17:54:06 2014
Copyright (c) 1982,200 5, Oracle. All rights reserved.
ERROR:
ORA-01017: invalid username/password; logon denied
Enter the User Name:

C: \ Documents and Settings \ guogang> sqlplus gg_test/gg_test@10.10.15.25 _ gg
SQL * Plus: Release 10.2.0.1.0-Production on Monday August 4 17:52:35 2014
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Connect:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter system set sec_case_sensitive_logon = false;
The system has been changed.

SQL> from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options disconnected

C: \ Documents and Settings \ guogang> sqlplus gg_test/gg_tesT@10.10.15.25 _ gg
SQL * Plus: Release 10.2.0.1.0-Production on Monday August 4 17:53:48 2014
Copyright (c) 1982,200 5, Oracle. All rights reserved.
Connect:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> show parameter sec_case_sensitive_logon
NAME TYPE VALUE
-----------------------------------------------------------------------------
Sec_case_sensitive_logon boolean FALSE

Oracle 11g logon Password

Possible causes include:
1. If you log on as a sys user, select as sysdba as the connection identity]
NOTE: If your sys user password is not modified during installation, the default password is:
[Change_on_install ].
If you forget it, You can reset it as follows:
1) Go to cmd
2) sqlplus/as sysdba
3) alter user sys identified by new password;

2. If you have created a new normal user login, please confirm the user name and password again. If it is not confirmed, use the sqlplus tool to recreate a user and try again as follows

1) Go to cmd
2) sqlplus/as sysdba or sqlplus sys/password as sysdba
3) create user username identified by password;
4) grant connect, resource to user name;
5) conn user name/Password
Note: If the connection is successful in step 5th, the user can log on to the system by setting up the connection.

---
The above is helpful to you.

How Does oracle 11g change the password of a user and never expire?

After the image is segmented using exrezssion web 2, there is a small circular hotspot area in a large irregular hotspot area. Currently, only a large hotspot is reflected after running, click the click event in the circular hotspot area that is also a large hotspot Area of the application, and the z attribute cannot be found for the property. Who can help me, or, you can use other methods to solve the multi-hotspot region superposition problem.