在默认情况下scott用户是被系统锁定的,你需要先已sys身份登陆对scott用户进行解锁。c:\>sqlplus /nolog
SQL>conn / as sysdba
SQL>alter user scott identified by tigger account unlock;
SQL>disconn
SQL>conn scott/tigger这样就可以作为scott用户进行登陆了
SQL>conn / as sysdba
SQL>alter user scott identified by tigger account unlock;
SQL>disconn
SQL>conn scott/tigger这样就可以作为scott用户进行登陆了
alter user scott identified by tigger account unlock;
disconn
conn scott/tigger
ERROR:
ORA-01033: ORACLE initialization or shutdown in progress
还进不去吗?呵呵。
sqlplus /nolog
conn / as sysdba
startup启动一下试试