• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
  • Skip to footer navigation

The Geek Diary

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • VCS
  • Interview Questions
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
  • DevOps
    • Docker
    • Shell Scripting
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

Unable to create spfile for Oracle ASM instance

by admin

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 are showing for ASM01 diskgroup:

Sql> select path,os_mb,header_status from v$asm_disk where group_number=1
PATH OS_MB HEADER_STATU
-------------------------------------------------- ---------- ------------
  0 UNKNOWN
[PATH]/lo10Glun002p1 10236 MEMBER

From the ASM instance alert log file:

Fri Jan 08 23:08:28 2016
NOTE: Using default ASM root directory ASM
NOTE: updated gpnp profile ASM diskstring: [PATH]/lo*p1
WARNING: media corrupt block seen on file '+[DGNAME]/asm/asmparameterfile/registry.253.900630509' blockno=4
Reread resulted in same corrupt block on file '+[DGNAME]/asm/asmparameterfile/registry.253.900630509' blockno=4 from mirror side 1 (ASM01_0000) logical extent number 0
Reread resulted in same corrupt block on file '+[DGNAME]/asm/asmparameterfile/registry.253.900630509' blockno=4 from mirror side 1 (ASM01_0000) logical extent number 0
Errors in file /diag/asm/+asm/+ASM/trace/+ASM_ora_52943.trc (incident=131337):
ORA-00600: internal error code, arguments: [ksprcvsp:ksfdread_resilver], [0x09D00B1D0], [4], [0x7F327BD77200], [1024], [], [], [], [], [], [], []
Incident details in: /diag/asm/+asm/+ASM/incident/incdir_131337/+ASM_ora_52943_i131337.trc
Use ADRCI or Support Workbench to package the incident.

The Solution

The diskgroup that originally contained the spfile has become corrupted. The only options are – create the spfile in a new diskgroup then drop the old diskgroup using the -force option. Or drop the corrupted diskgroup and recreate it.

Filed Under: ASM, oracle

Some more articles you might also be interested in …

  1. Oracle 12c New Feature: LREG Background Process
  2. How to get the Values Assigned by Default to a Profile in Oracle Database
  3. Oracle RAC : understanding split brain
  4. How To Size UNDO Tablespace For Automatic Undo Management
  5. Oracle Database 12c New Feature: Transaction Guard and Application Continuity
  6. Oracle OS watcher (OSWatcher) – Understanding oswiostat
  7. RMAN Restore/Duplicate Performs Implicit Crosschecking and Cataloging
  8. Oracle GoldenGate: Replicat Sample Parameter File
  9. Oracle RMAN – Restore and Recovery of a Noarchivelog Database
  10. How To Calculate The Required Network Bandwidth Transfer Of Redo In Data Guard Environments

You May Also Like

Primary Sidebar

Recent Posts

  • nixos-rebuild Command Examples in Linux
  • nixos-option: Command Examples in Linux
  • nixos-container : Command Examples in Linux
  • nitrogen Command Examples in Linux

© 2023 · The Geek Diary

  • Archives
  • Contact Us
  • Copyright