演示默认学习用户scott,默认密码是tiger
默认学习用户scott,默认密码是tiger
oracle@prd:/home/oracle$sqlplus /nolog
SQL> conn scott/tiger
ERROR:
ORA-28000: the account is locked
SQL> exit
oracle@prd:/home/oracle$sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 20:28:21 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn / as sysdba //用超级管理账户登录
Connected.
SQL> alter user scott account unlock; //解锁
User altered.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
//重新登录sqlplus软件,/nolog表示没有任何用户登录
oracle@prd:/home/oracle$sqlplus /nolog
SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 21 20:28:53 2022
Copyright (c) 1982, 2013, Oracle. All rights reserved.
SQL> conn scott/tiger //提示密码已过期,重新设置
ERROR:
ORA-28001: the password has expired
Changing password for scott
New password:
Retype new password:
Password changed
Connected.
SQL> show user;
USER is "SCOTT"
SQL>alter user scott identified by tiger;
User altered.