Hello Friends,
This post we will discuss about error OPW-00010: Could not create the password file. This resource has a Password File.
In our case file was not present in location and it was present in config of database ,Error OPW-00010 occurred when we attempted to create one. Password file creation failed. While doing so, a Password File for this resource.
[oracle@dm01db01 ~]$ orapwd dbuniquename=CDBRAT file='+DATAC2/CDBRAT/PASSWORD/pwdcdbrat' entries=10
Enter password for SYS:
OPW-00010: Could not create the password file. This resource has a Password File.
[oracle@dm01db01 ~]$ srvctl config database -d CDBRAT
Database unique name: CDBRAT
Database name: CDBRAT
Oracle home: /u02/app/oracle/product/19.0.0.0/dbhome_3
Oracle user: oracle
Spfile: +DATAC2/CDBRAT/PARAMETERFILE/spfile.302.1129568937
Password file: +DATAC2/CDBRAT/PASSWORD/pwdcdbrat.262.1129568131 -----Wrong pwd file / non available file
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Indeed, the password file's location has been set, however the file mentioned is wrong.
Because of this, we need to make a password file for it.
The error code OPW-00010 indicates that the RAC database configuration contained a password file with a name that differed from the one you supplied.
Oracle won't permit you to make a new password file and overwrite the configured one in order to safeguard it.
Solution :
In order to fix OPW-00010, we need change the location of the password file to make it appear as though there isn't one at the moment.
[oracle@dm01db01 ~]$ srvctl config database -d CDBRAT
Database unique name: CDBRAT
Database name: CDBRAT
Oracle home: /u02/app/oracle/product/19.0.0.0/dbhome_3
Oracle user: oracle
Spfile: +DATAC2/CDBRAT/PARAMETERFILE/spfile.302.1129568937
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Create new password file :
[oracle@dm01db01 ~]$ orapwd dbuniquename=CDBRAT file='+DATAC2' entries=10
Enter password for SYS:
[oracle@dm01db01 ~]$
ASMCMD> ls -l
Type Redund Striped Time Sys Name
PASSWORD HIGH COARSE MAR 21 19:00:00 Y pwdcdbrat.270.1132082551
ASMCMD> pwd
+DATAC2/CDBRAT/PASSWORD
New password file updated .
[oracle@dm01db01 ~]$ srvctl config database -d CDBRAT
Database unique name: CDBRAT
Database name: CDBRAT
Oracle home: /u02/app/oracle/product/19.0.0.0/dbhome_3
Oracle user: oracle
Spfile: +DATAC2/CDBRAT/PARAMETERFILE/spfile.302.1129568937
Password file: +DATAC2/CDBRAT/PASSWORD/pwdcdbrat.270.1132082551
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
ConversionConversion EmoticonEmoticon