Hi All,
Database - 11.2.0.1
Os - WIndows server 2008
This is non-production database. Working on movement of database from non-asm to asm. Datafiles are stored in filesystem -
D:\APP\ADMINISTRATOR\ORADATA\ASH1\USERS01.DBF
Below are the steps for the asm diskgroup creation. While doing so, I am getting error.
D:\app\Administrator\product\11.2.0\dbhome_1\database>oradim -new -sid +ASM
Instance created.
D:\app\Administrator\asmdisk>asmtool -create asmdisk1.asm 200
D:\app\Administrator\asmdisk>dir
Volume in drive D is New Volume
Volume Serial Number is 6436-2D87
Directory of D:\app\Administrator\asmdisk
03/05/2017 09:37 AM <DIR> .
03/05/2017 09:37 AM <DIR> ..
03/05/2017 09:51 AM 209,715,200 asmdisk1.asm
1 File(s) 209,715,200 bytes
2 Dir(s) 22,915,624,960 bytes free
D:\app\Administrator\asmdisk>
D:\app\Administrator\product\11.2.0\dbhome_1\database>type init+ASM.ora
instance_type=ASM
ASM_DISKSTRING='D:\app\Administrator\asmdisk\*'
_ASM_ALLOW_ONLY_RAW_DISKS=FALSE
D:\app\Administrator\product\11.2.0\dbhome_1\database>echo %ORACLE_SID%
+ASM
D:\app\Administrator\product\11.2.0\dbhome_1\database>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Wed May 3 09:54:48 2017
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
ORA-29701: unable to connect to Cluster Synchronization Service
SQL> exit
Disconnected
Please assist me to startup the asm instance. Once it start, I will create diskgroup and the same thing will be assigned at pfile and bounced back to mounted stage.
Regards,
Ashish Kumar Mahanta