OraFAQ Forum: Security » GRANT sysdba fails with ORA-01996 (pawwword file full)

Home » RDBMS Server » Security » GRANT sysdba fails with ORA-01996 (pawwword file full)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

GRANT sysdba fails with ORA-01996 (pawwword file full) [message #112223]

Wed, 23 March 2005 15:17

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

Report message to a moderator

Re: GRANT sysdba fails with ORA-01996 (pawwword file full) [message #112231 is a reply to message #112223]

Wed, 23 March 2005 16:03

Frank Naude
Messages: 4579
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

Report message to a moderator

Re: GRANT sysdba fails with ORA-01996 (pawwword file full) [message #112242 is a reply to message #112231]

Wed, 23 March 2005 19:19

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

Report message to a moderator

Re: GRANT sysdba fails with ORA-01996 (pawwword file full) [message #112321 is a reply to message #112242]

Thu, 24 March 2005 07:19

Frank Naude
Messages: 4579
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

Report message to a moderator

Re: GRANT sysdba fails with ORA-01996 (pawwword file full) [message #112756 is a reply to message #112223]

Tue, 29 March 2005 02:26

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 13:04:55 CDT 2024