Basic Oracle Concepts and Programming Question:

Where Are the Settings Stored for Each Instance in Oracle?

Oracle Database Interview Question
Oracle Database Interview Question

Answer:

Settings for each instance are stored in a file called Server Parameter File (SPFile). Oracle supports two types of parameter files, Text type, and Binary type. parameter files should be located in $ORACLE_HOMEdatabase directory. A parameter file should be named like "init$SID.ora", where $SID is the instance name.


Previous QuestionNext Question
How To Use "startup" Command to Start Default Instance?What To Do If the Binary SPFile Is Wrong for the Default Instance?