Oracle - Instance Settings Stored in SPFile in Oracle

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.

⇒Introduction to Oracle Database 10g Express Edition

⇒⇒Oracle Database Tutorials

2016-10-16, 424👍, 0💬

Popular Posts:

Verifying SQL Server...

How do you know if SQL Server is running on your local system in SQL Server? After installing SQL Se...

What Is Microsoft SQ...

What is Microsoft SQL Server in SQL Server? Microsoft SQL Server is a relational database management...

Import One Table bac...

How To Import One Table Back from a Dump File in Oracle? If you only want to import one table back t...

IF ... ELSE Statemen...

How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...

sys.server_principal...

How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...