Oracle 11g 的默认密码? [英] Default passwords of Oracle 11g?
问题描述
我安装了 Oracle 11g.我没有更改 SYSTEM 和 SYS 的密码.但是现在我发现默认密码不起作用.请帮忙.
I installed Oracle 11g. I didn't change the passwords for SYSTEM and SYS. However now I find that the default passwords do not work. Please help.
推荐答案
可以在不指定密码的情况下连接到数据库.完成后,您可以重置密码.我假设你已经在你的机器上安装了数据库;如果没有,您首先需要连接到运行数据库的机器.
It is possible to connect to the database without specifying a password. Once you've done that you can then reset the passwords. I'm assuming that you've installed the database on your machine; if not you'll first need to connect to the machine the database is running on.
确保您的用户帐户是
dba
组的成员.您如何执行此操作取决于您运行的操作系统.
Ensure your user account is a member of the
dba
group. How you do this depends on what OS you are running.
在命令提示符/shell/终端窗口中根据需要输入 sqlplus/as sysdba
.这应该让您以 SYS 身份登录到数据库.
Enter sqlplus / as sysdba
in a Command Prompt/shell/Terminal window as appropriate. This should log you in to the database as SYS.
登录后即可进入
alter user SYS identified by "newpassword";
重置 SYS 密码,对于 SYSTEM 也是如此.
to reset the SYS password, and similarly for SYSTEM.
(注意:我没有在 Oracle 12c 上尝试过任何这些;我假设它们自 Oracle 11g 以来没有改变过.)
(Note: I haven't tried any of this on Oracle 12c; I'm assuming they haven't changed things since Oracle 11g.)
这篇关于Oracle 11g 的默认密码?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!