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

See what I got:

[oracle_at_learning dbs]$ cat inittest1.ora SPFILE='+DISKTEST/test/spfiletest.ora'

[oracle_at_learning~]$ export ORACLE_SID=test1 [oracle_at_learning~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Sat Feb 9 20:31:30 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

SQL> connect / as sysdba
Connected to an idle instance.
SQL> create pfile from spfile;
create pfile from spfile
*
ERROR at line 1:
ORA-27037: unable to obtain file status
Linux-x86 Error: 2: No such file or directory Additional information: 3

Thanks

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:Ntqrj.359$n42.215_at_newsfe08.phx...
> "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
> Database mounted.
> Database opened.
Received on Sat Feb 09 2008 - 19:36:25 CST