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...
pwdfile
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}...