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

"joe bayer" <joebayerr_at_hotmail.com> wrote in news:Dnorj.130$eU3.92_at_trndny04:

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

What makes you think the DB needs to be up to create the pfile???????

 sqlplus

SQL*Plus: Release 11.1.0.6.0 - Production on Sat Feb 9 15:02:46 2008

Copyright (c) 1982, 2007, Oracle. All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create pfile from spfile;

File created.

SQL> startup
ORACLE instance started.

Total System Global Area 401743872 bytes

Fixed Size                  1300212 bytes
Variable Size             356518156 bytes
Database Buffers           37748736 bytes
Redo Buffers                6176768 bytes