View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM
instance is already running. You used the following steps to start the database instance and open
the database:
Which file is used to start the instance in this case?
A.
init.ora
B.
spfile.ora
C.
initorcl.ora
D.
spfile+ASM.ora
The answer is true
why?
(standby)(ora10g@ora10):dbs> ls -l
total 6948
-rw-r—– 1 ora10g oinstall 452 Mar 16 18:45 alert_ora10.log
-rw-rw—- 1 ora10g oinstall 1552 May 12 18:47 hc_ora10.dat
-rw-r–r– 1 ora10g oinstall 12920 May 3 2001 initdw.ora
-rw-r—– 1 ora10g oinstall 8385 Sep 11 1998 initold.ora
-rw-r—– 1 ora10g oinstall 24 Jan 3 14:49 lkORA10
-rw-r—– 1 ora10g oinstall 1536 Jan 3 14:51 orapwora10
-rw-r–r– 1 ora10g oinstall 1112 Jan 27 11:27 pao.ora
-rw-r—– 1 ora10g oinstall 7061504 Feb 24 17:42 snapcf_ora10.f
-rw-r—– 1 ora10g oinstall 3584 Feb 24 17:37 spfile.ora
(standby)(ora10g@ora10):dbs> sql
SQL*Plus: Release 10.2.0.5.0 – Production on Mon May 12 18:47:51 2014
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 1862270976 bytes
Fixed Size 2097112 bytes
Variable Size 469762088 bytes
Database Buffers 1375731712 bytes
Redo Buffers 14680064 bytes
SQL> Disconnected from Oracle Database 10g Release 10.2.0.5.0 – 64bit Production
(standby)(ora10g@ora10):dbs>
From Oracle 11g R2 Site:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/start.htm#i1006091
Extract:
About Initialization Parameter Files and Startup
When you start the database instance, it attempts to read the initialization parameters from an SPFILE in a platform-specific default location. If it finds no SPFILE, it searches for a text initialization parameter file.
Table 2-3 lists PFILE and SPFILE default names and locations.
In the platform-specific default location, Oracle Database locates your initialization parameter file by examining file names in the following order:
1.spfileORACLE_SID.ora
2.spfile.ora
3.initORACLE_SID.ora
The first two files are SPFILEs and the third is a text initialization parameter file. If DBCA created the SPFILE in an Oracle Automatic Storage Management disk group, the database searches for the SPFILE in the disk group.
Note:
The spfile.ora file is included in this search path because in an Oracle Real Application Clusters environment one server parameter file is used to store the initialization parameter settings for all instances. There is no instance-specific location for storing a server parameter file.