Oracle 11g sets the user password to be case sensitive, oracle11g

Oracle 11g sets the user password to be case sensitive, 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.

A heartbeat error occurred while installing oracle 11g. The password management interface was skipped and no password was set, causing login failure.

You can log on to the database using the operating system authentication method, and then use the command to change the password. The method is as follows: open a command prompt (Start Menu -- run -- "cmd ")
Sqlplus "/as sysdba"
SQL> alter user sys identified by xxxx;