Wednesday, September 4, 2013

Oracle 12c Password file management with ASMCMD commands

Now that it is possible to store the Oracle password file inside ASM - Oracle Database 12c. A functionality that helps by RAC databases and cluster, we do not have to manage to keep the files in sync between servers anymore.

 See my other blog posts on this:

Are there commands created for ASMCMD to maintain the passwordfile for databases.
The answer to this question is === YES

ASMCMD in Oracle 12c has several new commands to manage password file

  • pwcopy        Copies a password file to the specified location.
  • pwcreate         Creates a password file at the specified location.
  • pwdelete         Deletes a password file at the specified location.
  • pwget        Returns the location of the password file.
  • pwmove        Moves the location of the password file.
  • pwset        Sets the location of the password file.
  • lspwusr        Lists the users from an Oracle ASM password file.
  • orapwusr         Adds, drops, or changes an Oracle ASM password user.
These commands can manage the Grid Infrastructure ASM password file or the Database password file.

Specify the type of instance using the parameters:

  • --asm                  
        The --asm option associates the password file with the Oracle ASM instance
        that ASMCMD is logged into.
  • --dbuniquename
        The --dbuniquename string option identifies the database unique name
        associated with the password file.