Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2009
    Posts
    32

    Unanswered: How to increase the number of entries in password file?

    If we have to drop the password first, what attention do we need to pay?
    Many thanks in advance

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    Quote Originally Posted by SQL ORACLE View Post
    If we have to drop the password first, what attention do we need to pay?
    Many thanks in advance
    To which password file are you referring to?
    If it's the one under ORACLE_HOME/dbs, then:
    Code:
    ==> orapwd -h
    Usage: orapwd file=<fname> password=<password> entries=<users> force=<y/n> nosysdba=<y/n>
    
      where
        file - name of password file (mand),
        password - password for SYS (mand),
        entries - maximum number of distinct DBA,
        force - whether to overwrite existing file (opt),
        nosysdba - whether to shut out the SYSDBA logon (opt for Database Vault only).
      There are no spaces around the equal-to (=) character.
    Otherwise if you refer to the password (user) table in the database, just increase the space allocated to the system tablespace.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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