什么用户名和安装Oracle 11g后连接SQL*Plus时需要输入密码吗?

发布于 2024-12-25 03:59:14 字数 124 浏览 2 评论 0原文

我在 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 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(3

季末如歌 2025-01-01 03:59:14

如果您忘记了任何用户的密码,那么您可以通过以 SYS 身份登录来重置:

sqlplus / as sysdba

然后:

alter user <username> identified by <password>;

如果您忘记了您拥有哪些用户,那么您可以运行:

select username from all_users;

如果您最近刚刚创建了数据库,则值得限制在 CREATED 上,因为默认数据库安装带有数十个自己的模式。例如,要查找上周添加的用户,请运行以下命令:

select * from all_users
where created > trunc(sysdate)-7;

If you've forgotten the password for any user then you can reset by logging in as 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:

select * from all_users
where created > trunc(sysdate)-7;
太阳公公是暖光 2025-01-01 03:59:14

输入 SYSTEM 作为用户名,安装 11g 期间输入的密码对我来说效果很好!

Enter SYSTEM as user-name and the password entered during installing 11g works well for me!

⊕婉儿 2025-01-01 03:59:14

用户名是指您必须连接到的架构。通常,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.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文