122. 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:
[oracle@edt4r4p1 dbs]$ echo $ORACLE_SID
orcl
[oracle@edt4r4p1 dbs]$ sqlplus
SQL*Plus: Release 11.1.0.6.0 - Production on Tue Oct 16 15:35:43 2007
Copyright (c) 1982, 2007, Oracle. All rights reserved.
Enter user-name: sys/oracle as sysdba
Connected to an idle instance.
SQL> STARTUPORACLE instance started.
......
Which file is used to start the instance in this case?
A.init.ora
B.spfile.ora
C.initorcl.ora
D.spfile+ASM.ora
Answer: B
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/12237245
启动实例过程包括执行以下任务:
• 按以下顺序搜索$ORACLE_HOME/dbs中具有特定名称的文件:
1. 搜索spfile<SID>.ora。
2. 如果未找到spfile<SID>.ora,则搜索spfile.ora。
3. 如果未找到spfile.ora,则搜索init<SID>.ora。