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