Oracle Database - (initialization|server) parameter file (init.ora | spfile.ora)

Card Puncher Data Processing

About

How to manage the initialization parameters when the database start.

Management

File Location

By default, the preconfigured database uses a parameter file (spfile) named spfilesid.ora, which is stored in the $ORACLE_HOME/dbs directory (dbs stands for database) .

db_name='ORCL'
memory_target=1G
processes = 150
audit_file_dest='<ORACLE_BASE>/admin/orcl/adump'
audit_trail ='db'
db_block_size=8192
db_domain=''
db_recovery_file_dest='<ORACLE_BASE>/fast_recovery_area'
db_recovery_file_dest_size=2G
diagnostic_dest='<ORACLE_BASE>'
dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
open_cursors=300 
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
# You may want to ensure that control files are created on separate physical
# devices
control_files = (ora_control1, ora_control2)
compatible ='11.2.0'

However, if you choose Automatic Storage Management for the database, Database Configuration Assistant typically uses the same storage mechanism for the server parameter file.

If the server parameter file is not located in the ORACLE_HOME/dbs directory, the database uses the SPFILE parameter in an initialization parameter file to locate it. The default initialization parameter file is ORACLE_HOME/dbs/initsid.ora.

list all initialization parameters

You can use the Oracle Enterprise Manager Database Control to view the location of the server parameter file and list all of the initialization parameters, as follows:

  • Log in to the Database Control.
  • Click Server.
  • In the Database Configuration section of the Server page, click Initialization Parameters.

Enterprise Manager displays a table listing the current value of each initialization parameter.

  • Select the SPFile tab.

Enterprise Manager displays a table listing the value of each initialization parameter specified in the server parameter file. The location of the server parameter file is displayed on top of the page.

In SQL Plus

The following command determine whether the system uses:

  • an initialization parameter file (initsid.ora)
  • or a server parameter file (spfiledbname.ora)
SQL> show parameter pfile;

NAME      TYPE        VALUE
--------- ----------- -------------------------------------------------------------
spfile    string      C:\APP\GERARD\PRODUCT\11.2.0\DBHOME_1\DATABASE\SPFILEORCL.ORA





Discover More
Oracle Database Standard Installation Parameters
Oracle Database - (Initialization|System) Parameters

Parameter are global variable. Their values are initialized from a file during the start of the Oracle Database. environment variable The SCOPE of a parameter Scope depends on whether you started...
Oracle Database 12c Step 12
Oracle Database - 12c Installation on Windows 64 bit

Installation of Oracle Database 12c (12.1.0.1.0) on Windows. You can download the oracle software from OTN or better...
Card Puncher Data Processing
Oracle Database - Control Files

Every Oracle database has a control file. Every time an instance of an Oracle database is started, its control file identifies the physical structure: the datafiles, the tempfiles, and redo...
Oracle Registry Windows
Oracle Database - Environment Variables / Registry Values

To configure the database installation, Oracle provide several Environment variable / Registry Value. : oracle_sid is used for a local connection - direct to the server - without using a listener...
Card Puncher Data Processing
Oracle Database - Oracle base directory (ORACLE_BASE)

The Oracle base directory is a top-level directory for Oracle software installations. environment variable The Optimal Flexible Architecture (OFA) guidelines recommend that you use a path similar...
Card Puncher Data Processing
Oracle Database - Parameter Files

Parameter files contain a list of configuration parameters for that instance and database. Both parameter files (pfiles) and server parameter files (spfiles) let you store and manage your initialization...
Card Puncher Data Processing
Oracle Database - Physical Database Structures (Files)

Oracle Database files include: data files, temporary files, control files, the server parameter file, the password file. redo log files, Archived Redo Log Files Parameter Files Alert...



Share this page:
Follow us:
Task Runner