Hi Gurus,
I need you help. Please give me a favour.
I am creating a ASM instance in my for my orcl instance. Below is step by step process which I did.
SQL> select name, open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
ORCL READ WRITE
SQL> select tablespace_name from dba_tablespaces;
TABLESPACE_NAME
------------------------------
SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
EXAMPLE
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
D:\APP\HIMANSHU\ORADATA\ORCL\SYSTEM01.DBF
D:\APP\HIMANSHU\ORADATA\ORCL\SYSAUX01.DBF
D:\APP\HIMANSHU\ORADATA\ORCL\UNDOTBS01.DBF
D:\APP\HIMANSHU\ORADATA\ORCL\USERS01.DBF
D:\APP\HIMANSHU\ORADATA\ORCL\EXAMPLE01.DBF
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
D:\APP\HIMANSHU\ORADATA\ORCL\CONTROL01.CTL
D:\APP\HIMANSHU\FLASH_RECOVERY_AREA\ORCL\CONTROL02.CTL
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
D:\APP\HIMANSHU\ORADATA\ORCL\REDO03.LOG
D:\APP\HIMANSHU\ORADATA\ORCL\REDO02.LOG
D:\APP\HIMANSHU\ORADATA\ORCL\REDO01.LOG
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
D:\>cd D:\app\Himanshu\oradata\orcl
D:\app\Himanshu\oradata\orcl>dir
Volume in drive D has no label.
Volume Serial Number is 84E1-F031
Directory of D:\app\Himanshu\oradata\orcl
12/07/2013 04:37 PM <DIR> .
12/07/2013 04:37 PM <DIR> ..
12/17/2013 11:15 PM 9,748,480 CONTROL01.CTL
12/16/2013 06:43 PM 104,865,792 EXAMPLE01.DBF
12/16/2013 12:13 AM 52,429,312 REDO01.LOG
12/16/2013 06:42 PM 52,429,312 REDO02.LOG
12/15/2013 09:01 PM 52,429,312 REDO03.LOG
12/17/2013 11:30 PM 597,696,512 SYSAUX01.DBF
12/16/2013 06:43 PM 723,525,632 SYSTEM01.DBF
12/17/2013 10:44 PM 20,979,712 TEMP01.DBF
12/16/2013 06:43 PM 57,679,872 UNDOTBS01.DBF
12/16/2013 06:43 PM 5,251,072 USERS01.DBF
10 File(s) 1,677,035,008 bytes
2 Dir(s) 190,895,730,688 bytes free
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
D:\>cd D:\app\Himanshu\oradata\orcl
D:\app\Himanshu\oradata\orcl>dir
Volume in drive D has no label.
Volume Serial Number is 84E1-F031
Directory of D:\app\Himanshu\oradata\orcl
12/07/2013 04:37 PM <DIR> .
12/07/2013 04:37 PM <DIR> ..
12/17/2013 11:15 PM 9,748,480 CONTROL01.CTL
12/16/2013 06:43 PM 104,865,792 EXAMPLE01.DBF
12/16/2013 12:13 AM 52,429,312 REDO01.LOG
12/16/2013 06:42 PM 52,429,312 REDO02.LOG
12/15/2013 09:01 PM 52,429,312 REDO03.LOG
12/17/2013 11:30 PM 597,696,512 SYSAUX01.DBF
12/16/2013 06:43 PM 723,525,632 SYSTEM01.DBF
12/17/2013 10:44 PM 20,979,712 TEMP01.DBF
12/16/2013 06:43 PM 57,679,872 UNDOTBS01.DBF
12/16/2013 06:43 PM 5,251,072 USERS01.DBF
10 File(s) 1,677,035,008 bytes
2 Dir(s) 190,895,730,688 bytes free
D:\app\Himanshu\oradata\orcl>cd D:\app\Himanshu\product\11.2.0\dbhome_2
D:\app\Himanshu\product\11.2.0\dbhome_2>cd database
D:\app\Himanshu\product\11.2.0\dbhome_2\database>dir
Volume in drive D has no label.
Volume Serial Number is 84E1-F031
Directory of D:\app\Himanshu\product\11.2.0\dbhome_2\database
12/17/2013 11:48 PM <DIR> .
12/17/2013 11:48 PM <DIR> ..
12/07/2013 04:33 PM <DIR> archive
12/07/2013 04:35 PM 2,048 hc_orcl.dat
12/22/2005 04:07 AM 31,744 oradba.exe
12/17/2013 11:50 PM 1,767 oradim.log
12/07/2013 04:41 PM 1,536 PWDorcl.ora
12/17/2013 10:42 PM 3,584 SPFILEORCL.ORA
5 File(s) 40,679 bytes
3 Dir(s) 190,895,714,304 bytes free
D:\app\Himanshu\product\11.2.0\dbhome_2\database>set ORACLE_SID=+ASM
D:\app\Himanshu\product\11.2.0\dbhome_2\database>echo %ORACLE_SID%
+ASM
After that I have created a parameter file and given a parameter which is required to create a ASM instance:
D:\app\Himanshu\product\11.2.0\dbhome_2\database>type init+ASM.ora
instance_type=asm
D:\app\Himanshu\product\11.2.0\dbhome_2\database>oradim -new -sid +ASM
Instance created.
D:\app\Himanshu\product\11.2.0\dbhome_2\database>mkdir c:\asmdisks
D:\app\Himanshu\product\11.2.0\dbhome_2\database>dir c:\asmdisks
Volume in drive C is OS
Volume Serial Number is 440C-A2D1
Directory of c:\asmdisks
12/18/2013 12:06 AM <DIR> .
12/18/2013 12:06 AM <DIR> ..
0 File(s) 0 bytes
2 Dir(s) 51,594,907,648 bytes free
D:\app\Himanshu\product\11.2.0\dbhome_2\database>asmtool -create c:\asmdisks\asmdisk1.asm 3
D:\app\Himanshu\product\11.2.0\dbhome_2\database>asmtool -create c:\asmdisks\asmdisk2.asm 3
D:\app\Himanshu\product\11.2.0\dbhome_2\database>asmtool -create c:\asmdisks\asmdisk3.asm 3
D:\app\Himanshu\product\11.2.0\dbhome_2\database>dir c:\asmdisks
Volume in drive C is OS
Volume Serial Number is 440C-A2D1
Directory of c:\asmdisks
12/18/2013 12:08 AM <DIR> .
12/18/2013 12:08 AM <DIR> ..
12/18/2013 12:07 AM 3,145,728 asmdisk1.asm
12/18/2013 12:08 AM 3,145,728 asmdisk2.asm
12/18/2013 12:08 AM 3,145,728 asmdisk3.asm
3 File(s) 9,437,184 bytes
2 Dir(s) 51,585,474,560 bytes free
Now I have edited pfile and given two more parameter :
D:\app\Himanshu\product\11.2.0\dbhome_2\database>type init+ASM.ora
instance_type=asm
ASM_DISKSTRING = 'c:\asmdisks\*'
_ALL_ALLOW_ONLY_RAW_DISKS=FALSE
Now I am starting my ASM instance and getting below error:
D:\app\Himanshu\product\11.2.0\dbhome_2\database>echo %ORACLE_SID%
+ASM
D:\app\Himanshu\product\11.2.0\dbhome_2\database>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed Dec 18 00:13:17 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup;
ORA-01078: failure in processing system parameters
LRM-00101: unknown parameter name '_ALL_ALLOW_ONLY_RAW_DISKS'
And If I am removing that hidden parameter I am getting belwo error :
SQL> startup;
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
Please give a help to remove this error also please guide me what wrong I am doing here.
Thanks,
Michel.