Hi Ihave been trying to configure spfile for ASM looking at a user guide
sho parameter spfile
when i try to show spfile parameters i get the following
SQL> sho parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
it should look like as follows:
SQL> sho parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /data/app/11.2.0/grid/dbs/spfile+ASM.ora
any ideas why this is, the following terminal session may give a clue..
SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 12 03:49:05 2010
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup pfile=/u01/app/11.2.0/grid/dbs/init+ASM.ora
ASM instance started
Total System Global Area 284565504 bytes
Fixed Size 1336036 bytes
Variable Size 258063644 bytes
ASM Cache 25165824 bytes
ORA-15110: no diskgroups mounted
SQL> create spfile from pfile;
File created.
SQL> sho parameter spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL>