Oracle 11g parameter file types and functions

Classification of parameter files:
Spfile:server parameter file
Binary format, out of file system bondage
Can only be placed on server side
Better consistency
Only use SQL commands to modify
SPFile priority is higher than pfile
Naming rules: Spfile<sid>.ora & Spfile.ora

Pfile:parameter file
Text file
Can be placed on the server side can also be side on the client side
Pfile flexible but too many replicas
Can be modified directly using a text editor
Naming rules: Init<sid>.ora

Where to save the parameter file: $ORACLE _home/dbs

Like what:

[email protected] ~]$ ll $ORACLE _home/dbs
Total 28
-RW-RW----1 Oracle oinstall 1544 02:53 Hc_orcl.dat
-rw-r--r--1 Oracle Oinstall 2851 may Init.ora
-rw-r--r--1 Oracle oinstall 5692 June 14:14 Initorcl.ora
-RW-R-----1 Oracle Oinstall 20:33 LKORCL
-RW-R-----1 Oracle oinstall 1536 10:44 ORAPWORCL
-RW-R-----1 Oracle oinstall 2560 11:44 Spfileorcl.ora

This article is from the "Liang blog" blog, make sure to keep this source http://7038006.blog.51cto.com/7028006/1841939

Oracle 11g parameter file types and functions