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, 次のコマンドを実行できます.

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

返信を残します