Re: Help: How can I get the spfile out of ASM disk

From: Steve Howard <stevedhoward_at_gmail.com>
Date: Sat, 9 Feb 2008 12:16:54 -0800 (PST)
Message-ID: <c34c6549-51be-455d-9067-58ea59add74b@e4g2000hsg.googlegroups.com>


On Feb 9, 12:33 pm, "joe bayer" <joebay..._at_hotmail.com> wrote:
> 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

CREATE PFILE='/tmp/tmp.ora' FROM SPFILE; Received on Sat Feb 09 2008 - 14:16:54 CST

Original text of this message