创建一个概要文件

 create profile frank_profile limit

    SESSIONS_PER_USER  5    IDLE_TIME  2    FAILED_LOGIN_ATTEMPTS 5;

创建一个测试的用户：

-- Create the user

create user TEST001

  identified by "123RR??"

  default tablespace TEST2_DATA  temporary tablespace temp02 profile FRANK_PROFILE quota unlimited on TEST2_DATA;

用sys用户登录查看用户的状态

SQL>  select USERNAME,ACCOUNT_STATUS from dba_users;

USERNAME                       ACCOUNT_STATUS

------------------------------ --------------------------------OUTLN                          OPENSYS                            OPENSYSTEM                         OPENTEST001                       OPENTSMSYS                         EXPIRED & LOCKEDDIP                            EXPIRED & LOCKEDDBSNMP                         EXPIRED & LOCKED；

然后用TEST001帐号登录数据库：

SQL> conn TEST001  

ERROR:ORA-12154: TNS:could not resolve the connect identifier specified

报错。原来是创建用户的时候忘了赋权先；

SQL> conn / as sysdba

Connected.SQL> grant create session,resource to TEST001;

Grant succeeded.

SQL> conn TEST001/123RR??Error accessing PRODUCT_USER_PROFILEWarning:  Product user profile information not loaded!You may need to run PUPBLD.SQL as SYSTEMConnected.SQL> show userUSER is "TEST001"SQL>  conn / as sysdbaConnected.

先锁上帐号：

SQL> alter user TEST001 account LOCK;

User altered.

SQL> select USERNAME,ACCOUNT_STATUS from dba_users;

USERNAME                       ACCOUNT_STATUS

------------------------------ --------------------------------OUTLN                          OPENSYS                            OPENSYSTEM                         OPENTEST001                       LOCKEDTSMSYS                         EXPIRED & LOCKEDDIP                            EXPIRED & LOCKEDDBSNMP                         EXPIRED & LOCKED

SQL> conn TEST001/123RR??ERROR:ORA-28000: the account is locked

解锁：

SQL> conn DBUSRC01/123future??

ERROR:ORA-28000: the account is locked

SQL> conn / as sysdbaConnected.SQL>  alter user TEST001 account unlock;

User altered.

SQL>  select USERNAME,ACCOUNT_STATUS from dba_users;

USERNAME                       ACCOUNT_STATUS

------------------------------ --------------------------------OUTLN                          OPENSYS                            OPENSYSTEM                         OPENTEST001                       OPENTSMSYS                         EXPIRED & LOCKEDDIP                            EXPIRED & LOCKEDDBSNMP                         EXPIRED & LOCKED

这样就可以登录了