ORA-00988: missing or invalid password(s)

I got ” ORA-00988: missing or invalid password(s) ”  error in Oracle database.

ORA-00988: missing or invalid password(s)

Details of error are as follows.

SQL> alter user msdba identified by '_#deveci%&';
alter user msdba identified by '_#deveci%&'
*
ERROR at line 1:
ORA-00988: missing or invalid password(s)

missing or invalid password(s)

This ORA-00988 error is related to the missing or invalid password.

Check the password if the password is a Oracle keyword or password starts with a number or  password contains special characters  if it is not wrapped in double quotes, you will get this error.

Double quotes in Oracle Password

To solve this error, you need to use password with wrapped in double quotes as follows.

SQL> alter user msdba identified by "_#deveci%&";

User altered.

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )