Oracle Database locates your initialization parameter file by examining filenames - Order - Oracle DBA

Q.  In the platform-specific default location, Oracle Database locates your initialization parameter file by examining filenames in which of the following order?
- Published on 12 Aug 15

a. spfile$ORACLE_SID.ora, init$ORACLE_SID.ora, spfile.ora
b. spfile.ora, spfile$ORACLE_SID.ora, init$ORACLE_SID.ora
c. spfile$ORACLE_SID.ora, spfile.ora, init$ORACLE_SID.ora
d. Intit$ORACLE_SID.ora, spfile.ora, spfile$ORACLE_SID.ora

ANSWER: spfile$ORACLE_SID.ora, spfile.ora, init$ORACLE_SID.ora

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 24 Aug 15
    -When you start the database instance, it attempts to read the initialization parameters from an SPFILE in a platform-specific default location.

    -If it finds no SPFILE, it searches for a text initialization parameter file.

    -In the platform-specific default location, Oracle Database locates your initialization parameter file by examining file names in the following order:

    -spfileORACLE_SID.ora
    -spfile.ora
    -initORACLE_SID.ora

    -The first two files are SPFILEs and the third is a text initialization parameter file.

    -If DBCA created the SPFILE in an Oracle Automatic Storage Management disk group, the database searches for the SPFILE in the disk group.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲