<<Back to DB Administration Main Page
OPW-00014: Could not delete password file
$orapwd FILE='+DG_TEST_DATA/testa/orapwtesta' delete=yOPW-00014: Could not delete password file +DG_TEST_DATA/testa/orapwtesta.
RESOURCE LIST: ora.testa.db
Solution
Use the below command to delete the Password File
$orapwd delete=y dbuniquename=testa <= for database
$orapwd delete=y asm=y <= for ASM
OPW-00029: Password complexity failed for SYS user
$orapwd FILE='+DG_TEST_DATA/testa/orapwtesta' ENTRIES=4 DBUNIQUENAME='testa' FORMAT=12.2Enter password for SYS:
OPW-00029: Password complexity failed for SYS user : Password must contain at least 8 characters.
Solution
1) Use Complex password
- Password must contain at least 8 characters
- Password must not contain double quotes
- Password must contain at least 1 letter
- Password must contain at least 1 digit
- Password must contain at least 1 special character
- Password must not contain the username
- Password must not contain username reversed
$orapwd FILE='+DG_TEST_DATA/testa/orapwtesta' ENTRIES=4 DBUNIQUENAME='testa' FORMAT=12
Enter password for SYS:
OPW-00001: Unable to open password-file
$ orapwd file='/u01/PWDtesta.ora'Enter password for SYS:
OPW-00001: Unable to open password-file
Solution
1) Check whether the specified location in file= exists if not then create it
1) Check if the user has permission to create file in the specified location if not the grant oracle user proper permission on the mentioned directory
ORA-01994: GRANT failed: password file missing or disabled
SQL> grant sysdba to pfile_test;grant sysdba to pfile_test
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
Solution
1) Check if the password file exists and correctly named. Password file name must be orapw$ORACLE_SID and should be present in $ORACLE_HOME/dbs or ASM DG
2) Check if remote_login_password_file parameter is set, It should be either shared or exclusive. It must not be set to none which disables to use the password file functionality
Comments
Post a Comment