Search This Blog

Total Pageviews

Thursday 24 August 2023

OPW-00010: Could not create the password file. This resource has a Password File.

OPW-00010: Could not create the password file. This resource has a Password File.






orapwd file='+DATA/orapwibrac' ENTRIES=10 DBUNIQUENAME=ibrac

Enter password for SYS:

OPW-00010: Could not create the password file. This resource has a Password File.

[grid@irac01 ~]$



srvctl config database -d ibrac
Database unique name: ibrac
Database name:
Oracle home: /u01/app/oracle/product/12.2.0/dbhome_1
Oracle user: oracle
Spfile: +data/IBRAC/PARAMETERFILE/spfile.4018.1145682969  --- as password file already in  this config 
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: oinstall
OSOPER group: oinstall
Database instances: ibrac1,ibrac2
Configured nodes: ibrac01,ibrac02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@ibrac01:~] $


                                  
modify without password file 
srvctl modify database -d ibrac -pwfile



[oracle@irac01:~] $srvctl config database -d ibrac
Database unique name: ibrac
Database name:
Oracle home: /u01/app/oracle/product/12.2.0/dbhome_1
Oracle user: oracle
Spfile: +data/IBRAC/PARAMETERFILE/spfile.4018.1145682969
Password file:                                             <<<<<<< now no password file !!!
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: oinstall
OSOPER group: oinstall
Database instances: ibrac1,ibrac2
Configured nodes: ibrac01,ibrac02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed



run again!!!

orapwd file='+DATA/orapwibrac' ENTRIES=10 DBUNIQUENAME=ibrac

Enter password for SYS:


ASMCMD [+] > ls -l +DATA/IBRAC/PASSWORD/
Type      Redund  Striped  Time             Sys  Name
PASSWORD  UNPROT  COARSE   AUG 24 08:00:00  Y    pwdibrac.4019.1145693377
ASMCMD [+] >


srvctl modify database -d ibrac -pwfile +DATA/IBRAC/PASSWORD/pwdibrac.4019.1145693377



SQL> alter user sys identified by sys ;  <<< change the password again :)

User altered.

SQL>



Oracle DBA

anuj blog Archive