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.
相关推荐
1、 查看当前被解锁的对象 示例： 将表aa加锁 执行 select * from aa for update; 方式一：通过SQL查询 select ‘alter system kill session ‘,””||trim(t2.sid)||’,’||trim(t2.serial#)||”’;’ from v$...
1.运行 cmd.exe； 2.输入 sqlplus / as sysdba,以系统管理员(sysdba)身份连接数据库，进行数据库管理操作。 3.连接成功后执行 alter user identityName identified ...PS: oracle 11g用户的解锁与加锁（hr模式） SQL
oracle 常用命令大全 oracle dba 常用命令 1 运行 SQLPLUS 工具 sqlplus 2 以 OS 的默认身份连接 / as sysdba ...show user 4 直接进入 SQLPLUS 命令...9 将 SCOTT 帐号解锁(加锁) alter user scott account unlock(lock);
export PATH=$PATH:$ORACLE_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib export ORACLE_SID=cams export ORACLE_TERM=vt100 export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data...
1.账户怎样加锁 2.账户怎样解锁 3.怎样恢复删除后的表内容 4.简单表命名规范
1 运行SQLPLUS工具 sqlplus 2 以OS的默认身份连接 / as sysdba 3 显示当前用户名 show user 4 直接进入SQLPLUS命令提示符 sqlplus /nolog 5 在命令提示符以OS身份连接 connect /... 9 将SCOTT帐号解锁(加锁) alter user
任何 SQL 语句执行时 Oracle 都隐式地对 SQL 所需的锁进行管理，因此用户无需显式地对资源加锁。Oracle 默认采用的锁机制能尽可能地减小对数据访问的限制，在保证数据一致性的同时实现高度的数据并发性。Oracle也...
15.3 表单的加锁和解锁 263 15.4 部门级系统管理员 263 15.5 用户管理 265 15.5.1 代理登录 265 15.5.2 工作交接、权限转移 267 15.6 设置系统管理员密码双加密 271 15.7 本章练习 273 第16章、 数据项与数据表详解 ...