摘要:
--1. --系统参数配置 connectsys/password@db_linkas sysdba select * from dba_profiles where resource_name like 'FAILED_LOGIN_ATTEMPTS%'; --1 DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10 --连续错误连接10次用户被锁定 --2. --查看被锁的用户 select LOCK_DATE,username from dba_users where username='USERNAME'; LOCK_DATE 阅读全文
摘要:
C:\Documents and Settings\Administrator>oradim -startup -sid testbasC:\Documents and Settings\Administrator>set ORACLE_SID=testbasC:\Documents and Settings\Administrator>sqlplus "/ as sysdba"SQL*Plus: Release 9.2.0.4.0 - Production on 星期四 6月 28 10:37:49 2007Copyright (c) 1982, 200 阅读全文