Shulou(Shulou.com)05/31 Report--

This article mainly introduces how to modify the oracle 11G character set, user name case-sensitive, password expiration, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let the editor take you to know about it.

1. Oracle view and modify the oracle character set:

Server side:

Select userenv ('language') from dual

Select * from nls_database_parameters

Oracle modifies the character set:

Connect system as sysdba

Shutdown immediate

Startup mount

Alter system enable restricted session

Alter system set JOB_QUEUE_PROCESSES=0

Alter system set AQ_TM_PROCESSES=0

Alter database open

Alter database character set internal_use ZHS16GBK

Shutdown immediate

Startup

View and modify Oracle character set, view and modify Oracle 10G character set; view and modify Oracle 11G character set

= =

2. Modifying the password of Oracle11g users is not case-sensitive

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 >

3. Password expires

(1) View the user's profile settings:

SELECT username,profile FROM dba_users

The average user's profile setting is DEFAULT.

(2) check the PASSWORD_LIFE_TIME settings in the system profiles:

SELECT * FROM dba_profiles 's WHERE s.profileholders defaULT 'AND resource_name='PASSWORD_LIFE_TIME'

PROFILE RESOURCE_NAME RESOURCE LIMIT

DEFAULT PASSWORD_LIFE_TIME PASSWORD 180dys

(3) modify the setting of PASSWORD_LIFE_TIM in DBA_PROFILES to ULIMITED.

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED

(4) accounts whose passwords are about to expire must change their passwords again (DBA permission is required)

Take system users as an example

[cpp] view plaincopyprint?

Sqlplus / as sysdba

Alter user system identified by root

The password will never expire again when you connect to the data.

If it is another user, then use a different user name.

[cpp] view plaincopyprint?

Alter user scott identified by tiger

Thank you for reading this article carefully. I hope the article "how to modify the oracle 11G character set, user name case sensitivity, password expiration" shared by the editor will be helpful to everyone. At the same time, I hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

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.