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)

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