ORA-01999
The database password file cannot be updated while the REMOTE_LOGIN_PASSWORDFILE parameter is in SHARED mode.
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.
ORA-01999
password file cannot be updated in SHARED mode
Cause
An attempt was made to perform one of the following operations, but none of these operations are allowed while the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE is set to SHARED and password file is in READ ONLY mode.
- Attempting to change 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 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, 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 INIT.ORA parameter to EXCLUSIVE, shutdown and restart the database instance and retry the operation.
ORA-01999
password file cannot be updated in SHARED mode
Cause
An attempt was made to perform one of the following operations, but none of these operations are allowed while the INIT.ORA parameter REMOTE_LOGIN_PASSWORDFILE is set to SHARED and password file is in READ ONLY mode.
- Attempting to change 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 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, 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 INIT.ORA parameter to EXCLUSIVE, shutdown and restart the database instance and retry the operation.