122.View the Exhibit and note the files available in the $ORACLE_HOME/dbs folder. The ASM instance i

Oracle数据库启动配置文件解析

今年我18

于 2016-08-02 20:52:40 发布

阅读量865

点赞数

CC 4.0 BY-SA版权

分类专栏： 1z0-052 文章标签： 1z0-052

本文链接：https://blog.youkuaiyun.com/dwj19830118/article/details/52097809

1z0-052 专栏收录该内容

187 篇文章

订阅专栏

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> 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