Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in01.usenetserver.com!news.usenetserver.com!in03.usenetserver.com!news.usenetserver.com!hwmnpeer01.phx!news.highwinds-media.com!hw-filter.phx!newsfe07.phx.POSTED!53ab2750!not-for-mail
Newsgroups: comp.databases.oracle.server
Subject: Re: Help: How can I get the spfile out of ASM disk
From: "Ana C. Dent" <anacedent@hotmail.com>
References: <mtlrj.39$YJ4.25@trndny01>
Organization: Your Company
User-Agent: Xnews/5.04.25
Lines: 30
Message-ID: <iOlrj.459$QJ3.350@newsfe07.phx>
NNTP-Posting-Host: 70.181.210.121
X-Complaints-To: newsmaster@cox.net
X-Trace: newsfe07.phx 1202579726 70.181.210.121 (Sat, 09 Feb 2008 10:55:26 MST)
NNTP-Posting-Date: Sat, 09 Feb 2008 10:55:26 MST
Date: Sat, 09 Feb 2008 17:55:26 GMT
Xref: usenetserver.com comp.databases.oracle.server:441333
X-Received-Date: Sat, 09 Feb 2008 12:55:27 EST (text.usenetserver.com)

"joe bayer" <joebayerr@hotmail.com> wrote in
news:mtlrj.39$YJ4.25@trndny01: 

> Dear group,
> 
> I am learning to use RAC on ASM disks on Oracle 10203 on linux.
> 
> I use DBCA to created a database.  The spfile is on ASM disks as well.
> After that, I did 'alter system set LOCAL_LISTENER=yyy' scope=both
> sid='*' 
> 
> But now I can not start my instances
> I got
> SQL> startup nomount
> ORA-00119: invalid specification for system parameter REMOTE_LISTENER
> ORA-00132: syntax error or unresolved network name 'LISTENERS_TEST'
> 
> How can I get my spfile out of the ASM disk and edit it?  I do not
> have a backup of spfile as this is a learning database.
> 
> Thanks for your help
> 
> 
> 

Right off the top I don't know how you can get a copy of the spfile,
but I do know how you can get the DB to open.

create a very sparse pfile then do
SQL> STARTUP NOMOUNT PFILE=newpfile.ora