Database Reference
In-Depth Information
C:> set ORACLE_SID=+ASM
C:> sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Tue Aug 14 16:17:51 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> STARTUP NOMOUNT PFILE=?\database\pfile+ASM.ora
ASM instance started
Total System Global Area 79691776 bytes
Fixed Size 1247396 bytes
Variable Size 53278556 bytes
ASM Cache 25165824 bytes
Next, we create a server parameter file (
SPFILE
), such that ASM will be able to store disk
group names it should mount at instance startup in the
SPFILE
.
SQL> CREATE SPFILE FROM PFILE='?\database\pfile+ASM.ora';
File created.
This creates an
SPFILE
called
spfile+ASM.ora
. Let's see whether ASM recognizes the
cooked files as disks.
SQL> SELECT path, header_status FROM v$asm_disk;
no rows selected
ASM does not see any disks that it might use. This is not surprising, since the default
setting of the parameter
_ASM_ALLOW_ONLY_RAW_DISKS
is
TRUE
. We need to shut down the
instance and restart it before we can change the parameter in the
SPFILE
that we created.
SQL> SHUTDOWN IMMEDIATE
ORA-15100: invalid or missing diskgroup name
ASM instance shutdown
SQL> STARTUP NOMOUNT
ASM instance started
…
SQL> SHOW PARAMETER SPFILE
NAME TYPE VALUE
-------- ----------- ------------------------------------------------
spfile string C:\ORACLE\PRODUCT\DB10.2\DATABASE\SPFILE+ASM.ORA
Since
_ASM_ALLOW_ONLY_RAW_DISKS
is a static parameter, another instance restart is
required after changing it.
SQL> ALTER SYSTEM SET "_asm_allow_only_raw_disks"=FALSE SCOPE=SPFILE SID='*';
System altered.
SQL> SHUTDOWN IMMEDIATE
ORA-15100: invalid or missing diskgroup name
ASM instance shutdown
SQL> STARTUP NOMOUNT
ASM instance started
…
