什么用户名和安装Oracle 11g后连接SQL*Plus时需要输入密码吗?
我在 Windows 7 上安装了 Oracle 11g
当我启动 sqlplus 时,它要求我输入用户名和密码
谁能告诉我需要插入什么用户名,当我尝试输入任何密码时,它不允许我输入单个字母。有理由吗?
I have installed Oracle 11g on Windows 7
When I start sqlplus, it ask me for a username and password
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?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(3)
如果您忘记了任何用户的密码,那么您可以通过以 SYS 身份登录来重置:
然后:
如果您忘记了您拥有哪些用户,那么您可以运行:
如果您最近刚刚创建了数据库,则值得限制在 CREATED 上,因为默认数据库安装带有数十个自己的模式。例如,要查找上周添加的用户,请运行以下命令:
If you've forgotten the password for any user then you can reset by logging in as SYS:
And then:
If you've forgotten which users you have then you can run:
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:
输入 SYSTEM 作为用户名,安装 11g 期间输入的密码对我来说效果很好!
Enter SYSTEM as user-name and the password entered during installing 11g works well for me!
用户名是指您必须连接到的架构。通常,
hr
架构是可用的示例架构。该密码将与您在 Oracle 安装期间设置的密码相同。The username refers to the schema to which you must connect to. Generally the
hr
schema is the sample schema that is available. The password will be the same password that you set during Oracle installation.