OracleDB12c New Feature: ASMCMD Commands for Password File Management

Starting with Oracle Database 12c, we can store the ASM and Database password file on ASM storage. This is helpful for RAC databases and cluster as we do not have to manage to keep the files in sync between servers.

ASMCMD in 12c includes several 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 string The --dbuniquename string option identifies the database unique name associated with the password file.

Leave a Reply

%d bloggers like this: