Oracle用户解锁

首先先连接上SQL*Plus: Release 12.1.0.2.0 Production on 星期四 2月 12 15:40:422015Copyright （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 ProductionWith the Partitioning, OLAP, AdvancedAnalytics and Real Application Testing optIons//对相应的列惊醒格式化操作，以便观察SQL> column username format a20SQL> column account_status format a20SQL> set pagesize 400//输入下面这条select语句，从dba_users查询用户以及状态信息SQL> select username,account_status fromdba_usersUSERNAME ACCOUNT_STATUS-------------------- --------------------C##TEST OPENC##SCOTT OPENORACLE_OCM EXPIRED & LOCKEDOJVMSYS EXPIRED & LOCKEDSYSKM EXPIRED & LOCKEDXS$NULL EXPIRED & LOCKEDGSMCATUSER EXPIRED & LOCKEDMDDATA EXPIRED & LOCKEDSYSBACKUP EXPIRED & LOCKEDDIP EXPIRED & LOCKEDSYSDG EXPIRED & LOCKEDAPEX_PUBLIC_USER EXPIRED & LOCKEDSPATIAL_CSW_ADMIN_US EXPIRED & LOCKEDR SPATIAL_WFS_ADMIN_US EXPIRED & LOCKEDR GSMUSER EXPIRED & LOCKEDAUDSYS EXPIRED& LOCKEDC##USER1 OPENFLOWS_FILES EXPIRED& LOCKEDDVF EXPIRED & LOCKEDMDSYS EXPIRED& LOCKEDORDSYS EXPIRED& LOCKEDDBSNMP EXPIRED & LOCKEDWMSYS EXPIRED & LOCKEDAPEX_040200 EXPIRED & LOCKEDAPPQOSSYS EXPIRED & LOCKEDGSMADMIN_INTERNAL EXPIRED & LOCKEDORDDATA EXPIRED & LOCKEDCTXSYS EXPIRED & LOCKEDANONYMOUS EXPIRED & LOCKEDXDB EXPIRED & LOCKEDORDPLUGINS EXPIRED & LOCKEDDVSYS EXPIRED & LOCKEDSI_INFORMTN_SCHEMA EXPIRED & LOCKEDOLAPSYS EXPIRED & LOCKEDLBACSYS EXPIRED & LOCKEDOUTLN EXPIRED & LOCKEDSYSTEM OPENSYS 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 OPENC##SCOTT OPENORACLE_OCM EXPIRED & LOCKEDOJVMSYS EXPIRED & LOCKEDSYSKM EXPIRED & LOCKEDXS$NULL EXPIRED & LOCKEDGSMCATUSER EXPIRED & LOCKEDMDDATA EXPIRED & LOCKEDSYSBACKUP EXPIRED & LOCKEDDIP EXPIRED & LOCKEDSYSDG EXPIRED & LOCKEDAPEX_PUBLIC_USER EXPIRED & LOCKEDSPATIAL_CSW_ADMIN_US EXPIRED & LOCKEDRSPATIAL_WFS_ADMIN_US EXPIRED & LOCKEDRGSMUSER EXPIRED & LOCKEDAUDSYS EXPIRED & LOCKEDC##USER1 OPENFLOWS_FILES EXPIRED & LOCKEDDVF EXPIRED & LOCKEDMDSYS EXPIRED & LOCKEDORDSYS EXPIRED & LOCKEDDBSNMP EXPIRED & LOCKEDWMSYS EXPIRED & LOCKEDAPEX_040200 EXPIRED & LOCKEDAPPQOSSYS EXPIRED & LOCKEDGSMADMIN_INTERNAL EXPIRED & LOCKEDORDDATA EXPIRED & LOCKEDCTXSYS EXPIRED & LOCKEDANONYMOUS EXPIRED & LOCKEDXDB EXPIRED & LOCKEDORDPLUGINS EXPIRED & LOCKEDDVSYS EXPIRED & LOCKEDSI_INFORMTN_SCHEMA EXPIRED & LOCKEDOLAPSYS EXPIRED & LOCKEDLBACSYS EXPIRED & LOCKEDOUTLN OPENSYSTEM OPENSYS OPEN已选择 38 行。如上，outln已经显示为open。//测试连接SQL> connect outln/admin已连接。更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址