在本机,执行: sqlplus /nolog conn / as sysdba 然后执行: ALTER USER system IDENTIFIED BY PWD; 密码就是PWD了!
(1)conn sys/sys as sysdba; //以DBA的身份登录 (2)alter user scott account unlock;// 然后解锁 (3)conn scott/tiger //弹出一个修改密码的对话框,修改一下密码就可以了
--进入sqlpuls命令窗口 sqlplus /nolog --操作系统认证方式登陆 conn / as sysdba --修改密码 alter user system identified by system; --用system用户重新登陆 conn system/system as sysdba;
sqlplus /nolog
conn / as sysdba
然后执行:
ALTER USER system IDENTIFIED BY PWD;
密码就是PWD了!
(2)alter user scott account unlock;// 然后解锁
(3)conn scott/tiger //弹出一个修改密码的对话框,修改一下密码就可以了
sqlplus /nolog
--操作系统认证方式登陆
conn / as sysdba
--修改密码
alter user system identified by system;
--用system用户重新登陆
conn system/system as sysdba;
推荐lz安装一个客户端软件,直接从客户端软件来做一些用户操作
客户端软件在oracle 官方网站有免费下载
(2)alter user system account unlock;// 然后解锁
(3)然后再以system用户登入就行了
ORA-28000:the account is locked
======================================
system用户锁了?很奇怪的事情
--进入sqlpuls命令窗口
sqlplus /nolog
--操作系统认证方式登陆
conn / as sysdba
--修改密码
alter user scott identified by system;
--用system用户重新登陆
conn scott/admin as sysdba;
sqlplus /nolog
conn / as sysdba
然后执行:
ALTER USER system IDENTIFIED BY ****(你新设置的密码);