Shulou(Shulou.com)06/01 Report--

The installation of the default database is complete, and the pfile and spfile of ASM are not found in the ORACLE_HOME/dbs directory. Manually create pfile and pfile as follows:

$exit# su-grid$ srvctl config asmASM home: / oracle/app/product/11.2.0ASM listener: LISTENERSpfile: + DATADG/asm/asmparameterfile/registry.253.970045839 # # this file does not exist ASM diskgroup discovery string: $$cd $ORACLE_HOME/dbs## directory does not have ASM's pfile and spfile$ lsab_+ASM.dat hc_+ASM.dat init.ora orapw+ASM$ # # manually specify the path of 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## create spfileSQL > create spfile from memory File created.SQL > # # check whether spfile generates SQL >! ls-ltotal 56 ltotal RW hc_+ASM.dat-rw-r--r---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 # # File generated SQL > $which crsctl/oracle/app/product/11.2.0/bin/crsctl$ exit## restart Database # / 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## found that spfileSQL > show parameter spfile has been detected NAME TYPE VALUE-- spfile string / oracle/app/product/11.2.0/dbs / spfile+ASM.oraSQL > # # create 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 has been found in total 72 RW grid oinstall 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 read and write *. _ aggregation_optimization_settings=0*._always_anti_join='CHOOSE '*. _ always_semi_join='CHOOSE'*._and_pruning_enabled=TRUE... Slightly; slightly.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.