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>
No comments:
Post a Comment