Home » RDBMS Server » Security » GRANT sysdba fails with ORA-01996 (pawwword file full)
GRANT sysdba fails with ORA-01996 (pawwword file full) [message #112223] Wed, 23 March 2005 15:17 Go to next message
bill mcbride
Messages: 12
Registered: May 2003
Junior Member
Hello,

I created user "backup_admin" for the RMAN process. When granting sysdba priviledge to this user, I get ora-01996, password file is full.

I ran select * from v$remote_users but this table or view does not exist.

Please suggest a fix for this. Any help appreciated!

Thanks,

Bill
Re: GRANT sysdba fails with ORA-01996 (pawwword file full) [message #112231 is a reply to message #112223] Wed, 23 March 2005 16:03 Go to previous messageGo to next message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
Recreate your password file with more entries.

$ orapwd
Usage: orapwd file=<fname> password=<password> entries=<users> force=<y/n>

  where
    file - name of password file (mand),
    password - password for SYS (mand),
    entries - maximum number of distinct DBA and OPERs (opt),
    force - whether to overwrite existing file (opt),


Best regards.

Frank
Re: GRANT sysdba fails with ORA-01996 (pawwword file full) [message #112242 is a reply to message #112231] Wed, 23 March 2005 19:19 Go to previous messageGo to next message
bill mcbride
Messages: 12
Registered: May 2003
Junior Member
Hi Frank,

Thanks for your response. Will this preserve the contents of the current file or will I need to rebuild the whole thing, OR can I just extend the number of users?

Thanks for your help!

Regards,

Bill
Re: GRANT sysdba fails with ORA-01996 (pawwword file full) [message #112321 is a reply to message #112242] Thu, 24 March 2005 07:19 Go to previous messageGo to next message
Frank Naude
Messages: 4570
Registered: April 1998
Senior Member
I'm afraid you will have to rebuild it from scratch. Do a select from v$pwfile_users to see what's in it.

Best regards.

Frank
Re: GRANT sysdba fails with ORA-01996 (pawwword file full) [message #112756 is a reply to message #112223] Tue, 29 March 2005 02:26 Go to previous message
sunil_v_mishra
Messages: 506
Registered: March 2005
Senior Member
hi,

Now if your password file is full then do one thing revoke privilige of sysdba from few user those who dont required this privileges. probably by doing this you dont have to create new password file other wise you have to create passwordfile

Note:- by revoking sysdba privileges from user that means you are removing user from password file .

Well you can try above mention things .... as i dont have much time coz of my work so i had not tried that thing ... so whatever will be the result please let me know..

thank you

friend
sunil

Previous Topic: Grant privileges on table to user
Next Topic: CREATE USER role
Goto Forum:
  


Current Time: Sun Dec 05 08:04:23 CST 2021