Hello,
I manually deleted a password file in ASM.
Now, when I try to to create a new one or add to password file I get these errors:
SQL> grant sysdba to mike;
grant sysdba to mike
*
ERROR at line 1:
ORA-01994: GRANT failed: password file missing or disabled
ORA-17503: ksfdopn:2 Failed to open file
+DATA/STRLN/PASSWORD/pwdstrln.356.907777681
ORA-15173: entry 'PASSWORD' does not exist in directory 'STRLN'
ORA-06512: at line 4
ORA-17503: ksfdopn:2 Failed to open file
+DATA/STRLN/PASSWORD/pwdstrln.356.907777681
ORA-15173: entry 'PASSWORD' does not exist in directory 'STRLN'
ORA-06512: at line 4
***********************************************************************************************************************************************************************************
[grid@dev-oracle001 trace]$ srvctl config database -d STRLN
Database unique name: STRLN
Database name: STRLN
Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/STRLN/PARAMETERFILE/spfile.363.907779573
Password file: +DATA/STRLN/PASSWORD/pwdstrln.356.907777681
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA,FRA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: dba
OSOPER group:
Database instances: STRLN1,STRLN2
Configured nodes: dev-oracle001,dev-oracle002
Database is administrator managed
*****************************************************************************************************************************************************************************************
ASMCMD> ls
DATAFILE/
PARAMETERFILE/
TEMPFILE/
ASMCMD> pwd
+data/strln
*****************************************************************************************************************************************************************************************
Clusterware still sees as password file there:
Password file: +DATA/STRLN/PASSWORD/pwdstrln.356.90777768
When I try to add to password file I get msg that it does not exist:
ORA-17503: ksfdopn:2 Failed to open file
+DATA/STRLN/PASSWORD/pwdstrln.356.907777681
ORA-15173: entry 'PASSWORD' does not exist in directory 'STRLN'
File physically does not exist. How do I go about getting clusterware to not recognize password file so that I can create a new one with the following command:
$ orapwd file='+DATA' force=y entries=10 password=oracle asm=y
When I run the command above to create one it returns without any errors. However, it does not create the password file in ASM.
Thank you in advance for any assistance with this!
Mike