Oracle Startup and SPFile file ____oracle

The use of parameter files in Oracle startup generally has the following situations 1 Single Instance 1.1 starts by default:

In non-RAC environments, the parameter files for Oracle databases are placed by default in the $oracle_home/dbs directory, and the order in which Oracle automatically looks for parameter files is

Spfile$oracle_sid.ora-> Spfile.ora-> init$oracle_sid.ora 1.2 Manually specify parameter files

You can also manually start a non-default pfile and SPFile file

STARTUP PFILE =/u01/oracle/dbs/myinit.ora

If you want to start a non-default spfile file, it is recommended that you use the following methods:

Pfile file Startup

STARTUP PFILE =/u01/oracle/dbs/spf_init.ora

Specify the location of the SPFile file in the Pfile file with the SPFile parameter

Cat/u01/oracle/dbs/spf_init.ora

SPFILE = use parameter files under/u01/oracle/dbs/test_spfile.ora 1.3 asm and bare devices

If you are using a raw device or ASM to store spfile files, it is common practice to

Modify the default Pfile file

VI $ORACLE _home/dbs/init$oracle_sid.ora

Spfile= ' +data/tyolap/spfile/spfile$oracle_sid.ora ' 2 RAC Environment

In Oracle RAC environments, the situation is slightly more complex, pfile startup is similar to Single-instance, and each instance sets its own Pfile file. While SPFile is started, it is generally recommended that spfile files be placed on shared storage 2.1 sqlplus boot 2.1.1 Shared storage is a raw device or ASM

If the shared storage is a raw device, the official document recommends a pfile connection, and the bare devices are more common in Oracle 10g RAC versions, as follows

1, use the default Pfile file for each instance to start

$ORACLE _home/dbs/init$oracle_sid.ora

2,pfile files point to shared SPFile

Spfile= '/dev/vx/rdsk/vg_zw_data1/lv_zw_spfile '

If you use ASM to place the SPFile file, the SPFile parameter points to the path in ASM

Spfile= ' +disk_group_name/dbunique_name/spfiledbname.ora ' 2.2 srvctl boot 2.2.1 The parameter file is not configured in OCR.

Start with Sqlplus, find in default directory

[oracle@dtydb5 ~]$ srvctl config database-d ms4adb-a
database unique name:ms4adb
database name:ms4adb
Orac Le home:/oracle/app/oracle/product/11.2.0/db_1
Oracle user:oracle
Spfile: +data/ms4adb/spfiletest.ora
Domain: 
Start options:open
Stop options:immediate
Database role:primary
Management policy:automatic
Server pools:ms4adb
Database instances:ms4adb1,ms4adb2,ms4adb3
Disk groups:data
Mount Point paths:< C14/>services: 
Type:rac The
database is enabled the database is
administrator managed

2, the parameter file uses the configuration under the default path

SYS@TYOLAP3 (DTYDB5) > show parameterpfile
NAME                                 TYPE        VALUE
spfile                               string      +data/ Tyolap/spfile/spfilety.ora

2.2.2 Configured the location of the parameter file

If a parameter file exists, the parameter file is used, which means that the parameter file configured in OCR is preferred.

First modify the SPFile file in OCR

Srvctl Modify database-d ms4adb-p ' +data/ms4adb/spfiletest.ora '
 [oracle@dtydb5 ~]$, Srvctl start database-dms4adb< C1/>SYS@MS4ADB3 (DTYDB5) > show parameterspfile
 NAME                                 TYPE                   VALUE

------------------------------- ---------------------------------------------------------
spfile                               string                 +data/ms4adb/ Spfiletest.ora 

The parameter file configured in 2.2.3 OCR does not exist

To start the error, and will not go to the $oracle_home/dbs directory down to find

[ORACLE@DTYDB5 ~]$  srvctl Modify database-d ms4adb-p ' +data/ms4adb/spfilems4adb_bak.ora '
[ORACLE@DTYDB5 ~]$ Srvctl stop database-dms4adb
[oracle@dtydb5 ~]$ srvctl start database-dms4adb
prcr-1079:failed to start resour Ceora.ms4adb.db
crs-5017:the Resource Action "ora.ms4adb.db start" encountered the following error:
ORA-01078: Failure in processing SystemParameters
ora-01565:error in identifying file ' +data/ms4adb/spfilems4adb_bak.ora '

In short: If the use of Srvctl startup, priority is to use the Srvctl query out of the configuration file, if the profile is wrong, this does not start normally, if the profile is null, the default path to find (currently I have not found the method to change the Pfile parameter go home value)