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.

1. 确保您的用户帐户是dba组的成员.如何执行此操作取决于您正在运行的操作系统.

1. Ensure your user account is a member of the dba group. How you do this depends on what OS you are running.

在相应的命令提示符/外壳/终端窗口中输入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屋！