2008.12.28ManagingOracleInstance(PFILE&SPFILE)

Initialization Parameter Files

 

$connect / as sysdba

$startup

spfiledb01.ora

 

Parameter file:

Pfile--Static parameter file

Spfile--Persistent server parameter file

$id

$clear scr

 

SQL>desc v$parameter;

SQL>select name,value  from v$parameter where ;

SQL>col name format a20

SQL>col value format a30

SQL>show parameter pga_ag

SQL>show parameter sga;

 

●PFILE initSID.ora (start)启动时加载,修改时最好参照现成的成功文件,不要用init.ora (太老).

      具体参数可以参照联机文档,Reference

text file;

changes take effect on the next startup

default location is $oracle_home/dbs     linux

                     $oracle_home/database win

$env | grep ORACLE_HOME

$env | grep PATH

SID:Site Identifier

set the enviorment parameter

  ORACLE_BASE=     (about oracle )   

  ORACLE_HOME=     (A database)

  ORACLE_SID=

  PATH =$ORACLE_HOME/bin:$PATH

 

 ●SPFILE   spfileSID.ora

binary file;

・Create from a pfile file

SQL>create spfile='$ORACLE_HOME/dbs/spfileDBA01.ora'from pfile='$ORACLE_HOME/dbs/initDBA01.ora'

 

$Strings spfilewilson.ora | more

(print the strings of printable characters in files)

 

mordify the spfile

SQL>ALTER SYSTEM SET PARAMETER=VALUEcomments)>the next time change)>default)>

SQL>show parameter

SQL>!

$string spfilewilson.ora

SQL>desc v$parameter

SQL>alter system set XX=XXX

SQL>alter system reset XX sid='SID' 

 

SPFILE vs PFILE

Spfile is better than pfile!