The Geek Diary

ASM

Unable to create spfile for Oracle ASM instance

by

The Problem While trying to create spfile in asm instance, the following errors are encountered: SQL> create spfile=’+[DGNAME]’ from pfile='[PATH]/grid/dbs/init+ASM.ora’; create spfile=’+[DGNAME]’ from pfile='[PATH]/dbs/init+ASM.ora’ * ERROR at line 1: ORA-01078: failure in processing system parameters ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver], [0x09D00B1D0], [4], [0x7F01BA873800], [1024], [], [], [], [], [], [], [] The following disks […]

Oracle ASM 11gR2 instance is unable to start due to missing ASM spfile

by

The Problem 1) On ASM 11gR2 the ASM spfile initialization parameter file is now stored in the first created diskgroup (e.g. DATA). For example: SQL> show parameter instance_type NAME TYPE VALUE ———————————— ———– —————————— instance_type string asm SQL> show parameter spfile NAME TYPE VALUE ———————————— ———– ————————————————- spfile string +DATA/asm/asmparameterfile/registry.253.697740955 2) If for any reason […]

Oracle 11gR2 (11.2.0.1) Unable To Create ASM Spfile Standalone

by

The Problem Unable to create spfile due to the next error: SQL> startup pfile=’init+ASM.ora’; ASM instance started Total System Global Area 283930624 bytes Fixed Size 2206088 bytes Variable Size 256558712 bytes ASM Cache 25165824 bytes ASM diskgroups mounted SQL> create spfile=’+DGR1′ from pfile=’init+ASM.ora’; create spfile=’+DGR1′ from pfile=’init+ASM.ora’ * ERROR at line 1: ORA-17502: ksfdcre:4 Failed […]

How to move ASM spfile to a shared device in RAC

by

If you are using pfile, it must be a text file on local filesystem. If using spfile, then it can be in the following locations. a filesystem file spfile on local filesystem spfile on shared device a ASM file in a ASM diskgroup (only for spfile for instances after 11.2) Here are steps to put […]

How To Create An ASM Diskgroup Using XML code in ASMCMD

by

The post provides you an example about how to create an ASM diskgroup using XML code through the asmcmd command. 1. Create a XML file (e.g. diskgroup.xml) with the next code: <dg name=”datadg” redundancy=”normal”> <fg name=”SAN1″> <dsk string=”ORCL:ASMDISK1″/> <dsk string=”ORCL:ASMDISK2″/> </fg> <fg name=”SAN2″> <dsk string=”ORCL:ASMDISK3″/> <dsk string=”ORCL:ASMDISK4″/> </fg> <a name=”compatible.asm” value=”11.2″/> <a name=”compatible.rdbms” value=”11.2″/> <a […]

How to start up the ASM instance when the spfile is misconstrued or lost

by

The Problem CRS and the ASM instance can not start up because the spfile is misconstrued or lost. – Starting ASM instance fails with error: SQL> startup; ORA-00099: warning: no parameter file specified for ASM instance ORA-00304: requested INSTANCE_NUMBER is busy – Starting up the CRS services fails with error # crsctl start crs CRS-4640: […]

12c ASM: PRCR-1001 : Resource ora.proxy_advm Does Not Exist (Flex ASM with Cardinality = ALL)

by

The Problem This a RAC cluster configuration composed of 2 nodes. Clusterware was upgrade from 11.2.0.4 to 12.1.0.2 release. And ASM was converted to “Flex ASM” with “Cardinality = ALL”. Validating the “ora.proxy_advm” resource state reports the below error: $ srvctl status asm -proxy -n asmcloud2 -verbose PRCR-1001 : Resource ora.proxy_advm does not exist The […]

How to Convert STANDARD ASM to FLEX ASM in 12C

by

You can convert an Oracle ASM configuration to an Oracle Flex ASM using ASMCA. This functionality is only available in an Oracle Grid Infrastructure 12c configuration. Before you convert an Oracle ASM configuration to an Oracle Flex ASM, you must ensure the following: Oracle Cluster Registry (OCR) is stored in a disk group. The server […]