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

From: joe bayer <>
Date: Sat, 09 Feb 2008 20:51:47 GMT
Message-ID: <Dnorj.130$eU3.92@trndny04>

How can I create spfile if I can not even start the instance with the spfile?

"Steve Howard" <> wrote in message
> On Feb 9, 12:33 pm, "joe bayer" <> 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:51:47 CST

Original text of this message