Oracle中的常规帐户操作

查询oracle中的所有用户, 但首先, your account should have dba

permission,如sys , 系统.

选择 * 来自dba_users;

Query all users which you can manage.

选择 * from all_users;

Query details about currnet user.

选择 * 来自user_users;

change system password to 123456.

alter user system identified by 123456;

 

user lock

There is some errors when tomcat connect to oracle.

ORA-28000: the account is locked

This indicate that user had been locked.

 

Sulotion:

的SQL> ALTER USER user ACCOUNT UNLOCK;

User altered.

 

Reason of user lock: The fail times of login is lager than maximum limit.

You can execute the following command to check the maximum login times.

的SQL> select resource_name,limit from dba_profiles where resource_name=’FAILED_LOGIN_ATTEMPTS’;

RESOURCE_NAME LIMIT
——————————– —————————————-

FAILED_LOGIN_ATTEMPTS 10

 

If you would not to limit login time, you can execute the following command.

的SQL> alter profile default limit failed_login_attempts unlimited;

Profile altered.

的SQL> select resource_name,limit from dba_profiles where resource_name=’FAILED_LOGIN_ATTEMPTS’;

RESOURCE_NAME LIMIT
——————————– —————————————-
FAILED_LOGIN_ATTEMPTS UNLIMITED

的SQL> alter profile default limit failed_login_attempts 10;

Profile altered.

的SQL> select resource_name,limit from dba_profiles where resource_name=’FAILED_LOGIN_ATTEMPTS’;

RESOURCE_NAME LIMIT
——————————– —————————————-
FAILED_LOGIN_ATTEMPTS 10