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

"joe bayer" <joebayerr_at_hotmail.com> wrote in news:mtlrj.39$YJ4.25_at_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 Received on Sat Feb 09 2008 - 11:55:26 CST