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.