Start an instance & reads instance configuration parameters (initialization parameters) - Oracle DBA

Q.  What should a database do to start an instance and it should read the instance configuration parameters (the initialization parameters)?
- Published on 30 Jul 15

a. SPFILE
b. PFILE
c. Both A & B
d. None of the above

ANSWER: Both A & B
 

    Discussion

  • Nirja Shah   -Posted on 25 Aug 15
    -To start an instance, the database must read instance configuration parameters (the initialization parameters) from either a server parameter file (SPFILE) or a text initialization parameter file.

    -SPFILE - The value of this parameter is the name of the current server parameter file (SPFILE) in use.
    -This parameter can be defined in a client side PFILE to indicate the name of the server parameter file to use.
    -When the default server parameter file is used by the server, the value of SPFILE is internally set by the server.

    -PFILE - PFILE is created using the CREATE PFILE statement.
    -Upon successful execution of this statement, Oracle Database creates a text parameter file on the server.
    -In a Real Application Clusters environment, it will contain all parameter settings of all instances.
    -It will also contain any comments that appeared on the same line with a parameter setting in the server parameter file.

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.)