Database - RAC/Scalability (MOSC)

MOSC Banner

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';

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center