1Z0-052 · Question #196
View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to start the database instance and open the database…
The correct answer is B. spfile.ora. Oracle searches for parameter files in a fixed priority order, and spfile.ora is the generic SPFILE name that is found before any PFILE when no SID-specific SPFILE exists in $ORACLE_HOME/dbs.
Question
View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance is already running. You used the following steps to start the database instance and open the database:
Which file is used to start the instance in this case?
Exhibits
Options
- Ainit.ora
- Bspfile.ora
- Cinitorcl.ora
- Dspfile+ASM.ora
How the community answered
(25 responses)- A8% (2)
- B88% (22)
- C4% (1)
Why each option
Oracle searches for parameter files in a fixed priority order, and spfile.ora is the generic SPFILE name that is found before any PFILE when no SID-specific SPFILE exists in $ORACLE_HOME/dbs.
init.ora is a generic PFILE name with lower search priority than any SPFILE; Oracle only falls back to PFILE names after exhausting the SPFILE search, and init<SID>.ora would still be preferred over the generic init.ora.
Oracle's parameter file lookup order is: spfile<SID>.ora first, then spfile.ora, then init<SID>.ora; when the exhibit shows spfile.ora present but no SID-specific SPFILE, the instance starts using spfile.ora as the binary server parameter file, which takes precedence over any PFILE.
initorcl.ora is the SID-specific PFILE and is only used if neither spfile<SID>.ora nor spfile.ora is found in the search path, making it lower priority than spfile.ora.
spfile+ASM.ora is the parameter file belonging to the ASM instance, not the database instance; each instance uses its own separate parameter file and the two are not interchangeable.
Concept tested: Oracle parameter file search order SPFILE vs PFILE precedence
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/creating-and-configuring-an-oracle-database.html
Topics
Community Discussion
No community discussion yet for this question.

