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> STARTUP ORACLE 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 答案:B 解析:这里考察的是数据库启动的时候读取配置文件的顺序,首先应该是读取spfile<sid>.ora,如果不存在那么读取 spfile.ora,如果不存在那么读取pfile文件,这里sid为orcl因此不存在spfileorcl.ora,所以读取了spfile.ora