忘记了Oracle用户名和密码，如何找回? [英] Forgot Oracle username and password, how to retrieve?

问题描述

我忘记了Oracle用户名和密码，因此无法使用它.我的Oracle版本是11.2.0.1.0(11g).我咨询了互联网.他们要求我执行"SYSDBA"之类的命令，但我无法执行该操作，因为一旦在命令提示符"屏幕上输入"SYSDBA"，它将命令作为用户名，然后要求输入密码.我不能执行他们建议的任何命令，因为我输入的内容都将作为用户名，随后要求输入密码并发生错误.

I have forgotten my Oracle username and password and hence not able to use it. My Oracle version is 11.2.0.1.0(11g). I consulted Internet. They asked me to execute commands like ‘SYSDBA’ but I was unable to do it as once I give ‘SYSDBA’ on Command Prompt screen, it takes the command as the username and next asks for password. I cannot execute any commands suggested by them as whatever I enter is taken as the username, subsequently password is asked and error occurs.

推荐答案

1. 打开您的SQL命令行，然后键入以下内容:

1. Open your SQL command line and type the following:

SQL> connect / as sysdba

连接后，您可以输入以下查询以获取用户名和密码的详细信息:

Once connected,you can enter the following query to get details of username and password:

SQL> select username,password from dba_users;

这将列出用户名，但密码不可见.但是您可以标识特定的用户名，然后更改该用户的密码. 要更改密码，请使用以下查询:

This will list down the usernames,but passwords would not be visible.But you can identify the particular username and then change the password for that user. For changing the password,use the below query:

SQL> alter user username identified by password;

此处的用户名是要更改其密码的用户名，而密码是新密码.

Here username is the name of user whose password you want to change and password is the new password.

这篇关于忘记了Oracle用户名和密码，如何找回?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！