Cause
An attempt was made to perform one of the following operations, but none of these operations are allowed while the initialization parameter REMOTE_LOGIN_PASSWORDFILE is set to SHARED and the password file is in read-only mode:
- Attempting to change the password for an administrative privileged user either using ALTER USER DDL statement or SQL*Plus PASSWORD command, or OCIPasswordChange API.
- Attempting to grant administrative privileges to a user.
- Attempting to revoke administrative privileges from a user.
- Attempting to drop an administrative privileged user.
If the password file was created in 12.2 format, then the following additional operations are disallowed when the REMOTE_LOGIN_PASSWORDFILE parameter is set to SHARED:
- An ALTER USER DDL statement making changes to an administrative privileged user's account status, password profile assignment, identification type, or password expiration timestamp.
- An ALTER PROFILE or DROP PROFILE CASCADE DDL statement for a password profile, which is assigned to an administrative privileged user.
Action
Set the REMOTE_LOGIN_PASSWORDFILE parameter to EXCLUSIVE, ensure that the file is writable, and restart the database instance. Then retry the operation.