无法在 Oracle 11g 中以新创建的用户身份登录
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/5731672/
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
Unable to log in as new created user in Oracle 11g
提问by AHungerArtist
I recently made a new tablespace and associated a user with it (sonar).
我最近创建了一个新表空间并将用户与其关联（声纳）。
Currently, a copy and paste of the user profile looks like this:
目前，用户配置文件的复制和粘贴如下所示：
Name SONAR
Profile DEFAULT
Authentication Password
Default Tablespace SONAR
Temporary Tablespace TEMP
Status UNLOCK
Default Consumer Group None
Role Admin Option Default
CONNECT N Y
DBA N Y
RESOURCE N Y
System Privilege Admin Option
CREATE SESSION N
UNLIMITED TABLESPACE N
I can log in to the OEM console with this new user but am unable to connect to the sonar tablespace with that user. I know the connection properties I'm using are valid because I can connect with other users and view their tablespaces.
我可以使用这个新用户登录到 OEM 控制台，但无法使用该用户连接到声纳表空间。我知道我使用的连接属性是有效的，因为我可以与其他用户连接并查看他们的表空间。
So, does anyone have an idea what I might be missing that is preventing me from connecting with this user and using their default tablespace? If I need to provide any more information, let me know. I'm not very experienced with DBA stuff.
那么，有没有人知道我可能遗漏了什么阻止我与该用户连接并使用他们的默认表空间？如果我需要提供更多信息，请告诉我。我对 DBA 的东西不是很有经验。
Thank you.
谢谢你。
回答by Justin Cave
Since you're getting an "ORA-01017: invalid username/ password" error, there are only a handful of possibilities
由于您收到“ORA-01017：无效的用户名/密码”错误，因此只有少数几种可能
- The password specified in SQL Developer is wrong.
- The username specified in SQL Developer is wrong.
- The password you're typing is correct but the tool is passing the wrong password to the database. When 11g made passwords case-sensitive by default, many tools hiccuped because they hadn't been preserving the casing in the passwords that were stored. I have no recollection of any version of SQL Developer being affected by this problem but if you have an old version, it's probably worth upgrading to the newly released 3.0 version anyway.
- The database you are connecting to is not the database where you created the
Sonaruser. If you can connect as other users using the same connection information, can you queryDBA_USERSand verify that you see theSonaruser?
- SQL Developer 中指定的密码错误。
- SQL Developer 中指定的用户名错误。
- 您输入的密码正确，但该工具将错误的密码传递给数据库。默认情况下，当 11g 使密码区分大小写时，许多工具会出现问题，因为它们没有在存储的密码中保留大小写。我不记得有任何版本的 SQL Developer 受到这个问题的影响，但如果你有一个旧版本，无论如何升级到新发布的 3.0 版本可能是值得的。
- 您要连接的数据库不是您创建
Sonar用户的数据库。如果您可以使用相同的连接信息作为其他用户进行连接，您DBA_USERS是否可以查询并验证您是否看到该Sonar用户？
