STechno

Note 601157 - Oracle9i: Server Parameter File

Header
Version / Date 35 / 2007-07-02
Priority Recommendations/additional info
Category Upgrade information
Primary Component BC-DB-ORA Oracle
Secondary Components BC-DB-ORA-DBA Database Administration with Oracle

Summary
Symptom


Oracle Server Parameter File (SPFILE)

The Oracle Server Parameter File (SPFILE) is a new feature available as of Oracle Release 9i. This note describes how to use the SPFILE rather than the Oracle parameter file init<SID>.ora (short: init.ora).

The following designations are used in this note:

  • <SID> is the <ORACLE_SID> which is the unique indicator of an Oracle database instance. This is not to be confused with the <SAPSID>, the SAP system ID (unique indicator of an SAP system).
  • init.ora is used as a synonym for the known Oracle parameter file init<SID>.ora.
  • SPFILE is the short form for Server Parameter File.

Oracle profile file, init<SID>.ora and init.ora (short form) are synonyms for the known Oracle parameter file.

SPFILE (short form), server-side parameter file, and sometimes also persistent parameter file are used as synonyms for the server parameter file spfile<SID>.ora.


Reason and Prerequisites



Documentation and migration note for Oracle9i: SPFILE

Solution
https://service.sap.com/sap/support/notes/601157 (SAP Service marketplace login required)

Key words :    ,   sql>, init< sid>, alter system, scope spfile, sql> create, system parameters, sql> alter, spfile< sid>, sql> select, spfile   , active spfile,   event, parameter changes, sql> connect, server parameter, create pfile, file   , sysdba   , standard location,   where, oracle parameter, parameter name>, create spfile,   setting, oracle server, setting system, default location, system reset, context forever, spfile sql>, command variant, issys modifiable, static parameters, incorrect parameter,   scope, current instance, spfile using, init< dbsid>, underscore parameters, special features, scope clause, scope memory, inconsistent spfile, spfile spfile, error message, parameter value,

Related Notes
1178409ORA-32021: parameter value longer than 255 characters
948197Merge fix for DBMS_STATS package on Oracle 9.2.x and 10.2.x
848708Oracle Database Configuration for NWDI server
830576Parameter recommendations for Oracle 10g
773173Using Oracle Fail Safe cluster on Windows with SPFILE
647697BRSPACE - New tool for Oracle database administration
598678Oracle 9i: New functions
596423Events and SPFILE