Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.
C:Documents and SettingsAdministrator>set oracle_sid=ora11g
C:Documents and SettingsAdministrator>sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:46:10 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> create user test1 identified by AAAAAA;
用户已创建。
SQL> EXIT
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断
开
C:Documents and SettingsAdministrator>SQLPLUS test1/aaaaaa
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:47:01 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名:
C:Documents and SettingsAdministrator>SQLPLUS test1/AAAAAA
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:47:09 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01045: 用户 TEST1 没有 CREATE SESSION 权限; 登录被拒绝
请输入用户名:
C:Documents and SettingsAdministrator>sqlplus / as sysdba
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:47:17 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> GRANT connect to test1;
授权成功。
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断
开
C:Documents and SettingsAdministrator>SQLPLUS test1/aaaaaa
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:47:46 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名: exit
C:Documents and SettingsAdministrator>SQLPLUS test1/AAAAAA
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:47:51 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit
从 Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断
开
C:Documents and SettingsAdministrator>SQLPLUS test1/aaaaaa
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:53:56 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名:
C:Documents and SettingsAdministrator>SQLPLUS test1/aaaaaa
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:53:57 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名:
C:Documents and SettingsAdministrator>SQLPLUS test1/aaaaaa
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:53:59 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名:
C:Documents and SettingsAdministrator>SQLPLUS test1/aaaaaa
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:54:00 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名:
C:Documents and SettingsAdministrator>SQLPLUS test1/aaaaaa
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:54:03 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名:
C:Documents and SettingsAdministrator>SQLPLUS test1/aaaaaa
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:54:06 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名:
C:Documents and SettingsAdministrator>SQLPLUS test1/aaaaaa
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:54:10 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名:
C:Documents and SettingsAdministrator>SQLPLUS test1/aaaaaa
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:54:16 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名:
C:Documents and SettingsAdministrator>SQLPLUS test1/aaaaaa
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:54:22 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名:
C:Documents and SettingsAdministrator>SQLPLUS test1/aaaaaa
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:54:30 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名:
C:Documents and SettingsAdministrator>SQLPLUS test1/aaaaaa
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:54:39 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-28000: 帐户已被锁定
请输入用户名:
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
请输入用户名:
ERROR:
ORA-01017: 用户名/口令无效; 登录被拒绝
SP2-0157: 在 3 次尝试之后无法连接到 ORACLE, 退出 SQL*Plus
C:Documents and SettingsAdministrator>SQLPLUS test1/aaaaaa
SQL*Plus: Release 11.1.0.6.0 - Production on 星期四 8月 11 13:54:47 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ERROR:
ORA-28000: 帐户已被锁定
请输入用户名：
输入完10次错误的密码后，当输入第11次密码时，提示
ORA-28000: 帐户已被锁定