Share the Oracle password retrieval method and the oracle password retrieval method

Source: Internet
Author: User

Share the Oracle password retrieval method and the oracle password retrieval method

I believe most people will encounter such problems. I have also encountered such problems.

First, he will ask you to enter the User name: you only need to enter connect/as sysdba, note that there is a space between as and sysdba. Then he will ask you to input
Password. But ignore him and click enter. The OK link is successfully linked. Next you will


1. Create a user/password and authorize


Create and authorize a user/password in Oracle


(1) create a user


Create user Username identified by password; (if it is a number, double quotation marks "111111" should be added; if it is a letter, it will not be used)


(2) authorize a user


Grant connect, resource to user name; (other tables can be operated only when the user has connect and resource)


(3) grant DBA Permissions


Grant dba to user name;


(4) permissions for creating sessions for users:


Grant create session to DB_USER


(3) grant DBA Permissions


Grant dba to user name;


(4) Withdrawal:
Revoke permission... from user name;


(5) delete a user:
2. Change the user name and password
Change user Password (for example, change sys user password to 123): alter user sys identified by 123;


1. Run cmd on windows


2. sqlplus/nolog


3. SQL> connsys/lmis @ lmisdx_localas sysdba connects to the database. You can usually Log On with the sys user.


4. SQL> select * from user $; find the user whose name is to be modified #.


5. SQL> UPDATE USER $ SET NAME = 'new Username 'WHERE USER # = 38;
1 row updated.


6. SQL> COMMIT; the submission is complete.


7. SQL> ALTER SYSTEM CHECKPOINT;
The system has been changed.


8. SQL> ALTER USER new username IDENTIFIED BY new password;
The system prompts that the new user does not exist.


SQL> ALTER USER new username IDENTIFIED BY new password


* ERROR located in row 1st: ORA-01918: User 'new user' does not exist


SQL> ALTER USER new username IDENTIFIED BY new password


* ERROR located in row 1st: ORA-01918: User 'new user' does not exist
9. SQL> ALTER SYSTEM FLUSH SHARED_POOL;
The system has been changed.


10. SQL> ALTER USER new USER IDENTIFIED BY new password;

The user has changed.



How to retrieve the super administrator password in Oracle

You only need to know the password of the oracle server.
Go to the server and use the command line to modify it
Sqlplus/nolog
Connect/as sysdba
Alter user sys identified by values 'new password'

What should I do if I forget the oracle password?

Run cmd and enter the following command:
Sqlplus/as sysdba --------- log in as sys
Alter user Username account unlock; --------- unlock
Alter user Username identified password ------------- Change Password

Then you can log on with your changed password.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.