ora-1996
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ora-1996

  1. #1
    Join Date
    Jun 2001
    Posts
    150
    I am getting this error when trying to run the procedure.

    ora-01996
    Does any one know what could be the cause??

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Error: ORA 1996
    Text: GRANT failed: password file is full
    -------------------------------------------------------------------------------
    Cause: The grant failed when a user could not be added to the password file,
    because all available slots in it were used already.
    Action: Either recreate a larger password file or free up slots in the
    password file by revoking the SYSOPER and SYSDBA privileges from some
    of the remote users.
    You can determine which remote users are valid and their privileges by
    issuing the following query in SQL*DBA:
    SELECT * FROM V$REMOTE_USERS;
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jun 2001
    Posts
    150
    well i also got this information but doesn't make sense to me.
    AS there is no user added and no user was deleted. is it related to space in sga???

  4. #4
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    1. Check v$pwfile_users to see the password file users
    2. The issue could be that you have run out of the #password entries, on such case recreate.
    3. If it on NT refer Note:114384.1 from metalink

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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