11g asm pfile & spfile

默认数据库安装完成，在ORACLE_HOME/dbs目录下并未发现ASM的pfile和spfile，手动创建pfile和pfile如下：

$ exit# su - grid$ srvctl config asmASM home: /oracle/app/product/11.2.0ASM listener: LISTENERSpfile: +DATADG/asm/asmparameterfile/registry.253.970045839   ##此文件并不存在ASM diskgroup discovery string: $ $ cd $ORACLE_HOME/dbs##目录下并没有ASM的pfile和spfile$ lsab_+ASM.dat  hc_+ASM.dat  init.ora     orapw+ASM$ ##手动指定spfile 的路径$srvctl modify asm -p /oracle/app/product/11.2.0/dbs/spfile+ASM.ora$ srvctl config asmASM home: /oracle/app/product/11.2.0ASM listener: LISTENERSpfile: /oracle/app/product/11.2.0/dbs/spfile+ASM.oraASM diskgroup discovery string: $ sqlplus / as sysasmSQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 16 08:50:26 2018Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Automatic Storage Management option##创建spfileSQL> create spfile from memory;File created.SQL> ##查看spfile 是否生成SQL> !ls -ltotal 56-rw-rw----    1 grid     oinstall       1676 Mar 07 10:02 ab_+ASM.dat-rw-rw----    1 grid     oinstall       1544 Mar 16 08:44 hc_+ASM.dat-rw-r--r--    1 grid     oinstall       2851 May 15 2009  init.ora-rw-r-----    1 grid     oinstall       1536 Mar 06 09:10 orapw+ASM-rw-r-----    1 grid     oinstall      11776 Mar 16 08:50 spfile+ASM.ora   ##文件已生成SQL> $ which crsctl/oracle/app/product/11.2.0/bin/crsctl$ exit##重启数据库# /oracle/app/product/11.2.0/bin/crsctl stop hasCRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'mng'CRS-2673: Attempting to stop 'ora.mngdb.db' on 'mng'CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'mng'CRS-2677: Stop of 'ora.mngdb.db' on 'mng' succeededCRS-2673: Attempting to stop 'ora.DATA.dg' on 'mng'CRS-2677: Stop of 'ora.DATA.dg' on 'mng' succeededCRS-2673: Attempting to stop 'ora.asm' on 'mng'CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'mng' succeededCRS-2677: Stop of 'ora.asm' on 'mng' succeededCRS-2673: Attempting to stop 'ora.cssd' on 'mng'CRS-2677: Stop of 'ora.cssd' on 'mng' succeededCRS-2673: Attempting to stop 'ora.evmd' on 'mng'CRS-2677: Stop of 'ora.evmd' on 'mng' succeededCRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'mng' has completedCRS-4133: Oracle High Availability Services has been stopped.#  /oracle/app/product/11.2.0/bin/crsctl start hasCRS-4123: Oracle High Availability Services has been started.# su - grid$ srsqlplus / as sysdbaSQL*Plus: Release 11.2.0.4.0 Production on Fri Mar 16 08:54:14 2018Copyright (c) 1982, 2013, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Automatic Storage Management option##发现已经可以检测到spfileSQL> show parameter spfile;NAME                                 TYPE        VALUE------------------------------------ ----------- ------------------------------spfile                               string      /oracle/app/product/11.2.0/dbs                                                 /spfile+ASM.oraSQL> ##创建pfileSQL> create pfile from spfile;File created.SQL> exitDisconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit ProductionWith the Automatic Storage Management option$ cd $ORACLE_HOME/dbs$ ls -l##pfile已经发现total 72-rw-rw----    1 grid     oinstall       1676 Mar 16 08:53 ab_+ASM.dat-rw-rw----    1 grid     oinstall       1544 Mar 16 08:53 hc_+ASM.dat-rw-r--r--    1 grid     oinstall       5242 Mar 16 08:54 init+ASM.ora-rw-r--r--    1 grid     oinstall       2851 May 15 2009  init.ora-rw-r-----    1 grid     oinstall       1536 Mar 06 09:10 orapw+ASM-rw-r-----    1 grid     oinstall      11776 Mar 16 08:50 spfile+ASM.ora$ more init+ASM.ora   ##pfile读写*._aggregation_optimization_settings=0*._always_anti_join='CHOOSE'*._always_semi_join='CHOOSE'*._and_pruning_enabled=TRUE...略..........................