ORA-01996
GRANT failed: password file 'string' is full
Cause
The grant failed when a user could not be added to the password file, because all available slots in it were used already.
Action
Either create a larger password file or free up slots in the password file by revoking the SYSOPER and SYSDBA privileges from some of the remote users. You can determine which remote users are valid and their privileges by issuing the following query in SQL*DBA:
SELECT * FROM V$REMOTE_USERS;
ORA-01996
GRANT failed: password file 'string' is full
Cause
The grant failed when a user could not be added to the password file, because all available slots in it were used already.
Action
Either create a larger password file or free up slots in the password file by revoking the SYSOPER and SYSDBA privileges from some of the remote users. You can determine which remote users are valid and their privileges by issuing the following query in SQL*DBA:
SELECT * FROM V$REMOTE_USERS;
ORA-01996
GRANT failed: password file 'string' is full
Cause
The grant failed when a user could not be added to the password file, because all available slots in it were used already.
Action
Either create a larger password file or free up slots in the password file by revoking the SYSOPER and SYSDBA privileges from some of the remote users. You can determine which remote users are valid and their privileges by issuing the following query in SQL*DBA:
SELECT * FROM V$REMOTE_USERS;