Re: Help: How can I get the spfile out of ASM disk
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" <stevedhoward_at_gmail.com> wrote in message
news:c34c6549-51be-455d-9067-58ea59add74b_at_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:51:47 CST