What is the use of spfile and init.ora in oracle?

init.ora and SPfile both contain information about DB parameters.

The database cannot start without an INIT.ORA but can start without an SPfile.

An SPfile cannot be edited directly , but one can be configured via the pfile (init.ora)

Init.ora is saved in ascii text format whereas the SPfile is saved in a binary format.

If both files exist , the database reads the SPfile first before processing the init.ora.

Oracle Guru's step in and correct if necessary .......... :)

,

Lekarshi

Improve Answer Discuss the question "What is the use of spfile and init.ora in oracle?" Watch Question

First answer by ID3412420354. Last edit by ID3412420354. Question popularity: 0 [recommend question]

Research your answer:

Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Databases > What is the use of spfile and init.ora in oracle?

Our contributors said this page should be displayed for the questions below. (Where do these come from)
If any of these are not a genuine rephrasing of the question, please help out and edit these alternates.
What does INIT mean?  What you s init in zobie state?