During starting RAC Database always finding local pfile
Hi there
I just configured RAC database with Data guard. OS Oracle Linux 7.8 and DB 19C. Data guard was also RAC two nodes instance which was configured manually.
Problem is , when I am trying to start physical standby node , it is always searching local parameter file instead of ASM stored spfile.
SQL> startup nomount;
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/19.3.0.0/dbhome1/dbs/initracstby2.ora'
I was created spfile as under in standby db
SQL> create spfile='+DATA/RACSTBY/PARAMETERFILE/spfile_new.ora' from pfile='/u01/dg-rac/pfile_prod_new.ora';