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

From: Ana C. Dent <>
Date: Sat, 09 Feb 2008 23:14:53 GMT
Message-ID: <Ntqrj.359$n42.215@newsfe08.phx>

"joe bayer" <> 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???????


SQL*Plus: Release - 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 - 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
Database mounted.
Database opened. Received on Sat Feb 09 2008 - 17:14:53 CST

Original text of this message