os authentication, logon in the operating system as a member of dba group, then execute:export ORACLE_SID=your_sid // for linux or set oracle_sid=your_sid // for windowsthen,sqlplus / as sysdba alter user sys identified by sys; // reset the password of sys
ora-01031:insufficient privileger 权限不足 你是用什么帐户登录进去的?是不是用户被锁了? cmd: sqlplus /nolog conn / as sysdb;解锁 alter user 用户名 account unlock;
注: alert 文件位置
unix下在:$ORACLE_BASE/admin/sid/bdump下
windows:%ORACLE_BASE%/admin/sid/bdump下
or
set oracle_sid=your_sid // for windowsthen,sqlplus / as sysdba
alter user sys identified by sys; // reset the password of sys
权限不足
你是用什么帐户登录进去的?是不是用户被锁了?
cmd: sqlplus /nolog
conn / as sysdb;解锁
alter user 用户名 account unlock;