Oracle Instance based on OracleDBA (2)

When Oracle starts, it needs to read the initialization parameter file
Text File Format: PFILE
$ ORACLE_HOME/dbs directory
Create PFILE
DBCA
Manually created
Cp init. ora $ ORACLE_HOME/dbs/initSID. ora
Modify initSID. ora
After dbca creates a database, spfileSID. ora is used by default when Oracle is started.
In general, we do not need init. ora to create pfile, because init. ora is too old and oracle8 is used.

SPFILE
Binary file
Maintained by Oracle Server and modified by SQL/plus
Always on the server side,
Backup initialization parameter file
Cannot be modified using vi
To create a spfile, you must have SYSDBA permission to execute
Create spfile = '$ ORALCE_HOE/dbs/spfileSID. ora' from pfile = '$ ORALCE_HOME/dbs/initSID. ora ';
It can be started before or after startup.
Sqlplus/nolog
Conn/as sysdba
Create spfile from pfile; // create the default spfile
File created;
View spfile content
Strings spfileSID. ora | more
You can use V $ SPPARAMETER to view spfile parameters.

 

This article is from "houzhh"