grant dba,sysdba,sysoper to sysman fails!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: grant dba,sysdba,sysoper to sysman fails!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    Hi all!

    Query:

    Working on Oracle v8i 8.1.6.0.0 with OS NT.

    I am receiving the following error as under:

    sql>conn internal/oracle@rman
    Connected.
    SQL>
    SQL> grant dba,sysdba,sysoper to sysman;
    grant dba,sysdba,sysoper to sysman
    *
    ERROR at line 1:
    ORA-01996: GRANT failed: password file
    'D:\Oracle\Oracle8i\DATABASE\PWDrman.ORA' is full

    Thanks & Regards,

    Amit.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    the error is clear, password file is full you have to recreate the password file with orapwd and increment entries parameter

  3. #3
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    When you create Password file with orapwd utility, you specify entries=n which means the maximum number of entries it can take. Once it is full, there is no way you can grant additional sysdba/ sysoper roles.
    You have to delete and recreate password file. This time be sure to have enough entries specified so that it can accomodate future anticipated growth. Deleting and recreating password file is risky.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width