Changing the Passwords of Oracle Database Users of the BFM

Prerequisites

There is no prerequisite for changing the passwords of default open users for the Oracle database. Password change has no impact on the system.

Context

Perform this task if you need to change the password of the Oracle database default user or the BFM database user. The default users include the sys and system users and the BFM database user refers to the bfm user.

The procedures for changing the passwords of the BFM database user and the Oracle database default user are similar. The only difference is that after changing the password of the BFM database user, you still need to change the value of bme.password in the ${HOME}/bfm/tomcat/webapps/bme/WEB-INF/classes/jdbc.properties configuration file of the BFM.

Changing a Database User Password

Log in to the database server as the oracle user. If the database is deployed in a two-node cluster, log in to the active node.
Connect to the database.
> sqlplus /as sysdba
Change the password of a database user.
SQL> alter user username identified by new password;

The command parameters are described as follows:
- username: indicates the name of a database user.
- new password: indicates a new password of a database user.
NOTICE:
When setting a password, carriers are advised to strengthen the password as follows:
- The length of the new password must be from 8 to 21 bytes.
- The new password must have the following combination of at least three characters:
  - The new password contains at least a lower case letter.
  - The new password contains at least an upper case letter.
  - The new password contains at least a number.
  - The new password contains at least a special character: `~!@#$%^&*()-_=+\|[{}];:'",<.>/? and space.
- The password cannot the same as the name of a user that attempts to log in (including the characters arranged in a reverse order).
The password is successfully changed if the following information is displayed:
```
User altered.
```
Check whether the new password takes effect.
1. Run the exit command to exit the sqlplus.
2. Connect to the database again.
  sqlplus username/new password@$ORACLE_SID
  
  If the connection is successful, the password is changed successfully.