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

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: Sun, 10 Feb 2008 02:55:49 -0800 (PST)
Message-ID: <b92ea58e-bc0b-4b84-9032-ad08e08171b2@h11g2000prf.googlegroups.com>


On Feb 10, 4:36 am, "joe bayer" <joebay..._at_hotmail.com> wrote:
> 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
>

See what's in $ORACLE_HOME/dbs/init<SID>.ora where <SID> is your Oracle database SID, verify that SPFILE=... in that file points to an accessible location and if it's on ASM then make sure ASM instance is up. You can also try to

create pfile='file-spec' from spfile;

where file-spec is full path to the pfile you want to be created.

And please, do not top-post.

Regards,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Sun Feb 10 2008 - 04:55:49 CST

Original text of this message