sys /system 登陆 看可以不C:\Documents and Settings\Administrator>sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on 星期四 8月 12 10:40:19 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn /as sysdba 已连接。 SQL> alter user system identified by sys 2 /用户已更改。SQL> alter user scott account unlock 2 /用户已更改。SQL> alter user scott identified by sys 2 /用户已更改。
can you try to re-create the password file (default $ORACLE_HOME/dbs/$ORACLE_SIDpwd.ora ) and check your sqlnet.ora (default in $TNS_ADMIN or $ORACLE_HOME/network/admin) for SQLNET.AUTHENTICATION_SERVICES (i think it has to be NTS, not really sure though)
看看这篇文章
http://topic.csdn.net/u/20090423/11/CA3E13FC-CE8B-408B-9ECE-B0B5CF5908EF.html
sys /system 登陆 看可以不C:\Documents and Settings\Administrator>sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on 星期四 8月 12 10:40:19 2010Copyright (c) 1982, 2005, Oracle. All rights reserved.SQL> conn /as sysdba
已连接。
SQL> alter user system identified by sys
2 /用户已更改。SQL> alter user scott account unlock
2 /用户已更改。SQL> alter user scott identified by sys
2 /用户已更改。
sqlplus "sys/ <password> as sysdba" sys用户的远程登录默认是禁止的。 但是别的用户如system以及普通用户远程访问默认应该是允许的。
形式为:
sqlplus "username/password@servicename"