nerdexam
Oracle

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.

Managing the Database Instance

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

1Z0-052 question #196 exhibit 1
1Z0-052 question #196 exhibit 2

Options

  • Ainit.ora
  • Bspfile.ora
  • Cinitorcl.ora
  • Dspfile+ASM.ora

How the community answered

(25 responses)
  • A
    8% (2)
  • B
    88% (22)
  • C
    4% (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.

Ainit.ora

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.

Bspfile.oraCorrect

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.

Cinitorcl.ora

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.

Dspfile+ASM.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

#SPFILE search order#parameter file#instance startup#ASM

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice