Oracle 11g 无法使用 sys 用户登录
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/18120528/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Oracle 11g can't log with sys user
提问by Dolphin
Today i meet a werid thing:I can't log on remote server Oracle database with sys user!
The username/password is sys/123,and my colleage could!this situation maintained still now.
今天遇到一个奇怪的事情:我无法使用sys用户登录远程服务器Oracle数据库!
用户名/密码是sys/123,我的同事可以!这种情况现在仍然存在。
But i can log on with an normal user,not a system dba.This is no privilege limit.Why? It's so werid.
但是我可以用普通用户登录,而不是系统 dba。这没有权限限制。为什么?太诡异了
This error info:
此错误信息:
ORA-01017:invalid username/password;logon denied.
The oracle version:11g.
甲骨文版本:11g。
Log on tool:PL/SQL
登录工具:PL/SQL
need other info?Is local install oracle 10g cause the problem?
需要其他信息吗?本地安装oracle 10g 是否会导致问题?
On the command line:
在命令行上:
SQL>show parameter remote_login_passwordfile The value is:EXCLUSIVE
回答by Dolphin
Solved:This problem bother me 2 day.Now the problem has fixed in 3 steps:
已解决:这个问题困扰了我 2 天。现在问题已通过 3 个步骤解决:
1.login the remote server and login as sys/123 as sysdba.
2.reset the password ( alter user sys identified by 123;)
3.relogin the oracle use sys,done!