安装 Oracle 11g 后连接 SQL*Plus 时应该输入什么用户名和密码？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/8722302/
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
What username & password should be entered when connecting to SQL*Plus after installing Oracle 11g?
提问by Hirvesh
I have installed Oracle 11g on Windows 7
我已经在 Windows 7 上安装了 Oracle 11g
When I start sqlplus, it ask me for a username and password
当我启动 sqlplus 时，它要求我输入用户名和密码
Can anybody tell me what username needs to be inserted and when I try to type in any password, it doesn't allow me to type a single letter. Is there a reason why?
谁能告诉我需要插入什么用户名，当我尝试输入任何密码时，它不允许我输入一个字母。有什么原因吗？
回答by John Doyle
If you've forgotten the password for any user then you can reset by logging in as SYS:
如果您忘记了任何用户的密码，则可以通过以 SYS 身份登录来重置：
sqlplus / as sysdba
And then:
进而：
alter user <username> identified by <password>;
If you've forgotten which users you have then you can run:
如果您忘记了自己拥有哪些用户，则可以运行：
select username from all_users;
If you have only recently created the database it would be worthwhile restricting on CREATED, as the default database install comes with dozens of its own schemas. For instance, to find users added in the last week run this:
如果您最近才创建了数据库，那么限制 CREATED 是值得的，因为默认的数据库安装带有许多自己的模式。例如，要查找上周添加的用户，请运行以下命令：
select * from all_users
where created > trunc(sysdate)-7;
回答by Bruce Yo
Enter SYSTEM as user-name and the password entered during installing 11g works well for me!
输入 SYSTEM 作为用户名，安装 11g 时输入的密码对我来说效果很好！
回答by Sathyajith Bhat
The username refers to the schema to which you must connect to. Generally the hrschema is the sample schema that is available. The password will be the same password that you set during Oracle installation.
用户名是指您必须连接到的架构。通常hr模式是可用的示例模式。该密码将与您在 Oracle 安装期间设置的密码相同。
