Posted on 2008-11-13
ORA-01996: GRANT failed: password file is full.
We have to create multiple user accounts with SYSDBA system privilege. All the existing users
and the new users must have the SYSDBA privilege.
I tried to create a user with sysdba system privilege. I got the following Oracle error:
ORA-01996: GRANT failed: password file is full
I queried the v$pwfile_users view and got the following output:
SQL> select count(*) from v$pwfile_users
Please clarify the following:
1. How do I find out how many entries are there in the current password file?
2. How do I modify the password file and increase the number of entries to 30? What are
the steps to increase the number of entries to 30?
3. Should a current password file be deleted?
4. Will all the users with the sysdba sysdba privilege be dropped when the password file is deleted?
Or, will the users be there in the database and only the sysdba privilege revoked?
5. If the current password file has to be deleted, how do I save the user accounts
6. How do I drop the current password file?
7. How do I create a new password file? Please let me know the steps.
8. Do I have to re-create user accounts with sysdba system privilege when I create the new
password file or just grant the sysdba system privilege to the users?
9. Should the new password file have the same name as the old password file name?
10. What is location of the password file?
11. Should I shutdown and re-start the database after dropping and recreating the new password
12. Should I restart the Oracle Service after re-creating the password file?
13. If the password file has to be deleted to increase the number of entries, will I able to login as SYS to do the DBA tasks when there is no password file?
14. How can I do the DBA tasks with a password file?
15. Do I have to keep a backup of the old password file in order to re-create the user in the new password file?
16. What will happen to the users during the time the current password file is deleted, the new password file is created, and the users recreated? Will they be able to use the database?
The ORA-01996: GRANT failed: password file is full has to be fixed in about forty database.
Please let me know how the above error can be quickly fixed in all the databases. I am concerned about the users when the password file is deleted.
This is a high priority task.