Regular account operation in Oracle

Query all users in oracle, but first of all, your account should have dba

permission,such as sys , system.

select * from dba_users;

Query all users which you can manage.

select * from all_users;

Query details about currnet user.

select * from 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