Thanks for the question, Oliver.
Asked: January 19, 2025 - 10:24 am UTC
Last updated: January 24, 2025 - 8:00 am UTC
Version: 19c
Viewed 1000+ times
You Asked
In 11g RAC, the init.ora file points the spfile in ASM, so sqlplus can find it.
but in 19c, sqlplus can startup even without the spfile nor init.ora,
how does that happen?
(I understand when I startup with svrctl , it will create a init.ora automatically)
Thank you.
and Connor said...
It is stored in CRS, eg
crsctl stat res ora.asm -p | egrep "ASM_DISKSTRING|SPFILE"
SPFILE=+DATA/ASM/ASMPARAMETERFILE/....