Help: How can I get the spfile out of ASM disk
From: joe bayer <joebayerr_at_hotmail.com>
Date: Sat, 09 Feb 2008 17:33:06 GMT
Message-ID: <mtlrj.39$YJ4.25@trndny01>
Date: Sat, 09 Feb 2008 17:33:06 GMT
Message-ID: <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 Received on Sat Feb 09 2008 - 11:33:06 CST