SSH登陆后：
su - oracle;
sqlplus /nolog;
conn system/密码; 或者
connect/as sysdba;
alter user 用户名 identified by 密码
oracle 解锁加锁
SQL*Plus:
Release 9.2.0.4.0 - Production on Tue Jul 14 18:12:38 2009
Copyright
(c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL>
conn sys/sys as sysdba
Connected.
SQL>
show user
USER
is "SYS"
SQL>
desc dba_users
Name
Null? Type
-----------------------------------------
-------- ----------------------------
USERNAME
NOT NULL VARCHAR2(30)
USER_ID
NOT NULL NUMBER
PASSWORD
VARCHAR2(30)
ACCOUNT_STATUS
NOT NULL VARCHAR2(32)
LOCK_DATE
DATE
EXPIRY_DATE
DATE
DEFAULT_TABLESPACE
NOT NULL VARCHAR2(30)
TEMPORARY_TABLESPACE
NOT NULL VARCHAR2(30)
CREATED
NOT NULL DATE
PROFILE
NOT NULL VARCHAR2(30)
INITIAL_RSRC_CONSUMER_GROUP
VARCHAR2(30)
EXTERNAL_NAME
VARCHAR2(4000)
SQL>
set lines 200
SQL>
select username,account_status from dba_users;
USERNAME
ACCOUNT_STATUS
------------------------------
--------------------------------
SYS
OPEN
SYSTEM
OPEN
DBSNMP
OPEN
SCOTT
OPEN
OUTLN
EXPIRED & LOCKED
WMSYS
EXPIRED & LOCKED
ORDSYS
EXPIRED & LOCKED
ORDPLUGINS
EXPIRED & LOCKED
MDSYS
EXPIRED & LOCKED
CTXSYS
EXPIRED & LOCKED
XDB
EXPIRED & LOCKED
USERNAME
ACCOUNT_STATUS
------------------------------
--------------------------------
ANONYMOUS
EXPIRED & LOCKED
WKSYS
EXPIRED & LOCKED
WKPROXY
EXPIRED & LOCKED
ODM
EXPIRED & LOCKED
ODM_MTR
EXPIRED & LOCKED
OLAPSYS
EXPIRED & LOCKED
HR
EXPIRED & LOCKED
OE
EXPIRED & LOCKED
PM
EXPIRED & LOCKED
SQL>
alter user hr account unlock;（解锁）
User
altered.
SQL>
select username,account_status from dba_users;
USERNAME
ACCOUNT_STATUS
------------------------------
--------------------------------
SYS
OPEN
SYSTEM
OPEN
DBSNMP
OPEN
SCOTT
OPEN
HR
EXPIRED
OUTLN
EXPIRED & LOCKED
WMSYS
EXPIRED & LOCKED
ORDSYS
EXPIRED & LOCKED
ORDPLUGINS
EXPIRED & LOCKED
QL>
alter user hr identified by hr;（更改密码）
User
altered.
SQL>
select username,account_status from dba_users;
USERNAME
ACCOUNT_STATUS
------------------------------
--------------------------------
SYS
OPEN
SYSTEM
OPEN
DBSNMP
OPEN
SCOTT
OPEN
HR
OPEN
OUTLN
EXPIRED & LOCKED
SQL>
conn hr/hr
Connected.
SQL>
conn /as sysdba
Connected.
SQL>
alter user hr account lock;（加锁）
User
altered.
SQL>
select username,account_status from dba_users;
USERNAME
ACCOUNT_STATUS
------------------------------
--------------------------------
SYS
OPEN
SYSTEM
OPEN
DBSNMP
OPEN
SCOTT
OPEN
HR
LOCKED
OUTLN
EXPIRED & LOCKED
SQL>
alter user hr password expire;（密码失效）
User
altered.
SQL>
select username,account_status from dba_users;
USERNAME
ACCOUNT_STATUS
------------------------------
--------------------------------
SYS
OPEN
SYSTEM
OPEN
DBSNMP
OPEN
SCOTT
OPEN
OUTLN
EXPIRED & LOCKED
WMSYS
EXPIRED & LOCKED
OLAPSYS
EXPIRED & LOCKED
HR
EXPIRED & LOCKED
OE
EXPIRED & LOCKED
PM
EXPIRED & LOCKED
SQL>
conn hr/hr
ERROR:
ORA-28000:
the account is locked
Warning:
You are no longer connected to ORACLE.
评论