Home » Infrastructure » Windows » ORA-01565: error in identifying file '+DATA/asm/spfileasm.ora'
ORA-01565: error in identifying file '+DATA/asm/spfileasm.ora' [message #263656] Thu, 30 August 2007 11:59
techvader01
Messages: 17
Registered: August 2006
Location: Los Angeles
Junior Member
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 30 09:44:15 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL> SQL> Connected to an idle instance.
SQL> ORA-01078: failure in processing system parameters
ORA-01565: error in identifying file '+DATA/asm/spfileasm.ora'
ORA-17503: ksfdopn:2 Failed to open file +DATA/asm/spfileasm.ora
ORA-15077: could not locate ASM instance serving a required diskgroup
Disconnected

What is the actually saying to me and what must I do to correct the problem. I created the ASM database with 3 diskgroups and it worked fine at the time. Why am I getting this msg now?
Previous Topic: How to display oracle BLOB image in VB6 ?
Next Topic: Cant Access SQLPLUS from Command Prompt
Goto Forum:
  


Current Time: Wed Dec 07 22:19:11 CST 2016

Total time taken to generate the page: 0.16688 seconds