Oracle如何解锁与加锁?
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。
答:网卡驱动安装下 本地连接有吗详情>>
答:计算机反键点管理——设备管理器——网络适配器详情>>