When I set the password forgot to add the sys password array, now create user cannot log in sys

CodePudding user response:

Available login to up sqlplus in OS authentication way, it is ok to revise a new;

PS: sys add password array, this sentence what mean?

CodePudding user response:

If you are to forget SYS USER's password, you can use the SYSTEM USER login, and then use the ALTER USER command to change the password,
Under the CMD command line input up sqlplus/as sysdba;
Method 1. SQL> Alter user sys identified by huozhe

Method 2. SQL> Grant connect to sys identified by 123456

CodePudding user response:

In that first sqlnet. ORA see if your Settings can use OS authentication login
If you can use up sqlplus/as sysdba
Then enter the password
Can enter a new password

CodePudding user response:

SQL> The alter user username identified by the original password;

CodePudding user response:

If you just forget sys user login password, you can log on to other users, such as the system user, then enter the alter user username identified by the new password;
If have forgotten the alter user sys identified by the new password;