ERROR
Sometimes when granting SYSDBA privileges to any particular user, an error message might be encountered like below.
ERROR at line 1:
ORA-01996: GRANT failed: password file
'C:\app\snoop\product\11.2.0\dbhome_1\DATABASE\PWDorcl.ORA' is full
REASON
This happens if there are already maximum number of users who have been granted SYSDBA privileges, hence the password file is full( the password file has a limit on no. of passwords that it can accommodate. Default is 5).
RESOLUTION
There are 2 ways of getting out of this problem:
a)Create a larger password file as it has become full.
b)Revoke the SYSDBA privilege from some of the remote users. Such users and their
privileges can be found by querying the dictionary view V$REMOTE_USERS.
No comments:
Post a Comment