sqlplus / as sysdba ora-01031 insufficient privileges

Why can’t you grab tickets when you travel on holiday?Reveal the key technology of 12306 how to ensure the ticket is not oversold>>>

Oracle has been used in recent projects. I forgot my previous account password, so I need to reset my password

conn/as sysdba;

The test found that there was an error when using the operating system to log in locally, most likely because the Current Windows user was not in the user group allowed by Oracle to log in. You need to add the current login user to the ora_ In the DBA user group, as shown in the figure below, also needs to confirm the file $oracle_ In home/network/admin/sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NTS)

After the test, you can log in, change the password and unlock the account successfully

alter user scott identified by tiger;
alter user scott account unlock;

Similar Posts: