Oracle用户解锁
首先先连接上
SQL*Plus: Release 12.1.0.2.0 Production on 星期四 2月 12 15:40:422015
Copyright (c) 1982, 2014, Oracle. All rights reserved.
请输入用户名: system
输入口令:
上次成功登录时间: 星期四 2月 12 2015 10:26:40 +08:00
连接到:
Oracle Database 12c Enterprise EditionRelease 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, AdvancedAnalytics and Real Application Testing opt
Ions
//对相应的列惊醒格式化操作,以便观察
SQL> column username format a20 SQL> column account_status format a20 SQL> set pagesize 400
//输入下面这条select语句,从dba_users查询用户以及状态信息
SQL> select username,account_status fromdba_users USERNAME ACCOUNT_STATUS -------------------- -------------------- C##TEST OPEN C##SCOTT OPEN ORACLE_OCM EXPIRED & LOCKED OJVMSYS EXPIRED & LOCKED SYSKM EXPIRED & LOCKED XS$NULL EXPIRED & LOCKED GSMCATUSER EXPIRED & LOCKED MDDATA EXPIRED & LOCKED SYSBACKUP EXPIRED & LOCKED DIP EXPIRED & LOCKED SYSDG EXPIRED & LOCKED APEX_PUBLIC_USER EXPIRED & LOCKED SPATIAL_CSW_ADMIN_US EXPIRED & LOCKED R SPATIAL_WFS_ADMIN_US EXPIRED & LOCKED R GSMUSER EXPIRED & LOCKED AUDSYS EXPIRED& LOCKED C##USER1 OPEN FLOWS_FILES EXPIRED& LOCKED DVF EXPIRED & LOCKED MDSYS EXPIRED& LOCKED ORDSYS EXPIRED& LOCKED DBSNMP EXPIRED & LOCKED WMSYS EXPIRED & LOCKED APEX_040200 EXPIRED & LOCKED APPQOSSYS EXPIRED & LOCKED GSMADMIN_INTERNAL EXPIRED & LOCKED ORDDATA EXPIRED & LOCKED CTXSYS EXPIRED & LOCKED ANONYMOUS EXPIRED & LOCKED XDB EXPIRED & LOCKED ORDPLUGINS EXPIRED & LOCKED DVSYS EXPIRED & LOCKED SI_INFORMTN_SCHEMA EXPIRED & LOCKED OLAPSYS EXPIRED & LOCKED LBACSYS EXPIRED & LOCKED OUTLN EXPIRED & LOCKED SYSTEM OPEN SYS OPEN
已选择 38 行。
如上面所示,如果username对应的account_status为open,表示该用户解锁, 如果username对应的account_status为EXPIRED,表示该用户已经过期,如果username对应的account_status为locked,表示该用户锁定。使用过期的或者锁定的账号是登陆不上的,我们必须先对用户解锁。
//接下来我们对outln用户进行解锁 SQL> alter user outln account unlock; 用户已更改。 //给该用户指定口令 SQL> alter user outln identified byadmin; 用户已更改。 //我们再查询所用用户 SQL> select username,account_status fromdba_users; USERNAME ACCOUNT_STATUS -------------------- -------------------- C##TEST OPEN C##SCOTT OPEN ORACLE_OCM EXPIRED & LOCKED OJVMSYS EXPIRED & LOCKED SYSKM EXPIRED & LOCKED XS$NULL EXPIRED & LOCKED GSMCATUSER EXPIRED & LOCKED MDDATA EXPIRED & LOCKED SYSBACKUP EXPIRED & LOCKED DIP EXPIRED & LOCKED SYSDG EXPIRED & LOCKED APEX_PUBLIC_USER EXPIRED & LOCKED SPATIAL_CSW_ADMIN_US EXPIRED & LOCKED R SPATIAL_WFS_ADMIN_US EXPIRED & LOCKED R GSMUSER EXPIRED & LOCKED AUDSYS EXPIRED & LOCKED C##USER1 OPEN FLOWS_FILES EXPIRED & LOCKED DVF EXPIRED & LOCKED MDSYS EXPIRED & LOCKED ORDSYS EXPIRED & LOCKED DBSNMP EXPIRED & LOCKED WMSYS EXPIRED & LOCKED APEX_040200 EXPIRED & LOCKED APPQOSSYS EXPIRED & LOCKED GSMADMIN_INTERNAL EXPIRED & LOCKED ORDDATA EXPIRED & LOCKED CTXSYS EXPIRED & LOCKED ANONYMOUS EXPIRED & LOCKED XDB EXPIRED & LOCKED ORDPLUGINS EXPIRED & LOCKED DVSYS EXPIRED & LOCKED SI_INFORMTN_SCHEMA EXPIRED & LOCKED OLAPSYS EXPIRED & LOCKED LBACSYS EXPIRED & LOCKED OUTLN OPEN SYSTEM OPEN SYS OPEN
已选择 38 行。
如上,outln已经显示为open。
//测试连接
SQL> connect outln/admin
已连接。
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。