This practice shows how the passwords in the password files in Oracle Database 21c are case-sensitive. In earlier Oracle Database releases, password files retain their original case-insensitive verifiers by default. The
IGNORECASE parameter, to enable or disable password file case sensitivity, is removed. All passwords in new password files are case-sensitive.
Before starting any new practice, refer to the Practices Environment recommendations.
Step 1 : Display the password file format of CDB21
Step 2 : Change the
SYS password and verify that the password is now case-sensitive
SYSuser password in the password file.
The usage notes mention all parameters that can be used in the command.
IGNORECASEis not mentioned because it is now a deprecated parameter.
Re-enter the command without the deprecated parameter.
Log on as
Display the list of the users.