Instance Settings Stored in SPFile in Oracle

Q

Where Are the Settings Stored for Each Instance in Oracle?

✍: FYIcenter.com

A

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_HOME\database directory. A parameter file should be named like "init$SID.ora", where $SID is the instance name.

⇒ Change Settings in Binary SPFile in Oracle

⇐ Start the Default Instance in Oracle

⇑ Introduction to Oracle Database 10g Express Edition

⇑⇑ Oracle Database Tutorials

2020-09-15, 2298🔥, 0💬