Shulou(Shulou.com)06/01 Report--

How to change the Oracle11g user password and not case-sensitive, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

Connect to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-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 TRUE

SQL > ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE

The system has changed.

SQL > show parameter sec_case_sensitive_logon

NAME TYPE VALUE

-

Connect to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-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 TRUE

SQL > ALTER SYSTEM SET SEC_CASE_SENSITIVE_LOGON = FALSE

The system has changed.

SQL > show parameter sec_case_sensitive_logon

NAME TYPE VALUE

-

Sec_case_sensitive_logon boolean FALSE

SQL > boolean FALSE

When the parameter "sec_case_sensitive_logon" is false, 11g is not case-sensitive.

In contrast, 10g is case-insensitive.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.