pwdfile

ORA-01994: GRANT failed: password file missing or disabled

While granting SYSDBA role to a database user, got below error. SQL> grant sysdba to DEV_DB; grant sysdba to DEV_DB * ERROR at line 1: ORA-01994: GRANT failed: password file missing or disabled SOL...

orapwd tool for password file in oracle

The password file stores a list of usernames and passwords that are allowed to remotely authenticate as SYSDBA over the network. Oracle must use this file to authenticate them, not the normal list of ...

Create password files for database in ASM diskgroup

Below are the steps for creating password file for database in ASM diskgroup . This method is valid only for oracle 12c onwards. SYNTAX – ASMCMD> pwcreate –dbuniquename {db_unique_name}...